Having issue with Altering tables with SQL text Duplicate tables

Lady1178 · December 29, 2010

Hi, i'm very new here and I hope I came to the right place for some serious help. I am trying to integrate a web messenger into my website using wordpress. PHPMyAdmin 2.4.0 MYSQL 5.0.77. According to the documentation for integrating this into my site I am to upload this text file first into mysql database:

-- ****************************************************************************

-- THIS SQL IS ONLY FOR NEW INSTALLATIONS!

-- IF YOU ARE UPGRADING, READ THE MANUAL AND RUN THE APPROPRIATE DB UPDATE SQLs

-- ****************************************************************************

CREATE TABLE `php121_users` (

`uid` int(11) NOT NULL auto_increment,

`uname` varchar(25) NOT NULL default '',

`upassword` varchar(40) NOT NULL default '',

`uemail` varchar(255) NOT NULL default '',

`php121_user_chatting` int(11) NOT NULL default '0',

`php121_smilies` tinyint(1) NOT NULL default '1',

`php121_level` tinyint(1) NOT NULL default '1',

`php121_showrequest` tinyint(1) NOT NULL default '1',

`php121_beep_newmsg` tinyint(1) NOT NULL default '1',

`php121_focus_newmsg` tinyint(1) NOT NULL default '1',

`php121_auto_email_transcript` TINYINT( 1 ) DEFAULT '0' NOT NULL ,

`php121_banned` tinyint(4) NOT NULL default '0',

`php121_timezone` tinyint(3) NOT NULL default '0',

`php121_timestamp` tinyint(1) NOT NULL default '1',

`php121_language` varchar(30) NOT NULL default 'English',

`php121_cl_update_key` int(11) NOT NULL default '0',

`imbl_appear_offline` int(1) NOT NULL default '0',

`imbl_away_message` varchar(255) NOT NULL default '',

`imbl_usertheme` varchar(64) NOT NULL default '',

`imbl_profileshowsbuddies` int(1) NOT NULL default '1',

`imbl_general_info` text NOT NULL,

`imbl_profile_timestamp` varchar(255) NOT NULL default '',

`imbl_profiletheme` varchar(64) NOT NULL default '',

`imbl_profile_gender` varchar(35) NOT NULL default '',

`imbl_profile_age` int(2) NOT NULL default '0',

`imbl_profile_location` varchar(35) NOT NULL default '',

`imbl_profile_status` varchar(35) NOT NULL default '',

`imbl_profile_orientation` varchar(35) NOT NULL default '',

`imbl_profile_occupation` varchar(35) NOT NULL default '',

`imbl_profile_avataruploaded` int(1) NOT NULL default '0',

`imbl_profile_avatarhide` int(1) NOT NULL default '0',

`php121_tabs_timestamp` int(11) NOT NULL default '0',

`php121_tabs_update` int(1) NOT NULL default '0',

PRIMARY KEY (`uid`)

) TYPE=MyISAM ;

CREATE TABLE `php121_blocks` (

`b_id` int(10) NOT NULL auto_increment,

`b_user` int(10) NOT NULL default '0',

`b_block` int(10) NOT NULL default '0',

PRIMARY KEY (`b_id`)

) TYPE=MyISAM ;

CREATE TABLE `php121_config` (

`config_name` varchar(255) NOT NULL default '',

`config_value` varchar(255) NOT NULL default '',

PRIMARY KEY (`config_name`)

) TYPE=MyISAM;

INSERT INTO `php121_config` VALUES ('server_timezone', '0');

INSERT INTO `php121_config` VALUES ('default_language', 'English');

INSERT INTO `php121_config` VALUES ('auto_email_transcript', '0');

INSERT INTO `php121_config` VALUES ('user_can_create_account', '1');

INSERT INTO `php121_config` VALUES ('user_can_delete_account', '1');

CREATE TABLE `php121_requests` (

`r_id` int(11) NOT NULL auto_increment,

`roomid` int(11) default NULL,

`r_to` int(11) NOT NULL default '0',

`r_from` int(11) NOT NULL default '0',

`r_time` int(11) NOT NULL default '0',

`r_result` tinyint(1) NOT NULL default '0',

`r_update_time` int(11) NOT NULL default '0',

`r_type` int(1) NOT NULL default '0',

PRIMARY KEY (`r_id`)

) TYPE=MyISAM ;

