
-- CREATE USER test WITH PASSWORD 'test' NOCREATEDB NOCREATEUSER;

CREATE TABLE "article" (
	id	integer,
	name	varchar(40),
	descr	varchar(80),
	price	float
);
GRANT ALL ON article TO test;

INSERT INTO article VALUES (1, 'product name 1', 'This is the first product', 32);
INSERT INTO article VALUES (2, 'product name 2', 'This is the second product', 18);
INSERT INTO article VALUES (3, 'product name 3', 'This is the thirdth product', 144);

CREATE TABLE "customer" (
	id		integer,
	name		varchar(40),
	givenname	varchar(20),
	age		integer
);
GRANT ALL ON customer TO test;

INSERT INTO customer VALUES (1, 'name 1', 'givenname 1', 27);
INSERT INTO customer VALUES (2, 'name 2', 'givenname 2', 48);
INSERT INTO customer VALUES (3, 'name 3', 'givenname 3', 72);


