You can use the following MySQL dump to create your Tavi database. Either feed it directly to the mysql command line utility, or to an administration tool such as [PhpMyAdmin].

Please remember that the Tavi database must already be created at this point. Use the aforementioned tools too to do that.

CREATE TABLE `interwiki` (
  `prefix` varchar(80) NOT NULL default '',
  `where_defined` varchar(80) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`prefix`)
);

CREATE TABLE `links` (
  `page` varchar(80) NOT NULL default '',
  `link` varchar(80) NOT NULL default '',
  `count` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`page`,`link`)
);

CREATE TABLE `pages` (
  `title` varchar(80) NOT NULL default '',
  `version` int(10) unsigned NOT NULL default '1',
  `time` timestamp(14) NOT NULL,
  `supercede` timestamp(14) NOT NULL,
  `mutable` set('off','on') NOT NULL default 'on',
  `username` varchar(80) default NULL,
  `author` varchar(80) NOT NULL default '',
  `comment` varchar(80) NOT NULL default '',
  `body` text,
  PRIMARY KEY  (`title`,`version`)
);

CREATE TABLE `rate` (
  `ip` char(20) NOT NULL default '',
  `time` timestamp(14) NOT NULL,
  `viewLimit` smallint(5) unsigned default NULL,
  `searchLimit` smallint(5) unsigned default NULL,
  `editLimit` smallint(5) unsigned default NULL,
  PRIMARY KEY  (`ip`)
);

CREATE TABLE `remote_pages` (
  `page` varchar(80) NOT NULL default '',
  `site` varchar(80) NOT NULL default '',
  PRIMARY KEY  (`page`,`site`)
);

CREATE TABLE `sisterwiki` (
  `prefix` varchar(80) NOT NULL default '',
  `where_defined` varchar(80) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`prefix`)
);