dbScript.txt

--usuario insertado para facilitar utilización
--username: 'admin'	password: 'admin'

CREATE DATABASE "EP2"
    WITH 
    OWNER = postgres
    ENCODING = 'UTF8'
    LC_COLLATE = 'English_United States.1252'
    LC_CTYPE = 'English_United States.1252'
    TABLESPACE = pg_default
    CONNECTION LIMIT = -1;

CREATE TABLE public.appuser
(
 	idUser serial primary key,
	fullname character varying(50) not null,
	username character varying(50) not null unique,
	password character varying(50) not null,
	userType bool not null
)

TABLESPACE pg_default;

ALTER TABLE public.appuser
    OWNER to postgres;


CREATE TABLE public.address
(
    idAddress serial primary key,
	idUser int references appuser(idUser),
	address character varying(50) not null
)

TABLESPACE pg_default;

ALTER TABLE public.address
    OWNER to postgres;

CREATE TABLE public.business
(
    idBusiness serial primary key,
	name character varying(50) not null,
	description character varying(100) not null
)

TABLESPACE pg_default;

ALTER TABLE public.business
    OWNER to postgres;	

CREATE TABLE public.product
(
    idProduct serial primary key,		
	idBusiness int references business(idBusiness),
	name character varying(50) not null
)

TABLESPACE pg_default;

ALTER TABLE public.product
    OWNER to postgres;

CREATE TABLE public.apporder
(
    idOrder serial primary key,
	createDate date not null,		
	idProduct int  references product(idProduct),
	idAddress int references address(idAddress)
)

TABLESPACE pg_default;

ALTER TABLE public.apporder
    OWNER to postgres;
	
INSERT INTO appuser (username, password, usertype, fullname)
VALUES ('admin', '21232f297a57a5a743894a0e4a801fc3', true, 'admin');