From 5cad9383aef2bdc2e1555db1161f43a45013d9ef Mon Sep 17 00:00:00 2001 From: =?utf8?q?David=20=E2=80=98Bombe=E2=80=99=20Roden?= Date: Tue, 10 Mar 2009 23:14:19 +0100 Subject: [PATCH] Add SQL table creation scripts. --- sql/Pages.sql | 7 +++++++ sql/Sites.sql | 7 +++++++ 2 files changed, 14 insertions(+) create mode 100644 sql/Pages.sql create mode 100644 sql/Sites.sql diff --git a/sql/Pages.sql b/sql/Pages.sql new file mode 100644 index 0000000..7196901 --- /dev/null +++ b/sql/Pages.sql @@ -0,0 +1,7 @@ +CREATE TABLE `Pages` ( + `ID` bigint(20) NOT NULL auto_increment, + `Site` bigint(20) NOT NULL, + `Path` text NOT NULL, + `LastUpdated` bigint(20) NOT NULL, + PRIMARY KEY (`ID`) +) diff --git a/sql/Sites.sql b/sql/Sites.sql new file mode 100644 index 0000000..a3e4c37 --- /dev/null +++ b/sql/Sites.sql @@ -0,0 +1,7 @@ +CREATE TABLE `Sites` ( + `ID` bigint(20) NOT NULL auto_increment, + `Key` char(95) NOT NULL, + `Name` text NOT NULL, + `Edition` int(11) NOT NULL, + PRIMARY KEY (`ID`) +) -- 2.7.4