hG2uusL8

1-- MySQL Workbench Synchronization
2-- Generated: 2016-10-24 14:52
3-- Model: New Model
4-- Version: 1.0
5-- Project: Name of the project
6-- Author: Jan Mittner
7
8SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
9SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
10SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
11
12ALTER TABLE `facult`.`jobs` 
13DROP FOREIGN KEY `fk_jobs_companies1`;
14
15ALTER TABLE `facult`.`users_discussions_messages_emails` 
16DROP FOREIGN KEY `fk_users_discussions_messages_emails_discussions_messages1`;
17
18ALTER TABLE `facult`.`study_fields` 
19DROP FOREIGN KEY `fk_study_fields_study_fields1`;
20
21ALTER TABLE `facult`.`users_events_emails` 
22DROP FOREIGN KEY `fk_users_events_emails_events1`;
23
24ALTER TABLE `facult`.`documents` 
25DROP COLUMN `filemtime`,
26CHANGE COLUMN `filesystem_type` `filesystem_type` VARCHAR(45) NULL DEFAULT NULL ,
27CHANGE COLUMN `tinyjpg_shrinked` `tinyjpg_shrinked` TINYINT(1) NULL DEFAULT 0 ,
28ADD COLUMN `filemtype` INT(11) NULL DEFAULT NULL AFTER `filesystem_type`;
29
30ALTER TABLE `facult`.`pages` 
31CHANGE COLUMN `pagetype` `pagetype` ENUM('page',  'link',  'external_link',  'article',  'articles',  'folder',  'documents',  'document',  'webinar') NOT NULL ,
32CHANGE COLUMN `show_webinar_button` `show_webinar_button` TINYINT(1) NULL DEFAULT 0 ;
33
34ALTER TABLE `facult`.`users` 
35DROP COLUMN `gsk_approved`,
36DROP COLUMN `gsk_team`,
37DROP COLUMN `unichance_attachment`,
38DROP COLUMN `it_lov_attachment`,
39DROP COLUMN `it_lov_cv`,
40DROP COLUMN `completed_it_lov_test_round2`,
41DROP COLUMN `completed_it_lov_test`,
42DROP COLUMN `business_school_letter`,
43DROP COLUMN `business_school`,
44DROP COLUMN `is_hostess`,
45DROP COLUMN `ikea_type`,
46DROP COLUMN `ikea_registration`,
47DROP COLUMN `ikea_project`,
48DROP COLUMN `partycv`,
49DROP COLUMN `endorsement_alert_hidden`,
50DROP COLUMN `unichance_banner_hidden`,
51DROP COLUMN `start_package_hidden`,
52DROP COLUMN `photographed`,
53DROP COLUMN `hostess_instant_registration`,
54DROP COLUMN `primat_instant_registration`,
55DROP COLUMN `searcheable`,
56DROP COLUMN `discussions_authorized_user`,
57DROP COLUMN `motivation_letter`,
58DROP COLUMN `unichance_approved`,
59DROP COLUMN `unichance`,
60CHANGE COLUMN `sign_out_id` `sign_out_id` INT(11) NULL DEFAULT NULL AFTER `town_id`,
61CHANGE COLUMN `headline` `headline` TEXT NULL DEFAULT NULL AFTER `student_event_hidden`,
62CHANGE COLUMN `is_admin` `is_admin` TINYINT(1) NULL DEFAULT 0 ,
63ADD INDEX `fk_users_newsletters1_idx` (`sign_out_id` ASC),
64DROP INDEX `fk_users_newsletters1` ,
65DROP INDEX `i_searcheable` ;
66
67ALTER TABLE `facult`.`companies` 
68CHANGE COLUMN `facebook_page` `facebook_page` VARCHAR(255) NULL DEFAULT NULL AFTER `twitter_page`,
69CHANGE COLUMN `premium_company` `premium_company` TINYINT(1) NULL DEFAULT 0 ,
70CHANGE COLUMN `work_in_progress` `work_in_progress` TINYINT(1) NULL DEFAULT 0 ,
71CHANGE COLUMN `rank` `rank` INT(11) NULL DEFAULT NULL ,
72CHANGE COLUMN `in_foreign_language` `in_foreign_language` TINYINT(1) NULL DEFAULT 0 ;
73
74ALTER TABLE `facult`.`jobs` 
75DROP COLUMN `premium_sort_date`,
76DROP COLUMN `processed_favourites_cvs`,
77ADD COLUMN `premium_sort_data` DATETIME NULL DEFAULT NULL AFTER `date_activated`;
78
79ALTER TABLE `facult`.`jobs_fulltext` 
80COLLATE = utf8_general_ci ;
81
82ALTER TABLE `facult`.`users_languages` 
83DROP COLUMN `priority`;
84
85ALTER TABLE `facult`.`users_discussions_messages_emails` 
86DROP INDEX `fk_users_discussions_messages_emails_discussions_messages1_idx` ;
87
88ALTER TABLE `facult`.`users_fulltext` 
89COLLATE = utf8_general_ci ;
90
91ALTER TABLE `facult`.`users_favourites_search_cv` 
92ADD INDEX `fk_users_favourites_search_cv_jobs1_idx` (`job_id` ASC),
93DROP INDEX `job_id` ;
94
95ALTER TABLE `facult`.`users_events_emails` 
96DROP INDEX `fk_users_events_emails_events1_idx` ;
97
98ALTER TABLE `facult`.`newsletters` 
99CHANGE COLUMN `hide_unsubscribe` `hide_unsubscribe` TINYINT(1) NULL DEFAULT 0 ;
100
101ALTER TABLE `facult`.`proudly_likes` 
102ADD INDEX `fk_proudly_likes_jobs_responses1_idx` (`job_response_id` ASC),
103DROP INDEX `fk_proudly_likes_jobs_responses1` ;
104
105CREATE TABLE IF NOT EXISTS `facult`.`cms_admins_passwords` (
106  `admin_password_id` INT(11) NOT NULL AUTO_INCREMENT,
107  `admin_id` INT(11) NOT NULL,
108  `token` VARCHAR(100) NULL DEFAULT NULL,
109  `pwd` VARCHAR(64) NULL DEFAULT NULL,
110  `created` DATETIME NULL DEFAULT NULL,
111  PRIMARY KEY (`admin_password_id`),
112  INDEX `fk_cms_admins_passwords_cms_admins1_idx` (`admin_id` ASC),
113  CONSTRAINT `fk_cms_admins_passwords_cms_admins1`
114    FOREIGN KEY (`admin_id`)
115    REFERENCES `facult`.`cms_admins` (`admin_id`)
116    ON DELETE CASCADE
117    ON UPDATE CASCADE)
118ENGINE = InnoDB
119DEFAULT CHARACTER SET = utf8
120COLLATE = utf8_czech_ci;
121
122ALTER TABLE `facult`.`favourites_search_cv_blacklist_emails` 
123CHANGE COLUMN `email` `email` VARCHAR(255) NULL DEFAULT NULL ;
124
125ALTER TABLE `facult`.`jobs_timeline_records` 
126CHANGE COLUMN `job_id` `job_id` INT(11) NOT NULL AFTER `entity_id`;
127
128DROP TABLE IF EXISTS `facult`.`webinars_registrations` ;
129
130DROP TABLE IF EXISTS `facult`.`vouchers` ;
131
132DROP TABLE IF EXISTS `facult`.`users_tests_questions` ;
133
134DROP TABLE IF EXISTS `facult`.`tests_questions` ;
135
136DROP TABLE IF EXISTS `facult`.`tests_answers` ;
137
138DROP TABLE IF EXISTS `facult`.`surveys_many_answers` ;
139
140DROP TABLE IF EXISTS `facult`.`surveys_answers` ;
141
142DROP TABLE IF EXISTS `facult`.`surveys` ;
143
144DROP TABLE IF EXISTS `facult`.`subscribed_messages` ;
145
146DROP TABLE IF EXISTS `facult`.`seminars` ;
147
148DROP TABLE IF EXISTS `facult`.`products_variants_properties_values` ;
149
150DROP TABLE IF EXISTS `facult`.`products_variants_attributes_associated` ;
151
152DROP TABLE IF EXISTS `facult`.`products_variants` ;
153
154DROP TABLE IF EXISTS `facult`.`products_units` ;
155
156DROP TABLE IF EXISTS `facult`.`products_templates_properties` ;
157
158DROP TABLE IF EXISTS `facult`.`products_templates_groups` ;
159
160DROP TABLE IF EXISTS `facult`.`products_templates` ;
161
162DROP TABLE IF EXISTS `facult`.`products_stocks` ;
163
164DROP TABLE IF EXISTS `facult`.`products_properties_values` ;
165
166DROP TABLE IF EXISTS `facult`.`products_properties_enums` ;
167
168DROP TABLE IF EXISTS `facult`.`products_properties` ;
169
170DROP TABLE IF EXISTS `facult`.`products_price_levels` ;
171
172DROP TABLE IF EXISTS `facult`.`products_icons` ;
173
174DROP TABLE IF EXISTS `facult`.`products_folders_associated` ;
175
176DROP TABLE IF EXISTS `facult`.`products_folders` ;
177
178DROP TABLE IF EXISTS `facult`.`products_colors` ;
179
180DROP TABLE IF EXISTS `facult`.`products_brands` ;
181
182DROP TABLE IF EXISTS `facult`.`products_attributes_associated` ;
183
184DROP TABLE IF EXISTS `facult`.`products_attributes` ;
185
186DROP TABLE IF EXISTS `facult`.`products` ;
187
188DROP TABLE IF EXISTS `facult`.`polls_votes` ;
189
190DROP TABLE IF EXISTS `facult`.`polls_answers` ;
191
192DROP TABLE IF EXISTS `facult`.`polls` ;
193
194DROP TABLE IF EXISTS `facult`.`orders_vouchers` ;
195
196DROP TABLE IF EXISTS `facult`.`orders_states` ;
197
198DROP TABLE IF EXISTS `facult`.`orders_products_jobs` ;
199
200DROP TABLE IF EXISTS `facult`.`orders_products_cvs` ;
201
202DROP TABLE IF EXISTS `facult`.`orders_products` ;
203
204DROP TABLE IF EXISTS `facult`.`orders_invoices` ;
205
206DROP TABLE IF EXISTS `facult`.`orders` ;
207
208DROP TABLE IF EXISTS `facult`.`news_folders` ;
209
210DROP TABLE IF EXISTS `facult`.`news` ;
211
212DROP TABLE IF EXISTS `facult`.`invoices_ranges` ;
213
214DROP TABLE IF EXISTS `facult`.`invoices_items` ;
215
216DROP TABLE IF EXISTS `facult`.`invoices_documents` ;
217
218DROP TABLE IF EXISTS `facult`.`invoices` ;
219
220DROP TABLE IF EXISTS `facult`.`events_study_fields` ;
221
222DROP TABLE IF EXISTS `facult`.`events_attendants` ;
223
224DROP TABLE IF EXISTS `facult`.`events` ;
225
226DROP TABLE IF EXISTS `facult`.`discussions_topics` ;
227
228DROP TABLE IF EXISTS `facult`.`discussions_messages` ;
229
230DROP TABLE IF EXISTS `facult`.`companies_statistics` ;
231
232DROP TABLE IF EXISTS `facult`.`communications` ;
233
234DROP TABLE IF EXISTS `facult`.`carts` ;
235
236DROP TABLE IF EXISTS `facult`.`calls` ;
237
238DROP TABLE IF EXISTS `facult`.`banners_positions` ;
239
240DROP TABLE IF EXISTS `facult`.`banners_clicks` ;
241
242DROP TABLE IF EXISTS `facult`.`banners` ;
243
244DROP TABLE IF EXISTS `facult`.`_products` ;
245
246ALTER TABLE `facult`.`jobs` 
247ADD CONSTRAINT `fk_jobs_companies1`
248  FOREIGN KEY (`company_id`)
249  REFERENCES `facult`.`companies` (`company_id`)
250  ON DELETE CASCADE
251  ON UPDATE CASCADE;
252
253ALTER TABLE `facult`.`study_fields` 
254ADD CONSTRAINT `fk_study_fields_study_fields1`
255  FOREIGN KEY (`parent_id`)
256  REFERENCES `facult`.`study_fields` (`study_field_id`)
257  ON DELETE SET NULL
258  ON UPDATE CASCADE;
259
260
261SET SQL_MODE=@OLD_SQL_MODE;
262SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
263SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;