DROP TABLE IF EXISTS `playsms_toolsSimplerate`;
CREATE TABLE `playsms_toolsSimplerate` (
  `c_timestamp` int(11) NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dst` varchar(100) NOT NULL,
  `prefix` varchar(10) NOT NULL,
  `rate` float NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `prefix` (`prefix`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

ALTER TABLE `playsms_tblConfig_main` ADD `cfg_default_rate` FLOAT NOT NULL DEFAULT '0';
ALTER TABLE `playsms_tblConfig_main` ADD `cfg_language_module` VARCHAR(10) DEFAULT 'en_US' ;

ALTER TABLE `playsms_tblUser` ADD `credit` DOUBLE NOT NULL default '0';

DROP TABLE IF EXISTS `playsms_tblErrorString`;
CREATE TABLE `playsms_tblErrorString` (
  `id` INT NOT NULL AUTO_INCREMENT ,
  `error_string` TEXT NOT NULL ,
  PRIMARY KEY ( `id` )
) ENGINE=MYISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `playsms_tblBilling`;
CREATE TABLE `playsms_tblBilling` (
  `id` INT NOT NULL AUTO_INCREMENT ,
  `c_timestamp` INT NOT NULL ,
  `post_datetime` VARCHAR( 20 ) NOT NULL DEFAULT '0000-00-00 00:00:00',
  `smslog_id` INT NOT NULL ,
  `rate` FLOAT NOT NULL DEFAULT '0',
  `credit` DOUBLE NOT NULL DEFAULT '0',
  `status` TINYINT NOT NULL ,
  PRIMARY KEY ( `id` )
) ENGINE=MYISAM DEFAULT CHARSET=utf8;

RENAME TABLE `playsms_tblUserPhonebook`  TO `playsms_toolsSimplephonebook` ;
RENAME TABLE `playsms_tblUserGroupPhonebook`  TO `playsms_toolsSimplephonebook_group` ;
RENAME TABLE `playsms_tblUserGroupPhonebook_public`  TO `playsms_toolsSimplephonebook_group_public` ;

INSERT INTO `playsms_tblUser_country` (`country_id` , `country_name`) VALUES ('200', 'New Caledonia');

ALTER TABLE `playsms_gatewayUplink_config` ADD `cfg_additional_param` VARCHAR(250) DEFAULT '' ;
ALTER TABLE `playsms_gatewayKannel_config` ADD `cfg_additional_param` VARCHAR(250) DEFAULT '' ;
ALTER TABLE `playsms_gatewayClickatell_config` ADD `cfg_additional_param` VARCHAR(250) DEFAULT '' ;

ALTER TABLE `playsms_tblSMSOutgoing` CHANGE `p_footer` `p_footer` VARCHAR( 30 ) NOT NULL DEFAULT '';

ALTER TABLE `playsms_tblUser` ADD `datetime_timezone` VARCHAR( 30 ) NOT NULL DEFAULT '+0700' ;
ALTER TABLE `playsms_gatewayClickatell_config` ADD `cfg_datetime_timezone` VARCHAR( 30 ) NOT NULL DEFAULT '+0700' ;
ALTER TABLE `playsms_gatewayKannel_config` ADD `cfg_datetime_timezone` VARCHAR( 30 ) NOT NULL DEFAULT '+0700' ;
ALTER TABLE `playsms_gatewayUplink_config` ADD `cfg_datetime_timezone` VARCHAR( 30 ) NOT NULL DEFAULT '+0700' ;
ALTER TABLE `playsms_tblConfig_main` ADD `cfg_datetime_timezone` VARCHAR( 30 ) NOT NULL DEFAULT '+0700' ;
ALTER TABLE `playsms_tblConfig_main` ADD `cfg_sms_max_count` TINYINT( 4 ) NOT NULL DEFAULT '3' ;

UPDATE `playsms_tblUser` SET `datetime_timezone`='+0700' ;
UPDATE `playsms_gatewayClickatell_config` SET `cfg_datetime_timezone`='+0700' ;
UPDATE `playsms_gatewayKannel_config` SET `cfg_datetime_timezone`='+0700' ;
UPDATE `playsms_gatewayUplink_config` SET `cfg_datetime_timezone`='+0700' ;
UPDATE `playsms_tblConfig_main` SET `cfg_datetime_timezone`='+0700' ;
UPDATE `playsms_tblConfig_main` SET `cfg_sms_max_count`='3' ;

ALTER TABLE `playsms_tblConfig_main` ADD `cfg_default_credit` FLOAT NOT NULL DEFAULT '0',
ADD `cfg_enable_register` TINYINT( 4 ) NOT NULL DEFAULT '0',
ADD `cfg_enable_forgot` TINYINT( 4 ) NOT NULL DEFAULT '1' ;

UPDATE `playsms_tblConfig_main` SET `cfg_default_credit`='0' ;
UPDATE `playsms_tblConfig_main` SET `cfg_enable_register`='0' ;
UPDATE `playsms_tblConfig_main` SET `cfg_enable_forgot`='1' ;

ALTER TABLE `playsms_tblUserInbox` ADD `in_receiver` VARCHAR( 20 ) NOT NULL AFTER `in_sender` ;
ALTER TABLE `playsms_tblSMSIncoming` ADD `in_receiver` VARCHAR( 20 ) NOT NULL AFTER `in_sender` ;