db.schema
changeset 36 221663a01729
parent 15 164da420a326
equal deleted inserted replaced
35:c2ac2609bd56 36:221663a01729
     1 DROP TABLE IF EXISTS db;
       
     2 CREATE TABLE db (
     1 CREATE TABLE db (
     3     id INTEGER PRIMARY KEY, 
     2     id INTEGER PRIMARY KEY, 
     4     givenname TEXT, surname TEXT, email TEXT, tel TEXT,
     3     givenname TEXT, surname TEXT, email TEXT, tel TEXT,
     5     uuid TEXT UNIQUE, 
     4     uuid TEXT UNIQUE, 
     6     created INT,
     5     created INT,
     7     confirmed INT DEFAULT NULL,
     6     confirmed INT DEFAULT NULL,
     8     payed INT DEFAULT NULL);
     7     payed INT DEFAULT NULL, pass INTEGER, rueck BOOL);