9
3

house_deposits.sql 539 B

1234567891011
  1. update commands set handler=518 where command='house_deposit';
  2. CREATE TABLE `character_house_deposits` (
  3. `timestamp` int(10) unsigned NOT NULL DEFAULT 0,
  4. `house_id` int(10) unsigned NOT NULL DEFAULT 0,
  5. `instance_id` int(10) unsigned NOT NULL DEFAULT 0,
  6. `name` varchar(64) not null default '',
  7. `amount` bigint unsigned NOT NULL DEFAULT 0,
  8. `last_amount` bigint unsigned NOT NULL DEFAULT 0,
  9. `status` int(10) unsigned NOT NULL DEFAULT 0,
  10. `last_status` int(10) unsigned NOT NULL DEFAULT 0
  11. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;