1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85
| Table Créer Table
categories CREATE TABLE `categories` (
`id` int(4) NOT NULL DEFAULT '0',
`name` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
colors CREATE TABLE `colors` (
`id` int(4) NOT NULL DEFAULT '0',
`name` varchar(200) DEFAULT NULL,
`rgb` varchar(6) DEFAULT NULL,
`is_trans` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
inventories CREATE TABLE `inventories` (
`id` int(4) NOT NULL DEFAULT '0',
`version` int(4) DEFAULT NULL,
`set_num` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `set_num` (`set_num`),
CONSTRAINT `inventories_ibfk_1` FOREIGN KEY (`set_num`) REFERENCES `sets` (`set_num`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8
inventory_parts CREATE TABLE `inventory_parts` (
`inventory_id` int(4) DEFAULT NULL,
`part_num` varchar(20) DEFAULT NULL,
`color_id` int(4) DEFAULT NULL,
`quantity` int(4) DEFAULT NULL,
`is_spare` tinyint(1) DEFAULT NULL,
KEY `inventory_id` (`inventory_id`),
KEY `color_id` (`color_id`),
KEY `part_num` (`part_num`),
CONSTRAINT `inventory_parts_ibfk_1` FOREIGN KEY (`inventory_id`) REFERENCES `inventories` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `inventory_parts_ibfk_2` FOREIGN KEY (`color_id`) REFERENCES `colors` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `inventory_parts_ibfk_3` FOREIGN KEY (`part_num`) REFERENCES `parts` (`part_num`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8
inventory_sets CREATE TABLE `inventory_sets` (
`inventory_id` int(4) DEFAULT NULL,
`set_num` varchar(20) DEFAULT NULL,
`quantity` int(4) DEFAULT NULL,
KEY `inventory_id` (`inventory_id`),
KEY `set_num` (`set_num`),
CONSTRAINT `inventory_sets_ibfk_1` FOREIGN KEY (`inventory_id`) REFERENCES `inventories` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `inventory_sets_ibfk_2` FOREIGN KEY (`set_num`) REFERENCES `sets` (`set_num`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8
my_sets CREATE TABLE `my_sets` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`sets_id` int(4) NOT NULL,
`is_build` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sets_id` (`sets_id`),
CONSTRAINT `my_sets_ibfk_1` FOREIGN KEY (`sets_id`) REFERENCES `sets` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1
parts CREATE TABLE `parts` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`part_num` varchar(20) NOT NULL DEFAULT '',
`name` varchar(250) DEFAULT NULL,
`category_id` int(4) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `part_num` (`part_num`),
KEY `category_id` (`category_id`) USING BTREE,
CONSTRAINT `parts_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=35156 DEFAULT CHARSET=utf8
sets CREATE TABLE `sets` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`set_num` varchar(20) NOT NULL DEFAULT '',
`name` varchar(256) DEFAULT NULL,
`year` int(4) DEFAULT NULL,
`theme_id` int(4) DEFAULT NULL,
`num_parts` int(4) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `set_num` (`set_num`) USING BTREE,
KEY `theme_id` (`theme_id`),
CONSTRAINT `sets_ibfk_1` FOREIGN KEY (`theme_id`) REFERENCES `themes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=15643 DEFAULT CHARSET=utf8
stock CREATE TABLE `stock` (
`part_id` int(4) NOT NULL,
`quantity` int(4) DEFAULT NULL,
KEY `part_id` (`part_id`),
CONSTRAINT `stock_ibfk_1` FOREIGN KEY (`part_id`) REFERENCES `parts` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8
themes CREATE TABLE `themes` (
`id` int(4) NOT NULL,
`name` varchar(40) DEFAULT NULL,
`parent_id` int(4) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
Partager