upgrade_svn1125.sql 813 B

123456789101112
  1. ALTER TABLE `mob_db2` Add column `Drop9id` mediumint(9) NOT NULL default '0';
  2. ALTER TABLE `mob_db2` Add column `Drop9per` mediumint(9) NOT NULL default '0';
  3. ALTER TABLE `mob_db2` Add column `DropCardid` mediumint(9) NOT NULL default '0';
  4. ALTER TABLE `mob_db2` Add column `DropCardper` mediumint(9) NOT NULL default '0';
  5. ALTER TABLE `mob_db2` Drop column `Item1`;
  6. ALTER TABLE `mob_db2` Drop column `Item2`;
  7. ALTER TABLE `mob_db2` Change column `Drop7d` `Drop7id` mediumint(9) NOT NULL default '0';
  8. ALTER TABLE `mob_db` Add column `Drop9id` mediumint(9) NOT NULL default '0';
  9. ALTER TABLE `mob_db` Add column `Drop9per` mediumint(9) NOT NULL default '0';
  10. ALTER TABLE `mob_db` Add column `DropCardid` mediumint(9) NOT NULL default '0';
  11. ALTER TABLE `mob_db` Add column `DropCardper` mediumint(9) NOT NULL default '0';