File indexing completed on 2024-05-12 04:45:55
0001 CREATE TABLE IF NOT EXISTS NOTES ( 0002 id TEXT PRIMARY KEY, 0003 url TEXT NOT NULL, 0004 color TEXT, 0005 favorite INT 0006 ); 0007 0008 CREATE TABLE IF NOT EXISTS NOTES_SYNC ( 0009 id TEXT, 0010 server TEXT, 0011 user TEXT, 0012 stamp TEXT, 0013 PRIMARY KEY(server, stamp), 0014 FOREIGN KEY(id) REFERENCES NOTES(id) 0015 ); 0016 0017 CREATE TABLE IF NOT EXISTS BOOKS ( 0018 title TEXT PRIMARY KEY, 0019 url TEXT NOT NULL 0020 ); 0021 0022 CREATE TABLE IF NOT EXISTS BOOKLETS ( 0023 id TEXT, 0024 book TEXT, 0025 url TEXT NOT NULL, 0026 PRIMARY KEY(id, book), 0027 FOREIGN KEY(book) REFERENCES BOOKS(id) 0028 ); 0029 0030 CREATE TABLE IF NOT EXISTS BOOKLETS_SYNC ( 0031 id TEXT, 0032 server TEXT, 0033 user TEXT, 0034 stamp TEXT, 0035 PRIMARY KEY(server, stamp), 0036 FOREIGN KEY(id) REFERENCES BOOKLETS(id) 0037 ); 0038 0039 CREATE TABLE IF NOT EXISTS LINKS ( 0040 url TEXT PRIMARY KEY, 0041 title TEXT, 0042 preview TEXT, 0043 favorite INT, 0044 adddate DATE, 0045 modified DATE 0046 );