Z2MrraGk

1CREATE TABLE IF NOT EXISTS `user_weapons` (
2	`ID` int(50) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3	`user_id` int(11) NOT NULL,
4	`weapon_part` int(50) UNSIGNED NOT NULL,
5	`quantity` int(10) UNSIGNED NOT NULL,
6	CONSTRAINT `fk_user_users`
7		FOREIGN KEY (`user_id`) REFERENCES `tbl_users`(user_id)
8		ON UPDATE CASCADE
9		ON DELETE CASCADE,
10	CONSTRAINT `fk_part_parts`
11		FOREIGN KEY (`weapon_part`) REFERENCES `weapons_parts`(part_id)
12		ON UPDATE CASCADE
13		ON DELETE CASCADE 
14) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;