Lots of changes

[PHPIPManager.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
new file mode 100644 (file)
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);