Create a new database
Create a new database called "db_speedcheck" in SQL Server Enterprise Manager.
This is basic usage of Microsoft SQL Server. You ARE required to have basic knowledge of these web technologies before proceeding, please refer to Microsoft.com if you need help.
Create a new table
You need to have proper privileges in creating and accessing the database.
Create a new table called "speedcheck_stats"
An easy way is to run the script provided below. Copy-and-paste or locate sql_speedcheck_stats_my_sql.txt in the /documents directory of package
CREATE TABLE [speedcheck_stats]
([speedcheck_stats_id] [int] IDENTITY (1, 1) NOT NULL,
[date_time] [datetime] NULL,
[ip_address] [varchar](50) NULL,
[transfer_type] [int] NULL,
[transfer_size] [int] NULL,
[time_taken] [int] NULL,
[session_id] [varchar](50) NULL,
[custom_1] [varchar](255) NULL,
[custom_2] [varchar](255) NULL,
[custom_3] [varchar](255) NULL)
ON [PRIMARY]
Save it, now the database has been created.