diff options
Diffstat (limited to 'data/database/tables-SQLite.sql')
| -rwxr-xr-x | data/database/tables-SQLite.sql | 35 |
1 files changed, 0 insertions, 35 deletions
diff --git a/data/database/tables-SQLite.sql b/data/database/tables-SQLite.sql deleted file mode 100755 index 7d68786..0000000 --- a/data/database/tables-SQLite.sql +++ /dev/null @@ -1,35 +0,0 @@ -CREATE TABLE serverlist( - id INTEGER PRIMARY KEY AUTOINCREMENT, - ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0', - port INTEGER NOT NULL DEFAULT 0, - gamename VARCHAR(100) NOT NULL DEFAULT ' ', - gamever VARCHAR(50) NOT NULL DEFAULT ' ', - hostname VARCHAR(100) NOT NULL DEFAULT ' ', - hostport INTEGER NOT NULL DEFAULT 0, - country VARCHAR(5), - b333ms BOOLEAN NOT NULL DEFAULT 0, - blacklisted BOOLEAN NOT NULL DEFAULT 0, - added timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP, - beacon timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP, - updated timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP -); - -CREATE TABLE pending( - id INTEGER PRIMARY KEY AUTOINCREMENT, - ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0', - beaconport INTEGER NOT NULL DEFAULT 0, - heartbeat INTEGER NOT NULL DEFAULT 0, - gamename VARCHAR(25) NOT NULL DEFAULT ' ', - secure VARCHAR(12) NOT NULL DEFAULT ' ', - enctype INTEGER NOT NULL DEFAULT 0, - added timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP -); - -CREATE TABLE games( - gamename VARCHAR(50) NOT NULL, - cipher VARCHAR(10) NOT NULL DEFAULT ' ', - description VARCHAR(200) NOT NULL DEFAULT ' ', - default_qport INTEGER NOT NULL DEFAULT 0, - num_uplink INTEGER NOT NULL DEFAULT 0, - num_total INTEGER NOT NULL DEFAULT 0 -); |