X-Git-Url: http://git.pjr.cc/?p=PHPIPManager.git;a=blobdiff_plain;f=db%2Fschema.sql;fp=db%2Fschema.sql;h=b7db16436ef6ec81bbc6604d03db51eac267d761;hp=0000000000000000000000000000000000000000;hb=bb7eb6654bf2983a7c9d45ad22b0ddbc5608dbe5;hpb=89d9c16291e80d7eb7d37d824e41f799095d3666

diff --git a/db/schema.sql b/db/schema.sql
new file mode 100644
index 0000000..b7db164
--- /dev/null
+++ b/db/schema.sql
@@ -0,0 +1,21 @@
+CREATE TABLE sqlite_sequence(name,seq);
+CREATE TABLE "hosts" (
+    "ho_id" INTEGER PRIMARY KEY AUTOINCREMENT,
+    "ho_sn_id" INTEGER,
+    "ho_ip" TEXT,
+    "ho_name" TEXT,
+    "ho_desc" TEXT
+);
+CREATE TABLE subnet (
+    "sn_id" INTEGER,
+    "snid_id" INTEGER,
+    "sn_ip" TEXT,
+    "sn_mask" TEXT,
+    "sn_name" TEXT
+, "sn_desc" TEXT);
+CREATE TABLE supernet (
+    "sn_id" INTEGER,
+    "sn_name" TEXT,
+    "sn_ip" TEXT,
+    "sn_mask" TEXT
+, "sn_desc" TEXT);