-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathsql.txt
145 lines (133 loc) · 8.36 KB
/
sql.txt
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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
INSERT INTO roles(name) VALUES('ROLE_USER');
INSERT INTO roles(name) VALUES('ROLE_MODERATOR');
INSERT INTO roles(name) VALUES('ROLE_ADMIN');
INSERT INTO public.categories(
description, name, status)
VALUES ( 'Tropikal Meyveler', 'tropikalMeyveler', 0);
INSERT INTO public.categories(
description, name, status)
VALUES ( 'Yumuşak Meyveler', 'yumusakMeyveler', 0);
INSERT INTO public.categories(
description, name, status)
VALUES ( 'Turunçgiller', 'turuncgiller', 1);
INSERT INTO public.categories(
description, name, status)
VALUES ( 'Yeşil Sebzeler', 'yesilSebzeler', 1);
INSERT INTO public.categories(
description, name, status)
VALUES ( 'Kök Sebzeler', 'kokSebzeler', 1);
INSERT INTO public.categories(
description, name, status)
VALUES ( 'Soğanlı Sebzeler', 'soganliSebzeler', 0);
INSERT INTO public.categories(
description, name, status)
VALUES ( 'Yapraklı Sebzeler', 'yaprakliSebzeler', 0);
INSERT INTO public.notices(
description, first_line, img_path, name, second_line, status, third_line)
VALUES ( 'offer2', '100 TL ve üzeri alışverişinizde', 'images/offers/offer2.jpg', 'offer2', 'Fırsat', 1, 'Ücretsiz kargo');
INSERT INTO public.notices(
description, first_line, img_path, name, second_line, status, third_line)
VALUES ( 'offer1', 'Meyve Sebzeler', 'images/offers/offer1.jpg', 'offer1', 'Organic', 1, 'Her zaman Taze');
INSERT INTO public.products(
description, img_path, name, price, status, category_id)
VALUES ( 'Haşlamalık Patates', 'patates.jpg', 'Patates',12.50,1,5);
INSERT INTO public.products(
description, img_path, name,price,status, category_id)
VALUES ( 'Yatak limonu', 'limon.jpg', 'Limon',18.00,1,3);
INSERT INTO public.products(
description, img_path, name, price, status, category_id)
VALUES ( 'Tane Karnabahar', 'Karnabahar.jpg', 'Karnabahar',20.00,1,4);
INSERT INTO public.products(
description, img_path, name, price,status, category_id)
VALUES ( 'Misket Limonu', 'misketlimonu.jpg', 'Misket limonu',25.00,1,3);
INSERT INTO public.products(
description, img_path, name, price, status, category_id)
VALUES ( 'İthal Ananas', 'ananas.jpg', 'Ananas',40.00,1,1);
INSERT INTO public.products(
description, img_path, name, price, status, category_id)
VALUES ( 'İthal Mango', 'mango.jpg', 'Mango',30.00,1,1);
INSERT INTO public.products(
description, img_path, name, price, status, category_id)
VALUES ( 'Dağ Çileği', 'çilek.jpg', 'Çilek',35.00,1,2);
INSERT INTO public.products(
description, img_path, name, price, status, category_id)
VALUES ( 'Salkım Üzüm', 'üzüm.jpg', 'Üzüm',25.00,1,2);
INSERT INTO public.products(
description, img_path, name, price, status, category_id)
VALUES ( 'Kızartmalık Kabak', 'kabak.jpg', 'Kabak',8.00,1,4);
INSERT INTO public.products(
description, img_path, name, price, status, category_id)
VALUES ( 'Kırmızı Turp', 'turp.jpg', 'Turp',10.00,1,5);
INSERT INTO public.products(
description, img_path, name, price, status, category_id)
VALUES ( 'Şeker havuç', 'havuc.jpg', 'Havuç',22.5,1,5);
INSERT INTO public.products(
description, img_path, name, price, status, category_id)
VALUES ( 'Kuru Soğan', 'soğan.jpg', 'Soğan',11.5,1,6);
INSERT INTO public.products(
description, img_path, name, price, status, category_id)
VALUES ( 'Taşköprü Sarımsak', 'sarımsak.jpg', 'Sarımsak',45.5,1,6);
INSERT INTO public.products(
description, img_path, name, price, status, category_id)
VALUES ( 'Kıvırcık Marul', 'marul.jpg', 'Marul',7.5,1,7);
INSERT INTO public.products(
description, img_path, name, price, status, category_id)
VALUES ( 'Dere Otu', 'dereotu.jpg', 'Dere otu',5.5,1,7);
INSERT INTO public.cities(name)VALUES ( 'İSTANBUL');
INSERT INTO public.districts(name, city_id) VALUES ( 'BEŞİKTAŞ', 1);
INSERT INTO public.districts(name, city_id) VALUES ( 'ŞİŞLİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('VİŞNEZADE MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('SİNANPAŞA MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('MURADİYE MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('CİHANNÜMA MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('TÜRKALİ MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('ABBASAĞA MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('YILDIZ MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('DİKİLİTAŞ MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('GAYRETTEPE MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('BALMUMCU MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('MECİDİYE MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('ORTAKÖY MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('LEVAZIM MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('ULUS MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('KURUÇEŞME MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('KÜLTÜR MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('NİSBETİYE MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('ARNAVUTKÖY MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('BEBEK MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('ETİLER MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('AKAT MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('LEVENT MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('KONAKLAR MAHALLESİ', 1);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('19 MAYIS MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('BOZKURT MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('CUMHURİYET MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('DUATEPE MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('ERGENEKON MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('ESKİŞEHİR MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('FERİKÖY MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('FULYA MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('GÜLBAHAR MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('HALİDE EDİP ADIVAR MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('HALİL RIFAT PAŞA MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('HALASKARGAZİ MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('HARBİYE MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('KAPTANPAŞA MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('KUŞTEPE MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('MAHMUT ŞEVKET PAŞA MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('MECİDİYEKÖY MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('MERKEZ MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('MEŞRUTİYET MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('PAŞA MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('TEŞVİKİYE MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('YAYLA MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('İNÖNÜ MAHALLESİ', 2);
INSERT INTO public.neighborhoods(name, district_id) VALUES ('İZZET PAŞA MAHALLESİ', 2);
Tropikal Meyveler: Ananas, mango, papaya, guava, kivi vb.
Kırmızı Meyveler: Çilek, kiraz, karpuz, kırmızı üzüm, nar vb.
Turunçgiller: Portakal, mandalina, greyfurt, limon, limetta vb.
Yumuşak Meyveler: Muz, armut, avokado, şeftali, nektarin vb.
Yeşil Sebzeler: Brokoli, kuşkonmaz, ıspanak, Brüksel lahanası, karnabahar vb.
Kök Sebzeler: Havuç, patates, kereviz, pancar, turp, şalgam vb.
Yapraklı Sebzeler: Marul, roka, pazı, lahana, pırasa vb.
Soğanlı Sebzeler: Soğan, sarımsak, taze soğan, pırasa vb.