Create Table Sales
CREATE SEQUENCE sales_sequence AS SMALLINT START 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1 ; CREATE TABLE sales ( id INT NOT NULL DEFAULT nextval( 'sales_sequence' ::regclass), name VARCHAR ( 50 ) NOT NULL , street VARCHAR ( 128 ), city VARCHAR ( 50 ) NOT NULL , phone VARCHAR ( 25 ) NOT NULL , cell VARCHAR ( 25 ), zip VARCHAR ( 6 ), created_at TIMESTAMP NOT NULL , updated_at TIMESTAMP NOT NULL ); ALTER TABLE ONLY sales ADD CONSTRAINT pk_sales PRIMARY KEY (id); CREATE TRIGGER sales_trig_create BEFORE INSERT ON sales FOR EACH ROW EXECUTE FUNCTION timestamp_on_create(); CREATE TRIGGER sales_trig_update BE...
Comments
Post a Comment