cRawrhnL

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
4
5ALTER TABLE `facult`.`users_discussions_messages_emails` 
6DROP FOREIGN KEY `fk_users_discussions_messages_emails_discussions_messages1`;
7
8ALTER TABLE `facult`.`study_fields` 
9DROP FOREIGN KEY `fk_study_fields_study_fields1`;
10
11ALTER TABLE `facult`.`users_events_emails` 
12DROP FOREIGN KEY `fk_users_events_emails_events1`;
13
14ALTER TABLE `facult`.`jobs_fulltext` 
15COLLATE = utf8_general_ci ;
16
17ALTER TABLE `facult`.`users_discussions_messages_emails` 
18DROP INDEX `fk_users_discussions_messages_emails_discussions_messages1_idx` ;
19
20ALTER TABLE `facult`.`users_fulltext` 
21COLLATE = utf8_general_ci ;
22
23ALTER TABLE `facult`.`users_favourites_search_cv` 
24ADD INDEX `fk_users_favourites_search_cv_jobs1_idx` (`job_id` ASC),
25DROP INDEX `job_id` ;
26
27ALTER TABLE `facult`.`users_events_emails` 
28DROP INDEX `fk_users_events_emails_events1_idx` ;
29
30ALTER TABLE `facult`.`newsletters` 
31CHANGE COLUMN `hide_unsubscribe` `hide_unsubscribe` TINYINT(1) NULL DEFAULT 0 ;
32
33ALTER TABLE `facult`.`proudly_likes` 
34ADD INDEX `fk_proudly_likes_jobs_responses1_idx` (`job_response_id` ASC),
35DROP INDEX `fk_proudly_likes_jobs_responses1` ;
36
37CREATE TABLE IF NOT EXISTS `facult`.`cms_admins_passwords` (
38  `admin_password_id` INT(11) NOT NULL AUTO_INCREMENT,
39  `admin_id` INT(11) NOT NULL,
40  `token` VARCHAR(100) NULL DEFAULT NULL,
41  `pwd` VARCHAR(64) NULL DEFAULT NULL,
42  `created` DATETIME NULL DEFAULT NULL,
43  PRIMARY KEY (`admin_password_id`),
44  INDEX `fk_cms_admins_passwords_cms_admins1_idx` (`admin_id` ASC),
45  CONSTRAINT `fk_cms_admins_passwords_cms_admins1`
46    FOREIGN KEY (`admin_id`)
47    REFERENCES `facult`.`cms_admins` (`admin_id`)
48    ON DELETE CASCADE
49    ON UPDATE CASCADE)
50ENGINE = InnoDB
51DEFAULT CHARACTER SET = utf8
52COLLATE = utf8_czech_ci;
53
54ALTER TABLE `facult`.`favourites_search_cv_blacklist_emails` 
55CHANGE COLUMN `email` `email` VARCHAR(255) NULL DEFAULT NULL ;
56
57ALTER TABLE `facult`.`jobs_timeline_records` 
58CHANGE COLUMN `job_id` `job_id` INT(11) NOT NULL AFTER `entity_id`;
59
60DROP TABLE IF EXISTS `facult`.`webinars_registrations` ;
61
62DROP TABLE IF EXISTS `facult`.`vouchers` ;
63
64DROP TABLE IF EXISTS `facult`.`users_tests_questions` ;
65
66DROP TABLE IF EXISTS `facult`.`tests_questions` ;
67
68DROP TABLE IF EXISTS `facult`.`tests_answers` ;
69
70DROP TABLE IF EXISTS `facult`.`surveys_many_answers` ;
71
72DROP TABLE IF EXISTS `facult`.`surveys_answers` ;
73
74DROP TABLE IF EXISTS `facult`.`surveys` ;
75
76DROP TABLE IF EXISTS `facult`.`subscribed_messages` ;
77
78DROP TABLE IF EXISTS `facult`.`seminars` ;
79
80DROP TABLE IF EXISTS `facult`.`products_variants_properties_values` ;
81
82DROP TABLE IF EXISTS `facult`.`products_variants_attributes_associated` ;
83
84DROP TABLE IF EXISTS `facult`.`products_variants` ;
85
86DROP TABLE IF EXISTS `facult`.`products_units` ;
87
88DROP TABLE IF EXISTS `facult`.`products_templates_properties` ;
89
90DROP TABLE IF EXISTS `facult`.`products_templates_groups` ;
91
92DROP TABLE IF EXISTS `facult`.`products_templates` ;
93
94DROP TABLE IF EXISTS `facult`.`products_stocks` ;
95
96DROP TABLE IF EXISTS `facult`.`products_properties_values` ;
97
98DROP TABLE IF EXISTS `facult`.`products_properties_enums` ;
99
100DROP TABLE IF EXISTS `facult`.`products_properties` ;
101
102DROP TABLE IF EXISTS `facult`.`products_price_levels` ;
103
104DROP TABLE IF EXISTS `facult`.`products_icons` ;
105
106DROP TABLE IF EXISTS `facult`.`products_folders_associated` ;
107
108DROP TABLE IF EXISTS `facult`.`products_folders` ;
109
110DROP TABLE IF EXISTS `facult`.`products_colors` ;
111
112DROP TABLE IF EXISTS `facult`.`products_brands` ;
113
114DROP TABLE IF EXISTS `facult`.`products_attributes_associated` ;
115
116DROP TABLE IF EXISTS `facult`.`products_attributes` ;
117
118DROP TABLE IF EXISTS `facult`.`products` ;
119
120DROP TABLE IF EXISTS `facult`.`polls_votes` ;
121
122DROP TABLE IF EXISTS `facult`.`polls_answers` ;
123
124DROP TABLE IF EXISTS `facult`.`polls` ;
125
126DROP TABLE IF EXISTS `facult`.`orders_vouchers` ;
127
128DROP TABLE IF EXISTS `facult`.`orders_states` ;
129
130DROP TABLE IF EXISTS `facult`.`orders_products_jobs` ;
131
132DROP TABLE IF EXISTS `facult`.`orders_products_cvs` ;
133
134DROP TABLE IF EXISTS `facult`.`orders_products` ;
135
136DROP TABLE IF EXISTS `facult`.`orders_invoices` ;
137
138DROP TABLE IF EXISTS `facult`.`orders` ;
139
140DROP TABLE IF EXISTS `facult`.`news_folders` ;
141
142DROP TABLE IF EXISTS `facult`.`news` ;
143
144DROP TABLE IF EXISTS `facult`.`invoices_ranges` ;
145
146DROP TABLE IF EXISTS `facult`.`invoices_items` ;
147
148DROP TABLE IF EXISTS `facult`.`invoices_documents` ;
149
150DROP TABLE IF EXISTS `facult`.`invoices` ;
151
152DROP TABLE IF EXISTS `facult`.`events_study_fields` ;
153
154DROP TABLE IF EXISTS `facult`.`events_attendants` ;
155
156DROP TABLE IF EXISTS `facult`.`events` ;
157
158DROP TABLE IF EXISTS `facult`.`discussions_topics` ;
159
160DROP TABLE IF EXISTS `facult`.`discussions_messages` ;
161
162DROP TABLE IF EXISTS `facult`.`companies_statistics` ;
163
164DROP TABLE IF EXISTS `facult`.`communications` ;
165
166DROP TABLE IF EXISTS `facult`.`carts` ;
167
168DROP TABLE IF EXISTS `facult`.`calls` ;
169
170DROP TABLE IF EXISTS `facult`.`banners_positions` ;
171
172DROP TABLE IF EXISTS `facult`.`banners_clicks` ;
173
174DROP TABLE IF EXISTS `facult`.`banners` ;
175
176DROP TABLE IF EXISTS `facult`.`_products` ;
177
178ALTER TABLE `facult`.`study_fields` 
179ADD CONSTRAINT `fk_study_fields_study_fields1`
180  FOREIGN KEY (`parent_id`)
181  REFERENCES `facult`.`study_fields` (`study_field_id`)
182  ON DELETE SET NULL
183  ON UPDATE CASCADE;
184
185
186SET SQL_MODE=@OLD_SQL_MODE;
187SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
188SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;