mirror of
https://github.com/librespeed/speedtest.git
synced 2026-11-22 16:14:56 +00:00
* Initial implementation of ipinfo.io offline database * Removed unnecessary code * add: download ipinfo db during docker build * fixed workflow * rename warning in workflow * commit to trigger workflow * Refactor getIP * Improved UI * Updated docker version with 5.4 changes * Updated README.md * Added fallback in getIP in case the offline db is missing * Fixed typos * just md linting * Removed vscode stuff * Implemented fallback in getIP for PHP<8 (returns only the IP) * Updated doc.md * Fixed comments in telemetry_settings.php * New quick start video * Corrected image name in doc_docker.md * Replaced speedtest with just test in stats.php * docker documentation update * typo --------- Co-authored-by: Federico Dossena <info@fdossena.com> Co-authored-by: Stefan Stidl <stefan.stidl@ffg.at>
30 lines
841 B
Transact-SQL
Executable file
30 lines
841 B
Transact-SQL
Executable file
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
CREATE TABLE [dbo].[speedtest_users](
|
|
[id] [bigint] IDENTITY(120,1) NOT NULL,
|
|
[timestamp] [datetime] NOT NULL,
|
|
[ip] [nvarchar](max) NOT NULL,
|
|
[ispinfo] [nvarchar](max) NULL,
|
|
[extra] [nvarchar](max) NULL,
|
|
[ua] [nvarchar](max) NOT NULL,
|
|
[lang] [nvarchar](max) NOT NULL,
|
|
[dl] [nvarchar](max) NULL,
|
|
[ul] [nvarchar](max) NULL,
|
|
[ping] [nvarchar](max) NULL,
|
|
[jitter] [nvarchar](max) NULL,
|
|
[log] [nvarchar](max) NULL,
|
|
CONSTRAINT [PK_speedtest_users] PRIMARY KEY CLUSTERED
|
|
(
|
|
[id] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[speedtest_users] ADD CONSTRAINT [DF_speedtest_users_timestamp] DEFAULT (getdate()) FOR [timestamp]
|
|
GO
|
|
|
|
|