Add SQL table creation scripts.

diff --git a/sql/Pages.sql b/sql/Pages.sql
new file mode 100644 (file)
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 (file)
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`)
+)