GRANT USAGE ON wakka.* TO 'wakka'@'localhost' IDENTIFIED BY '@wakkapass@';

GRANT SELECT, INSERT, UPDATE, DELETE ON wakka.* TO 'wakka'@'localhost';

CREATE DATABASE IF NOT EXISTS wakka;
USE wakka;

CREATE TABLE IF NOT EXISTS `wakka_pages` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`tag` varchar(50) NOT NULL default '',
	`time` datetime NOT NULL default '0000-00-00 00:00:00',
	`body` text NOT NULL,
	`body_r` text NOT NULL,
	`owner` varchar(50) NOT NULL default '',
	`user` varchar(50) NOT NULL default '',
	`latest` enum('Y','N') NOT NULL default 'N',
	`handler` varchar(30) NOT NULL default 'page',
	`comment_on` varchar(50) NOT NULL default '',
	PRIMARY KEY (`id`),
	FULLTEXT KEY tag (`tag`, `body`),
	KEY idx_tag (`tag`),
	KEY idx_time (`time`),
	KEY idx_latest (`latest`),
	KEY idx_comment_on (`comment_on`)
	) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS `wakka_acls` (
	`page_tag` varchar(50) NOT NULL default '',
	`privilege` varchar(20) NOT NULL default '',
	`list` text NOT NULL,
	PRIMARY KEY (`page_tag`, `privilege`)
	) TYPE=MyISAM;

CREATE TABLE `wakka_links` (
	`from_tag` char(50) NOT NULL default '',
	`to_tag` char(50) NOT NULL default '',
	UNIQUE KEY from_tag (`from_tag`, `to_tag`),
	KEY idx_from (`from_tag`),
	KEY idx_to (`to_tag`)
	) TYPE=MyISAM;

CREATE TABLE `wakka_referrers` (
	`page_tag` char(50) NOT NULL default '',
	`referrer` char(150) NOT NULL default '',
	`time` datetime NOT NULL default '0000-00-00 00:00:00',
	KEY idx_page_tag (`page_tag`),
	KEY idx_time (`time`)
	) TYPE=MyISAM;

CREATE TABLE `wakka_users` (
	`name` varchar(80) NOT NULL default '',
	`password` varchar(32) NOT NULL default '',
	`email` varchar(50) NOT NULL default '',
	`motto` text NOT NULL,
	`revisioncount` int(10) unsigned NOT NULL default '20',
	`changescount` int(10) unsigned NOT NULL default '50',
	`doubleclickedit` enum('Y','N') NOT NULL default 'Y',
	`signuptime` datetime NOT NULL default '0000-00-00 00:00:00',
	`show_comments` enum('Y','N') NOT NULL default 'N',
	PRIMARY KEY (`name`),
	KEY idx_name (`name`),
	KEY idx_signuptime (`signuptime`)
	) TYPE=MyISAM;

INSERT INTO `wakka_pages` SET
	`tag` = 'HomePage',
	`body` = 'Welcome to your Wakka site! Click on the \"Edit this page\" link at the bottom to get started.\n\nAlso don\'t forget to visit [[WakkaWiki:WakkaWiki WakkaWiki]]!\n\nUseful pages: OrphanedPages, WantedPages, TextSearch.',
	`user` = 'WakkaInstaller',
	`time` = now(),
	`latest` = 'Y';

INSERT INTO `wakka_pages` SET
	`tag` = 'RecentChanges',
	`body` = '{{RecentChanges}}',
	`user` = 'WakkaInstaller',
	`time` = now(),
	`latest` = 'Y';

INSERT INTO `wakka_pages` SET
	`tag` = 'RecentlyCommented',
	`body` = '{{RecentlyCommented}}',
	`user` = 'WakkaInstaller',
	`time` = now(),
	`latest` = 'Y';

INSERT INTO `wakka_pages` SET
	`tag` = 'UserSettings',
	`body` = '{{UserSettings}}',
	`user` = 'WakkaInstaller',
	`time` = now(),
	`latest` = 'Y';

INSERT INTO `wakka_pages` SET
	`tag` = 'PageIndex',
	`body` = '{{PageIndex}}',
	`user` = 'WakkaInstaller',
	`time` = now(),
	`latest` = 'Y';

INSERT INTO `wakka_pages` SET
	`tag` = 'WantedPages',
	`body` = '{{WantedPages}}',
	`user` = 'WakkaInstaller',
	`time` = now(),
	`latest` = 'Y';

INSERT INTO `wakka_pages` SET
	`tag` = 'OrphanedPages',
	`body` = '{{OrphanedPages}}',
	`user` = 'WakkaInstaller',
	`time` = now(),
	`latest` = 'Y';

INSERT INTO `wakka_pages` SET
	`tag` = 'TextSearch',
	`body` = '{{TextSearch}}',
	`user` = 'WakkaInstaller',
	`time` = now(),
	`latest` = 'Y';

INSERT INTO `wakka_pages` SET
	`tag` = 'MyPages',
	`body` = '{{MyPages}}',
	`user` = 'WakkaInstaller',
	`time` = now(),
	`latest` = 'Y';

INSERT INTO `wakka_pages` SET
	`tag` = 'MyChanges',
	`body` = '{{MyChanges}}',
	`user` = 'WakkaInstaller',
	`time` = now(),
	`latest` = 'Y';

INSERT INTO `wakka_pages` SET
	`tag` = 'PageIndex',
	`body` = '{{PageIndex}}',
	`user` = 'WakkaInstaller',
	`time` = now(),
	`latest` = 'Y';