Return to DB_Format.sql CVS log

Up to [local] / palm / MemoDB2ClassicNote

Annotation of palm/MemoDB2ClassicNote/DB_Format.sql, Revision 1.1

1.1     ! andrew      1: -- $AFresh1$
        !             2: BEGIN TRANSACTION;
        !             3:     CREATE TABLE __WebKitDatabaseInfoTable__ (
        !             4:         key TEXT NOT NULL ON CONFLICT FAIL UNIQUE ON CONFLICT REPLACE,
        !             5:         value TEXT NOT NULL ON CONFLICT FAIL
        !             6:     );
        !             7:     INSERT INTO __WebKitDatabaseInfoTable__ VALUES('WebKitDatabaseVersionKey','');
        !             8:
        !             9:     CREATE TABLE categories (
        !            10:         cat_id INTEGER PRIMARY KEY,
        !            11:         category TEXT,
        !            12:         templ_id INTEGER DEFAULT 0,
        !            13:         color INTEGER DEFAULT 0,
        !            14:         passwd INTEGER DEFAULT 0
        !            15:     );
        !            16:     -- INSERT INTO categories VALUES(0,'undefined',0,0,0);
        !            17:
        !            18:     CREATE TABLE keywords (
        !            19:         kw_id INTEGER PRIMARY KEY,
        !            20:         color INTEGER,
        !            21:         keyword TEXT
        !            22:     );
        !            23:
        !            24:     CREATE TABLE memos (
        !            25:         memo_id INTEGER PRIMARY KEY,
        !            26:         cat_id INTEGER,
        !            27:         head TEXT,
        !            28:         memo TEXT,
        !            29:         pos INTEGER DEFAULT 0,
        !            30:         level INTEGER DEFAULT 0,
        !            31:         keyword INTEGER DEFAULT 0,
        !            32:         privat INTEGER DEFAULT 0,
        !            33:         created TIMESTAMP,
        !            34:         changed TIMESTAMP
        !            35:     );
        !            36:
        !            37:     CREATE TABLE version (dbver INTEGER PRIMARY KEY);
        !            38:     INSERT INTO version VALUES(1);
        !            39:     INSERT INTO version VALUES(2);
        !            40: COMMIT;