CREATE TABLE `php121_control` (

`id` int(1) NOT NULL default '1',

`CL_LastModified` int(11) NOT NULL default '0',

`CL_UpdateKey` int(11) NOT NULL default '0',

PRIMARY KEY (`id`)

) TYPE=MyISAM;

INSERT INTO `php121_control` VALUES (1, 1, 1);

INSERT INTO `php121_control` VALUES (2, 1, 1);

CREATE TABLE `php121_messages` (

`msgid` int(11) NOT NULL auto_increment,

`roomid` int(11) NOT NULL default '0',

`username` varchar(25) NOT NULL default '',

`timestamp` int(11) NOT NULL default '0',

`servernotice` int(1) NOT NULL default '0',

`message` longtext NOT NULL,

PRIMARY KEY (`msgid`)

) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `php121_rooms` (

`roomid` int(11) NOT NULL default '0',

`uname` varchar(25) NOT NULL default '',

`joined` int(11) NOT NULL default '0',

`lastping` int(11) NOT NULL default '0',

`timedout` int(1) NOT NULL default '0',

PRIMARY KEY (`roomid`,`uname`)

) TYPE=MyISAM;

CREATE TABLE `php121_smilies` (

`id` smallint(5) NOT NULL auto_increment,

`code` varchar(50) NOT NULL default '',

`filename` varchar(100) NOT NULL default '',

`description` varchar(75) NOT NULL default '',

`pack` varchar(50) NOT NULL default '',

PRIMARY KEY (`id`)

) TYPE=MyISAM AUTO_INCREMENT=44 ;

INSERT INTO `php121_smilies` VALUES (1, '', 'icon_biggrin.gif', 'Very Happy', 'phpbb');

INSERT INTO `php121_smilies` VALUES (2, '', 'icon_smile.gif', 'Smile', 'phpbb');

INSERT INTO `php121_smilies` VALUES (3, ':smile:', 'icon_smile.gif', 'Smile', 'phpbb');

INSERT INTO `php121_smilies` VALUES (4, '', 'icon_sad.gif', 'Sad', 'phpbb');

INSERT INTO `php121_smilies` VALUES (5, ':-(', 'icon_sad.gif', 'Sad', 'phpbb');

INSERT INTO `php121_smilies` VALUES (6, ':sad:', 'icon_sad.gif', 'Sad', 'phpbb');

INSERT INTO `php121_smilies` VALUES (7, '', 'icon_surprised.gif', 'Surprised', 'phpbb');

INSERT INTO `php121_smilies` VALUES (8, ':-o', 'icon_surprised.gif', 'Surprised', 'phpbb');

INSERT INTO `php121_smilies` VALUES (9, ':eek:', 'icon_surprised.gif', 'Surprised', 'phpbb');

INSERT INTO `php121_smilies` VALUES (10, '8O', 'icon_eek.gif', 'Shocked', 'phpbb');

INSERT INTO `php121_smilies` VALUES (11, '8-O', 'icon_eek.gif', 'Shocked', 'phpbb');

INSERT INTO `php121_smilies` VALUES (12, ':shock:', 'icon_eek.gif', 'Shocked', 'phpbb');

INSERT INTO `php121_smilies` VALUES (13, ':?', 'icon_confused.gif', 'Confused', 'phpbb');

INSERT INTO `php121_smilies` VALUES (14, ':-?', 'icon_confused.gif', 'Confused', 'phpbb');

INSERT INTO `php121_smilies` VALUES (15, ':???:', 'icon_confused.gif', 'Confused', 'phpbb');

INSERT INTO `php121_smilies` VALUES (16, '', 'icon_cool.gif', 'Cool', 'phpbb');

INSERT INTO `php121_smilies` VALUES (17, '8-)', 'icon_cool.gif', 'Cool', 'phpbb');

