USE tucniakdb;
CREATE TABLE s_items (
	pk_s_items		INT 		NOT NULL PRIMARY KEY AUTO_INCREMENT,
	fk_s_codes		INT			NOT NULL,
	fk_s_messures	INT			NOT NULL,
	number			VARCHAR(10) NOT NULL,
	name 			VARCHAR(40) NOT NULL
);
CREATE TABLE s_messures (
	pk_s_messures	INT 		NOT NULL PRIMARY KEY AUTO_INCREMENT,
	messure 		VARCHAR(10) NOT NULL
);
CREATE TABLE s_codes (
	pk_s_codes		INT 		NOT NULL PRIMARY KEY AUTO_INCREMENT,
	code 			VARCHAR(10) NOT NULL
);
CREATE TABLE s_add (
	pk_s_add		INT			NOT NULL PRIMARY KEY AUTO_INCREMENT,
	fk_s_inputs 	INT			NOT NULL,
	fk_s_items	 	INT			NOT NULL,
	count			INT			NOT NULL,
	price			INT			NOT NULL
);
#	guarantiee		DATETIME	NOT NULL DEFAULT ""
CREATE TABLE s_inputs (
	pk_s_inputs		INT			NOT NULL PRIMARY KEY AUTO_INCREMENT,
	fk_a_letters	INT			NOT NULL,
	code			VARCHAR(10)	NOT NULL,
	date			DATETIME	NOT NULL
);
CREATE TABLE s_serial (
	pk_s_serial		INT			NOT NULL PRIMARY KEY AUTO_INCREMENT,
	fk_s_add		INT			NOT NULL,
	number			VARCHAR(20)	NOT NULL
);
CREATE TABLE s_output (
	pk_s_output		INT			NOT NULL PRIMARY KEY AUTO_INCREMENT,
	fk_s_outputs	INT 		NOT NULL,
	count			INT			NOT NULL,
	price			INT			NOT NULL
);
CREATE TABLE s_outputs (
	pk_s_outputs	INT			NOT NULL PRIMARY KEY AUTO_INCREMENT,
	fk_a_letters	INT			NOT NULL,
	code			VARCHAR(10)	NOT NULL,
	date			DATETIME	NOT NULL
);