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` ;
