Here is the table structure, I was extract from create-db.pl :
- (homedb)
- links
- page varchar(80) NOT NULL
- link varchar(80) NOT NULL
- count integer default 0
- PRIMARY KEY (page,link)
- pages
- title varchar(80) NOT NULL
- version int(10) unsigned DEFAULT '1'
- time timestamp(14)
- supercede timestamp(14)
- mutable set('off', 'on') DEFAULT 'on' NOT NULL
- username varchar(80)
- author varchar(80) DEFAULT '' NOT NULL
- comment varchar(80) DEFAULT '' NOT NULL
- body text
- PRIMARY KEY (title, version)
- rate
- ip char(20) DEFAULT '' NOT NULL
- time timestamp(14)
- viewLimit smallint(5) unsigned
- searchLimit smallint(5) unsigned
- editLimit smallint(5) unsigned
- PRIMARY KEY (ip)
- interwiki
- prefix varchar(80) NOT NULL
- where_defined varchar(80) NOT NULL
- url varchar(255) DEFAULT '' NOT NULL
- primary key (prefix)
- sisterwiki
- prefix varchar(80) NOT NULL
- where_defined varchar(80) NOT NULL
- url varchar(255) DEFAULT '' NOT NULL
- primary key (prefix)
- remotepages
- page varchar(80) NOT NULL
- site varchar(80) NOT NULL
- primary key (page,site)