DROP TABLE `playsms_tblErrorString` ;

ALTER TABLE `playsms_tblSMSTemplate` RENAME TO `playsms_toolsMsgtemplate` ;

ALTER TABLE `playsms_tblUser` ADD `register_datetime` varchar(20) NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `plus_sign_add` ;
ALTER TABLE `playsms_tblUser` ADD `lastupdate_datetime` varchar(20) NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `register_datetime` ;
ALTER TABLE `playsms_tblUser` ADD `token` VARCHAR(32) NOT NULL DEFAULT '' AFTER `password`;
ALTER TABLE `playsms_tblUser` ADD `enable_webservices` TINYINT(4) NOT NULL DEFAULT '0' AFTER `token`;
ALTER TABLE `playsms_tblUser` ADD `webservices_ip` varchar(100) NOT NULL DEFAULT '127.0.0.1, 192.168.*.*' AFTER `enable_webservices` ;
ALTER TABLE `playsms_tblUser` ADD `local_length` TINYINT NOT NULL DEFAULT '9' AFTER `plus_sign_add`;

ALTER TABLE `playsms_tblUser` MODIFY `password` varchar(32) NOT NULL ;

ALTER TABLE `playsms_tblSMSOutgoing` ADD `queue_code` varchar(40) NOT NULL ;

ALTER TABLE `playsms_featurePoll` ADD `poll_message_valid` varchar(100) NOT NULL ;
ALTER TABLE `playsms_featurePoll` ADD `poll_message_invalid` varchar(100) NOT NULL ;

ALTER TABLE `playsms_featureSubscribe` ADD `subscribe_param` varchar(20) NOT NULL ;
ALTER TABLE `playsms_featureSubscribe` ADD `unsubscribe_param` varchar(20) NOT NULL ;
ALTER TABLE `playsms_featureSubscribe` ADD `forward_param` varchar(20) NOT NULL ;

ALTER TABLE `playsms_featureSubscribe_msg` ADD `create_datetime` varchar(20) NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `msg` ;
ALTER TABLE `playsms_featureSubscribe_msg` ADD `update_datetime` varchar(20) NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `create_datetime` ;
ALTER TABLE `playsms_featureSubscribe_msg` ADD `counter` tinyint(4) NOT NULL DEFAULT '0' AFTER `update_datetime` ;

ALTER TABLE `playsms_gatewayUplink_config` ADD `cfg_token` varchar(32) NULL AFTER `cfg_password` ;

ALTER TABLE `playsms_gatewayUplink` ADD `up_remote_queue_code` varchar(32) NOT NULL, ADD `up_dst` varchar(100) NOT NULL ;

ALTER TABLE  `playsms_toolsSimplephonebook` CHANGE  `c_timestamp`  `c_timestamp` INT( 11 ) NOT NULL DEFAULT  '0',
CHANGE  `pid`  `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
CHANGE  `gpid`  `gpid` INT( 11 ) NOT NULL DEFAULT  '0',
CHANGE  `uid`  `uid` INT( 11 ) NOT NULL DEFAULT  '0',
CHANGE  `p_num`  `mobile` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '',
CHANGE  `p_desc`  `name` VARCHAR( 250 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '',
CHANGE  `p_email`  `email` VARCHAR( 250 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '' ;

RENAME TABLE  `playsms_toolsSimplephonebook` TO  `playsms_toolsPhonebook` ;

ALTER TABLE  `playsms_toolsSimplephonebook_group` CHANGE  `c_timestamp`  `c_timestamp` INT( 11 ) NOT NULL DEFAULT  '0',
CHANGE  `gpid`  `id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
CHANGE  `uid`  `uid` INT( 11 ) NOT NULL DEFAULT  '0',
CHANGE  `gp_name`  `name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '',
CHANGE  `gp_code`  `code` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '' ;

RENAME TABLE  `playsms_toolsSimplephonebook_group` TO  `playsms_toolsPhonebook_group` ;

--
-- Table structure for table `playsms_gatewayNexmo`
--

CREATE TABLE `playsms_gatewayNexmo` (
  `c_timestamp` int(11) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `local_slid` int(11) NOT NULL DEFAULT '0',
  `remote_slid` varchar(40) NOT NULL DEFAULT '',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `network` varchar(20) NOT NULL DEFAULT '',
  `error_text` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `playsms_gatewayNexmo`
--




