made scan work... think i also have a solution for ipv6 sunetting... its pretty simpl...
[PHPIPManager.git] / db / schema.sql
1 CREATE TABLE sqlite_sequence(name,seq);
2 CREATE TABLE "hosts" (
3     "ho_id" INTEGER PRIMARY KEY AUTOINCREMENT,
4     "ho_sn_id" INTEGER,
5     "ho_ip" TEXT,
6     "ho_name" TEXT,
7     "ho_desc" TEXT
8 );
9 CREATE TABLE subnet (
10     "sn_id" INTEGER,
11     "snid_id" INTEGER,
12     "sn_ip" TEXT,
13     "sn_mask" TEXT,
14     "sn_name" TEXT
15 , "sn_desc" TEXT);
16 CREATE TABLE supernet (
17     "sn_id" INTEGER,
18     "sn_name" TEXT,
19     "sn_ip" TEXT,
20     "sn_mask" TEXT
21 , "sn_desc" TEXT);