dblayout.sql

--
-- File generated with SQLiteStudio v3.0.4 on Do. Mai 18 13:28:54 2017
--
-- Text encoding used: UTF-8
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;

-- Table: groups
CREATE TABLE groups (group_id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE, name TEXT UNIQUE, chldvlv INTEGER DEFAULT (4) NOT NULL, open BOOLEAN DEFAULT (0), updated DATETIME, updatedby TEXT);

-- Table: pclist
CREATE TABLE pclist (id INTEGER PRIMARY KEY UNIQUE, ip TEXT NOT NULL UNIQUE, group_id INTEGER NOT NULL, updated DATETIME, updatedby TEXT);

-- Table: nclistsuser
CREATE TABLE nclistsuser (id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE, name TEXT UNIQUE, password TEXT NOT NULL, updated DATETIME, updatedby TEXT);
INSERT INTO nclistsuser (id, name, password, updated, updatedby) VALUES (0, 'admin', '$1$DOjc9ufI$Z4mNyrOZm8AXJYmRfUAsw1', '2017-05-23 15:50:00', '0');

-- Table: domains
CREATE TABLE domains (id INTEGER PRIMARY KEY UNIQUE, url TEXT UNIQUE NOT NULL, ip TEXT NOT NULL UNIQUE, priority INT DEFAULT (0), intern BOOLEAN DEFAULT (0), enable BOOLEAN DEFAULT (1), childlvl INT DEFAULT (4), updated DATETIME, updatedby TEXT);
INSERT INTO domains (id, url, ip, priority, intern, enable, childlvl, updated, updatedby) VALUES (0, 'antolin.de', '217.13.73.6', 0, 0, 1, 1, NULL, NULL);

COMMIT TRANSACTION;
PRAGMA foreign_keys = on;