ZevYkJTc

1create table if not exists shop_user
2(
3	id serial not null
4		constraint shop_user_pkey
5			primary key,
6	login varchar(50) not null,
7	password varchar(32),
8	hash varchar(32) not null
9)
10;
11
12alter table shop_user owner to postgres
13;
14
15create unique index if not exists shop_user_id_uindex
16	on shop_user (id)
17;
18
19create unique index if not exists shop_user_login_uindex
20	on shop_user (login)
21;
22
23create table if not exists goods
24(
25	id serial not null
26		constraint goods_pkey
27			primary key,
28	title varchar(100),
29	description varchar(500),
30	photo varchar(500),
31	price double precision
32)
33;
34
35alter table goods owner to postgres
36;
37
38create unique index if not exists goods_id_uindex
39	on goods (id)
40;
41
42UPDATE public.shop_user SET login = '2', password = 'c81e728d9d4c2f636f067f89cc14862c', hash = 'f4bdfe34e8078ce93cd4bee5391341e8' WHERE id = 2;
43UPDATE public.shop_user SET login = '1', password = 'c4ca4238a0b923820dcc509a6f75849b', hash = '2f24133949bd21d6020cb55dab75196a' WHERE id = 1;
44UPDATE public.goods SET title = 'Коробка', description = 'Отличная коробочка из икеи', photo = 'https://fabrikaupakovki.ru/upload/iblock/1d4/1d424d46c16117c6ad1c994f624a5b72.png', price = 20 WHERE id = 1;
45UPDATE public.goods SET title = 'Сумка', description = 'Легендарная клетчетая сумка', photo = 'http://sibregionopt.ru/images/cms/data/import_files/b8/sumka_hoz_2_kletchataya_shir45_40vys.jpeg', price = 100 WHERE id = 3;
46UPDATE public.goods SET title = 'Пакет', description = 'Пакет всему голова', photo = 'http://images.zakupka.com/i/firms/27/44/44722/paket-bmv-430-700_e508edd3d7aa0dc_800x600_1.jpg', price = 5 WHERE id = 2;