X-Git-Url: http://git.pjr.cc/?p=PHPIPManager.git;a=blobdiff_plain;f=lib%2Fdb.php;h=77a9068dcf5dd9c79a53d7dcf05d057b8cd02811;hp=afa66798d4ce3836bdddba02ac11e9324228e698;hb=0264b5a42242521bd85ab2568f4bf23381df7a36;hpb=2569c990f8e6d6cd66bf85e0db5da9dcd671825a

diff --git a/lib/db.php b/lib/db.php
index afa6679..77a9068 100644
--- a/lib/db.php
+++ b/lib/db.php
@@ -10,10 +10,10 @@ class db {
 		$sql = 'CREATE TABLE "hosts" ("ho_id" INTEGER PRIMARY KEY AUTOINCREMENT,"ho_sn_id" INTEGER,"ho_ip" TEXT,"ho_name" TEXT,"ho_desc" TEXT);';
 		$this->dbobject->query($sql);
 		
-		$sql = 'CREATE TABLE subnet ("sn_id" INTEGER,"snid_id" INTEGER,"sn_ip" TEXT,"sn_mask" TEXT,"sn_name" TEXT, "sn_desc" TEXT);';
+		$sql = 'CREATE TABLE subnet ("sn_id" INTEGER PRIMARY KEY AUTOINCREMENT,"snid_id" INTEGER,"sn_ip" TEXT,"sn_mask" TEXT,"sn_name" TEXT, "sn_desc" TEXT);';
 		$this->dbobject->query($sql);
 		
-		$sql = 'CREATE TABLE supernet ("sn_id" INTEGER,"sn_name" TEXT,"sn_ip" TEXT,"sn_mask" TEXT,"sn_desc" TEXT);';
+		$sql = 'CREATE TABLE supernet ("sn_id" INTEGER PRIMARY KEY AUTOINCREMENT,"sn_name" TEXT,"sn_ip" TEXT,"sn_mask" TEXT,"sn_desc" TEXT);';
 		$this->dbobject->query($sql);
 	}