Jump to content
  • 0

mysql erro syntax

Scofield

Asked by Scofield,

 Share

Question

Scofield Marin

Scofield

Posted
  • Group:  Members
  • Topic Count:  107
  • Topics Per Day:  0.03
  • Content Count:  265
  • Reputation:   11
  • Joined:  01/11/13
  • Last Seen:  
Posted (edited)

I try to apply this db but always give error, I believe it is because she is too old

 

if someone can correct me thank

 

ERRO:  #1064 - You have an error in your SQL syntax; check the manual
that corresponds to your MariaDB server version for the right syntax to
use near 'TYPE=MyISAM AUTO_INCREMENT=1' at line 8

#
# Database : `sgcp`
#

DROP TABLE IF EXISTS `mainnews`;
CREATE TABLE `mainnews` (
  `post_id` int(11) NOT NULL auto_increment,
  `title` varchar(60) NOT NULL,
  `message` text NOT NULL,
  `poster` text NOT NULL,
  `date` varchar(255) NOT NULL,
  PRIMARY KEY  (`post_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `privilege`;
CREATE TABLE `privilege` (
  `account_id` int(11) NOT NULL default '0',
  `privilege` int(11) NOT NULL default '0',
  PRIMARY KEY  (`account_id`)
) TYPE=MyISAM;
INSERT INTO `privilege` VALUES (704554,5);

DROP TABLE IF EXISTS `bugreport`;
CREATE TABLE `bugreport` (
  `post_id` int(11) NOT NULL auto_increment,
  `report` text NOT NULL,
  `poster` text NOT NULL,
  `sex` char(1) NOT NULL default 'M',
  `ip` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  PRIMARY KEY  (`post_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `forum`;
CREATE TABLE `forum` (
  `forum_id` int(11) NOT NULL auto_increment,
  `category_id` int(11) NOT NULL,
  `forum_title` varchar(255) default '',
  `forum_description` varchar(255) default '',
  `forum_perm` mediumtext NOT NULL,
  PRIMARY KEY  (`forum_id`)
) TYPE=MyISAM;
INSERT INTO `forum` (category_id,forum_title,forum_description,forum_perm) VALUES ('1','A Test Forum','A test forum that may be removed at any time','[g1]:show_perm::read_perm::reply_perm::start_perm:[/g1][g2]:show_perm::read_perm::reply_perm::start_perm:[/g2][g3][/g3][g4]:show_perm::read_perm::reply_perm::start_perm:[/g4][g5]:show_perm::read_perm::reply_perm::start_perm:[/g5]');

DROP TABLE IF EXISTS `board_reply`;
CREATE TABLE `board_reply` (
  `reply_id` int(11) NOT NULL auto_increment,
  `topic_id` int(11) NOT NULL,
  `forum_id` int(11) NOT NULL,
  `reply_user_id` varchar(255) default '',
  `reply_emo` int(11) NOT NULL,
  `reply_message` text,
  `reply_ip` varchar(255) NOT NULL default '0.0.0.0',
  `reply_date` varchar(255) default '',
  `reply_upload` varchar(255) default '',
  `reply_edit_name` varchar(255) default '',
  `reply_edit_date` varchar(255) default '',
  PRIMARY KEY  (`reply_id`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `board_topic`;
CREATE TABLE `board_topic` (
  `topic_id` int(11) NOT NULL auto_increment,
  `forum_id` int(11) NOT NULL,
  `pinned_mode` varchar(255) NOT NULL default '0',
  `closed_mode` varchar(255) NOT NULL default '0',
  `topic_name` varchar(255) default '',
  `topic_description` varchar(255) default '',
  `topic_starter` varchar(255) NOT NULL default '',
  `topic_reading` varchar(255) NOT NULL default '0',
  `topic_replying` varchar(255) NOT NULL default '0',
  `topic_lastreply_name` varchar(255) default '',
  `topic_start_date` varchar(255) default '',
  `topic_last_action_date` varchar(255) default '',
  PRIMARY KEY  (`topic_id`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `user_profile`;
CREATE TABLE `user_profile` (
  `user_number` int(11) unsigned NOT NULL auto_increment,
  `user_id` int(11) unsigned NOT NULL,
  `display_name` varchar(255)  NOT NULL default '',
  `user_sls_pass` varchar(255)  NOT NULL default '',
  `user_time_offset` varchar(255) default '',
  `user_ranking` varchar(255) NOT NULL default '0',
  `user_avatar` varchar(255) default '',
  `user_avatar_width` varchar(255) NOT NULL default '0',
  `user_avatar_height` varchar(255) NOT NULL default '0',
  `user_signature_message` text,
  `user_flood_protection` varchar(12) NOT NULL default '0',
  `user_joined` varchar(255) default '',
  `user_last_login` varchar(255) default '',
  `user_online` tinyint(1) default '0',
  PRIMARY KEY  (`user_number`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `status`;
CREATE TABLE `status` (
  `last_checked` varchar(255) NOT NULL default '',
  `login` int(11) NOT NULL default '0',
  `char` int(11) NOT NULL default '0',
  `map` int(11) NOT NULL default '0',
  PRIMARY KEY  (`last_checked`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `user_online`;
CREATE TABLE `user_online` (
  `session` char(100) NOT NULL,
  `time` int(11) DEFAULT '0' NOT NULL
) TYPE=MyISAM;

DROP TABLE IF EXISTS `poll`;
CREATE TABLE `poll` (
  `poll_id` int(11) NOT NULL auto_increment,
  `topic_id` int(11) NOT NULL,
  `starter_id` varchar(255) default '',
  `last_vote_date` varchar(255) default '',
  `poll_question` varchar(255) default '',
  `choice1` text,
  `choice2` text,
  `choice3` text,
  `choice4` text,
  `choice5` text,
  `choice6` text,
  `choice7` text,
  `choice8` text,
  `choice9` text,
  `choice10` text,
  PRIMARY KEY  (`poll_id`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `poll_vote`;
CREATE TABLE `poll_vote` (
  `poll_id` int(11) NOT NULL auto_increment,
  `topic_id` int(11) NOT NULL,
  `vote1` int(11) default '0',
  `vote2` int(11) default '0',
  `vote3` int(11) default '0',
  `vote4` int(11) default '0',
  `vote5` int(11) default '0',
  `vote6` int(11) default '0',
  `vote7` int(11) default '0',
  `vote8` int(11) default '0',
  `vote9` int(11) default '0',
  `vote10` int(11) default '0',
  PRIMARY KEY  (`poll_id`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `voters`;
CREATE TABLE `voters` (
  `vid` int(11) NOT NULL auto_increment,
  `ip_address` varchar(255) default '',
  `vote_date` varchar(255) default '',
  `topic_id` varchar(255) default '',
  `member_id` varchar(255) default '',
  PRIMARY KEY  (`vid`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups` (
  `g_id` int(11) NOT NULL auto_increment,
  `g_title` varchar(32) default '',
  `g_img` varchar(255) default '',
  `g_color` varchar(255) default '',
  `g_view_board` tinyint(1),
  `g_post_new_topics` tinyint(1),
  `g_post_polls` tinyint(1),
  `g_vote_polls` tinyint(1),
  `g_edit_topics` tinyint(1),
  `g_edit_posts` tinyint(1),
  `g_delete_topics` tinyint(1),
  `g_delete_posts` tinyint(1),
  `g_move_topics` tinyint(1),
  `g_file_upload` tinyint(1),
  `g_avatar_upload` tinyint(1),
  `g_pinned_topics` tinyint(1),
  `g_closed_topics` tinyint(1),
  `g_read_news` tinyint(1),
  `g_read_privilege` tinyint(1),
  `g_add_news` tinyint(1),
  `g_add_privilege` tinyint(1),
  `g_edit_news` tinyint(1),
  `g_edit_privilege` tinyint(1),
  `g_delete_news` tinyint(1),
  `g_delete_privilege` tinyint(1),
  `g_delete_id` tinyint(1),
  `g_view_lastestcp` tinyint(1),
  `g_view_adminmenu` tinyint(1),
  `g_view_topic_option` tinyint(1),
  `g_upload_nonlimit` int(11),
  `g_post_closed_topics` tinyint(1),
  `g_non_showip` tinyint(1),
  `g_no_delay_posts` tinyint(1),
  `g_view_userip` tinyint(1),
  `g_searching_id` tinyint(1),
  `g_edit_rank_title` tinyint(1),
  `g_edit_mes_control` tinyint(1),
  `g_forum_manage` tinyint(1),
  `g_account_manage` tinyint(1),
  PRIMARY KEY  (`g_id`)
) TYPE=MyISAM;
INSERT INTO `groups` VALUES (1,'Guest','guest.gif','',1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
INSERT INTO `groups` VALUES (2,'Member','member.gif','',1,1,1,1,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
INSERT INTO `groups` VALUES (3,'Banned','banned.gif','gray',1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
INSERT INTO `groups` VALUES (4,'Sub Admin','sub_admin.gif','green',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1,0,1,0,0,0,1,1,1,1,1,1,1,1,0,0,0,0);
INSERT INTO `groups` VALUES (5,'Administrator','admin.gif','red',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1);

DROP TABLE IF EXISTS `query_log`;
CREATE TABLE `query_log` (
  `action_id` int(11) NOT NULL auto_increment,
  `Date` datetime NOT NULL default '0000-00-00 00:00:00',
  `User` varchar(24) NOT NULL default '',
  `IP` varchar(20) NOT NULL default '',
  `page` varchar(24) NOT NULL default '',
  `query` text NOT NULL,
  PRIMARY KEY  (`action_id`),
  KEY `action_id` (`action_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `ranking_ignore`;
CREATE TABLE `ranking_ignore` (
  `account_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`account_id`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `security_code`;
CREATE TABLE `security_code` (
  `sc_id` text NOT NULL,
  `sc_code` varchar(11) NOT NULL default '0',
  `sc_time` int(11) NOT NULL default '0'
) TYPE=MyISAM;

DROP TABLE IF EXISTS `rank_title`;
CREATE TABLE `rank_title` (
  `title_id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '0',
  `min_post` int(11) NOT NULL default '0',
  PRIMARY KEY  (`title_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;
INSERT INTO `rank_title` VALUES (1,'Baby',0);
INSERT INTO `rank_title` VALUES (2,'Child',10);
INSERT INTO `rank_title` VALUES (3,'Adult',30);
INSERT INTO `rank_title` VALUES (4,'Major',50);
INSERT INTO `rank_title` VALUES (5,'Colonel',100);
INSERT INTO `rank_title` VALUES (6,'General',200);
INSERT INTO `rank_title` VALUES (7,'Sir',350);
INSERT INTO `rank_title` VALUES (8,'Baron',600);
INSERT INTO `rank_title` VALUES (9,'Marquis',900);
INSERT INTO `rank_title` VALUES (10,'King',1200);

DROP TABLE IF EXISTS `register_log`;
CREATE TABLE `register_log` (
  `reg_id` int(11) NOT NULL auto_increment,
  `Date` datetime NOT NULL default '0000-00-00 00:00:00',
  `account_id` int(11) unsigned NOT NULL,
  `userid` varchar(23) NOT NULL default '',
  `level` tinyint(3) NOT NULL default '0',
  `ip` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`reg_id`),
  KEY (`account_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `memory`;
CREATE TABLE `memory` (
  `memory_id` int(11) NOT NULL auto_increment,
  `memory_object` varchar(255) default '',
  `memory_value1` varchar(255) default '',
  `memory_value2` varchar(255) default '',
  `memory_value3` text,
  PRIMARY KEY  (`memory_id`)
) TYPE=MyISAM;
INSERT INTO `memory` (memory_object,memory_value1) VALUES ('sgcp_install','1');
INSERT INTO `memory` (memory_object,memory_value1) VALUES ('ro_message','Administrator');
INSERT INTO `memory` (memory_object,memory_value1,memory_value2,memory_value3) VALUES ('forum_category','1','1','A Test Category');
Edited by cumbe11
Link to comment
Share on other sites

2 answers to this question

Recommended Posts

Asura Poring

Asura

Posted
  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  707
  • Reputation:   168
  • Joined:  01/26/12
  • Last Seen:  
Posted

Hi cumbe11,

 

Instead of 'TYPE=MyISAM', should try using 'ENGINE=MyISAM'.

 

#
# Database : `sgcp`
#
 
DROP TABLE IF EXISTS `mainnews`;
CREATE TABLE `mainnews` (
  `post_id` int(11) NOT NULL auto_increment,
  `title` varchar(60) NOT NULL,
  `message` text NOT NULL,
  `poster` text NOT NULL,
  `date` varchar(255) NOT NULL,
  PRIMARY KEY  (`post_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;
 
DROP TABLE IF EXISTS `privilege`;
CREATE TABLE `privilege` (
  `account_id` int(11) NOT NULL default '0',
  `privilege` int(11) NOT NULL default '0',
  PRIMARY KEY  (`account_id`)
) ENGINE=MyISAM;
 
INSERT INTO `privilege` VALUES (704554,5);
 
DROP TABLE IF EXISTS `bugreport`;
CREATE TABLE `bugreport` (
  `post_id` int(11) NOT NULL auto_increment,
  `report` text NOT NULL,
  `poster` text NOT NULL,
  `sex` char(1) NOT NULL default 'M',
  `ip` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  PRIMARY KEY  (`post_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;
 
DROP TABLE IF EXISTS `forum`;
CREATE TABLE `forum` (
  `forum_id` int(11) NOT NULL auto_increment,
  `category_id` int(11) NOT NULL,
  `forum_title` varchar(255) default '',
  `forum_description` varchar(255) default '',
  `forum_perm` mediumtext NOT NULL,
  PRIMARY KEY  (`forum_id`)
) ENGINE=MyISAM;
INSERT INTO `forum` (category_id,forum_title,forum_description,forum_perm) VALUES ('1','A Test Forum','A test forum that may be removed at any time','[g1]:show_perm::read_perm::reply_perm::start_perm:[/g1][g2]:show_perm::read_perm::reply_perm::start_perm:[/g2][g3][/g3][g4]:show_perm::read_perm::reply_perm::start_perm:[/g4][g5]:show_perm::read_perm::reply_perm::start_perm:[/g5]');
 
DROP TABLE IF EXISTS `board_reply`;
CREATE TABLE `board_reply` (
  `reply_id` int(11) NOT NULL auto_increment,
  `topic_id` int(11) NOT NULL,
  `forum_id` int(11) NOT NULL,
  `reply_user_id` varchar(255) default '',
  `reply_emo` int(11) NOT NULL,
  `reply_message` text,
  `reply_ip` varchar(255) NOT NULL default '0.0.0.0',
  `reply_date` varchar(255) default '',
  `reply_upload` varchar(255) default '',
  `reply_edit_name` varchar(255) default '',
  `reply_edit_date` varchar(255) default '',
  PRIMARY KEY  (`reply_id`)
) ENGINE=MyISAM;
 
DROP TABLE IF EXISTS `board_topic`;
CREATE TABLE `board_topic` (
  `topic_id` int(11) NOT NULL auto_increment,
  `forum_id` int(11) NOT NULL,
  `pinned_mode` varchar(255) NOT NULL default '0',
  `closed_mode` varchar(255) NOT NULL default '0',
  `topic_name` varchar(255) default '',
  `topic_description` varchar(255) default '',
  `topic_starter` varchar(255) NOT NULL default '',
  `topic_reading` varchar(255) NOT NULL default '0',
  `topic_replying` varchar(255) NOT NULL default '0',
  `topic_lastreply_name` varchar(255) default '',
  `topic_start_date` varchar(255) default '',
  `topic_last_action_date` varchar(255) default '',
  PRIMARY KEY  (`topic_id`)
) ENGINE=MyISAM;
 
DROP TABLE IF EXISTS `user_profile`;
CREATE TABLE `user_profile` (
  `user_number` int(11) unsigned NOT NULL auto_increment,
  `user_id` int(11) unsigned NOT NULL,
  `display_name` varchar(255)  NOT NULL default '',
  `user_sls_pass` varchar(255)  NOT NULL default '',
  `user_time_offset` varchar(255) default '',
  `user_ranking` varchar(255) NOT NULL default '0',
  `user_avatar` varchar(255) default '',
  `user_avatar_width` varchar(255) NOT NULL default '0',
  `user_avatar_height` varchar(255) NOT NULL default '0',
  `user_signature_message` text,
  `user_flood_protection` varchar(12) NOT NULL default '0',
  `user_joined` varchar(255) default '',
  `user_last_login` varchar(255) default '',
  `user_online` tinyint(1) default '0',
  PRIMARY KEY  (`user_number`)
) ENGINE=MyISAM;
 
DROP TABLE IF EXISTS `status`;
CREATE TABLE `status` (
  `last_checked` varchar(255) NOT NULL default '',
  `login` int(11) NOT NULL default '0',
  `char` int(11) NOT NULL default '0',
  `map` int(11) NOT NULL default '0',
  PRIMARY KEY  (`last_checked`)
) ENGINE=MyISAM;
 
DROP TABLE IF EXISTS `user_online`;
CREATE TABLE `user_online` (
  `session` char(100) NOT NULL,
  `time` int(11) DEFAULT '0' NOT NULL
) ENGINE=MyISAM;
 
DROP TABLE IF EXISTS `poll`;
CREATE TABLE `poll` (
  `poll_id` int(11) NOT NULL auto_increment,
  `topic_id` int(11) NOT NULL,
  `starter_id` varchar(255) default '',
  `last_vote_date` varchar(255) default '',
  `poll_question` varchar(255) default '',
  `choice1` text,
  `choice2` text,
  `choice3` text,
  `choice4` text,
  `choice5` text,
  `choice6` text,
  `choice7` text,
  `choice8` text,
  `choice9` text,
  `choice10` text,
  PRIMARY KEY  (`poll_id`)
) ENGINE=MyISAM;
 
DROP TABLE IF EXISTS `poll_vote`;
CREATE TABLE `poll_vote` (
  `poll_id` int(11) NOT NULL auto_increment,
  `topic_id` int(11) NOT NULL,
  `vote1` int(11) default '0',
  `vote2` int(11) default '0',
  `vote3` int(11) default '0',
  `vote4` int(11) default '0',
  `vote5` int(11) default '0',
  `vote6` int(11) default '0',
  `vote7` int(11) default '0',
  `vote8` int(11) default '0',
  `vote9` int(11) default '0',
  `vote10` int(11) default '0',
  PRIMARY KEY  (`poll_id`)
) ENGINE=MyISAM;
 
DROP TABLE IF EXISTS `voters`;
CREATE TABLE `voters` (
  `vid` int(11) NOT NULL auto_increment,
  `ip_address` varchar(255) default '',
  `vote_date` varchar(255) default '',
  `topic_id` varchar(255) default '',
  `member_id` varchar(255) default '',
  PRIMARY KEY  (`vid`)
) ENGINE=MyISAM;
 
DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups` (
  `g_id` int(11) NOT NULL auto_increment,
  `g_title` varchar(32) default '',
  `g_img` varchar(255) default '',
  `g_color` varchar(255) default '',
  `g_view_board` tinyint(1),
  `g_post_new_topics` tinyint(1),
  `g_post_polls` tinyint(1),
  `g_vote_polls` tinyint(1),
  `g_edit_topics` tinyint(1),
  `g_edit_posts` tinyint(1),
  `g_delete_topics` tinyint(1),
  `g_delete_posts` tinyint(1),
  `g_move_topics` tinyint(1),
  `g_file_upload` tinyint(1),
  `g_avatar_upload` tinyint(1),
  `g_pinned_topics` tinyint(1),
  `g_closed_topics` tinyint(1),
  `g_read_news` tinyint(1),
  `g_read_privilege` tinyint(1),
  `g_add_news` tinyint(1),
  `g_add_privilege` tinyint(1),
  `g_edit_news` tinyint(1),
  `g_edit_privilege` tinyint(1),
  `g_delete_news` tinyint(1),
  `g_delete_privilege` tinyint(1),
  `g_delete_id` tinyint(1),
  `g_view_lastestcp` tinyint(1),
  `g_view_adminmenu` tinyint(1),
  `g_view_topic_option` tinyint(1),
  `g_upload_nonlimit` int(11),
  `g_post_closed_topics` tinyint(1),
  `g_non_showip` tinyint(1),
  `g_no_delay_posts` tinyint(1),
  `g_view_userip` tinyint(1),
  `g_searching_id` tinyint(1),
  `g_edit_rank_title` tinyint(1),
  `g_edit_mes_control` tinyint(1),
  `g_forum_manage` tinyint(1),
  `g_account_manage` tinyint(1),
  PRIMARY KEY  (`g_id`)
) ENGINE=MyISAM;
INSERT INTO `groups` VALUES (1,'Guest','guest.gif','',1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
INSERT INTO `groups` VALUES (2,'Member','member.gif','',1,1,1,1,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
INSERT INTO `groups` VALUES (3,'Banned','banned.gif','gray',1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
INSERT INTO `groups` VALUES (4,'Sub Admin','sub_admin.gif','green',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1,0,1,0,0,0,1,1,1,1,1,1,1,1,0,0,0,0);
INSERT INTO `groups` VALUES (5,'Administrator','admin.gif','red',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1);
 
DROP TABLE IF EXISTS `query_log`;
CREATE TABLE `query_log` (
  `action_id` int(11) NOT NULL auto_increment,
  `Date` datetime NOT NULL default '0000-00-00 00:00:00',
  `User` varchar(24) NOT NULL default '',
  `IP` varchar(20) NOT NULL default '',
  `page` varchar(24) NOT NULL default '',
  `query` text NOT NULL,
  PRIMARY KEY  (`action_id`),
  KEY `action_id` (`action_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;
 
DROP TABLE IF EXISTS `ranking_ignore`;
CREATE TABLE `ranking_ignore` (
  `account_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`account_id`)
) ENGINE=MyISAM;
 
DROP TABLE IF EXISTS `security_code`;
CREATE TABLE `security_code` (
  `sc_id` text NOT NULL,
  `sc_code` varchar(11) NOT NULL default '0',
  `sc_time` int(11) NOT NULL default '0'
) ENGINE=MyISAM;
 
DROP TABLE IF EXISTS `rank_title`;
CREATE TABLE `rank_title` (
  `title_id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '0',
  `min_post` int(11) NOT NULL default '0',
  PRIMARY KEY  (`title_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;
INSERT INTO `rank_title` VALUES (1,'Baby',0);
INSERT INTO `rank_title` VALUES (2,'Child',10);
INSERT INTO `rank_title` VALUES (3,'Adult',30);
INSERT INTO `rank_title` VALUES (4,'Major',50);
INSERT INTO `rank_title` VALUES (5,'Colonel',100);
INSERT INTO `rank_title` VALUES (6,'General',200);
INSERT INTO `rank_title` VALUES (7,'Sir',350);
INSERT INTO `rank_title` VALUES (8,'Baron',600);
INSERT INTO `rank_title` VALUES (9,'Marquis',900);
INSERT INTO `rank_title` VALUES (10,'King',1200);
 
DROP TABLE IF EXISTS `register_log`;
CREATE TABLE `register_log` (
  `reg_id` int(11) NOT NULL auto_increment,
  `Date` datetime NOT NULL default '0000-00-00 00:00:00',
  `account_id` int(11) unsigned NOT NULL,
  `userid` varchar(23) NOT NULL default '',
  `level` tinyint(3) NOT NULL default '0',
  `ip` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`reg_id`),
  KEY (`account_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
 
DROP TABLE IF EXISTS `memory`;
CREATE TABLE `memory` (
  `memory_id` int(11) NOT NULL auto_increment,
  `memory_object` varchar(255) default '',
  `memory_value1` varchar(255) default '',
  `memory_value2` varchar(255) default '',
  `memory_value3` text,
  PRIMARY KEY  (`memory_id`)
) ENGINE=MyISAM;
 
INSERT INTO `memory` (memory_object,memory_value1) VALUES ('sgcp_install','1');
INSERT INTO `memory` (memory_object,memory_value1) VALUES ('ro_message','Administrator');
INSERT INTO `memory` (memory_object,memory_value1,memory_value2,memory_value3) VALUES ('forum_category','1','1','A Test Category');
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to question listing
×
×
  • Create New...