-- Working as of April 16th, 2013

--
-- Table changes for table `auction`
--

ALTER TABLE `auction` ADD `unique_id` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `card3` ;

--
-- Table changes for table `cart_inventory`
--

ALTER TABLE `cart_inventory` ADD `unique_id` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `expire_time` ;

--
-- Table changes for table `char`
--

ALTER TABLE `char` ADD `slotchange` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `delete_date` ,
ADD `char_opt` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `slotchange`,
CHANGE `weapon` `weapon` SMALLINT( 6 ) UNSIGNED NOT NULL DEFAULT '0' ,
DROP INDEX `name` ,
ADD UNIQUE `name_key` ( `name` ) ;

--
-- Table changes for table `elemental`
--

ALTER TABLE `elemental` ADD `atk1` MEDIUMINT(6) unsigned NOT NULL default '0' AFTER `max_sp`,
ADD `atk2` MEDIUMINT(6) unsigned NOT NULL default '0' AFTER `atk1`,
ADD `matk` MEDIUMINT(6) unsigned NOT NULL default '0' AFTER `atk2`,
ADD `aspd` smallint(4) unsigned NOT NULL default '0' AFTER `matk`,
ADD `def` smallint(4) unsigned NOT NULL default '0' AFTER `aspd`,
ADD `mdef` smallint(4) unsigned NOT NULL default '0' AFTER `def`,
ADD `flee` smallint(4) unsigned NOT NULL default '0' AFTER `mdef`,
ADD `hit` smallint(4) unsigned NOT NULL default '0' AFTER `flee`,
DROP `str`,
DROP `agi`,
DROP `vit`,
DROP `int`,
DROP `dex`,
DROP `luk`;

--
-- Table changes for table `hotkey`
--

ALTER TABLE `hotkey` DROP INDEX `char_id`;

--
-- Table changes for table `global_reg_value`
--

ALTER TABLE `global_reg_value` CHANGE `type` `type` TINYINT( 1 ) NOT NULL DEFAULT '3',
DROP INDEX `char_id` ;

--
-- Table changes for table `guild_position`
--

ALTER TABLE `guild_position` DROP INDEX `guild_id` ;

--
-- Table changes for table `guild_storage`
--

ALTER TABLE `guild_storage` ADD `unique_id` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `expire_time` ;

--
-- Table changes for table `homunculus`
--

ALTER TABLE `homunculus` ADD `prev_class` MEDIUMINT( 9 ) NOT NULL DEFAULT '0' AFTER `class` ;

--
-- Table changes for table `inventory` 
--

ALTER TABLE `inventory` ADD `favorite` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
ADD `unique_id` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `favorite` ;

--
-- Table changes for table `login`
--

ALTER TABLE `login` CHANGE `level` `group_id` TINYINT( 3 ) NOT NULL DEFAULT '0',
ADD `character_slots` TINYINT( 3 ) unsigned NOT NULL default '0',
ADD `pincode` varchar(4) NOT NULL default '',
ADD `pincode_change` int(11) unsigned NOT NULL default '0';

--
-- Table changes for table `mail`
--

ALTER TABLE `mail` ADD `unique_id` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `card3` ;

--
-- Table changes for table `skill`
--

ALTER TABLE `skill` ADD `flag` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `lv` ,
DROP INDEX `char_id` ;

--
-- Table drop for unused table `skillcooldown`.
--

DROP TABLE `skillcooldown` ;

--
-- Table changes for table `skill_homunculus`
--

ALTER TABLE `skill_homunculus` DROP INDEX `homun_id`;

--
-- Table structure for new table `sql_updates`
--

CREATE TABLE IF NOT EXISTS `sql_updates` (
  `timestamp` int(11) unsigned NOT NULL,
  `ignored` enum('Yes','No') NOT NULL DEFAULT 'No',
  PRIMARY KEY (`timestamp`)
) ENGINE=MyISAM;

-- Existent updates to enter
INSERT INTO `sql_updates` (`timestamp`) VALUES (1360858500);
INSERT INTO `sql_updates` (`timestamp`) VALUES (1360951560);
INSERT INTO `sql_updates` (`timestamp`) VALUES (1362445531);
INSERT INTO `sql_updates` (`timestamp`) VALUES (1362528000);
INSERT INTO `sql_updates` (`timestamp`) VALUES (1362794218);
INSERT INTO `sql_updates` (`timestamp`) VALUES (1364409316);
INSERT INTO `sql_updates` (`timestamp`) VALUES (1366075474);
INSERT INTO `sql_updates` (`timestamp`) VALUES (1366078541);


--
-- Table changes for table `storage`
--

ALTER TABLE `storage` ADD `unique_id` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `expire_time` ;

--
-- Table structure for new table `interreg`
--

CREATE TABLE IF NOT EXISTS `interreg` (
  `varname` varchar(11) NOT NULL,
  `value` varchar(20) NOT NULL,
   PRIMARY KEY (`varname`)
) ENGINE=InnoDB;
INSERT INTO `interreg` (`varname`, `value`) VALUES
('unique_id', '0');