You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
34 lines
927 B
34 lines
927 B
/* polls sqlite database */
|
|
/* create a table polls (id, descrip, published, updated) */
|
|
/* create a table pollques (id, pollid, question) */
|
|
/* create a table pollans (id, pollid, pollquesid, answer, totlvotes) */
|
|
/* create a table pollresp (id, pollid, pollquesid, pollansid, datetime) */
|
|
CREATE TABLE polls (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
descrip TEXT,
|
|
username TEXT,
|
|
published INTEGER,
|
|
updated INTEGER
|
|
);
|
|
|
|
CREATE TABLE pollques (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
pollid INTEGER,
|
|
question TEXT
|
|
);
|
|
|
|
CREATE TABLE pollans (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
pollid INTEGER,
|
|
pollquesid INTEGER,
|
|
answer TEXT,
|
|
totlvotes INTEGER
|
|
);
|
|
|
|
CREATE TABLE pollresp (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
pollid INTEGER,
|
|
pollquesid INTEGER,
|
|
pollansid INTEGER,
|
|
datetime INTEGER
|
|
); |