RKF
Newbie | Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору
iB Database Set-up
.
mySQL Database Creation Error
1 error(s) were found trying to set up mySQL, please use go back to correct these errors
mySQL create table error. You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '; CREATE TABLE ib_address_books ( ID smallint(10) unsigned (CREATE TABLE ib_active_sessions ( ID varchar(32) DEFAULT '0' NOT NULL, MEMBER_NAME varchar(32), MEMBER_PASSWORD varchar(32), MEMBER_ID varchar(32), THIS_IP varchar(16), LAST_LOG_IN int(10), USER_AGENT varchar(80), RUNNING_TIME int(10), MEMBER_LOGSTATE tinyint(1), LOCATION varchar(160), LOG_IN_TYPE tinyint(1), MEMBER_GROUP smallint(3), PRIMARY KEY (ID) ); CREATE TABLE ib_address_books ( ID smallint(10) unsigned DEFAULT '0' NOT NULL, IN_MEMBER_ID varchar(32) NOT NULL, MEMBER_ID varchar(32) NOT NULL, IN_MEMBER_NAME varchar(32) NOT NULL, RECEIVE_MSG tinyint(1), IN_MEMBER_DESC varchar(50), PRIMARY KEY (ID) ); CREATE TABLE ib_attachments ( ID smallint(10) unsigned DEFAULT '0' NOT NULL, MIME_TYPE varchar(128), FILE_NAME varchar(64), PRIMARY KEY (ID) ); CREATE TABLE ib_authorisation ( ID smallint(10) unsigned DEFAULT '0' NOT NULL, UNIQUE_CODE varchar(32) NOT NULL, DATE_ENTERED int(10) DEFAULT '0' NOT NULL, MEMBER_ID varchar(32) NOT NULL, MEMBER_NAME varchar(32) NOT NULL, THIS_IP varchar(16), MEMBER_EMAIL varchar(128) NOT NULL, _WHERE varchar(64), MEMBER_GROUP tinyint(2), PRIMARY KEY (ID), INDEX authorisation_idx1(DATE_ENTERED), INDEX authorisation_idx2(MEMBER_ID) ); CREATE TABLE ib_calendar ( MEMBER_ID varchar(32) NOT NULL, MEMBER_NAME varchar(32) NOT NULL, DAY smallint(2) DEFAULT '0' NOT NULL, MONTH smallint(2) DEFAULT '0' NOT NULL, YEAR smallint(4) DEFAULT '0' NOT NULL, TIME_ADJUST varchar(4), UTIME int(10) NULL, FORUM_ID smallint(5) NULL, TOPIC_ID bigint(10) NULL, PRIMARY KEY (MEMBER_ID), INDEX calendar_idx1(FORUM_ID), INDEX calendar_idx2(TOPIC_ID) ); CREATE TABLE ib_categories ( CAT_ID tinyint(3) unsigned DEFAULT '0' NOT NULL, CAT_POS tinyint(3), CAT_STATE varchar(10), CAT_NAME varchar(128) NOT NULL, CAT_DESC text, SUB_CAT_ID int(10), VIEW varchar(50), IMAGE varchar(128), URL varchar(128), PRIMARY KEY (CAT_ID) ); CREATE TABLE ib_email_templates ( ID varchar(20) NOT NULL, TYPE char(1) NOT NULL, TEMPLATE text, PRIMARY KEY (ID) ); CREATE TABLE ib_forum_info ( FORUM_ID smallint(5) DEFAULT '0' NOT NULL, FORUM_TOPICS int(6), FORUM_POSTS int(6), FORUM_LAST_POST bigint(10), FORUM_LAST_POSTER varchar(32), FORUM_LAST_POSTER_N varchar(32), FORUM_NAME varchar(128) NOT NULL, FORUM_DESC text, FORUM_POSITION tinyint(2), FORUM_IBC tinyint(1), FORUM_HTML tinyint(1), FORUM_STATUS varchar(10), FORUM_START_THREADS varchar(32), FORUM_REPLY_THREADS varchar(32), FORUM_VIEW_THREADS varchar(32), FORUM_PROTECT varchar(32), CATEGORY tinyint(2) DEFAULT '0' NOT NULL, L_TOPIC_TITLE varchar(32), L_TOPIC_ID bigint(10), SORT_KEY varchar(32), SORT_ORDER varchar(32), PRUNE_DAYS tinyint(3), SHOW_RULES tinyint(1), ALLOW_ATTACH tinyint(1), MODERATE tinyint(1), PRIMARY KEY (FORUM_ID) ); CREATE TABLE ib_forum_moderators ( MODERATOR_ID mediumint(5) unsigned DEFAULT '0' NOT NULL, FORUM_ID smallint(5) DEFAULT '0' NOT NULL, MEMBER_NAME varchar(32) NOT NULL, MEMBER_ID varchar(32) DEFAULT '0' NOT NULL, EDIT_POST tinyint(1), EDIT_TOPIC tinyint(1), DELETE_POST tinyint(1), DELETE_TOPIC tinyint(1), VIEW_IP tinyint(1), OPEN_TOPIC tinyint(1), CLOSE_TOPIC tinyint(1), MASS_MOVE tinyint(1), MASS_PRUNE tinyint(1), MOVE_TOPIC tinyint(1), PIN_TOPIC tinyint(1), UNPIN_TOPIC tinyint(1), POST_Q tinyint(1), TOPIC_Q tinyint(1), ALLOW_WARN tinyint(1), ADD_TOPIC_WATCH tinyint(1), REMOVE_TOPIC_WATCH tinyint(1), PRIMARY KEY (MODERATOR_ID) ); CREATE TABLE ib_forum_poll_voters ( ID bigint(20) DEFAULT '0' NOT NULL, VOTER_IP varchar(16) NOT NULL, DATE int(10) DEFAULT '0' NOT NULL, POLL_ID bigint(10), MEMBER_ID varchar(32), FORUM_ID smallint(5), PRIMARY KEY (ID), INDEX forum_poll_voters_idx1(MEMBER_ID,POLL_ID,FORUM_ID) ); CREATE TABLE ib_forum_polls ( ID bigint(10) DEFAULT '0' NOT NULL, POLL_ID bigint(10) DEFAULT '0' NOT NULL, POLL_TITLE varchar(128) DEFAULT '0' NOT NULL, POLL_DESC text, POLL_STARTED int(10), POLL_ANSWERS text, POLL_STARTER varchar(32), POLL_STARTER_N varchar(32), TOTAL_VOTES int(10), FORUM_ID smallint(5), PRIMARY KEY (ID), INDEX forum_polls_idx1(FORUM_ID,POLL_ID) ); CREATE TABLE ib_forum_posts ( POST_ID bigint(10) unsigned DEFAULT '0' NOT NULL, AUTHOR varchar(32), ENABLE_SIG tinyint(1), ENABLE_EMO tinyint(1), IP_ADDR varchar(16), POST_DATE int(10), POST_ICON smallint(3), POST text, AUTHOR_TYPE tinyint(1), QUEUED tinyint(1), TOPIC_ID bigint(10), FORUM_ID smallint(5), ATTACH_ID varchar(64), ATTACH_HITS int(5), ATTACH_TYPE varchar(128), PRIMARY KEY (POST_ID), INDEX forum_posts_idx1(TOPIC_ID,QUEUED), INDEX forum_posts_idx2(FORUM_ID,TOPIC_ID,QUEUED), INDEX forum_posts_idx3(POST_DATE) ); CREATE TABLE ib_forum_rules ( ID smallint(5) DEFAULT '0' NOT NULL, RULES_TITLE varchar(128) NOT NULL, RULES_TEXT text, LAST_UPDATE int(10), SHOW_ALL tinyint(1), PRIMARY KEY (ID) ); CREATE TABLE ib_forum_subscriptions ( ID mediumint(9) unsigned DEFAULT '0' NOT NULL, MEMBER_ID varchar(32) NOT NULL, MEMBER_NAME varchar(32), EMAIL_ADDRESS varchar(100), FORUM_ID smallint(5) DEFAULT '0', TOPIC_ID bigint(10) DEFAULT '0', DATE_STARTED int(10), SEND_ONCE tinyint(1) DEFAULT '0', PRUNE tinyint(2), rFULL tinyint(1), PRIMARY KEY (ID), INDEX forum_subscriptions_idx1(FORUM_ID,TOPIC_ID,MEMBER_ID) ); CREATE TABLE ib_forum_topics ( TOPIC_ID bigint(10) unsigned DEFAULT '0' NOT NULL, TOPIC_TITLE varchar(70) NOT NULL, TOPIC_DESC varchar(70), TOPIC_STATE varchar(8), TOPIC_POSTS smallint(4), TOPIC_STARTER varchar(32), TOPIC_START_DATE int(10), TOPIC_LAST_POSTER varchar(32), TOPIC_LAST_DATE int(10), TOPIC_ICON tinyint(2), TOPIC_STARTER_N varchar(32), TOPIC_LASTP_N varchar(32), POLL_STATE varchar(8), LAST_VOTE int(10), TOPIC_VIEWS int(5), FORUM_ID smallint(5), APPROVED tinyint(1), TOPIC_AUTHOR_TYPE tinyint(1), PIN_STATE tinyint(1), MOVED_TO varchar(64), WATCHED tinyint(1), PRIMARY KEY (TOPIC_ID), INDEX forum_topics_idx1(FORUM_ID,PIN_STATE,TOPIC_LAST_DATE), INDEX forum_topics_idx2(WATCHED,FORUM_ID), INDEX forum_topics_idx3(TOPIC_LAST_DATE) ); CREATE TABLE ib_help ( ID int(3) unsigned DEFAULT '0' NOT NULL, TITLE varchar(128) NOT NULL, TEXT text, PRIMARY KEY (ID) ); CREATE TABLE ib_mem_groups ( ID tinyint(2) unsigned DEFAULT '0' NOT NULL, VIEW_BOARD tinyint(1), MEM_INFO tinyint(1), OTHER_TOPICS tinyint(1), USE_SEARCH tinyint(1), EMAIL_FRIEND tinyint(1), INVITE_FRIEND tinyint(1), EDIT_PROFILE tinyint(1), POST_NEW_TOPICS tinyint(1), REPLY_OWN_TOPICS tinyint(1), REPLY_OTHER_TOPICS tinyint(1), EDIT_OWN_POSTS tinyint(1), DELETE_OWN_POSTS tinyint(1), OPEN_CLOSE_TOPICS tinyint(1), DELETE_OWN_TOPICS tinyint(1), POST_POLLS tinyint(1), VOTE_POLLS tinyint(1), USE_PM tinyint(1), IS_SUPMOD tinyint(1), ACCESS_CP tinyint(1), TITLE varchar(32) NOT NULL, CAN_REMOVE tinyint(1), READ_AD_LOGS tinyint(1), DELETE_AD_LOGS tinyint(1), EDIT_GROUPS tinyint(1), APPEND_EDIT tinyint(1), ACCESS_OFFLINE tinyint(1), AVOID_Q tinyint(1), AVOID_FLOOD tinyint(1), TEAM_ICON varchar(64), ATTACH_MAX bigint(20), ADD_EVENT char(3), UPLOAD_AVATARS tinyint(1), MAX_MESSAGES int(3), PRIMARY KEY (ID) ); CREATE TABLE ib_member_notepads ( MEMBER_ID varchar(32) DEFAULT '0' NOT NULL, NOTEPAD_TEXT text, SAVED_P text, SAVED_M text, PRIMARY KEY (MEMBER_ID) ); CREATE TABLE ib_member_profiles ( MEMBER_ID varchar(32) DEFAULT '0' NOT NULL, MEMBER_NAME varchar(32) NOT NULL, MEMBER_GROUP tinyint(2) DEFAULT '0' NOT NULL, MEMBER_PASSWORD varchar(32) NOT NULL, MEMBER_EMAIL varchar(100) NOT NULL, MEMBER_JOINED int(10) DEFAULT '0' NOT NULL, MEMBER_LEVEL smallint(5), MEMBER_IP varchar(16) NOT NULL, MEMBER_AVATAR varchar(128), AVATAR_DIMS varchar(9), MEMBER_POSTS mediumint(7), PHOTO varchar(128), CANCEL_SUBS tinyint(1), AOLNAME varchar(40), ICQNUMBER varchar(40), LOCATION varchar(128), SIGNATURE text, WEBSITE varchar(70), YAHOONAME varchar(32), MEMBER_TITLE varchar(64), LAST_UPDATE int(10), ALLOW_ADMIN_EMAILS tinyint(1) DEFAULT '1', TIME_ADJUST char(3), INTERESTS text, HIDE_EMAIL tinyint(1), PM_REMINDER char(3), EMAIL_FULL_POST char(3), MEMBER_SKIN varchar(32), WARN_LEVEL tinyint(2), LANGUAGE varchar(32), MSNNAME varchar(32), LAST_POST varchar(32), ALLOW_POST tinyint(1), VIEW_SIGS tinyint(1), VIEW_IMG tinyint(1), VIEW_AVS tinyint(1), LAST_LOG_IN int(10), LAST_ACTIVITY int(10), GENDER tinyint(1), MEMBER_NAME_R varchar(40), POST_FONT_COLOR varchar(15), PRIMARY KEY (MEMBER_ID) ); CREATE TABLE ib_member_titles ( ID smallint(5) DEFAULT '0' NOT NULL, POSTS int(10), TITLE varchar(128), ADVANCE_GROUP smallint(5), PIPS varchar(128), PRIMARY KEY (ID) ); CREATE TABLE ib_message_data ( MESSAGE_ID bigint(10) unsigned DEFAULT '0' NOT NULL, DATE int(10), READ_STATE tinyint(1), TITLE varchar(128), MESSAGE text, MESSAGE_ICON tinyint(2), FROM_ID varchar(32), FROM_NAME varchar(32), REPLY tinyint(1), REPLY_DATE int(10), VIRTUAL_DIR varchar(32), MEMBER_ID varchar(32), RECIPIENT_ID varchar(32), RECIPIENT_NAME varchar(32), PRIMARY KEY (MESSAGE_ID), INDEX message_data_idx1(MEMBER_ID), INDEX message_data_idx2(DATE) ); CREATE TABLE ib_message_stats ( MEMBER_ID varchar(32) NOT NULL, LAST_READ int(10), NEW_MESSAGES tinyint(2), LAST_FROM_NAME varchar(32), LAST_FROM_ID varchar(32), LAST_MSG_TITLE varchar(128), LAST_MSG_ID bigint(10), LAST_SENT int(10), TOTAL_MESSAGES int(4), VIRTUAL_DIR text, SHOW_POPUP tinyint(1), PRIMARY KEY (MEMBER_ID) ); CREATE TABLE ib_mod_email ( ID smallint(5) unsigned DEFAULT '0' NOT NULL, FORUM_ID smallint(5) DEFAULT '0' NOT NULL, FORUM_NAME varchar(128), EMAIL varchar(128), MEMBER_ID varchar(32) NOT NULL, MEMBER_NAME varchar(32), TEXT text NOT NULL, CHOICE tinyint(1) DEFAULT '0' NOT NULL, WHENE tinyint(1) DEFAULT '0' NOT NULL, SENT tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (ID) ); CREATE TABLE ib_mod_posts ( ID int(8) DEFAULT '0' NOT NULL, AUTHOR varchar(32), IP_ADDR varchar(16), POST_DATE int(10), POST text, AUTHOR_TYPE smallint(1), TOPIC_ID bigint(10) DEFAULT '0', FORUM_ID smallint(5) DEFAULT '0', TYPE varchar(5), POST_ID bigint(10), ATTACH_ID varchar(64), PRIMARY KEY (ID) ); CREATE TABLE ib_moderator_logs ( ID mediumint(5) DEFAULT '0' NOT NULL, FORUM_ID smallint(5), TOPIC_ID bigint(10) DEFAULT '0', POST_ID bigint(10) DEFAULT '0', MEMBER_ID varchar(32) NOT NULL, MEMBER_NAME varchar(32) NOT NULL, REMOTE_ADDR varchar(32), HTTP_REFERER varchar(255), TIME int(10), TOPIC_TITLE varchar(128), ACTION varchar(128), QUERY_STRING varchar(128), PRIMARY KEY (ID) ); CREATE TABLE ib_search_log ( LOG_ID bigint(20) unsigned DEFAULT '0' NOT NULL, AUTHOR_ID varchar(32), MEMBER_NAME varchar(32), DATE int(10), TOPIC_TITLE varchar(128), POST text, FORUM_ID smallint(5) DEFAULT '0' NOT NULL, TOPIC_ID bigint(10) DEFAULT '0', POST_ID bigint(10) DEFAULT '0', POSTER_IP varchar(16), PRIMARY KEY (LOG_ID), INDEX search_log_idx1(FORUM_ID,DATE) ); CREATE TABLE ib_ssi_templates ( ID varchar(20) NOT NULL, TEMPLATE text, EXPORT_FILENAME varchar(32), PRIMARY KEY (ID) ); CREATE TABLE ib_templates ( ID varchar(20) NOT NULL, TEMPLATE text, NAME varchar(128), PRIMARY KEY (ID) ); CREATE TABLE ib_topic_views ( ID bigint(10) unsigned DEFAULT '0' NOT NULL, TOPIC_ID bigint(10) DEFAULT '0' NOT NULL, FORUM_ID smallint(5) DEFAULT '0' NOT NULL, MEMBER_ID varchar(32), VIEWED int(10), POSTED_IN tinyint(1) DEFAULT '0' NOT NULL, SENT tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (ID), INDEX topic_views_idx1(MEMBER_ID) );)
че за фигня? |
