E9uneBuM

1create database products;
2use products;
3
4drop table if exists category;
5create table category(
6	id int(11) not null auto_increment,
7	parent_category_id int(11) default null,
8	name varchar(255) not null,
9	description text,
10	created_at datetime,
11	updated_at datetime,
12	primary key(id),
13	foreign key(parent_category_id)
14	references category(id) on update cascade on delete set null	
15)ENGINE=InnoDB default charset=utf8;
16
17drop table if exists item;
18create table item(
19	id int(11) not null auto_increment,
20	category_id int(11) not null,
21	name varhcar(255),
22	description text,
23	is_active tinyint(1) default 1,
24	created_at datetime,
25	updated_at datetime,
26	primary key(id),
27	foreign key(category_id)
28	references category(id) on update cascade on delete restrict	
29)ENGINE=InnoDB default charset=utf8;
30
31drop table if exists item_price;
32create table item_price;(
33	id int(11) auto_increment,
34	item_id int(11) not null,
35	price double(11,2) not null,
36	description text,
37	is_active tinyint(1) default 1,
38	created_at datetime,
39	updated_at datetime,
40	primary key(id),
41	foreign key(item_id)
42	references item(id) on update cascade on delete no action
43)ENGINE=InnoDB default charset=utf8;