6BgHUpPy

1
2--drop table if exists product_category cascade;
3--drop SEQUENCE product_category_id_seq;
4
5CREATE SEQUENCE product_category_id_seq
6    START WITH 1
7    INCREMENT BY 1
8    NO MINVALUE
9    NO MAXVALUE
10    CACHE 1;
11
12CREATE TABLE product_category (
13    id bigint NOT NULL DEFAULT nextval('product_category_id_seq'::regclass) ,
14    parent_id bigint,
15	code varchar(50),
16	name character varying(255),
17    creation_date timestamp without time zone DEFAULT now() NOT NULL
18);