| EXPECTED_DATABASE_VERSION |
= |
"3" |
| SCHEMA |
= |
%q{ CREATE TABLE meta ( key TEXT PRIMARY KEY, value TEXT ); CREATE TABLE entry ( itemid INTEGER PRIMARY KEY, anum INTEGER, subject TEXT, event TEXT, moodid INTEGER, mood TEXT, music TEXT, location TEXT, taglist TEXT, pickeyword TEXT, preformatted INTEGER, backdated INTEGER, comments INTEGER, year INTEGER, month INTEGER, day INTEGER, timestamp INTEGER, security INTEGER ); CREATE INDEX dateindex ON entry (year, month, day); CREATE INDEX timeindex ON entry (timestamp); CREATE TABLE comment ( commentid INTEGER PRIMARY KEY, posterid INTEGER, itemid INTEGER, parentid INTEGER, state TEXT, -- screened/deleted/active subject TEXT, body TEXT, timestamp INTEGER -- unix timestamp ); CREATE INDEX commententry ON comment (itemid); CREATE TABLE users ( userid INTEGER PRIMARY KEY, username TEXT ); CREATE TABLE commentprop ( commentid INTEGER, -- not primary key 'cause non-unique key TEXT, value TEXT ); }.gsub(/^ /, '') |