changeset 36 | 221663a01729 |
parent 15 | 164da420a326 |
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); |