.ht.sqlite1 lines ISO-8859-1 Unix (LF) SQLite format 3 @ -%
, h, : ) 3 anonymousAnonymous userplain2013-09-26 06:13:50 ') ]]3 rootThe Root Userroot@dbwebb.sesha1saltd21c9f16483f2261fc0477cdc006ff6d31ebd52372a6ae9365335d284648708c6bd516f24d586b4f2013-09-26 06:13:50
+ )3 userThe User Group2013-09-26 06:13:505 ;3 adminThe Administrator Group2013-09-26 06:13:50
32013-09-26 06:13:50 32013-09-26 06:13:50
P h3tableUserUserCREATE TABLE User (id INTEGER PRIMARY KEY, acronym TEXT KEY, name TEXT, email TEXT, meta TEXT, algorithm TEXT, salt TEXT, password TEXT, created DATETIME default (datetime('now')), updated DATETIME default NULL)-5tableGroupsGroupsCREATE TABLE Groups (id INTEGER PRIMARY KEY, acronym TEXT KEY, name TEXT, created DATETIME default (datetime('now')), updated DATETIME default NULL))##tableUser2GroupsUser2GroupsCREATE TABLE User2Groups (idUser INTEGER, idGroups INTEGER, created DATETIME default (datetime('now')), PRIMARY KEY(idUser, idGroups))5I# indexsqlite_autoindex_User2Groups_1User2Groupsw AtableCategoryCategoryCREATE TABLE Category (id INTEGER PRIMARY KEY, key TEXT KEY, title TEXT, description TEXT)
[D o5tableContentContentCREATE TABLE Content (id INTEGER PRIMARY KEY, key TEXT KEY, type TEXT, idCategory INT default null, title TEXT, data TEXT, datafile TEXT default NULL, filter TEXT, url TEXT KEY, breadcrumb TEXT, parenttitle TEXT, template TEXT, idUser INT, created DATETIME default (datetime('now')), updated DATETIME default NULL, deleted DATETIME default NULL, published DATETIME default NULL, FOREIGN KEY(idUser) REFERENCES User(id), FOREIGN KEY(idCategory) REFERENCES Category(id))IytableDocsDocsCREATE VIRTUAL TABLE Docs USING fts4(key, title, data)y%%5tableDocs_contentDocs_content
CREATE TABLE 'Docs_content'(docid INTEGER PRIMARY KEY, 'c0key', 'c1title', 'c2data')l ''tableDocs_segmentsDocs_segments CREATE TABLE 'Docs_segments'(blockid INTEGER PRIMARY KEY, block BLOB)9
##9tableDocs_segdirDocs_segdir CREATE TABLE 'Docs_segdir'(level INTEGER,idx INTEGER,start_block INTEGER,leaves_end_block INTEGER,end_block INTEGER,root BLOB,PRIMARY KEY(level, idx))
g ' g [tableGuestbookGuestbookCREATE TABLE Guestbook (id INTEGER PRIMARY KEY, entry TEXT, created DATETIME default (datetime('now')))5 I# indexsqlite_autoindex_Docs_segdir_1Docs_segdir
f %%tableDocs_docsizeDocs_docsizeCREATE TABLE 'Docs_docsize'(docid INTEGER PRIMARY KEY, size BLOB)[
tableDocs_statDocs_statCREATE TABLE 'Docs_stat'(id INTEGER PRIMARY KEY, value BLOB)tableBookBookCREATE TABLE Book (id INTEGER PRIMARY KEY, key TEXT KEY, title TEXT, idUser INT, created DATETIME default (datetime('now')), updated DATETIME default NULL, published DATETIME default NULL, deleted DATETIME default NULL, FOREIGN KEY(idUser) REFERENCES User(id))uAtableChapterChapterCREATE TABLE Chapter (id INTEGER PRIMARY KEY, position INTEGER, idBook INTEGER, idContent INTEGER published DATETIME default NULL, FOREIGN KEY(idBook) REFERENCES Book(id), FOREIGN KEY(idContent) REFERENCES Content(id))