INSERT INTO `php121_smilies` VALUES (18, ':cool:', 'icon_cool.gif', 'Cool', 'phpbb');

INSERT INTO `php121_smilies` VALUES (19, ' :lol: ', 'icon_lol.gif', 'Laughing', 'phpbb');

INSERT INTO `php121_smilies` VALUES (20, ':x', 'icon_mad.gif', 'Mad', 'phpbb');

INSERT INTO `php121_smilies` VALUES (21, ':-x', 'icon_mad.gif', 'Mad', 'phpbb');

INSERT INTO `php121_smilies` VALUES (22, ':mad:', 'icon_mad.gif', 'Mad', 'phpbb');

INSERT INTO `php121_smilies` VALUES (23, '', 'icon_razz.gif', 'Razz', 'phpbb');

INSERT INTO `php121_smilies` VALUES (24, ':-P', 'icon_razz.gif', 'Razz', 'phpbb');

INSERT INTO `php121_smilies` VALUES (25, ':razz:', 'icon_razz.gif', 'Razz', 'phpbb');

INSERT INTO `php121_smilies` VALUES (26, ':oops:', 'icon_redface.gif', 'Embarassed', 'phpbb');

INSERT INTO `php121_smilies` VALUES (27, ' :cry: ', 'icon_cry.gif', 'Crying or Very sad', 'phpbb');

INSERT INTO `php121_smilies` VALUES (28, ':evil:', 'icon_evil.gif', 'Evil or Very Mad', 'phpbb');

INSERT INTO `php121_smilies` VALUES (29, ':twisted:', 'icon_twisted.gif', 'Twisted Evil', 'phpbb');

