changeset 13 | deb39a02243b |
parent 9 | 32a383000254 |
child 15 | 164da420a326 |
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); |