CREATE TABLE `community` (
`community_id` int(10) unsigned NOT NULL auto_increment,
`community_title` varchar(100) collate utf8_unicode_ci NOT NULL default '',
`community_description` text collate utf8_unicode_ci,
`community_address` varchar(20) collate utf8_unicode_ci NOT NULL default '',
`is_closed` smallint(1) unsigned default NULL,
`community_points` double NOT NULL default '0',
`community_members` int(10) unsigned NOT NULL default '0',
`community_added` datetime default '0000-00-00 00:00:00',
`is_banned` smallint(1) unsigned default NULL,
`ban_reason` text collate utf8_unicode_ci,
`ban_time` datetime default NULL,
`community_topics` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`community_id`),
KEY `community_address` (`community_address`),
KEY `community_points` (`community_points`),
KEY `community_members` (`community_members`),
KEY `community_topics` (`community_topics`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE `community_tags` (
`tag_id` int(10) unsigned NOT NULL default '0',
`community_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tag_id`,`community_id`),
KEY `FK_community_tags_2` (`community_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE `community_users` (
`community_id` int(10) unsigned NOT NULL default '0',
`user_id` int(10) unsigned NOT NULL default '0',
`is_owner` smallint(1) unsigned default NULL,
`is_moderator` smallint(1) unsigned default NULL,
`is_banned` text collate utf8_unicode_ci,
`is_invited` datetime default NULL,
`is_asker` datetime default NULL,
`joined_date` datetime default NULL,
PRIMARY KEY (`community_id`,`user_id`),
KEY `community_id` (`community_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
ALTER TABLE `topics` ADD `community_id` INT( 10 ) UNSIGNED default NULL ;
ALTER TABLE `topics` ADD `is_hidden` INT( 1 ) UNSIGNED default NULL;
надо в инструкции это вынести
Я вспомнил, что конфиг в новой версии поменялся и поэтому стоит записать сначала новый а потом его настроить. Возможно в этом грабля?
Написать комментарий