mirror of
https://github.com/librespeed/speedtest.git
synced 2024-05-10 18:54:52 +00:00
sstidl
e5f54fbd78
* Update README.md Added simple manual instructions * Link to docker documentation * Add basic docker compose example * add descriptive alt-text to GIF * Fix some typos and formatting * Updated Docker to use php8.2-apache as the upstream image. * Clean up apt lists after installation in Dockerfile * Update Dockerfile Co-authored-by: Quentame <[email protected]> * fix typo * doc: sqlite db persistance explained * Create docker-publish.yml * Update docker-publish.yml * Update docker-publish.yml * fix action * switch docker image location * without image signing * remove signing * switch units to Mbit/s * move examples to folder * fix ipinfo parsing * fix regression on getIpinfo * removed trailing whitespaces * integrate ios favicon closes #400 * set single-server-full as index --------- Co-authored-by: Les W <[email protected]> Co-authored-by: bt90 <[email protected]> Co-authored-by: An | Anton Röhm <[email protected]> Co-authored-by: 0kyn <[email protected]> Co-authored-by: Marc Zampetti <[email protected]> Co-authored-by: Peter Dave Hello <[email protected]> Co-authored-by: Quentame <[email protected]> Co-authored-by: Stefan STIDL <[email protected]>
31 lines
841 B
Transact-SQL
31 lines
841 B
Transact-SQL
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
|
|
|
|
|