From: David ‘Bombe’ Roden <bombe@pterodactylus.net>
Date: Tue, 10 Mar 2009 22:14:19 +0000 (+0100)
Subject: Add SQL table creation scripts.
X-Git-Url: https://git.pterodactylus.net/?p=arachne.git;a=commitdiff_plain;h=5cad9383aef2bdc2e1555db1161f43a45013d9ef;hp=a637923e6ea2bd6d53180b7e843b02a191b6d6e5

Add SQL table creation scripts.
---

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`)
+)