Icy Phoenix

Lack perform this query
CREATE TABLE ip_karma_comments (
karma_id mediumint(8) NOT NULL auto_increment,
karma_to mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
karma_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
karma_desc char(255) NOT NULL,
karma_date int(11) DEFAULT '0' NOT NULL,
karma_key tinyint(1) DEFAULT '0' NOT NULL,
karma_viewed tinyint(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (karma_id)
);

INSERT INTO `ip_config` SET `config_name`='karma_comments', `config_value`='0';
INSERT INTO `ip_config` SET `config_name`='karma_comments_obligatory', `config_value`='0';
INSERT INTO `ip_config` SET `config_name`='karma_comments_max', `config_value`='3';
INSERT INTO `ip_config` SET `config_name`='karma_onoff', `config_value`='1';
INSERT INTO `ip_config` SET `config_name`='simple_karma', `config_value`='0';
INSERT INTO `ip_config` SET `config_name`='time_between_karma', `config_value`='24';
INSERT INTO `ip_config` SET `config_name`='admin_karma', `config_value`='1';
INSERT INTO `ip_config` SET `config_name`='min_post_karma', `config_value`='0';
INSERT INTO `ip_config` SET `config_name`='lag_karmer', `config_value`='1';
ALTER TABLE `ip_users` ADD `karma_plus` MEDIUMINT DEFAULT '0' NOT NULL ;
ALTER TABLE `ip_users` ADD `karma_minus` MEDIUMINT DEFAULT '0' NOT NULL ;
ALTER TABLE `ip_users` ADD `karma_time` BIGINT DEFAULT '0' NOT NULL ;

#
# NOTa: If it is an update of the icy clean is ip and if venis an update is phpphpbb

CREATE TABLE `ip_medal` (
`medal_id` mediumint(8) UNSIGNED NOT NULL auto_increment,
`cat_id` mediumint(8) UNSIGNED NOT NULL default '1',
`medal_name` varchar(40) NOT NULL,
`medal_description` varchar(255) NOT NULL,
`medal_image` varchar(40) NULL,
PRIMARY KEY (`medal_id`)
);

CREATE TABLE `ip_medal_user` (
`issue_id` mediumint(8) UNSIGNED NOT NULL auto_increment,
`medal_id` mediumint(8) UNSIGNED NOT NULL,
`user_id` mediumint(8) UNSIGNED NOT NULL,
`issue_reason` varchar(255) NOT NULL,
`issue_time` int(11) NOT NULL,
PRIMARY KEY (`issue_id`)
);

CREATE TABLE `ip_medal_mod` (
`mod_id` mediumint(8) UNSIGNED NOT NULL auto_increment,
`medal_id` mediumint(8) UNSIGNED NOT NULL,
`user_id` mediumint(8) UNSIGNED NOT NULL,
PRIMARY KEY (`mod_id`)
);

CREATE TABLE `ip_medal_cat` (
`cat_id` mediumint(8) UNSIGNED NOT NULL auto_increment,
`cat_title` varchar(100) NOT NULL,
`cat_order` mediumint(8) UNSIGNED NOT NULL default '0',
PRIMARY KEY (`cat_id`),
KEY `cat_order` (`cat_order`)
);

INSERT INTO `ip_config` VALUES ('allow_medal_display', '0');
INSERT INTO `ip_config` VALUES ('medal_display_row', '1');
INSERT INTO `ip_config` VALUES ('medal_display_col', '1');
INSERT INTO `ip_config` VALUES ('medal_display_width', '');
INSERT INTO `ip_config` VALUES ('medal_display_height', '');
INSERT INTO `ip_config` VALUES ('medal_display_order', '');
INSERT INTO `ip_medal_cat` VALUES ('1', 'Default', '10');