· 5 years ago · May 14, 2020, 01:40 PM
1-- MySQL dump 10.13 Distrib 5.7.30, for Linux (x86_64)
2--
3-- Host: 0.0.0.0 Database: bodyfit
4-- ------------------------------------------------------
5-- Server version 8.0.20
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT = @@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS = @@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION = @@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE = @@TIME_ZONE */;
12/*!40103 SET TIME_ZONE = '+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS = @@UNIQUE_CHECKS, UNIQUE_CHECKS = 0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS = @@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS = 0 */;
15/*!40101 SET @OLD_SQL_MODE = @@SQL_MODE, SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES = @@SQL_NOTES, SQL_NOTES = 0 */;
17
18--
19-- Table structure for table choice
20--
21SET FOREIGN_KEY_CHECKS = 0;
22DROP TABLE IF EXISTS choice;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE choice
26(
27 id int NOT NULL AUTO_INCREMENT,
28 title varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
29 measurement_unit smallint DEFAULT NULL,
30 value decimal(8, 2) DEFAULT NULL,
31 range_start int DEFAULT NULL,
32 range_end int DEFAULT NULL,
33 variable_id int DEFAULT NULL,
34 type smallint DEFAULT NULL COMMENT '(DC2Type:choiceType)',
35 icon varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
36 input_type smallint NOT NULL COMMENT '(DC2Type:inputChoiceType)',
37 is_active tinyint(1) NOT NULL,
38 sub_title varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
39 is_deny_select_another_choices tinyint(1) NOT NULL,
40 PRIMARY KEY (id),
41 KEY IDX_C1AB5A92F3037E8E (variable_id),
42 CONSTRAINT FK_C1AB5A92F3037E8E FOREIGN KEY (variable_id) REFERENCES variable (id) ON DELETE SET NULL
43) ENGINE = InnoDB
44 AUTO_INCREMENT = 95
45 DEFAULT CHARSET = utf8mb4
46 COLLATE = utf8mb4_unicode_ci;
47/*!40101 SET character_set_client = @saved_cs_client */;
48
49--
50-- Dumping data for table choice
51--
52
53LOCK TABLES choice WRITE;
54/*!40000 ALTER TABLE choice DISABLE KEYS */;
55INSERT INTO choice
56VALUES (1, 'Age', NULL, NULL, 18, 80, 1, 0, NULL, 2, 1, NULL, 0),
57 (2, 'Height', 1, NULL, 130, 199, 2, 1, NULL, 2, 1, NULL, 0),
58 (3, 'Height', 2, NULL, 4, 7, 2, 1, NULL, 2, 1, NULL, 0),
59 (4, 'Height_in', 2, NULL, 0, 11, 2, 6, NULL, 2, 1, NULL, 0),
60 (5, 'Current Weight', 1, NULL, 40, 179, 3, 2, NULL, 2, 1, NULL, 0),
61 (6, 'Desired Weight', 1, NULL, 40, 180, 5, 3, NULL, 2, 1, NULL, 0),
62 (7, 'Almost nothing', NULL, 1.00, NULL, NULL, 4, NULL, NULL, 0, 1, NULL, 0),
63 (8, 'Only walks', NULL, 2.00, NULL, NULL, 4, NULL, NULL, 0, 1, NULL, 0),
64 (9, '1-2 times a week', NULL, 3.00, NULL, NULL, 4, NULL, NULL, 0, 1, NULL, 0),
65 (10, '3-5 times a week', NULL, 4.00, NULL, NULL, 4, NULL, NULL, 0, 1, NULL, 0),
66 (11, '5-7 times a week', NULL, 5.00, NULL, NULL, 4, NULL, NULL, 0, 1, NULL, 0),
67 (12, 'Current Weight', 2, NULL, 90, 400, 3, 2, NULL, 2, 1, NULL, 0),
68 (13, 'Desired Weight', 2, NULL, 90, 400, 5, 3, NULL, 2, 1, NULL, 0),
69 (14, 'Man', NULL, 2.00, NULL, NULL, NULL, 5, NULL, 0, 1, NULL, 0),
70 (15, 'Woman', NULL, 1.00, NULL, NULL, NULL, 4, NULL, 0, 1, NULL, 0),
71 (16, 'At the office', NULL, 1.00, NULL, NULL, NULL, NULL, '7c3f75098d8e1d977c8c3f1f3a5c047b.svg', 0, 1,
72 NULL, 0),
73 (17, 'I go out at lunch time', NULL, 2.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
74 (18, 'Daily long walks', NULL, 2.00, NULL, NULL, NULL, NULL, '790d078074d718e5c40101364d8ed1a8.svg', 0, 1,
75 NULL, 0),
76 (19, 'Physical work', NULL, 3.00, NULL, NULL, NULL, NULL, 'a66b8a9a4c3397f0ba77ec6aec432d96.svg', 0, 1,
77 NULL, 0),
78 (20, 'Mostly at home', NULL, 4.00, NULL, NULL, NULL, NULL, '611cc8bb64c6a45bab3cedcbc4737f8f.svg', 0, 1,
79 NULL, 0),
80 (21, 'Only coffee or tea', 1, 1.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
81 (22, 'Less than 2 glasses (0,5 L)', 1, 2.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
82 (23, '2-6 glasses (0,5-1,5 L)', 1, 3.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
83 (24, '7-10 glasses (1,5-2,5 L)', 1, 4.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
84 (25, 'More than 10 glasses', 1, 5.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
85 (26, 'More than 10 glasses', 2, 5.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
86 (27, '7-10 glasses (56-80 oz)', 2, 4.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
87 (28, '2-6 glasses (16-48 oz)', 2, 3.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
88 (29, 'Less than 2 glasses (16 oz)', 2, 2.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
89 (30, 'Only coffee or tea', 2, 1.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
90 (31, 'Less than 5 hours', NULL, 1.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
91 (32, '5-6 hours', NULL, 2.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
92 (33, '6-7 hours', NULL, 3.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
93 (34, '7-8 hours', NULL, 3.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
94 (35, 'More than 8 hours', NULL, 4.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
95 (36, 'Potato', NULL, NULL, NULL, NULL, NULL, NULL, '8c22e8771fe04fc9075c68d5b516ceb0.svg', 1, 1, NULL, 0),
96 (37, 'Peas', NULL, NULL, NULL, NULL, NULL, NULL, '82c78edd8dbefd87ca612976ce6e90a4.svg', 1, 1, NULL, 0),
97 (38, 'Quinoa', NULL, NULL, NULL, NULL, NULL, NULL, '87c1bec10e773afc25d046d9c50410ad.svg', 1, 1, NULL, 0),
98 (39, 'Rice', NULL, NULL, NULL, NULL, NULL, NULL, '7a750fd17724b610c2b1c40dbdafbf5d.svg', 1, 1, NULL, 0),
99 (40, 'Mushrooms', NULL, NULL, NULL, NULL, NULL, NULL, '32ecacc8258e687532a41a63f12dac74.svg', 1, 1, NULL, 0),
100 (41, 'Couscous', NULL, NULL, NULL, NULL, NULL, NULL, 'cc92822a01243d19a37834eb688bacf2.svg', 1, 1, NULL, 0),
101 (42, 'Eggs', NULL, NULL, NULL, NULL, NULL, NULL, '798d6a0cdfcc5aada6278a7471ca80d9.svg', 1, 1, NULL, 0),
102 (43, 'Yogurt', NULL, NULL, NULL, NULL, NULL, NULL, '563ee28996c0fc9b16ecc5e86c46d429.svg', 1, 1, NULL, 0),
103 (44, 'Milk', NULL, NULL, NULL, NULL, NULL, NULL, '32cc8f9425e29ff82e3dd967724ff190.svg', 1, 1, NULL, 0),
104 (45, 'Cottage cheese', NULL, NULL, NULL, NULL, NULL, NULL, 'b25b5b5c72ed16ff8d4e6a16c432e870.svg', 1, 1,
105 NULL, 0),
106 (46, 'Tofu', NULL, NULL, NULL, NULL, NULL, NULL, '31e6b89944662421cfde08cac39b2267.svg', 1, 1, NULL, 0),
107 (47, 'Oatmeal', NULL, NULL, NULL, NULL, NULL, NULL, '0826cb08bbcf38fc0cf0492826dde2b4.svg', 1, 1, NULL, 0),
108 (48, 'Hummus', NULL, NULL, NULL, NULL, NULL, NULL, 'dfbdd7c452d9276fb10cb4a363f0c215.svg', 1, 1, NULL, 0),
109 (49, 'Noodles', NULL, NULL, NULL, NULL, NULL, NULL, '55a0ecb982f4fc69eb77707271324763.svg', 1, 1, NULL, 0),
110 (50, 'Plant milk', NULL, NULL, NULL, NULL, NULL, NULL, '098dcdbd6cb5b7d04c2fbd28be522b13.svg', 1, 1, NULL,
111 0),
112 (51, 'Turkey', NULL, NULL, NULL, NULL, NULL, NULL, 'ac4de36a386f36ef91ae9bad44d7a53d.svg', 1, 1, NULL, 0),
113 (52, 'Fish', NULL, NULL, NULL, NULL, NULL, NULL, '6f1b500d56d669da6d9439ac82ca8d0c.svg', 1, 1, NULL, 0),
114 (53, 'Beef', NULL, NULL, NULL, NULL, NULL, NULL, '1b46417cf7fc414ab4172c240d5a5f8e.svg', 1, 1, NULL, 0),
115 (54, 'Chicken', NULL, NULL, NULL, NULL, NULL, NULL, 'c97bcbbe5537574cdb0b60f470fa969e.svg', 1, 1, NULL, 0),
116 (55, 'Pork', NULL, NULL, NULL, NULL, NULL, NULL, 'd6dda5a0322bdb1c11945de958fe0517.svg', 1, 1, NULL, 0),
117 (56, 'less than 30 min', NULL, 30.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
118 (57, 'I'm lactose intolerant', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 1, NULL, 0),
119 (58, 'I don't eat gluten', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 1, NULL, 0),
120 (59, 'I'm vegetarian', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 1, NULL, 0),
121 (60, 'I'm vegan', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 1, NULL, 0),
122 (61, 'None of above', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 1, NULL, 0),
123 (62, 'Pear-shaped', NULL, 1.00, NULL, NULL, NULL, NULL, '984fa9792374cd8a057f37c72c9d753b.svg', 0, 1,
124 'Naturally slimmer shoulders and thicker thighs', 0),
125 (63, 'Hourglass', NULL, 3.00, NULL, NULL, NULL, NULL, 'c62219efee3d4776554333afd063ac59.svg', 0, 1,
126 'Wide bust and hips, a narrow waist', 0),
127 (64, 'ectomorph', NULL, 1.00, NULL, NULL, NULL, NULL, '771c854a894fbcf34139a02d3e517b8f.svg', 0, 1,
128 'Lean and long, fast metabolism', 0),
129 (65, 'mesomorph', NULL, 2.00, NULL, NULL, NULL, NULL, '1da08bb5af4e5709d51b03000eb0398c.svg', 0, 1,
130 'Muscular and well-built, average metabolism', 0),
131 (66, 'Lose weight', NULL, 1.00, NULL, NULL, NULL, NULL, '222f83767797f5a0b15ce7782c081f8b.svg', 0, 1,
132 'Start losing weight and burning fat', 0),
133 (67, 'Develop healthy habits', NULL, 2.00, NULL, NULL, NULL, NULL, '38a1d1874f780a221de6612638582971.svg',
134 0, 1, 'Get healthy eating habits on a balanced diet', 0),
135 (68, 'Increase energy', NULL, 3.00, NULL, NULL, NULL, NULL, '57d0b697e3b3dd74b4080e6b5e828de8.svg', 0, 1,
136 'Feel more active during the day', 0),
137 (69, 'endomorph', NULL, 3.00, NULL, NULL, NULL, NULL, '6459cb1159d87fb6295d38bb73b4b651.svg', 0, 1,
138 'Soft and round, slow metabolism', 0),
139 (70, 'Square-shaped', NULL, 2.00, NULL, NULL, NULL, NULL, 'e870af2c45da0d3212ec1d6c9330b539.svg', 0, 1,
140 'Naturally wide shoulders and thighs', 0),
141 (71, 'Yes', NULL, 1.00, NULL, NULL, NULL, NULL, '03b6595006bcc1ab8e2db1a2a31fecf5.svg', 0, 1, NULL, 0),
142 (72, 'No', NULL, 2.00, NULL, NULL, NULL, NULL, '08a0657635c5a4bce646e6d441798cbe.svg', 0, 1, NULL, 0),
143 (73, 'Less than 1 year', NULL, 1.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
144 (74, '1-3 years', NULL, 2.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
145 (75, 'More than 3 years', NULL, 3.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
146 (76, 'I\'ve never been at my ideal weight', NULL, 4.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
147 (77, 'I eat late at night', NULL, 1.00, NULL, NULL, NULL, NULL, '45dc735fe28163c82a995393cec81e3e.svg', 0,
148 1, NULL, 0),
149 (78, 'I don\'t get enough sleep', NULL, 2.00, NULL, NULL, NULL, NULL,
150 '0e5fe6563125bef5da1c2b023c2bb18d.svg', 0, 1, NULL, 0),
151 (79, 'I can\'t give up eating sweets', NULL, 3.00, NULL, NULL, NULL, NULL,
152 '2c3a29e24fe50623dacc5d4217b12b77.svg', 0, 1, NULL, 0),
153 (80, 'I love soft drinks', NULL, 4.00, NULL, NULL, NULL, NULL, '403da2455af5e7a413d9d90e3bd90f82.svg', 0,
154 1, NULL, 0),
155 (81, 'I consume a lot of salt', NULL, 5.00, NULL, NULL, NULL, NULL, '9c9013b9a45256b36be183c1060c5ed0.svg',
156 0, 1, NULL, 0),
157 (82, 'None of the above', NULL, 6.00, NULL, NULL, NULL, NULL, '6d00014b5742fe08a36e9b7b2c5422cb.svg', 0, 1,
158 NULL, 0),
159 (83, 'Steady', NULL, 1.00, NULL, NULL, NULL, NULL, '7d98b93b49803120770c40a34beeaab1.svg', 0, 1,
160 'I feel active all day long', 0),
161 (84, 'Dragging before meals', NULL, 2.00, NULL, NULL, NULL, NULL, 'd59eecbb9e8b1fce4fdfbc8d944c9c62.svg',
162 0, 1, 'I feel tired when hungry', 0),
163 (85, 'Post lunch slump', NULL, 3.00, NULL, NULL, NULL, NULL, '99c033fb3b3ba8a0536d50b73990f6ed.svg', 0, 1,
164 'I feel sleepy after meal', 0),
165 (86, '30-60 min', NULL, 60.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
166 (87, 'More than 1 hour', NULL, 61.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0),
167 (88, 'None', NULL, 88.00, NULL, NULL, NULL, NULL, '8a195643e8914629405aac7aee666df6.svg', 0, 1, NULL, 0),
168 (89, 'At the office', NULL, 1.00, NULL, NULL, NULL, NULL, '219bd11213643c85f33f6fa610454c91.svg', 0, 1,
169 NULL, 0),
170 (90, 'Daily long walks', NULL, 2.00, NULL, NULL, NULL, NULL, '8d7adbe78dde3b601203cb9b51d6b0dc.svg', 0, 1,
171 NULL, 0),
172 (91, 'Physical work', NULL, 3.00, NULL, NULL, NULL, NULL, '2e622118ced5f559619305e24719625d.svg', 0, 1,
173 NULL, 0),
174 (92, 'Yes', NULL, 1.00, NULL, NULL, NULL, NULL, '9d7b0cba6868b8d3492e8ff888fda888.svg', 0, 1, NULL, 0),
175 (93, 'No', NULL, 2.00, NULL, NULL, NULL, NULL, '6249ac3afa1cb9ecf3bb7f16e512aee8.svg', 0, 1, NULL, 0),
176 (94, 'Test', NULL, 123.00, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 0);
177/*!40000 ALTER TABLE `choice` ENABLE KEYS */;
178UNLOCK TABLES;
179
180--
181-- Table structure for table quiz_step
182--
183
184DROP TABLE IF EXISTS quiz_step;
185/*!40101 SET @saved_cs_client = @@character_set_client */;
186/*!40101 SET character_set_client = utf8 */;
187CREATE TABLE quiz_step
188(
189 id int NOT NULL AUTO_INCREMENT,
190 title varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
191 subtitle varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
192 description varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
193 is_auto_submit tinyint(1) NOT NULL DEFAULT '0',
194 is_with_measurement_units tinyint(1) NOT NULL DEFAULT '0',
195 type smallint DEFAULT NULL COMMENT '(DC2Type:quizStepType)',
196 static_page_id int DEFAULT NULL,
197 icon varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
198 is_active tinyint(1) NOT NULL,
199 url varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
200 icon_inactive varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
201 progress_bar_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
202 PRIMARY KEY (id),
203 UNIQUE KEY UNIQ_8948026795C43776 (static_page_id),
204 UNIQUE KEY UNIQ_89480267F47645AE (url),
205 CONSTRAINT FK_8948026795C43776 FOREIGN KEY (static_page_id) REFERENCES static_page (id)
206) ENGINE = InnoDB
207 AUTO_INCREMENT = 21
208 DEFAULT CHARSET = utf8mb4
209 COLLATE = utf8mb4_unicode_ci;
210/*!40101 SET character_set_client = @saved_cs_client */;
211
212--
213-- Dumping data for table quiz_step
214--
215
216LOCK TABLES quiz_step WRITE;
217/*!40000 ALTER TABLE quiz_step
218 DISABLE KEYS */;
219INSERT INTO quiz_step
220VALUES (1, 'Body measures', 'Got it. Let’s now check where we are', 'What are your current body dimensions?', 0, 1, 5,
221 NULL, 'cdf068b786bacad6587dff8f05cd7e96.svg', 1, 'step-measures', '6044d1dfaa08a7007c3e0c181b42495c.svg',
222 'Body measures'),
223 (2, 'Fitness',
224 'It is important to take into consideration the activity level for a [man/woman] who wants to [lose XX kg] and [works at the office]',
225 'What describes you best:', 1, 0, 2, NULL, 'd171b6fbd43d5db629666b651d79eedb.svg', 1, 'step-fitness',
226 '78047edc1a169facf7c8cc951f88cca5.svg', 'Fitness'),
227 (3, 'Get a guided weight loss plan', 'Pass our quick quiz to find out what works specifically for you',
228 'Select your gender', 1, 0, 0, NULL, '99e967686fd697fc23611a59e7e49697.svg', 1, 'step-gender',
229 '2c25502ebbfd2462bb4b1d8dae00c423.svg', 'Gender'),
230 (4, 'Typical day',
231 '[Men/women] in their [XX]s, who want to [Y], require a more personalized approach<br />depending on the current lifestyle.',
232 'Describe your typical day:', 1, 0, 1, 2, '1c2d1b202c86679645bb725f82cb10c2.svg', 1, 'step-typicalday',
233 '7fd9fc4d5a5630951ed5008afc2f1037.svg', 'Typical day'),
234 (5, 'Water', NULL, 'How much water do you drink daily?', 1, 1, 3, NULL, '4a328749bb87064018a444e8dab5ffd0.svg',
235 1, 'step-water', '935e2db9946959bebca0fc830b22aaf5.svg', 'Water'),
236 (6, 'Sleep', NULL, 'How much do you sleep?', 1, 0, 4, NULL, 'a727488a36ad1babf06c2dc1f531374d.svg', 1,
237 'step-sleep', '6b4efaabb96a180d5dac0a1dd3fba2d6.svg', 'Sleep'),
238 (7, 'Veggies', NULL, 'Mark the vegetables you want to include:', 0, 0, 6, NULL,
239 '225db1c2d25b39293edf59304f90009f.svg', 1, 'step-veggies', '5141887c1a70e68e6e56f8e3ecb038a3.svg', 'Veggies'),
240 (8, 'Products', NULL, 'Mark the products you want to include:', 0, 0, 7, NULL,
241 'e2829bcc0df0fb800d643504f5e9b72d.svg', 1, 'step-products', '7b0db5e3e333800eed4bb645eeed1bc0.svg', 'Products'),
242 (9, 'Meat', NULL, 'Mark the kinds of meat you want to include:', 0, 0, 8, NULL,
243 '37ec0881024329a35038365a9cdbcfff.svg', 1, 'step-meat', '770775d1df7fa424abf84123b5be854b.svg', 'Meat'),
244 (11, 'Time for meal preparation', NULL, 'How much time do you have for meal preparation?', 1, 0, 11, NULL,
245 '664a8ae9b735858678e2ebc4e00e4726.svg', 1, 'step-time', '89d14431970d780331217d23995f7b11.svg', 'Cooking time'),
246 (12, 'RESTRICTIONS', NULL, 'Do you have any dietary restrictions or allergies?', 0, 0, 10, NULL,
247 '140c796fb72a92c386b1e92c5c5eb649.svg', 1, 'step-restrictions', '4716457f71b215e14deb914fa1ba387d.svg',
248 'RESTRICTIONS'),
249 (13, 'Body type', 'Each body type has a specific metabolic structure',
250 'Select a body type that describes you best', 1, 0, NULL, NULL, 'f4e605c41f18c9283c7a6a74f3028895.svg', 1,
251 'step-bodytype', '887c0b4c39208cebcddf5ab227f7abe4.svg', 'Body type'),
252 (14, 'Goal', 'Well-balanced meals bring various positive effects, but we will focus on your goal the most.',
253 'What is a primary goal for you?', 1, 0, NULL, NULL, '28fbc8a46785fe84952cefddbfdf5651.svg', 1, 'step-goal',
254 'd8a10b3e7ad2947cd4e1ea2b1619e4a8.svg', 'Goal'),
255 (15, 'Desired weight', NULL, 'Ok, what is your perfect weight?', 0, 1, 12, NULL,
256 'e87ff3fe0da56798a924cbdff79fcbed.svg', 1, 'step-targetweight', '406e7f41564fd0825d9e51e379481bc6.svg',
257 'Desired weight'),
258 (16, 'Food processing', 'How you process food can have a tremendous impact on weight loss results.',
259 'Do you experience stomach discomfort during the day?', 1, 0, NULL, NULL,
260 'a240d136a8c8262cde87cfa89a0d94af.svg', 1, 'step-stomachdiscomfort', '344b655798afd3cc813f5e2e8f1eefd8.svg',
261 'Food processing'),
262 (17, 'Food processing', 'How you process food can have a tremendous impact on weight loss results.',
263 'Do you experience stomach heaviness in the morning?', 1, 0, NULL, NULL, '7fc5134564c1e84a111d85d1408905b7.svg',
264 1, 'step-stomachheaviness', '1bb9c31009508107159a06b8adec7a22.svg', 'Food processing'),
265 (18, 'Time since ideal weight', NULL, 'How long has it been since you were at your ideal weight?', 1, 0, NULL,
266 NULL, 'c7a1bd335e92e5356d59c8a3c846c797.svg', 1, 'step-sinceideal', 'ae07924d20848af2b1de1a72942171a2.svg',
267 'Time since ideal weight'),
268 (19, 'Habits', NULL, 'Select all that is true for you:', 0, 0, NULL, NULL,
269 '997b83e360c9ba363507ec7f968dc95a.svg', 1, 'step-eatinghabits', 'bc96df1e8d8d2700cacef4f3d23499ed.svg',
270 'Habits'),
271 (20, 'Energy level', NULL, 'How is your energy from day to day?', 1, 0, NULL, NULL,
272 '80147f99ad37ad3acea02fb3f8131c1b.svg', 1, 'step-energylevel', '3fc4b38666ced91171f2fb6d855535f8.svg',
273 'Energy level');
274/*!40000 ALTER TABLE quiz_step ENABLE KEYS */;
275UNLOCK TABLES;
276
277--
278-- Table structure for table quiz_step_choice
279--
280
281DROP TABLE IF EXISTS quiz_step_choice;
282/*!40101 SET @saved_cs_client = @@character_set_client */;
283/*!40101 SET character_set_client = utf8 */;
284CREATE TABLE quiz_step_choice
285(
286 id int NOT NULL AUTO_INCREMENT,
287 choice_id int NOT NULL,
288 quiz_step_id int DEFAULT NULL,
289 position smallint unsigned NOT NULL DEFAULT '0',
290 PRIMARY KEY (id),
291 KEY IDX_C3938448998666D1 (choice_id),
292 KEY IDX_C393844861E8B33C (quiz_step_id),
293 CONSTRAINT FK_C393844861E8B33C FOREIGN KEY (quiz_step_id) REFERENCES quiz_step (id),
294 CONSTRAINT FK_C3938448998666D1 FOREIGN KEY (choice_id) REFERENCES choice (id)
295) ENGINE = InnoDB
296 AUTO_INCREMENT = 100
297 DEFAULT CHARSET = utf8mb4
298 COLLATE = utf8mb4_unicode_ci;
299/*!40101 SET character_set_client = @saved_cs_client */;
300
301--
302-- Dumping data for table quiz_step_choice
303--
304
305LOCK TABLES quiz_step_choice WRITE;
306/*!40000 ALTER TABLE quiz_step_choice DISABLE KEYS */;
307INSERT INTO quiz_step_choice
308VALUES (1, 1, 1, 1),
309 (2, 2, 1, 2),
310 (3, 5, 1, 3),
311 (4, 3, 1, 4),
312 (5, 4, 1, 5),
313 (6, 12, 1, 6),
314 (7, 7, 2, 1),
315 (8, 8, 2, 2),
316 (9, 9, 2, 3),
317 (10, 10, 2, 4),
318 (11, 11, 2, 5),
319 (12, 14, 3, 1),
320 (13, 15, 3, 2),
321 (14, 21, 5, 1),
322 (15, 22, 5, 2),
323 (16, 23, 5, 3),
324 (17, 24, 5, 4),
325 (18, 25, 5, 5),
326 (19, 30, 5, 6),
327 (20, 29, 5, 7),
328 (21, 28, 5, 8),
329 (22, 27, 5, 9),
330 (23, 26, 5, 10),
331 (24, 16, 4, 1),
332 (26, 18, 4, 2),
333 (27, 19, 4, 3),
334 (28, 20, 4, 4),
335 (29, 31, 6, 1),
336 (30, 32, 6, 2),
337 (32, 34, 6, 3),
338 (33, 35, 6, 4),
339 (34, 36, 7, 4),
340 (35, 37, 7, 5),
341 (36, 38, 7, 3),
342 (37, 39, 7, 1),
343 (38, 40, 7, 2),
344 (39, 41, 7, 6),
345 (40, 42, 8, 9),
346 (41, 43, 8, 1),
347 (42, 44, 8, 7),
348 (43, 45, 8, 5),
349 (44, 46, 8, 2),
350 (45, 47, 8, 6),
351 (46, 48, 8, 8),
352 (47, 49, 8, 4),
353 (48, 50, 8, 3),
354 (49, 51, 9, 1),
355 (50, 52, 9, 2),
356 (51, 53, 9, 5),
357 (52, 54, 9, 3),
358 (53, 55, 9, 4),
359 (54, 56, 11, 1),
360 (55, 61, 12, 5),
361 (56, 57, 12, 1),
362 (57, 58, 12, 2),
363 (58, 59, 12, 3),
364 (59, 60, 12, 4),
365 (60, 65, 13, 2),
366 (61, 64, 13, 1),
367 (64, 66, 14, 1),
368 (65, 67, 14, 2),
369 (66, 68, 14, 3),
370 (69, 13, 15, 1),
371 (70, 6, 15, 2),
372 (71, 69, 13, 3),
373 (72, 62, 13, 4),
374 (73, 70, 13, 5),
375 (74, 63, 13, 6),
376 (75, 71, 16, 1),
377 (76, 72, 16, 2),
378 (77, 92, 17, 1),
379 (78, 93, 17, 2),
380 (79, 73, 18, 1),
381 (80, 74, 18, 2),
382 (81, 75, 18, 3),
383 (82, 76, 18, 4),
384 (83, 77, 19, 1),
385 (84, 78, 19, 2),
386 (85, 79, 19, 3),
387 (86, 80, 19, 4),
388 (87, 81, 19, 5),
389 (88, 82, 19, 6),
390 (89, 83, 20, 1),
391 (90, 84, 20, 2),
392 (91, 85, 20, 3),
393 (92, 86, 11, 2),
394 (93, 87, 11, 3),
395 (94, 88, 9, 6),
396 (95, 89, 4, 5),
397 (96, 90, 4, 6),
398 (97, 91, 4, 7),
399 (99, 94, 20, 4);
400/*!40000 ALTER TABLE quiz_step_choice ENABLE KEYS */;
401UNLOCK TABLES;
402
403--
404-- Table structure for table quiz_step_group
405--
406
407DROP TABLE IF EXISTS quiz_step_group;
408/*!40101 SET @saved_cs_client = @@character_set_client */;
409/*!40101 SET character_set_client = utf8 */;
410CREATE TABLE quiz_step_group
411(
412 id int NOT NULL AUTO_INCREMENT,
413 site_id int DEFAULT NULL,
414 url varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
415 name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
416 default_measure_unit smallint NOT NULL,
417 user_registration_form_position smallint NOT NULL,
418 is_active tinyint(1) NOT NULL,
419 is_default_for_site tinyint(1) NOT NULL,
420 price_package_id int DEFAULT NULL,
421 PRIMARY KEY (id),
422 UNIQUE KEY UNIQ_388D940640C4A4FB (price_package_id),
423 KEY IDX_388D9406F6BD1646 (site_id),
424 CONSTRAINT FK_388D940640C4A4FB FOREIGN KEY (price_package_id) REFERENCES price_package (id),
425 CONSTRAINT FK_388D9406F6BD1646 FOREIGN KEY (site_id) REFERENCES site (id)
426) ENGINE = InnoDB
427 AUTO_INCREMENT = 3
428 DEFAULT CHARSET = utf8mb4
429 COLLATE = utf8mb4_unicode_ci;
430/*!40101 SET character_set_client = @saved_cs_client */;
431
432--
433-- Dumping data for table quiz_step_group
434--
435
436LOCK TABLES quiz_step_group WRITE;
437/*!40000 ALTER TABLE quiz_step_group DISABLE KEYS */;
438INSERT INTO quiz_step_group
439VALUES (1, 1, 'test', 'test', 1, 0, 1, 1, 1),
440 (2, 1, 'test3', 'test', 1, 0, 0, 0, 2);
441/*!40000 ALTER TABLE quiz_step_group ENABLE KEYS */;
442UNLOCK TABLES;
443
444--
445-- Table structure for table quiz_step_group_choice_item
446--
447
448DROP TABLE IF EXISTS quiz_step_group_choice_item;
449/*!40101 SET @saved_cs_client = @@character_set_client */;
450/*!40101 SET character_set_client = utf8 */;
451CREATE TABLE quiz_step_group_choice_item
452(
453 id int NOT NULL AUTO_INCREMENT,
454 current_choice_id int DEFAULT NULL,
455 quiz_step_group_item_id int NOT NULL,
456 quiz_step_choice_id int NOT NULL,
457 range_start int DEFAULT NULL,
458 range_end int DEFAULT NULL,
459 input_type smallint NOT NULL COMMENT '(DC2Type:inputChoiceType)',
460 PRIMARY KEY (id),
461 KEY IDX_14D8EF8E42A0D77D (current_choice_id),
462 KEY IDX_14D8EF8E88B01CCA (quiz_step_group_item_id),
463 KEY IDX_14D8EF8E2E21863A (quiz_step_choice_id),
464 CONSTRAINT FK_14D8EF8E2E21863A FOREIGN KEY (quiz_step_choice_id) REFERENCES quiz_step_choice (id) ON DELETE CASCADE,
465 CONSTRAINT FK_14D8EF8E42A0D77D FOREIGN KEY (current_choice_id) REFERENCES choice (id),
466 CONSTRAINT FK_14D8EF8E88B01CCA FOREIGN KEY (quiz_step_group_item_id) REFERENCES quiz_step_group_item (id) ON DELETE CASCADE
467) ENGINE = InnoDB
468 AUTO_INCREMENT = 146
469 DEFAULT CHARSET = utf8mb4
470 COLLATE = utf8mb4_unicode_ci;
471/*!40101 SET character_set_client = @saved_cs_client */;
472
473--
474-- Dumping data for table quiz_step_group_choice_item
475--
476
477LOCK TABLES quiz_step_group_choice_item WRITE;
478/*!40000 ALTER TABLE quiz_step_group_choice_item DISABLE KEYS */;
479INSERT INTO quiz_step_group_choice_item
480VALUES (1, 14, 1, 12, NULL, NULL, 0),
481 (2, 15, 1, 13, NULL, NULL, 0),
482 (13, 7, 4, 7, NULL, NULL, 0),
483 (14, 8, 4, 8, NULL, NULL, 0),
484 (15, 9, 4, 9, NULL, NULL, 0),
485 (16, 10, 4, 10, NULL, NULL, 0),
486 (17, 11, 4, 11, NULL, NULL, 0),
487 (32, 61, 7, 55, NULL, NULL, 3),
488 (33, 57, 7, 56, NULL, NULL, 3),
489 (34, 58, 7, 57, NULL, NULL, 3),
490 (35, 59, 7, 58, NULL, NULL, 3),
491 (36, 60, 7, 59, NULL, NULL, 3),
492 (43, 21, 10, 14, NULL, NULL, 0),
493 (44, 22, 10, 15, NULL, NULL, 0),
494 (45, 23, 10, 16, NULL, NULL, 0),
495 (46, 24, 10, 17, NULL, NULL, 0),
496 (47, 25, 10, 18, NULL, NULL, 0),
497 (48, 30, 10, 19, NULL, NULL, 0),
498 (49, 29, 10, 20, NULL, NULL, 0),
499 (50, 28, 10, 21, NULL, NULL, 0),
500 (51, 27, 10, 22, NULL, NULL, 0),
501 (52, 26, 10, 23, NULL, NULL, 0),
502 (53, 36, 11, 34, NULL, NULL, 1),
503 (54, 37, 11, 35, NULL, NULL, 1),
504 (55, 38, 11, 36, NULL, NULL, 1),
505 (56, 39, 11, 37, NULL, NULL, 1),
506 (57, 40, 11, 38, NULL, NULL, 1),
507 (58, 41, 11, 39, NULL, NULL, 1),
508 (59, 31, 12, 29, NULL, NULL, 0),
509 (60, 32, 12, 30, NULL, NULL, 0),
510 (62, 34, 12, 32, NULL, NULL, 0),
511 (63, 35, 12, 33, NULL, NULL, 0),
512 (64, 65, 13, 60, NULL, NULL, 0),
513 (65, 64, 13, 61, NULL, NULL, 0),
514 (66, 69, 13, 71, NULL, NULL, 0),
515 (67, 62, 13, 72, NULL, NULL, 0),
516 (68, 70, 13, 73, NULL, NULL, 0),
517 (69, 63, 13, 74, NULL, NULL, 0),
518 (70, 1, 14, 1, 18, 80, 2),
519 (71, 2, 14, 2, 130, 199, 2),
520 (72, 5, 14, 3, 40, 179, 2),
521 (73, 3, 14, 4, 4, 7, 2),
522 (74, 4, 14, 5, 0, 11, 2),
523 (75, 12, 14, 6, 90, 400, 2),
524 (76, 42, 15, 40, NULL, NULL, 1),
525 (77, 43, 15, 41, NULL, NULL, 1),
526 (78, 44, 15, 42, NULL, NULL, 1),
527 (79, 45, 15, 43, NULL, NULL, 1),
528 (80, 46, 15, 44, NULL, NULL, 1),
529 (81, 47, 15, 45, NULL, NULL, 1),
530 (82, 48, 15, 46, NULL, NULL, 1),
531 (83, 49, 15, 47, NULL, NULL, 1),
532 (84, 50, 15, 48, NULL, NULL, 1),
533 (85, 13, 16, 69, 90, 400, 2),
534 (86, 6, 16, 70, 40, 180, 2),
535 (101, 56, 19, 54, NULL, NULL, 0),
536 (102, 86, 19, 92, NULL, NULL, 0),
537 (103, 87, 19, 93, NULL, NULL, 0),
538 (104, 16, 20, 24, NULL, NULL, 0),
539 (105, 18, 20, 26, NULL, NULL, 0),
540 (106, 19, 20, 27, NULL, NULL, 0),
541 (107, 20, 20, 28, NULL, NULL, 0),
542 (108, 89, 20, 95, NULL, NULL, 0),
543 (109, 90, 20, 96, NULL, NULL, 0),
544 (110, 91, 20, 97, NULL, NULL, 0),
545 (112, 66, 21, 64, NULL, NULL, 0),
546 (113, 67, 21, 65, NULL, NULL, 0),
547 (114, 68, 21, 66, NULL, NULL, 0),
548 (119, 51, 24, 49, NULL, NULL, 1),
549 (120, 52, 24, 50, NULL, NULL, 1),
550 (121, 53, 24, 51, NULL, NULL, 1),
551 (122, 54, 24, 52, NULL, NULL, 1),
552 (123, 55, 24, 53, NULL, NULL, 1),
553 (124, 88, 24, 94, NULL, NULL, 0),
554 (125, 73, 25, 79, NULL, NULL, 0),
555 (126, 74, 25, 80, NULL, NULL, 0),
556 (127, 75, 25, 81, NULL, NULL, 0),
557 (128, 76, 25, 82, NULL, NULL, 0),
558 (129, 77, 26, 83, NULL, NULL, 0),
559 (130, 78, 26, 84, NULL, NULL, 0),
560 (131, 79, 26, 85, NULL, NULL, 0),
561 (132, 80, 26, 86, NULL, NULL, 0),
562 (133, 81, 26, 87, NULL, NULL, 0),
563 (134, 82, 26, 88, NULL, NULL, 0),
564 (135, 83, 27, 89, NULL, NULL, 0),
565 (136, 84, 27, 90, NULL, NULL, 0),
566 (137, 85, 27, 91, NULL, NULL, 0),
567 (138, 71, 28, 75, NULL, NULL, 0),
568 (139, 72, 28, 76, NULL, NULL, 0),
569 (140, 92, 29, 77, NULL, NULL, 0),
570 (141, 93, 29, 78, NULL, NULL, 0),
571 (142, 83, 30, 89, NULL, NULL, 0),
572 (143, 84, 30, 90, NULL, NULL, 0),
573 (144, 85, 30, 91, NULL, NULL, 0),
574 (145, 94, 30, 99, NULL, NULL, 0);
575/*!40000 ALTER TABLE quiz_step_group_choice_item ENABLE KEYS */;
576UNLOCK TABLES;
577
578--
579-- Table structure for table quiz_step_group_item
580--
581
582DROP TABLE IF EXISTS quiz_step_group_item;
583/*!40101 SET @saved_cs_client = @@character_set_client */;
584/*!40101 SET character_set_client = utf8 */;
585CREATE TABLE quiz_step_group_item
586(
587 id int NOT NULL AUTO_INCREMENT,
588 quiz_step_id int NOT NULL,
589 quiz_step_group_id int DEFAULT NULL,
590 position smallint NOT NULL,
591 PRIMARY KEY (id),
592 KEY IDX_12EE27E61E8B33C (quiz_step_id),
593 KEY IDX_12EE27EE4E80939 (quiz_step_group_id),
594 CONSTRAINT FK_12EE27E61E8B33C FOREIGN KEY (quiz_step_id) REFERENCES quiz_step (id),
595 CONSTRAINT FK_12EE27EE4E80939 FOREIGN KEY (quiz_step_group_id) REFERENCES quiz_step_group (id)
596) ENGINE = InnoDB
597 AUTO_INCREMENT = 31
598 DEFAULT CHARSET = utf8mb4
599 COLLATE = utf8mb4_unicode_ci;
600/*!40101 SET character_set_client = @saved_cs_client */;
601
602--
603-- Dumping data for table quiz_step_group_item
604--
605
606LOCK TABLES quiz_step_group_item WRITE;
607/*!40000 ALTER TABLE quiz_step_group_item DISABLE KEYS */;
608INSERT INTO quiz_step_group_item
609VALUES (1, 3, 1, 1),
610 (4, 2, 1, 11),
611 (7, 12, 1, 16),
612 (10, 5, 1, 14),
613 (11, 7, 1, 17),
614 (12, 6, 1, 13),
615 (13, 13, 1, 5),
616 (14, 1, 1, 4),
617 (15, 8, 1, 18),
618 (16, 15, 1, 3),
619 (19, 11, 1, 15),
620 (20, 4, 1, 6),
621 (21, 14, 1, 2),
622 (24, 9, 1, 19),
623 (25, 18, 1, 9),
624 (26, 19, 1, 10),
625 (27, 20, 1, 12),
626 (28, 16, 1, 7),
627 (29, 17, 1, 8),
628 (30, 20, 2, 1);
629/*!40000 ALTER TABLE quiz_step_group_item ENABLE KEYS */;
630UNLOCK TABLES;
631/*!40103 SET TIME_ZONE = @OLD_TIME_ZONE */;
632
633/*!40101 SET SQL_MODE = @OLD_SQL_MODE */;
634/*!40014 SET FOREIGN_KEY_CHECKS = @OLD_FOREIGN_KEY_CHECKS */;
635/*!40014 SET UNIQUE_CHECKS = @OLD_UNIQUE_CHECKS */;
636/*!40101 SET CHARACTER_SET_CLIENT = @OLD_CHARACTER_SET_CLIENT */;
637/*!40101 SET CHARACTER_SET_RESULTS = @OLD_CHARACTER_SET_RESULTS */;
638/*!40101 SET COLLATION_CONNECTION = @OLD_COLLATION_CONNECTION */;
639/*!40111 SET SQL_NOTES = @OLD_SQL_NOTES */;
640
641-- Dump completed on 2020-05-14 13:51:31
642SET FOREIGN_KEY_CHECKS = 1