documented db create

2 files changed, 2 insertions, 1 deletions

diff --git a/Readme b/Readme
index 3655f7c..711b410 100644
--- a/Readme
+++ b/Readme
@@ -2,4 +2,4 @@
 
 Dump Database Structure:
 
-sudo -u www-data echo '.dump' | sqlite3 /srv/nzbget/datenbank.sqlite | grep CREATE
+echo '.dump' | sudo -u www-data sqlite3 /srv/nzbget/datenbank.sqlite | grep CREATE > create_db.sql
diff --git a/create_db.sql b/create_db.sql
index e0fade0..acaf064 100644
--- a/create_db.sql
+++ b/create_db.sql
@@ -2,3 +2,4 @@ CREATE TABLE download(download_id INTEGER PRIMARY KEY ASC,owner INTEGER, size IN
 CREATE TABLE category (category_id INTEGER PRIMARY KEY ASC, name text);
 CREATE TABLE owner (owner_id INTEGER PRIMARY KEY ASC, name text, quoata INTEGER DEFAULT 100000, quota_used INTEGER DEFAULT 0);
 CREATE TABLE seen ( seen_id INTEGER PRIMARY KEY ASC , download INTEGER , user INTEGER);
+CREATE TABLE ip(ip_id INTEGER PRIMARY KEY ASC,owner INTEGER, subnet text, mask INTEGER);