Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `items` (
- `object_id` INT(11) NOT NULL,
- `owner_id` INT(11) NOT NULL,
- `item_id` INT(7) NOT NULL,
- `count` BIGINT(20) NOT NULL,
- `enchant_level` INT(11) NOT NULL,
- `loc` VARCHAR(32) NOT NULL,
- `loc_data` INT(11) NOT NULL,
- `life_time` INT(11) NOT NULL,
- `augmentation_id` INT(11) NOT NULL,
- `attribute_fire` INT(11) NOT NULL,
- `attribute_water` INT(11) NOT NULL,
- `attribute_wind` INT(11) NOT NULL,
- `attribute_earth` INT(11) NOT NULL,
- `attribute_holy` INT(11) NOT NULL,
- `attribute_unholy` INT(11) NOT NULL,
- `custom_type1` INT(5) NOT NULL,
- `custom_type2` INT(5) NOT NULL,
- `custom_flags` INT(11) NOT NULL,
- `agathion_energy` INT(11) NOT NULL,
- PRIMARY KEY (`object_id`),
- KEY `owner_id` (`owner_id`),
- KEY `loc` (`loc`),
- KEY `item_id` (`item_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement