type | name | tbl_name | rootpage | sql |
---|---|---|---|---|
table | access_load | access_load | 2 | CREATE TABLE access_load( ipaddr text primary key, lastaccess time, load real, captcha int ) |
table | attachment | attachment | 4 | CREATE TABLE attachment( atn integer primary key, tn int, size int, date int, user text, mime text, fname text, description text, content blob ) |
table | chng | chng | 5 | CREATE TABLE chng( cn integer primary key, date int, branch text, milestone int, user text, directory text, message text ) |
table | config | config | 6 | CREATE TABLE config( name text primary key, value text ) |
table | cookie | cookie | 8 | CREATE TABLE cookie( cookie char(32) primary key, user text, expires int, ipaddr varchar(32), agent text ) |
table | enums | enums | 10 | CREATE TABLE enums( type text, idx int, name text, value text, color text ) |
table | filechng | filechng | 12 | CREATE TABLE filechng( cn int, filename text, vers text, prevvers text, chngtype int, nins int, ndel int, UNIQUE(filename,vers) ) |
table | markup | markup | 15 | CREATE TABLE markup( markup text primary key, type int, formatter text, description text ) |
table | ticket | ticket | 17 | CREATE TABLE ticket( tn integer primary key, type text, status text, origtime int, changetime int, derivedfrom int, version text, assignedto text, severity int, priority text, subsystem text, owner text, title text, contact text, extra1 numeric, extra2 numeric, extra3 numeric, extra4 numeric, extra5 numeric, description text, remarks text ) |
table | tktchng | tktchng | 18 | CREATE TABLE tktchng( tn int, user text, chngtime int, fieldid text, oldval text, newval text ) |
table | user | user | 19 | CREATE TABLE user( id text primary key, name text, email text, passwd text, notify text, http text, capabilities text ) |
table | xref | xref | 22 | CREATE TABLE xref( tn int, cn int ) |
table | file | file | 23 | CREATE TABLE file( isdir boolean, base text, dir text, lastcn int, unique(dir,base) ) |
table | tool | tool | 25 | CREATE TABLE tool( name text primary key, perms text, object text, command text, description text ) |
table | wiki | wiki | 27 | CREATE TABLE wiki( name text, invtime int, locked boolean, who text, ipaddr text, text clob, reason text, UNIQUE(name,invtime) ) |
table | inspect | inspect | 29 | CREATE TABLE inspect( cn integer not null, inspecttime int not null, inspector text not null, ticket int, result text, comment text ) |
table | reportfmt | reportfmt | 30 | CREATE TABLE reportfmt( rn integer primary key, owner text, title text, description text, cols text, sqlcode text ) |
Rows: 17