-
Notifications
You must be signed in to change notification settings - Fork 0
/
dog_show_data.sql
112 lines (102 loc) · 17 KB
/
dog_show_data.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
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
-- MyUser model
INSERT INTO exibition.core_myuser (id, password, last_login, is_superuser, username, first_name, last_name, is_staff, is_active, date_joined, email) VALUES (2, 'pbkdf2_sha256$720000$4HErCUbaLZZXNSpjVWZjPk$C/hn7MOwP5HgZ9+Y06LPcI432601P21pNXIapV0PTGk=', null, 0, 'john', 'John', 'Smith', 0, 1, '2024-02-29 18:43:31.193351', 'john@email.com');
INSERT INTO exibition.core_myuser (id, password, last_login, is_superuser, username, first_name, last_name, is_staff, is_active, date_joined, email) VALUES (3, 'pbkdf2_sha256$720000$qfWPaXFcVgJtbB4R89Vdms$qo4Z8my87cRRLzoBdQwTKDeijQgoceE5tY3bhF3zKj8=', null, 0, 'costa', 'Paulo', 'Costa', 0, 1, '2024-02-29 18:44:16.041525', 'costa@email.com');
INSERT INTO exibition.core_myuser (id, password, last_login, is_superuser, username, first_name, last_name, is_staff, is_active, date_joined, email) VALUES (4, 'pbkdf2_sha256$720000$HpGyHZYzUPqnUaNIlL9dCU$O3Tjvx1AozDJ8kwVoUPv5j7uUg2shhs6A3fWnQPY1uM=', null, 0, 'johnwick', 'John', 'Wick', 0, 1, '2024-02-29 18:44:46.040024', 'johnwick@email.com');
INSERT INTO exibition.core_myuser (id, password, last_login, is_superuser, username, first_name, last_name, is_staff, is_active, date_joined, email) VALUES (5, 'pbkdf2_sha256$720000$Q5WO4mNSaftTmbQfHbLprH$WVkG/2CsswNps1U7j278n+neh5J45g6IBjlya4kQ//8=', null, 0, 'bruswayne', 'Brus', 'Wayne', 0, 1, '2024-02-29 18:45:26.212586', 'bruswayne@email.com');
INSERT INTO exibition.core_myuser (id, password, last_login, is_superuser, username, first_name, last_name, is_staff, is_active, date_joined, email) VALUES (6, 'pbkdf2_sha256$720000$VoD82Uq4g9pzPueFrpnYXP$xAiRzNVffBcDIvvEBtlSqL6IaTwUJXG38RciOnmjoPQ=', null, 0, 'rose', 'Rose', 'Namajunas', 0, 1, '2024-02-29 18:46:11.052759', 'rose@email.com');
INSERT INTO exibition.core_myuser (id, password, last_login, is_superuser, username, first_name, last_name, is_staff, is_active, date_joined, email) VALUES (7, 'pbkdf2_sha256$720000$uiQiqGiQAMEuMSOczqjfWu$smDfEV1Hx+VNl1tiW0SMpeMkf+vLDVI1ZwUjm0ljH98=', null, 0, 'amanda', 'Amanda', 'Nunes', 0, 1, '2024-02-29 18:46:40.876868', 'amanda@email.com');
INSERT INTO exibition.core_myuser (id, password, last_login, is_superuser, username, first_name, last_name, is_staff, is_active, date_joined, email) VALUES (8, 'pbkdf2_sha256$720000$jnduSinlCqOUIURU9Zstcq$omQOoueF4p8XCISyiJNsd6pVB4FG8a3xKXmakrqKfuI=', null, 0, 'holly', 'Holly', 'Holm', 0, 1, '2024-02-29 18:47:29.049427', 'holly@email.com');
INSERT INTO exibition.core_myuser (id, password, last_login, is_superuser, username, first_name, last_name, is_staff, is_active, date_joined, email) VALUES (9, 'pbkdf2_sha256$720000$IA7Q22c7ahOmFvbm3E6ufw$LanRK8krJEzdgPRr4ffWF97Sg/zXoAhH6/WQV5sTYKQ=', null, 0, 'michael', 'Michael', 'Chandler', 0, 1, '2024-02-29 18:48:16.096915', 'michael@email.com');
INSERT INTO exibition.core_myuser (id, password, last_login, is_superuser, username, first_name, last_name, is_staff, is_active, date_joined, email) VALUES (10, 'pbkdf2_sha256$720000$ZYjbDwolbZnYwTK4aiFU8D$f9/K9xyl8S17byOI/rbEWBq17EHj9+PpNZOcf257A3Q=', null, 0, 'charles', 'Charles', 'Oliveira', 0, 1, '2024-02-29 18:48:40.745323', 'charles@email.com');
INSERT INTO exibition.core_myuser (id, password, last_login, is_superuser, username, first_name, last_name, is_staff, is_active, date_joined, email) VALUES (11, 'pbkdf2_sha256$720000$6XbNTu2iRSMvXhhClvRSks$vtLmBxFbPl46P2NlyIX+wLqEKwE3ii7ex1ecJOao7t4=', null, 0, 'alex', 'Alexander', 'Volkanovski', 0, 1, '2024-02-29 18:49:10.711703', 'alex@email.com');
INSERT INTO exibition.core_myuser (id, password, last_login, is_superuser, username, first_name, last_name, is_staff, is_active, date_joined, email) VALUES (12, 'pbkdf2_sha256$720000$Df5dOBfEg4j9wfWianaEer$qSvJw0DVzEjAv/3Mn1dZEBtmx3Gy6NlzgBY+TedP0vA=', null, 0, 'israel', 'Israel', 'Adesanya', 0, 1, '2024-02-29 18:49:39.875364', 'israel@email.com');
INSERT INTO exibition.core_myuser (id, password, last_login, is_superuser, username, first_name, last_name, is_staff, is_active, date_joined, email) VALUES (13, 'pbkdf2_sha256$720000$btBbGAECsbWIgyvUTysZMY$b6kk+mOVg3VjzWnXRIn/e8IUl3F5RLlJMFLbRReBuC8=', null, 0, 'rob', 'Robert', 'Wittaker', 0, 1, '2024-02-29 18:50:09.009004', 'rob@email.com');
INSERT INTO exibition.core_myuser (id, password, last_login, is_superuser, username, first_name, last_name, is_staff, is_active, date_joined, email) VALUES (14, 'pbkdf2_sha256$720000$l0gYhWcX7pxQYftHGlynry$jCz21dTOVUwisA3oVgvyQVUnCSyhqXGCojmdisxkXdk=', null, 0, 'forest', 'Forest', 'Gump', 0, 1, '2024-02-29 18:50:33.057590', 'forest@email.com');
INSERT INTO exibition.core_myuser (id, password, last_login, is_superuser, username, first_name, last_name, is_staff, is_active, date_joined, email) VALUES (15, 'pbkdf2_sha256$720000$HbiNuIj3MYzkmLPdOYSqSL$pbKtDtEvQ9ZMmazIk62z7NfSwEh8DAIZ4AzPvKjfgzs=', null, 0, 'ilia', 'Ilia', 'Topuria', 0, 1, '2024-02-29 18:51:02.773024', 'ilia@email.com');
INSERT INTO exibition.core_myuser (id, password, last_login, is_superuser, username, first_name, last_name, is_staff, is_active, date_joined, email) VALUES (16, 'pbkdf2_sha256$720000$IZBzYH0X0HNEZ8Cggwu5vZ$K3k+gdxo2rZA6upUItTnHnrbecyoCZidQ5z/8UJ8tFw=', null, 0, 'vukan', 'Vukan', 'Tasic', 0, 1, '2024-02-29 18:53:05.217253', 'vukan@email.com');
-- Owner model
INSERT INTO exibition.exibition_owner (id, phone, address, user_id) VALUES (2, null, null, 2);
INSERT INTO exibition.exibition_owner (id, phone, address, user_id) VALUES (3, null, null, 3);
INSERT INTO exibition.exibition_owner (id, phone, address, user_id) VALUES (4, null, null, 4);
INSERT INTO exibition.exibition_owner (id, phone, address, user_id) VALUES (5, null, null, 5);
INSERT INTO exibition.exibition_owner (id, phone, address, user_id) VALUES (6, null, null, 6);
INSERT INTO exibition.exibition_owner (id, phone, address, user_id) VALUES (7, null, null, 7);
INSERT INTO exibition.exibition_owner (id, phone, address, user_id) VALUES (8, null, null, 8);
INSERT INTO exibition.exibition_owner (id, phone, address, user_id) VALUES (9, null, null, 9);
INSERT INTO exibition.exibition_owner (id, phone, address, user_id) VALUES (10, null, null, 10);
INSERT INTO exibition.exibition_owner (id, phone, address, user_id) VALUES (11, null, null, 11);
INSERT INTO exibition.exibition_owner (id, phone, address, user_id) VALUES (12, null, null, 12);
INSERT INTO exibition.exibition_owner (id, phone, address, user_id) VALUES (13, null, null, 13);
INSERT INTO exibition.exibition_owner (id, phone, address, user_id) VALUES (14, null, null, 14);
INSERT INTO exibition.exibition_owner (id, phone, address, user_id) VALUES (15, null, null, 15);
INSERT INTO exibition.exibition_owner (id, phone, address, user_id) VALUES (16, null, null, 16);
-- Breed model
INSERT INTO exibition.exibition_breed (id, name, slug, description) VALUES (1, 'Labrador Retriever', 'labrador-retriever', 'Friendly and outgoing. Excellent with families.');
INSERT INTO exibition.exibition_breed (id, name, slug, description) VALUES (2, 'German Shepherd', 'german-shepherd', 'Loyal and courageous. Great for protection.');
INSERT INTO exibition.exibition_breed (id, name, slug, description) VALUES (3, 'Golden Retriever', 'golden-retriever', 'Intelligent and friendly. Good with children.');
INSERT INTO exibition.exibition_breed (id, name, slug, description) VALUES (4, 'Bulldog', 'bulldog', 'Docile and willful. Known for their distinctive appearance.');
INSERT INTO exibition.exibition_breed (id, name, slug, description) VALUES (5, 'Beagle', 'beagle', 'Gentle and even-tempered. Good companions.');
INSERT INTO exibition.exibition_breed (id, name, slug, description) VALUES (6, 'Poodle', 'poodle', 'Highly intelligent and easy to train. Comes in various sizes.');
INSERT INTO exibition.exibition_breed (id, name, slug, description) VALUES (7, 'Boxer', 'boxer', 'Energetic and playful. Protective and loyal.');
INSERT INTO exibition.exibition_breed (id, name, slug, description) VALUES (8, 'Dachshund', 'dachshund', 'Curious and brave. Recognizable by their elongated bodies.');
INSERT INTO exibition.exibition_breed (id, name, slug, description) VALUES (9, 'Siberian Husky', 'siberian-husky', 'Strong-willed and energetic. Needs plenty of exercise.');
INSERT INTO exibition.exibition_breed (id, name, slug, description) VALUES (10, 'Doberman Pinscher', 'doberman-pinscher', 'Intelligent and alert. Often used in police and military work.');
INSERT INTO exibition.exibition_breed (id, name, slug, description) VALUES (11, 'Jack Russel', 'jack-russel', 'Friendly and outgoing. Excellent with families.');
INSERT INTO exibition.exibition_breed (id, name, slug, description) VALUES (12, 'Belgian Shepherd', 'belgian-shepherd', 'Loyal and courageous. Great for protection.');
INSERT INTO exibition.exibition_breed (id, name, slug, description) VALUES (13, 'Pitbull', 'golden-retriever', 'Intelligent and friendly. Good with children.');
INSERT INTO exibition.exibition_breed (id, name, slug, description) VALUES (14, 'American Stafford', 'bulldog', 'Docile and willful. Known for their distinctive appearance.');
INSERT INTO exibition.exibition_breed (id, name, slug, description) VALUES (15, 'Alaskan Malamute', 'alaskan-malamute', 'Gentle and even-tempered. Good companions.');
-- Dog model
INSERT INTO exibition.exibition_dog (id, name, gender, age, weight, color, breed_id, owner_id, image) VALUES (1, 'Dog 1', 'M', 3, 25, 'Brown', 1, 1, null);
INSERT INTO exibition.exibition_dog (id, name, gender, age, weight, color, breed_id, owner_id, image) VALUES (2, 'Dog 2', 'F', 2, 20, 'Black', 2, 2, null);
INSERT INTO exibition.exibition_dog (id, name, gender, age, weight, color, breed_id, owner_id, image) VALUES (3, 'Dog 3', 'M', 4, 30, 'White', 3, 3, null);
INSERT INTO exibition.exibition_dog (id, name, gender, age, weight, color, breed_id, owner_id, image) VALUES (4, 'Dog 4', 'F', 5, 22, 'Golden', 4, 4, null);
INSERT INTO exibition.exibition_dog (id, name, gender, age, weight, color, breed_id, owner_id, image) VALUES (5, 'Dog 5', 'M', 2, 18, 'Tan', 5, 5, null);
INSERT INTO exibition.exibition_dog (id, name, gender, age, weight, color, breed_id, owner_id, image) VALUES (6, 'Dog 6', 'F', 1, 15, 'Gray', 6, 6, null);
INSERT INTO exibition.exibition_dog (id, name, gender, age, weight, color, breed_id, owner_id, image) VALUES (7, 'Dog 7', 'M', 3, 28, 'Black and White', 7, 7, null);
INSERT INTO exibition.exibition_dog (id, name, gender, age, weight, color, breed_id, owner_id, image) VALUES (8, 'Dog 8', 'F', 4, 26, 'Brindle', 8, 8, null);
INSERT INTO exibition.exibition_dog (id, name, gender, age, weight, color, breed_id, owner_id, image) VALUES (9, 'Dog 9', 'M', 2, 21, 'Red', 9, 9, null);
INSERT INTO exibition.exibition_dog (id, name, gender, age, weight, color, breed_id, owner_id, image) VALUES (10, 'Dog 10', 'F', 3, 24, 'Cream', 10, 10, null);
INSERT INTO exibition.exibition_dog (id, name, gender, age, weight, color, breed_id, owner_id, image) VALUES (11, 'Dog 11', 'M', 5, 32, 'Fawn', 1, 11, null);
INSERT INTO exibition.exibition_dog (id, name, gender, age, weight, color, breed_id, owner_id, image) VALUES (12, 'Dog 12', 'F', 2, 19, 'Blue', 2, 12, null);
INSERT INTO exibition.exibition_dog (id, name, gender, age, weight, color, breed_id, owner_id, image) VALUES (13, 'Dog 13', 'M', 1, 16, 'Liver', 3, 13, null);
INSERT INTO exibition.exibition_dog (id, name, gender, age, weight, color, breed_id, owner_id, image) VALUES (14, 'Dog 14', 'F', 4, 29, 'Silver', 4, 14, null);
INSERT INTO exibition.exibition_dog (id, name, gender, age, weight, color, breed_id, owner_id, image) VALUES (15, 'Dog 15', 'M', 3, 23, 'Yellow', 5, 15, null);
-- Sponsor model
INSERT INTO exibition.exibition_sponsor (id, name, contact_person, contact_email, contact_phone) VALUES (11, 'Sponsor 1', 'Person 1', 'sponsor1@example.com', 127890);
INSERT INTO exibition.exibition_sponsor (id, name, contact_person, contact_email, contact_phone) VALUES (12, 'Sponsor 2', 'Person 2', 'sponsor2@example.com', 238901);
INSERT INTO exibition.exibition_sponsor (id, name, contact_person, contact_email, contact_phone) VALUES (13, 'Sponsor 3', 'Person 3', 'sponsor3@example.com', 345612);
INSERT INTO exibition.exibition_sponsor (id, name, contact_person, contact_email, contact_phone) VALUES (14, 'Sponsor 4', 'Person 4', 'sponsor4@example.com', 456123);
INSERT INTO exibition.exibition_sponsor (id, name, contact_person, contact_email, contact_phone) VALUES (15, 'Sponsor 5', 'Person 5', 'sponsor5@example.com', 561234);
-- show model
INSERT INTO exibition.exibition_show (id, name, location, start_date, end_date, sponsor_id) VALUES (16, 'Show 1', 'Location 1', '2024-03-01 10:00:00', '2024-03-02 18:00:00', 11);
INSERT INTO exibition.exibition_show (id, name, location, start_date, end_date, sponsor_id) VALUES (17, 'Show 2', 'Location 2', '2024-03-10 09:00:00', '2024-03-12 17:00:00', 12);
INSERT INTO exibition.exibition_show (id, name, location, start_date, end_date, sponsor_id) VALUES (18, 'Show 3', 'Location 3', '2024-03-15 10:00:00', '2024-03-17 18:00:00', 12);
INSERT INTO exibition.exibition_show (id, name, location, start_date, end_date, sponsor_id) VALUES (19, 'Show 4', 'Location 4', '2024-03-20 09:00:00', '2024-03-22 17:00:00', 14);
INSERT INTO exibition.exibition_show (id, name, location, start_date, end_date, sponsor_id) VALUES (20, 'Show 5', 'Location 5', '2024-03-25 10:00:00', '2024-03-27 18:00:00', 15);
INSERT INTO exibition.exibition_show (id, name, location, start_date, end_date, sponsor_id) VALUES (21, 'Show 6', 'Location 6', '2024-03-30 09:00:00', '2024-04-01 17:00:00', 15);
INSERT INTO exibition.exibition_show (id, name, location, start_date, end_date, sponsor_id) VALUES (22, 'Show 7', 'Location 7', '2024-04-05 10:00:00', '2024-04-07 18:00:00', 15);
INSERT INTO exibition.exibition_show (id, name, location, start_date, end_date, sponsor_id) VALUES (23, 'Show 8', 'Location 8', '2024-04-10 09:00:00', '2024-04-12 17:00:00', 14);
INSERT INTO exibition.exibition_show (id, name, location, start_date, end_date, sponsor_id) VALUES (24, 'Show 9', 'Location 9', '2024-04-15 10:00:00', '2024-04-17 18:00:00', 12);
INSERT INTO exibition.exibition_show (id, name, location, start_date, end_date, sponsor_id) VALUES (25, 'Show 10', 'Location 10', '2024-04-20 09:00:00', '2024-04-22 17:00:00', 13);
INSERT INTO exibition.exibition_show (id, name, location, start_date, end_date, sponsor_id) VALUES (26, 'Show 11', 'Location 11', '2024-04-25 10:00:00', '2024-04-27 18:00:00', 13);
INSERT INTO exibition.exibition_show (id, name, location, start_date, end_date, sponsor_id) VALUES (27, 'Show 12', 'Location 12', '2024-04-30 09:00:00', '2024-05-02 17:00:00', 11);
INSERT INTO exibition.exibition_show (id, name, location, start_date, end_date, sponsor_id) VALUES (28, 'Show 13', 'Location 13', '2024-05-05 10:00:00', '2024-05-07 18:00:00', 15);
INSERT INTO exibition.exibition_show (id, name, location, start_date, end_date, sponsor_id) VALUES (29, 'Show 14', 'Location 14', '2024-05-10 09:00:00', '2024-05-12 17:00:00', 14);
INSERT INTO exibition.exibition_show (id, name, location, start_date, end_date, sponsor_id) VALUES (30, 'Show 15', 'Location 15', '2024-05-15 10:00:00', '2024-05-17 18:00:00', 13);
-- judge model
INSERT INTO exibition.exibition_judge (id, first_name, last_name, email, phone) VALUES (1, 'Judge 1', 'Lastname 1', 'judge1@example.com', 1235567);
INSERT INTO exibition.exibition_judge (id, first_name, last_name, email, phone) VALUES (2, 'Judge 2', 'Lastname 2', 'judge2@example.com', 9876210);
INSERT INTO exibition.exibition_judge (id, first_name, last_name, email, phone) VALUES (3, 'Judge 3', 'Lastname 3', 'judge3@example.com', 1231234);
INSERT INTO exibition.exibition_judge (id, first_name, last_name, email, phone) VALUES (4, 'Judge 4', 'Lastname 4', 'judge4@example.com', 9879876);
INSERT INTO exibition.exibition_judge (id, first_name, last_name, email, phone) VALUES (5, 'Judge 5', 'Lastname 5', 'judge5@example.com', 4890123);
INSERT INTO exibition.exibition_judge (id, first_name, last_name, email, phone) VALUES (6, 'Judge 6', 'Lastname 6', 'judge6@example.com', 7823456);
INSERT INTO exibition.exibition_judge (id, first_name, last_name, email, phone) VALUES (7, 'Judge 7', 'Lastname 7', 'judge7@example.com', 8234567);
INSERT INTO exibition.exibition_judge (id, first_name, last_name, email, phone) VALUES (8, 'Judge 8', 'Lastname 8', 'judge8@example.com', 5901234);
INSERT INTO exibition.exibition_judge (id, first_name, last_name, email, phone) VALUES (9, 'Judge 9', 'Lastname 9', 'judge9@example.com', 6012345);
INSERT INTO exibition.exibition_judge (id, first_name, last_name, email, phone) VALUES (10, 'Judge 10', 'Lastname 10', 'judge10@example.com', 3789012);
INSERT INTO exibition.exibition_judge (id, first_name, last_name, email, phone) VALUES (11, 'Judge 11', 'Lastname 11', 'judge11@example.com', 2345678);
INSERT INTO exibition.exibition_judge (id, first_name, last_name, email, phone) VALUES (12, 'Judge 12', 'Lastname 12', 'judge12@example.com', 2378901);
INSERT INTO exibition.exibition_judge (id, first_name, last_name, email, phone) VALUES (13, 'Judge 13', 'Lastname 13', 'judge13@example.com', 156789);
INSERT INTO exibition.exibition_judge (id, first_name, last_name, email, phone) VALUES (14, 'Judge 14', 'Lastname 14', 'judge14@example.com', 8934567);
INSERT INTO exibition.exibition_judge (id, first_name, last_name, email, phone) VALUES (15, 'Judge 15', 'Lastname 15', 'judge15@example.com', 9045678);