-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinit.sql
72 lines (61 loc) · 2.53 KB
/
init.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
insert into categories_category (id, clr, desc, name)
values
('c001', 'red', 'none', 'solid'),
('c002', 'green', 'none', 'food');
insert into products_product (ttl, desc, img, id, cat_id)
values
('chair', 'used to seat', 'imgs/chair_h6pQLPi.jpeg', 'p001', 'c001'),
('table', 'used to eat on it', '', 'p002', 'c002'),
('sardine', 'none', '', 'p003', 'c001'),
('laptop', 'u r on a one right now', '', 'p004', 'c002'),
('sneakers', 'none', '', 'p005', 'c002');
insert into storagesites_sitetype (name)
values
('Public'),
('Private'),
('Hazmat'),
('Cold storage'),
('Smart'),
('Distribution Center');
insert into storagesites_site (id, addr, img, name, type_id, phone)
values
('s001', 'safi', '', 'marsa', 4, '0636363636'),
('s002', 'youssoufia', '', 'local', 2, '0636363637'),
('s003', 'rabat', '', 'center', 5, '0636363638'),
('s004', 'agadir', '', 'garage', 2, '0636363639');
insert into suppliers_supplier (id, is_active, addr, desc, email, img, name, site, phone)
values
('s001', true, 'youssoufia', 'what ever u want', '[email protected]', 'http://nelson.com/', 'karim4business', '', '0636363640'),
('s002', true, 'agadir', 'none', '[email protected]', '', 'cna3', 'https://peterson.com/', '0636363641'),
('s003', false, 'safi', 'none', '[email protected]', '', 'ocp', 'https://www.smith-jackson.org/', '0636363642');
insert into items_item (id, img, desc, qty, ttl, site_id, suppl_id, prod_id, currency, price)
values
('i001', '', 'none', 10, 'chair', 's001', 's001', 'p001', 'MAD', 0),
('i002', '', 'none', 40, 'laptop', 's002', 's002', 'p002', 'MAD', 0),
('i003', '', 'none', 60, 'pc case', 's003', 's003', 'p003', 'MAD', 0),
('i004', '', 'none', 6, 'table', 's004', 's001', 'p004', 'MAD', 0),
('i005', '', 'none', 190, 'cable', 's002', 's002', 'p005', 'MAD', 0),
('i006', '', 'none', 300, 'book', 's002', 's003', 'p001', 'MAD', 0),
('i007', '', 'none', 200, 'notebook', 's003', 's001', 'p002', 'MAD', 0),
('i008', '', 'none', 1100, 'sardine', 's004', 's002', 'p003', 'MAD', 0),
('i009', '', 'none', 1000, 'indomi', 's001', 's003', 'p004', 'MAD', 0),
('i010', '', 'none', 150, 'momo', 's002', 's001', 'p005', 'MAD', 0),
('i011', '', 'none', 120, 'mirindina','s002', 's002', 'p001', 'MAD', 0),
('i012', '', 'none', 10000, 'kabaila', 's003', 's003', 'p005', 'MAD', 0);
insert into users_user
values
(
1,
'pbkdf2_sha256$720000$Y9CmQU2sbpdnVEg6EUFwKU$SDUnK+lGhqwhl1yhQzP+6PUG9C9Iipv/1rg3i623w7Y=',
NULL,
1,
'karim',
1,
1,
'2024-08-24 03:35:09.233883',
'staff',
NULL,NULL,'',
'karim','elkhanoufi',
'2024-08-24 03:35:09.233924'
);