Описание таблиц
My SQL для
R4.0
Wacko Таблицы:
- wiki_acls
- wiki_cache
- wiki_links
- wiki_pages
- wiki_pagewatches
- wiki_referrers
- wiki_revisions
- wiki_upload
- wiki_users
CREATE TABLE `wackowiki_acls` (
`page_tag` varchar(250) binary NOT NULL default '',
`supertag` varchar(250) NOT NULL default '',
`privilege` varchar(20) NOT NULL default '',
`list` text NOT NULL,
PRIMARY KEY (`page_tag`,`privilege`),
KEY `supertag` (`supertag`)
) TYPE=MyISAM;
CREATE TABLE `wackowiki_cache` (
`name` varchar(32) NOT NULL default '',
`method` varchar(20) NOT NULL default '',
`query` varchar(100) NOT NULL default '',
KEY `name` (`name`)
) TYPE=MyISAM;
CREATE TABLE `wackowiki_links` (
`from_tag` varchar(250) binary NOT NULL default '',
`to_tag` varchar(250) binary NOT NULL default '',
`to_supertag` varchar(250) NOT NULL default '',
KEY `from_tag` (`from_tag`,`to_tag`),
KEY `idx_from` (`from_tag`),
KEY `idx_to` (`to_tag`)
) TYPE=MyISAM;
CREATE TABLE `wackowiki_pages` (
`id` int(10) unsigned NOT NULL auto_increment,
`tag` varchar(250) binary NOT NULL default '',
`supertag` varchar(250) NOT NULL default '',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
`body` text NOT NULL,
`body_r` text NOT NULL,
`body_toc` 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(250) binary NOT NULL default '',
`super_comment_on` varchar(250) NOT NULL default '',
`hits` int(11) NOT NULL default '0',
`lang` varchar(20) NOT NULL default '',
`description` varchar(250) NOT NULL default '',
`keywords` varchar(250) binary NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_tag` (`tag`),
KEY `idx_supertag` (`supertag`),
KEY `idx_time` (`time`),
KEY `idx_latest` (`latest`),
KEY `idx_comment_on` (`comment_on`),
KEY `idx_super_comment_on` (`super_comment_on`),
FULLTEXT KEY `body` (`body`)
) TYPE=MyISAM;
CREATE TABLE `wackowiki_pagewatches` (
`id` int(10) NOT NULL auto_increment,
`user` varchar(80) NOT NULL default '',
`tag` varchar(250) binary NOT NULL default '',
`time` timestamp(14) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
CREATE TABLE `wackowiki_referrers` (
`page_tag` char(250) binary 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 `wackowiki_revisions` (
`id` int(10) unsigned NOT NULL auto_increment,
`tag` varchar(250) binary NOT NULL default '',
`supertag` varchar(250) binary 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(250) binary NOT NULL default '',
`super_comment_on` varchar(250) NOT NULL default '',
`lang` varchar(20) NOT NULL default '',
`description` varchar(250) NOT NULL default '',
`keywords` varchar(250) binary NOT NULL default '',
PRIMARY KEY (`id`),
KEY `idx_tag` (`tag`),
KEY `idx_supertag` (`supertag`),
KEY `idx_time` (`time`),
KEY `idx_latest` (`latest`),
KEY `idx_comment_on` (`comment_on`)
) TYPE=MyISAM;
CREATE TABLE `wackowiki_upload` (
`id` int(11) NOT NULL auto_increment,
`page_id` int(11) NOT NULL default '0',
`filename` varchar(250) NOT NULL default '',
`description` varchar(250) NOT NULL default '',
`uploaded_dt` datetime NOT NULL default '0000-00-00 00:00:00',
`filesize` int(11) NOT NULL default '0',
`picture_w` int(11) NOT NULL default '0',
`picture_h` int(11) NOT NULL default '0',
`file_ext` varchar(10) NOT NULL default '',
`user` varchar(80) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `page_id` (`page_id`,`filename`),
KEY `page_id_2` (`page_id`,`uploaded_dt`),
KEY `user_id` (`user`,`page_id`)
) TYPE=MyISAM;
CREATE TABLE `wackowiki_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',
`bookmarks` text NOT NULL,
`lang` varchar(20) NOT NULL default '',
`show_spaces` enum('Y','N') NOT NULL default 'Y',
`showdatetime` enum('Y','N') NOT NULL default 'Y',
`typografica` enum('Y','N') NOT NULL default 'Y',
`more` text NOT NULL,
`changepassword` varchar(100) NOT NULL default '',
`email_confirm` varchar(40) NOT NULL default '',
PRIMARY KEY (`name`),
KEY `idx_name` (`name`),
KEY `idx_signuptime` (`signuptime`)
) TYPE=MyISAM;