INSERT INTO `php121_smilies` VALUES (30, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes', 'phpbb');

INSERT INTO `php121_smilies` VALUES (31, ':wink:', 'icon_wink.gif', 'Wink', 'phpbb');

INSERT INTO `php121_smilies` VALUES (32, '', 'icon_wink.gif', 'Wink', 'phpbb');

INSERT INTO `php121_smilies` VALUES (33, ':!:', 'icon_exclaim.gif', 'Exclamation', 'phpbb');

INSERT INTO `php121_smilies` VALUES (34, ':?:', 'icon_question.gif', 'Question', 'phpbb');

INSERT INTO `php121_smilies` VALUES (35, ' :idea: ', 'icon_idea.gif', 'Idea', 'phpbb');

INSERT INTO `php121_smilies` VALUES (36, ':arrow:', 'icon_arrow.gif', 'Arrow', 'phpbb');

INSERT INTO `php121_smilies` VALUES (37, ':|', 'icon_neutral.gif', 'Neutral', 'phpbb');

INSERT INTO `php121_smilies` VALUES (38, ':-|', 'icon_neutral.gif', 'Neutral', 'phpbb');

INSERT INTO `php121_smilies` VALUES (39, ':neutral:', 'icon_neutral.gif', 'Neutral', 'phpbb');

INSERT INTO `php121_smilies` VALUES (40, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green', 'phpbb');

INSERT INTO `php121_smilies` VALUES (41, ': ^_^ :', 'aiwebs_004.gif', 'Smile (Japanese)', 'phpbb');

INSERT INTO `php121_smilies` VALUES (42, ':wave:', 'wavey.gif', '', 'phpbb');

INSERT INTO `php121_smilies` VALUES (43, ':samurai:', 'samurai.gif', '', 'phpbb');

-- --------------------------------------------------------

--

-- Table structure for table `imbuddylist`

--

CREATE TABLE `imbuddylist` (

`id` int(20) NOT NULL auto_increment,

`userid` int(32) NOT NULL default '0',

`buddyid` int(32) NOT NULL default '0',

`buddygroup` int(32) NOT NULL default '0',

`buddycomment` varchar(255) NOT NULL default '',

PRIMARY KEY (`id`)

) TYPE=MyISAM;

-- --------------------------------------------------------

--

-- Table structure for table `imbuddylist_config`

--

CREATE TABLE `imbuddylist_config` (

`config_name` varchar(255) NOT NULL default '',

`defaulttheme` varchar(255) NOT NULL default '',

`group_allonline_opened` int(1) NOT NULL default '1',

`group_onlinebuddies_opened` int(1) NOT NULL default '1',

`group_offlinebuddies_opened` int(1) NOT NULL default '0',

`profile_enabled` int(1) NOT NULL default '1',

`buddylist_enabled` int(1) NOT NULL default '1',

`awaymsg_enabled` int(1) NOT NULL default '1',

`showonline_enabled` int(1) NOT NULL default '1',

`usersearch_enabled` int(1) NOT NULL default '1',

`profilecomments_enabled` int(1) NOT NULL default '1',

`profileavatars_enabled` int(1) NOT NULL default '1',

`buddycomments_enabled` int(1) NOT NULL default '1',

`offlinemessages_enabled` int(1) NOT NULL default '1',

`debugmode_enabled` int(1) NOT NULL default '0',

`adminscontrolusersettings` int(1) NOT NULL default '0',

`chatlogsaving_enabled` int(1) NOT NULL default '1',

`staffsupportsystem_enabled` int(1) NOT NULL default '1',

`usersautoacceptchatrequests` int(1) NOT NULL default '0',

PRIMARY KEY (`config_name`)

) TYPE=MyISAM;

INSERT INTO `imbuddylist_config` VALUES ('imbuddylist', '', 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0);

-- --------------------------------------------------------

--

-- Table structure for table `imbuddylist_groups`

--

CREATE TABLE `imbuddylist_groups` (

`id` int(20) NOT NULL auto_increment,

`userid` int(32) NOT NULL default '0',

`group` varchar(21) NOT NULL default '',

`opened` int(1) NOT NULL default '1',

PRIMARY KEY (`id`)

) TYPE=MyISAM;

-- --------------------------------------------------------

--

-- Table structure for table `imbuddylist_profilecomments`

--

CREATE TABLE `imbuddylist_profilecomments` (

`comment_id` int(20) NOT NULL auto_increment,

`profile_id` int(20) NOT NULL default '0',

`poster_id` int(20) NOT NULL default '0',

`timestamp` int(11) NOT NULL default '0',

PRIMARY KEY (`comment_id`),

KEY `profile_id` (`profile_id`),

KEY `poster_id` (`poster_id`),

KEY `timestamp` (`timestamp`)

) TYPE=MyISAM;

-- --------------------------------------------------------

--

-- Table structure for table `imbuddylist_profilecomments_text`

--

CREATE TABLE `imbuddylist_profilecomments_text` (

`comment_id` int(20) NOT NULL auto_increment,

`comment_text` text,

PRIMARY KEY (`comment_id`)

) TYPE=MyISAM;

-- --------------------------------------------------------

--

-- Table structure for table `imbuddylist_staffbuddies`

--

CREATE TABLE `imbuddylist_staffbuddies` (

`id` int(20) NOT NULL auto_increment,

`userid` varchar(45) NOT NULL default '1',

`buddyid` varchar(45) NOT NULL default '',

`buddygroup` varchar(45) NOT NULL default '',

`displayname` varchar(40) NOT NULL default '',

PRIMARY KEY (`id`)

) TYPE=MyISAM;

-- --------------------------------------------------------

--

-- Table structure for table `imbuddylist_staffgroups`

--

CREATE TABLE `imbuddylist_staffgroups` (

`id` int(20) NOT NULL auto_increment,

`userid` varchar(45) NOT NULL default '1',

`group` varchar(45) NOT NULL default '',

`opened` int(1) NOT NULL default '1',

PRIMARY KEY (`id`)

) TYPE=MyISAM;

-- --------------------------------------------------------

--

-- Table structure for table `php121_offlinemessages`

--

CREATE TABLE `php121_offlinemessages` (

`offlineim_id` INT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY ,

`receiver_id` INT(20) NOT NULL ,

`sender_id` INT(20) NOT NULL ,

`timestamp` INT(11) NOT NULL ,

`subject` varchar(50) NOT NULL default '',

`unread` int(1) NOT NULL default '1',

INDEX ( `receiver_id` )

) TYPE = MYISAM ;

-- --------------------------------------------------------

--

-- Table structure for table `php121_offlinemessages_text`

--

CREATE TABLE `php121_offlinemessages_text` (

`offlineim_id` INT( 20 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,

`offlineim_text` TEXT NULL

) TYPE = MYISAM ;

CREATE TABLE `php121_chatlogs` (

`id` int(99) NOT NULL auto_increment,

`room_id` int(99) NOT NULL default '0',

`timestamp` int(11) NOT NULL default '0',

`usernames` text NOT NULL,

`textlog` text NOT NULL,

PRIMARY KEY (`id`)

) TYPE=MyISAM ;

END CODE

After entering that into the database I am to enter this Alter Table code:

-- ONLY RUN THIS SQL IF THIS IS A **NEW** INSTALLATION OF PHP121 **AND**

-- YOU ARE WANTING TO USE YOUR **EXISTING** USER TABLE

-- DO NOT RUN THIS IF YOU ARE UPGRADING!

-- IF YOU ARE UPGRADING AN EXISTING USER TABLE, YOU NEED TO EDIT THE APPROPRIATE

-- UPDATE SQL FILE AND CHANGE ANY TABLE NAMES FOR THE USERS TABLE.

-- BEFORE IMPORTING THIS FILE, YOU NEED TO IMPORT php121.sql - IMPORTANT!!!!

-- CHANGE `users` ON THE FOLLOWING LINE TO BE THE NAME OF YOUR USER TABLE

-- THEN MAKE SURE YOU HAVE EDITED php121config.php TO HAVE THE CORRECT

-- SETTINGS FOR A CUSTOM TABLE.

ALTER TABLE `wp_users` ADD `php121_user_chatting` INT( 11 ) DEFAULT '0' NOT NULL ,

ADD `php121_smilies` TINYINT( 1 ) DEFAULT '1' NOT NULL ,

ADD `php121_level` TINYINT( 1 ) DEFAULT '1' NOT NULL ,

ADD `php121_showrequest` TINYINT( 1 ) DEFAULT '1' NOT NULL ,

ADD `php121_beep_newmsg` TINYINT( 1 ) DEFAULT '1' NOT NULL ,

ADD `php121_focus_newmsg` TINYINT( 1 ) DEFAULT '1' NOT NULL ,

ADD `php121_auto_email_transcript` TINYINT( 1 ) DEFAULT '0' NOT NULL ,

ADD `php121_banned` TINYINT( 1 ) DEFAULT '0' NOT NULL ,

ADD `php121_timezone` TINYINT( 3 ) DEFAULT '0' NOT NULL ,

ADD `php121_timestamp` TINYINT( 1 ) DEFAULT '1' NOT NULL ,

ADD `php121_language` VARCHAR( 30 ) DEFAULT 'English' NOT NULL ,

ADD `php121_cl_update_key` int(11) NOT NULL default '0',

ADD `imbl_appear_offline` int(1) NOT NULL default '0',

ADD `imbl_away_message` varchar(255) NOT NULL default '',

ADD `imbl_usertheme` varchar(64) NOT NULL default '',

ADD `imbl_profileshowsbuddies` int(1) NOT NULL default '1',

ADD `imbl_general_info` text NOT NULL,

ADD `imbl_profile_timestamp` varchar(255) NOT NULL default '',

ADD `imbl_profiletheme` varchar(64) NOT NULL default '',

ADD `imbl_profile_gender` varchar(35) NOT NULL default '',

ADD `imbl_profile_age` int(2) NOT NULL default '0',

ADD `imbl_profile_location` varchar(35) NOT NULL default '',

ADD `imbl_profile_status` varchar(35) NOT NULL default '',

ADD `imbl_profile_orientation` varchar(35) NOT NULL default '',

ADD `imbl_profile_occupation` varchar(35) NOT NULL default '',

ADD `imbl_profile_avataruploaded` int(1) NOT NULL default '0',

ADD `imbl_profile_avatarhide` int(1) NOT NULL default '0',

ADD `php121_tabs_timestamp` int(11) NOT NULL default '0',

ADD `php121_tabs_update` int(1) NOT NULL default '0';