Changeset a436340 for src/main/resources/data.sql

Timestamp:

02/05/23 19:55:10 (17 months ago)

Author:

Gjoko Kostadinov <gjoko.kostadinov@…>

Branches:

master

Children:

2b0a4db

Parents:

cc52b09

Message:

Adding customer registration

File:

• src/main/resources/data.sql (modified) (1 diff)

src/main/resources/data.sql

@@ -4 +4 @@
 insert into stakeholder (id, created, email, first_name, last_name, modified, password, stakeholder_type, username)
 values (nextval('hibernate_sequence'), current_timestamp, 'user1@schedlr.com', 'gjoko', 'kostadinov', current_timestamp, '$2a$10$Zc28AcCpAgxB.e67UMF/2.FgchjH9QWB7z8nP0TdkrFneV4IHPXji','CUSTOMER', 'user');
+
+insert into business_type (id, created, modified, name)
+values (1, current_timestamp, current_timestamp, 'tailor'),
+       (2, current_timestamp, current_timestamp, 'nail salon'),
+       (3, current_timestamp, current_timestamp, 'massage parlor'),
+       (4, current_timestamp, current_timestamp, 'makeup studio'),
+       (5, current_timestamp, current_timestamp, 'hairdresser'),
+       (6, current_timestamp, current_timestamp, 'barber');
+
+insert into service_type (id, created, modified, name, business_type_id)
+values (nextval('hibernate_sequence'), current_timestamp, current_timestamp, 'haircut', 5),
+       (nextval('hibernate_sequence'), current_timestamp, current_timestamp, 'beard shaving', 6),
+       (nextval('hibernate_sequence'), current_timestamp, current_timestamp, 'eye brow plucking', 6),
+       (nextval('hibernate_sequence'), current_timestamp, current_timestamp, 'waxing', 6),
+       (nextval('hibernate_sequence'), current_timestamp, current_timestamp, 'nail extensions', 2),
+       (nextval('hibernate_sequence'), current_timestamp, current_timestamp, 'dress shortening', 1),
+       (nextval('hibernate_sequence'), current_timestamp, current_timestamp, 'holes fixing', 1);