Цитата:
Сообщение от strelock
У меня нету таблицы такой в БД
|
создай таблицу db_l2jdc и зделай sql запрос:
Код:
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `clan_introductions`;
CREATE TABLE `clan_introductions` (
`serverId` int(8) NOT NULL,
`clanId` int(8) NOT NULL,
`introduction` text collate ucs2_bin NOT NULL,
PRIMARY KEY (`serverId`,`clanId`)
) ENGINE=MyISAM DEFAULT CHARSET=ucs2 COLLATE=ucs2_bin;
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
`serverId` int(8) NOT NULL default '0',
`comment_id` int(8) NOT NULL default '0',
`comment_ownerid` int(8) NOT NULL default '0',
`comment_date` decimal(20,0) NOT NULL default '0',
`comment_post_id` int(8) NOT NULL default '0',
`comment_topic_id` int(8) NOT NULL default '0',
`comment_forum_id` int(8) NOT NULL default '0',
`comment_txt` text collate ucs2_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=ucs2 COLLATE=ucs2_bin;
DROP TABLE IF EXISTS `forums`;
CREATE TABLE `forums` (
`serverId` int(8) NOT NULL default '0',
`forum_id` int(8) NOT NULL default '0',
`forum_name` varchar(255) collate ucs2_bin NOT NULL default '',
`forum_post` int(8) NOT NULL default '0',
`forum_type` int(8) NOT NULL default '0',
`forum_owner_id` int(8) NOT NULL default '0',
PRIMARY KEY (`serverId`,`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=ucs2 COLLATE=ucs2_bin;
DROP TABLE IF EXISTS `posts`;
CREATE TABLE `posts` (
`serverId` int(8) NOT NULL default '0',
`post_id` int(8) NOT NULL default '0',
`post_ownerid` int(8) NOT NULL default '0',
`post_recipient_list` varchar(255) collate ucs2_bin NOT NULL default '0',
`post_parent_id` int(8) NOT NULL default '0',
`post_date` decimal(20,0) NOT NULL default '0',
`post_topic_id` int(8) NOT NULL default '0',
`post_forum_id` int(8) NOT NULL default '0',
`post_txt` text collate ucs2_bin NOT NULL,
`post_title` text collate ucs2_bin,
`post_type` int(8) NOT NULL default '0',
`post_read_count` int(8) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=ucs2 COLLATE=ucs2_bin;
DROP TABLE IF EXISTS `registered_gameservers`;
CREATE TABLE `registered_gameservers` (
`serverId` int(11) NOT NULL default '0',
`hex_id` varchar(50) collate ucs2_bin NOT NULL default '',
`host` varchar(50) collate ucs2_bin NOT NULL default '',
PRIMARY KEY (`serverId`)
) ENGINE=MyISAM DEFAULT CHARSET=ucs2 COLLATE=ucs2_bin;
DROP TABLE IF EXISTS `topics`;
CREATE TABLE `topics` (
`serverId` int(8) NOT NULL default '0',
`topic_id` int(8) NOT NULL default '0',
`topic_forum_id` int(8) NOT NULL default '0',
`topic_name` varchar(255) collate ucs2_bin NOT NULL default '',
`topic_ownerid` int(8) NOT NULL default '0',
`topic_permissions` int(8) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=ucs2 COLLATE=ucs2_bin;