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(40), 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) );)