 
 ---# Adding new columns to log_group_requests
 ALTER TABLE {$db_prefix}log_group_requests
-ADD COLUMN status smallint NOT NULL default '0',
-ADD COLUMN id_member_acted int NOT NULL default '0',
-ADD COLUMN member_name_acted varchar(255) NOT NULL default '',
-ADD COLUMN time_acted int NOT NULL default '0',
-ADD COLUMN act_reason text NOT NULL;
+ADD COLUMN IF NOT EXISTS status smallint NOT NULL default '0',
+ADD COLUMN IF NOT EXISTS id_member_acted int NOT NULL default '0',
+ADD COLUMN IF NOT EXISTS member_name_acted varchar(255) NOT NULL default '',
+ADD COLUMN IF NOT EXISTS time_acted int NOT NULL default '0',
+ADD COLUMN IF NOT EXISTS act_reason text NOT NULL;
 ---#
 
 ---# Adjusting the indexes for log_group_requests

/******************************************************************************/
---# Add location column to calendar table
ALTER TABLE {$db_prefix}calendar
ADD COLUMN location VARCHAR(255) NOT NULL DEFAULT '';
---#

/******************************************************************************/

/******************************************************************************/
---# Adding new columns to categories...
ALTER TABLE {$db_prefix}categories
ADD COLUMN IF NOT EXISTS description text;


UPDATE {$db_prefix}categories
