DuskoDugousko

CREATE TABLE `types` (id TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,type VARCHAR(15) NOT NULL DEFAULT '',PRIMARY KEY (id));CREATE TABLE `packagings` (id TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,package VARCHAR(15) NOT NULL DEFAULT '',PRIMARY KEY (id));CREATE TABLE `materials` (id TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,name VARCHAR(15) NOT NULL DEFAULT '',PRIMARY KEY (id));CREATE TABLE `parts` (id TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,name VARCHAR(30) NOT NULL DEFAULT '',part_type TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,price SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,packaging TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,material TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,weight SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,width SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,height SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,PRIMARY KEY (id));CREATE TABLE `part_builds` (id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,part_id TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,stamp INT(10) UNSIGNED NOT NULL DEFAULT 0,modifications BLOB NOT NULL DEFAULT '',PRIMARY KEY (id));