db.schema
changeset 13 deb39a02243b
parent 9 32a383000254
child 15 164da420a326
equal deleted inserted replaced
12:ff85a4e74db7 13:deb39a02243b
     1 DROP TABLE IF EXISTS db;
     1 DROP TABLE IF EXISTS db;
     2 CREATE TABLE db (
     2 CREATE TABLE db (
     3     id INTEGER PRIMARY KEY, 
     3     id INTEGER PRIMARY KEY, 
     4     givenname TEXT, surname TEXT, mail TEXT, tel TEXT,
     4     givenname TEXT, surname TEXT, mail TEXT, tel TEXT,
     5     uuid TEXT UNIQUE, 
     5     uuid TEXT UNIQUE, 
     6     timestamp BIGINT, 
     6     created INT,
     7     ack bool DEFAULT NULL,
     7     confirmed INT DEFAULT NULL,
     8     payed INT DEFAULT NULL);
     8     payed INT DEFAULT NULL);