Advertisement
GOODPower

Untitled

Mar 7th, 2014
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.85 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `items` (
  2.   `object_id` INT(11) NOT NULL,
  3.   `owner_id` INT(11) NOT NULL,
  4.   `item_id` INT(7) NOT NULL,
  5.   `count` BIGINT(20) NOT NULL,
  6.   `enchant_level` INT(11) NOT NULL,
  7.   `loc` VARCHAR(32) NOT NULL,
  8.   `loc_data` INT(11) NOT NULL,
  9.   `life_time` INT(11) NOT NULL,  
  10.   `augmentation_id` INT(11) NOT NULL,
  11.   `attribute_fire` INT(11) NOT NULL,
  12.   `attribute_water` INT(11) NOT NULL,
  13.   `attribute_wind` INT(11) NOT NULL,
  14.   `attribute_earth` INT(11) NOT NULL,
  15.   `attribute_holy` INT(11) NOT NULL,
  16.   `attribute_unholy` INT(11) NOT NULL,
  17.   `custom_type1` INT(5) NOT NULL,
  18.   `custom_type2` INT(5) NOT NULL,
  19.   `custom_flags` INT(11) NOT NULL,
  20.   `agathion_energy` INT(11) NOT NULL,
  21.   PRIMARY KEY  (`object_id`),
  22.   KEY `owner_id` (`owner_id`),
  23.   KEY `loc` (`loc`),
  24.   KEY `item_id` (`item_id`)
  25. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement