| changeset 15 | 164da420a326 |
| parent 13 | deb39a02243b |
| child 36 | 221663a01729 |
| 14:2de6e3df1dd2 | 15:164da420a326 |
|---|---|
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, email TEXT, tel TEXT, |
5 uuid TEXT UNIQUE, |
5 uuid TEXT UNIQUE, |
6 created INT, |
6 created INT, |
7 confirmed INT DEFAULT NULL, |
7 confirmed INT DEFAULT NULL, |
8 payed INT DEFAULT NULL); |
8 payed INT DEFAULT NULL); |