upgrade_svn17080.sql 614 B

1234567891011121314
  1. CREATE TABLE IF NOT EXISTS `interreg` (
  2. `varname` varchar(11) NOT NULL,
  3. `value` varchar(20) NOT NULL,
  4. PRIMARY KEY (`varname`)
  5. ) ENGINE=InnoDB;
  6. INSERT INTO `interreg` (`varname`, `value`) VALUES
  7. ('nsiuid', '0');
  8. ALTER TABLE `auction` ADD `nsiuid` BIGINT NOT NULL DEFAULT '0';
  9. ALTER TABLE `cart_inventory` ADD `nsiuid` BIGINT NOT NULL DEFAULT '0';
  10. ALTER TABLE `guild_storage` ADD `nsiuid` BIGINT NOT NULL DEFAULT '0';
  11. ALTER TABLE `inventory` ADD `nsiuid` BIGINT NOT NULL DEFAULT '0';
  12. ALTER TABLE `mail` ADD `nsiuid` BIGINT NOT NULL DEFAULT '0';
  13. ALTER TABLE `storage` ADD `nsiuid` BIGINT NOT NULL DEFAULT '0';