playSMS Forum

playSMS version 1.0 has been released

Yeah, no party or anything. I thought it would but… nothing special on it though, just plain bugfixes and all :slight_smile:

Anyway, it has been released and its available for download, so, new installation can use that one instead of old 0.9.9.2

Upgrades from 1.0-rc9 is just like usual, replace all files, keep config.php and update DB. But the DB for 1.0-rc9 to 1.0 isn’t available on the package, so use below SQL inserts instead (save it to a file and insert to your DB), upgrade-to-10.sql:

-- 1.0


-- version
UPDATE `playsms_tblRegistry` SET `registry_value` = '1.0' WHERE `registry_group` = 'core' AND `registry_family` = 'config' AND `registry_key` = 'playsms_version' ;


-- phonebook
DROP INDEX `uid` ON `playsms_featurePhonebook` ;
DROP INDEX `mobile` ON `playsms_featurePhonebook` ;
DROP INDEX `uid_mobile` ON `playsms_featurePhonebook` ;

DROP INDEX `uid` ON `playsms_featurePhonebook_group` ;
DROP INDEX `flag_sender` ON `playsms_featurePhonebook_group` ;
DROP INDEX `code` ON `playsms_featurePhonebook_group` ;

DROP INDEX `pid` ON `playsms_featurePhonebook_group_contacts` ;
DROP INDEX `gpid` ON `playsms_featurePhonebook_group_contacts` ;

CREATE INDEX `pid` ON `playsms_featurePhonebook_group_contacts` (`pid`) ;
CREATE INDEX `gpid` ON `playsms_featurePhonebook_group_contacts` (`gpid`) ;

CREATE INDEX `uid` on `playsms_tblSMSOutgoing` (`uid`);
CREATE INDEX `in_uid` on `playsms_tblSMSIncoming` (`in_uid`);
CREATE INDEX `in_uid` on `playsms_tblSMSInbox` (`in_uid`);

Enjoy.

anton

1 Like