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 file file 23 CREATE TABLE file( isdir boolean, base text, dir text, lastcn int, unique(dir,base) )
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 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 markup markup 15 CREATE TABLE markup( markup text primary key, type int, formatter text, description text )
table reportfmt reportfmt 30 CREATE TABLE reportfmt( rn integer primary key, owner text, title text, description text, cols text, sqlcode 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 tool tool 25 CREATE TABLE tool( name text primary key, perms text, object text, command text, description 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 wiki wiki 27 CREATE TABLE wiki( name text, invtime int, locked boolean, who text, ipaddr text, text clob, reason text, UNIQUE(name,invtime) )
table xref xref 22 CREATE TABLE xref( tn int, cn int )
Rows: 17