· 7 years ago · Sep 02, 2018, 03:32 PM
1CREATE TABLE IF NOT EXISTS `player_items` (
2 `player_id` int(11) NOT NULL DEFAULT '0',
3 `pid` int(11) NOT NULL DEFAULT '0',
4 `sid` int(11) NOT NULL DEFAULT '0',
5 `itemtype` smallint(6) NOT NULL DEFAULT '0',
6 `count` smallint(5) NOT NULL DEFAULT '0',
7 `attributes` blob NOT NULL,
8 FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
9 KEY `sid` (`sid`)
10) ENGINE=InnoDB;