# This is a fix for InnoDB in MySQL >= 4.1.x
# It "suspends judgement" for fkey relationships until are tables are set.
SET FOREIGN_KEY_CHECKS = 0;

#-----------------------------------------------------------------------------
#-- countries
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `countries`;


CREATE TABLE `countries`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(50)  NOT NULL,
	PRIMARY KEY (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- regions
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `regions`;


CREATE TABLE `regions`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(50)  NOT NULL,
	PRIMARY KEY (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- user_rols
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `user_rols`;


CREATE TABLE `user_rols`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100)  NOT NULL,
	PRIMARY KEY (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- users
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `users`;


CREATE TABLE `users`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`username` VARCHAR(50)  NOT NULL,
	`name` VARCHAR(100)  NOT NULL,
	`lastname` VARCHAR(100)  NOT NULL,
	`email` VARCHAR(100)  NOT NULL,
	`phone` VARCHAR(100)  NOT NULL,
	`gender` INTEGER,
	`status` INTEGER,
	`couple` VARCHAR(100),
	`has_kids` INTEGER default 0,
	`filename` VARCHAR(150),
	`city_id` INTEGER,
	`address` VARCHAR(150),
	`description` TEXT,
	`password` VARCHAR(32) default '81dc9bdb52d04dc20036dbd8313ed055' NOT NULL,
	`joined_at` DATETIME,
	`birthday` DATETIME,
	`football_team` VARCHAR(100),
	`shirt_size` VARCHAR(5),
	`pant_size` INTEGER,
	`foot_size` INTEGER,
	`legajo` VARCHAR(70),
	`coorp` VARCHAR(100),
	`device_model` VARCHAR(100),
	`device_imei` VARCHAR(20),
	`android_version` VARCHAR(20),
	`app_version` VARCHAR(20),
	`rol_id` INTEGER  NOT NULL,
	`region_id` INTEGER  NOT NULL,
	`is_admin` INTEGER default 0 NOT NULL,
	`deleted_at` DATETIME,
	`updated_at` DATETIME,
	`created_at` DATETIME,
	PRIMARY KEY (`id`),
	UNIQUE KEY `users_username_unique` (`username`),
	INDEX `users_FI_1` (`city_id`),
	CONSTRAINT `users_FK_1`
		FOREIGN KEY (`city_id`)
		REFERENCES `cities` (`id`),
	INDEX `users_FI_2` (`rol_id`),
	CONSTRAINT `users_FK_2`
		FOREIGN KEY (`rol_id`)
		REFERENCES `user_rols` (`id`),
	INDEX `users_FI_3` (`region_id`),
	CONSTRAINT `users_FK_3`
		FOREIGN KEY (`region_id`)
		REFERENCES `regions` (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- user_supervisors
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `user_supervisors`;


CREATE TABLE `user_supervisors`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`user_id` INTEGER  NOT NULL,
	`supervisor_id` INTEGER  NOT NULL,
	PRIMARY KEY (`id`),
	INDEX `user_supervisors_FI_1` (`user_id`),
	CONSTRAINT `user_supervisors_FK_1`
		FOREIGN KEY (`user_id`)
		REFERENCES `users` (`id`),
	INDEX `user_supervisors_FI_2` (`supervisor_id`),
	CONSTRAINT `user_supervisors_FK_2`
		FOREIGN KEY (`supervisor_id`)
		REFERENCES `users` (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- user_log
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `user_log`;


CREATE TABLE `user_log`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`user_id` INTEGER  NOT NULL,
	`ip` VARCHAR(50),
	`login_at` DATETIME,
	`logout_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `user_log_FI_1` (`user_id`),
	CONSTRAINT `user_log_FK_1`
		FOREIGN KEY (`user_id`)
		REFERENCES `users` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- provinces
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `provinces`;


CREATE TABLE `provinces`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100)  NOT NULL,
	`country_id` INTEGER  NOT NULL,
	PRIMARY KEY (`id`),
	INDEX `provinces_FI_1` (`country_id`),
	CONSTRAINT `provinces_FK_1`
		FOREIGN KEY (`country_id`)
		REFERENCES `countries` (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- cities
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `cities`;


CREATE TABLE `cities`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100)  NOT NULL,
	`cp` INTEGER(4)  NOT NULL,
	`province_id` INTEGER default 0,
	PRIMARY KEY (`id`),
	INDEX `cities_FI_1` (`province_id`),
	CONSTRAINT `cities_FK_1`
		FOREIGN KEY (`province_id`)
		REFERENCES `provinces` (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- channels
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `channels`;


CREATE TABLE `channels`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100)  NOT NULL,
	PRIMARY KEY (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- channel_formats
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `channel_formats`;


CREATE TABLE `channel_formats`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`channel_id` INTEGER,
	`name` VARCHAR(100),
	PRIMARY KEY (`id`),
	INDEX `channel_formats_FI_1` (`channel_id`),
	CONSTRAINT `channel_formats_FK_1`
		FOREIGN KEY (`channel_id`)
		REFERENCES `channels` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- chains
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `chains`;


CREATE TABLE `chains`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100)  NOT NULL,
	`icon` VARCHAR(250),
	`mail` VARCHAR(100),
	PRIMARY KEY (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- suppliers
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `suppliers`;


CREATE TABLE `suppliers`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100)  NOT NULL,
	`mail` VARCHAR(100)  NOT NULL,
	PRIMARY KEY (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- nodes
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `nodes`;


CREATE TABLE `nodes`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`custom_id` VARCHAR(150),
	`address` VARCHAR(150)  NOT NULL,
	`city_id` INTEGER  NOT NULL,
	`region_id` INTEGER  NOT NULL,
	`lat` VARCHAR(200),
	`lng` VARCHAR(200),
	`channel_id` INTEGER,
	`channel_format_id` INTEGER,
	`cluster_id` INTEGER,
	`chain_id` INTEGER,
	`comercial_name` VARCHAR(150),
	`name` VARCHAR(150)  NOT NULL,
	`filename` VARCHAR(250)  NOT NULL,
	`phone` VARCHAR(100),
	`operator` VARCHAR(100),
	`mail` VARCHAR(100),
	`mail_executive` VARCHAR(100),
	`manager` VARCHAR(100),
	`window` INTEGER default 0,
	`has_perfumery_exhibitor` INTEGER default 0,
	`supplier_id` INTEGER,
	`sellers` INTEGER default 0,
	`backlight` INTEGER default 0,
	`has_gondola` INTEGER default 0,
	`focus` INTEGER default 0 NOT NULL,
	`boxes` INTEGER,
	`delivery_day` VARCHAR(100),
	`other_company` VARCHAR(100),
	`director` VARCHAR(100),
	`executive` VARCHAR(100),
	`subexecutive` VARCHAR(100),
	`chief_lounge` VARCHAR(100),
	`subchief` VARCHAR(100),
	`warehouse_manager` VARCHAR(100),
	`deposit_manager` VARCHAR(100),
	`contact_1` VARCHAR(100),
	`contact_2` VARCHAR(100),
	`deleted_at` DATETIME,
	`created_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `nodes_FI_1` (`city_id`),
	CONSTRAINT `nodes_FK_1`
		FOREIGN KEY (`city_id`)
		REFERENCES `cities` (`id`),
	INDEX `nodes_FI_2` (`region_id`),
	CONSTRAINT `nodes_FK_2`
		FOREIGN KEY (`region_id`)
		REFERENCES `regions` (`id`),
	INDEX `nodes_FI_3` (`channel_id`),
	CONSTRAINT `nodes_FK_3`
		FOREIGN KEY (`channel_id`)
		REFERENCES `channels` (`id`),
	INDEX `nodes_FI_4` (`cluster_id`),
	CONSTRAINT `nodes_FK_4`
		FOREIGN KEY (`cluster_id`)
		REFERENCES `clusters` (`id`),
	INDEX `nodes_FI_5` (`chain_id`),
	CONSTRAINT `nodes_FK_5`
		FOREIGN KEY (`chain_id`)
		REFERENCES `chains` (`id`),
	INDEX `nodes_FI_6` (`supplier_id`),
	CONSTRAINT `nodes_FK_6`
		FOREIGN KEY (`supplier_id`)
		REFERENCES `suppliers` (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- node_targets
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `node_targets`;


CREATE TABLE `node_targets`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`node_id` INTEGER  NOT NULL,
	`user_id` INTEGER,
	`name` VARCHAR(150)  NOT NULL,
	`value` INTEGER,
	`completed` DATETIME,
	`created_by` INTEGER  NOT NULL,
	`expire_at` DATETIME,
	`created_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `node_targets_FI_1` (`node_id`),
	CONSTRAINT `node_targets_FK_1`
		FOREIGN KEY (`node_id`)
		REFERENCES `nodes` (`id`),
	INDEX `node_targets_FI_2` (`user_id`),
	CONSTRAINT `node_targets_FK_2`
		FOREIGN KEY (`user_id`)
		REFERENCES `users` (`id`),
	INDEX `node_targets_FI_3` (`value`),
	CONSTRAINT `node_targets_FK_3`
		FOREIGN KEY (`value`)
		REFERENCES `node_target_values` (`id`),
	INDEX `node_targets_FI_4` (`created_by`),
	CONSTRAINT `node_targets_FK_4`
		FOREIGN KEY (`created_by`)
		REFERENCES `users` (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- node_target_values
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `node_target_values`;


CREATE TABLE `node_target_values`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100)  NOT NULL,
	PRIMARY KEY (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- node_images
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `node_images`;


CREATE TABLE `node_images`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`node_id` INTEGER  NOT NULL,
	`title` VARCHAR(100)  NOT NULL,
	`filename` VARCHAR(100)  NOT NULL,
	`created_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `node_images_FI_1` (`node_id`),
	CONSTRAINT `node_images_FK_1`
		FOREIGN KEY (`node_id`)
		REFERENCES `nodes` (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- form_types
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `form_types`;


CREATE TABLE `form_types`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100)  NOT NULL,
	PRIMARY KEY (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- forms
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `forms`;


CREATE TABLE `forms`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100)  NOT NULL,
	`type_id` INTEGER  NOT NULL,
	`condition_id` INTEGER  NOT NULL,
	`deleted_at` DATETIME,
	`ordering` INTEGER default 0,
	`estimated` INTEGER default 0,
	`has_report` INTEGER default 0,
	`updated_at` DATETIME,
	`created_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `forms_FI_1` (`type_id`),
	CONSTRAINT `forms_FK_1`
		FOREIGN KEY (`type_id`)
		REFERENCES `form_types` (`id`),
	INDEX `forms_FI_2` (`condition_id`),
	CONSTRAINT `forms_FK_2`
		FOREIGN KEY (`condition_id`)
		REFERENCES `form_conditions` (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- form_conditions
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `form_conditions`;


CREATE TABLE `form_conditions`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100)  NOT NULL,
	`description` VARCHAR(255)  NOT NULL,
	PRIMARY KEY (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- form_planification
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `form_planification`;


CREATE TABLE `form_planification`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`form_id` INTEGER  NOT NULL,
	`date` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `form_planification_FI_1` (`form_id`),
	CONSTRAINT `form_planification_FK_1`
		FOREIGN KEY (`form_id`)
		REFERENCES `forms` (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- form_rols
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `form_rols`;


CREATE TABLE `form_rols`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`form_id` INTEGER  NOT NULL,
	`rol_id` INTEGER  NOT NULL,
	PRIMARY KEY (`id`),
	INDEX `form_rols_FI_1` (`form_id`),
	CONSTRAINT `form_rols_FK_1`
		FOREIGN KEY (`form_id`)
		REFERENCES `forms` (`id`)
		ON DELETE CASCADE,
	INDEX `form_rols_FI_2` (`rol_id`),
	CONSTRAINT `form_rols_FK_2`
		FOREIGN KEY (`rol_id`)
		REFERENCES `user_rols` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- categories
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `categories`;


CREATE TABLE `categories`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100)  NOT NULL,
	`deleted_at` DATETIME,
	PRIMARY KEY (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- subcategories
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `subcategories`;


CREATE TABLE `subcategories`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100)  NOT NULL,
	`category_id` INTEGER,
	`deleted_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `subcategories_FI_1` (`category_id`),
	CONSTRAINT `subcategories_FK_1`
		FOREIGN KEY (`category_id`)
		REFERENCES `categories` (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- brands
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `brands`;


CREATE TABLE `brands`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100)  NOT NULL,
	PRIMARY KEY (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- manufacturers
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `manufacturers`;


CREATE TABLE `manufacturers`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100)  NOT NULL,
	PRIMARY KEY (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- tags
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `tags`;


CREATE TABLE `tags`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100)  NOT NULL,
	`subcategory_id` INTEGER,
	`ean` VARCHAR(100),
	`brand_id` INTEGER,
	`manufacturer_id` INTEGER,
	`focus` INTEGER default 0,
	`deleted_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `tags_FI_1` (`subcategory_id`),
	CONSTRAINT `tags_FK_1`
		FOREIGN KEY (`subcategory_id`)
		REFERENCES `subcategories` (`id`),
	INDEX `tags_FI_2` (`brand_id`),
	CONSTRAINT `tags_FK_2`
		FOREIGN KEY (`brand_id`)
		REFERENCES `brands` (`id`),
	INDEX `tags_FI_3` (`manufacturer_id`),
	CONSTRAINT `tags_FK_3`
		FOREIGN KEY (`manufacturer_id`)
		REFERENCES `manufacturers` (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- suppliers_tags
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `suppliers_tags`;


CREATE TABLE `suppliers_tags`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`supplier_id` INTEGER,
	`tag_id` INTEGER,
	PRIMARY KEY (`id`),
	INDEX `suppliers_tags_FI_1` (`supplier_id`),
	CONSTRAINT `suppliers_tags_FK_1`
		FOREIGN KEY (`supplier_id`)
		REFERENCES `suppliers` (`id`)
		ON DELETE CASCADE,
	INDEX `suppliers_tags_FI_2` (`tag_id`),
	CONSTRAINT `suppliers_tags_FK_2`
		FOREIGN KEY (`tag_id`)
		REFERENCES `tags` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- forms_tags
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `forms_tags`;


CREATE TABLE `forms_tags`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`form_id` INTEGER  NOT NULL,
	`tag_id` INTEGER  NOT NULL,
	`ordering` INTEGER default 0,
	PRIMARY KEY (`id`),
	INDEX `forms_tags_FI_1` (`form_id`),
	CONSTRAINT `forms_tags_FK_1`
		FOREIGN KEY (`form_id`)
		REFERENCES `forms` (`id`)
		ON DELETE CASCADE,
	INDEX `forms_tags_FI_2` (`tag_id`),
	CONSTRAINT `forms_tags_FK_2`
		FOREIGN KEY (`tag_id`)
		REFERENCES `tags` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- form_custom_values
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `form_custom_values`;


CREATE TABLE `form_custom_values`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100)  NOT NULL,
	`form_id` INTEGER  NOT NULL,
	PRIMARY KEY (`id`),
	INDEX `form_custom_values_FI_1` (`form_id`),
	CONSTRAINT `form_custom_values_FK_1`
		FOREIGN KEY (`form_id`)
		REFERENCES `forms` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- node_forms
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `node_forms`;


CREATE TABLE `node_forms`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`node_id` INTEGER,
	`form_id` INTEGER  NOT NULL,
	PRIMARY KEY (`id`),
	INDEX `node_forms_FI_1` (`node_id`),
	CONSTRAINT `node_forms_FK_1`
		FOREIGN KEY (`node_id`)
		REFERENCES `nodes` (`id`)
		ON DELETE CASCADE,
	INDEX `node_forms_FI_2` (`form_id`),
	CONSTRAINT `node_forms_FK_2`
		FOREIGN KEY (`form_id`)
		REFERENCES `forms` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- node_inactive_tags
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `node_inactive_tags`;


CREATE TABLE `node_inactive_tags`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`node_id` INTEGER,
	`tag_id` INTEGER  NOT NULL,
	PRIMARY KEY (`id`),
	INDEX `node_inactive_tags_FI_1` (`node_id`),
	CONSTRAINT `node_inactive_tags_FK_1`
		FOREIGN KEY (`node_id`)
		REFERENCES `nodes` (`id`)
		ON DELETE CASCADE,
	INDEX `node_inactive_tags_FI_2` (`tag_id`),
	CONSTRAINT `node_inactive_tags_FK_2`
		FOREIGN KEY (`tag_id`)
		REFERENCES `tags` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- checkouts
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `checkouts`;


CREATE TABLE `checkouts`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`node_id` INTEGER,
	`user_id` INTEGER,
	`route_id` INTEGER,
	`json` VARCHAR(200),
	`lat` VARCHAR(200),
	`lng` VARCHAR(200),
	`complete` INTEGER default 0,
	`is_mobile` INTEGER default 0,
	`visited_at` DATETIME,
	`left_at` DATETIME,
	`created_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `checkouts_FI_1` (`node_id`),
	CONSTRAINT `checkouts_FK_1`
		FOREIGN KEY (`node_id`)
		REFERENCES `nodes` (`id`)
		ON DELETE CASCADE,
	INDEX `checkouts_FI_2` (`user_id`),
	CONSTRAINT `checkouts_FK_2`
		FOREIGN KEY (`user_id`)
		REFERENCES `users` (`id`)
		ON DELETE CASCADE,
	INDEX `checkouts_FI_3` (`route_id`),
	CONSTRAINT `checkouts_FK_3`
		FOREIGN KEY (`route_id`)
		REFERENCES `routes` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- checkout_data
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `checkout_data`;


CREATE TABLE `checkout_data`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`checkout_id` INTEGER,
	`form_id` INTEGER,
	`tag_id` INTEGER,
	`value` DOUBLE default 0,
	`text` TEXT,
	`filename` VARCHAR(255),
	`created_at` DATETIME,
	`active` INTEGER default 1,
	PRIMARY KEY (`id`),
	INDEX `checkout_data_FI_1` (`checkout_id`),
	CONSTRAINT `checkout_data_FK_1`
		FOREIGN KEY (`checkout_id`)
		REFERENCES `checkouts` (`id`)
		ON DELETE CASCADE,
	INDEX `checkout_data_FI_2` (`form_id`),
	CONSTRAINT `checkout_data_FK_2`
		FOREIGN KEY (`form_id`)
		REFERENCES `forms` (`id`)
		ON DELETE CASCADE,
	INDEX `checkout_data_FI_3` (`tag_id`),
	CONSTRAINT `checkout_data_FK_3`
		FOREIGN KEY (`tag_id`)
		REFERENCES `tags` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- routes
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `routes`;


CREATE TABLE `routes`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100)  NOT NULL,
	`frequency` INTEGER default 1 NOT NULL,
	`completed` INTEGER default 0,
	`date_from` DATETIME  NOT NULL,
	`date_to` DATETIME  NOT NULL,
	`deleted_at` DATETIME,
	`updated_by` INTEGER,
	`created_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `routes_FI_1` (`updated_by`),
	CONSTRAINT `routes_FK_1`
		FOREIGN KEY (`updated_by`)
		REFERENCES `users` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- route_planification
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `route_planification`;


CREATE TABLE `route_planification`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`route_id` INTEGER,
	`day` INTEGER  NOT NULL,
	`date` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `route_planification_FI_1` (`route_id`),
	CONSTRAINT `route_planification_FK_1`
		FOREIGN KEY (`route_id`)
		REFERENCES `routes` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- route_nodes
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `route_nodes`;


CREATE TABLE `route_nodes`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`node_id` INTEGER,
	`route_id` INTEGER,
	`from_hour` FLOAT,
	`to_hour` FLOAT,
	PRIMARY KEY (`id`),
	INDEX `route_nodes_FI_1` (`node_id`),
	CONSTRAINT `route_nodes_FK_1`
		FOREIGN KEY (`node_id`)
		REFERENCES `nodes` (`id`)
		ON DELETE CASCADE,
	INDEX `route_nodes_FI_2` (`route_id`),
	CONSTRAINT `route_nodes_FK_2`
		FOREIGN KEY (`route_id`)
		REFERENCES `routes` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- route_users
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `route_users`;


CREATE TABLE `route_users`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`user_id` INTEGER,
	`route_id` INTEGER,
	PRIMARY KEY (`id`),
	INDEX `route_users_FI_1` (`user_id`),
	CONSTRAINT `route_users_FK_1`
		FOREIGN KEY (`user_id`)
		REFERENCES `users` (`id`)
		ON DELETE CASCADE,
	INDEX `route_users_FI_2` (`route_id`),
	CONSTRAINT `route_users_FK_2`
		FOREIGN KEY (`route_id`)
		REFERENCES `routes` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- alerts
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `alerts`;


CREATE TABLE `alerts`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`subject` VARCHAR(100),
	`body` TEXT,
	`user_id` INTEGER  NOT NULL,
	`created_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `alerts_FI_1` (`user_id`),
	CONSTRAINT `alerts_FK_1`
		FOREIGN KEY (`user_id`)
		REFERENCES `users` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- alert_users
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `alert_users`;


CREATE TABLE `alert_users`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`user_id` INTEGER  NOT NULL,
	`alert_id` INTEGER  NOT NULL,
	`readed_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `alert_users_FI_1` (`user_id`),
	CONSTRAINT `alert_users_FK_1`
		FOREIGN KEY (`user_id`)
		REFERENCES `users` (`id`)
		ON DELETE CASCADE,
	INDEX `alert_users_FI_2` (`alert_id`),
	CONSTRAINT `alert_users_FK_2`
		FOREIGN KEY (`alert_id`)
		REFERENCES `alerts` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- news
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `news`;


CREATE TABLE `news`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`title` VARCHAR(100)  NOT NULL,
	`body` TEXT,
	`filename` VARCHAR(100),
	`user_id` INTEGER  NOT NULL,
	`created_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `news_FI_1` (`user_id`),
	CONSTRAINT `news_FK_1`
		FOREIGN KEY (`user_id`)
		REFERENCES `users` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- elearning
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `elearning`;


CREATE TABLE `elearning`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`title` VARCHAR(150)  NOT NULL,
	`description` TEXT,
	`user_id` INTEGER  NOT NULL,
	`youtube` VARCHAR(100),
	`filename1` VARCHAR(100),
	`filename2` VARCHAR(100),
	`filename3` VARCHAR(100),
	`filename4` VARCHAR(100),
	`filename5` VARCHAR(100),
	`created_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `elearning_FI_1` (`user_id`),
	CONSTRAINT `elearning_FK_1`
		FOREIGN KEY (`user_id`)
		REFERENCES `users` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- elearning_users
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `elearning_users`;


CREATE TABLE `elearning_users`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`user_id` INTEGER  NOT NULL,
	`elearning_id` INTEGER  NOT NULL,
	PRIMARY KEY (`id`),
	INDEX `elearning_users_FI_1` (`user_id`),
	CONSTRAINT `elearning_users_FK_1`
		FOREIGN KEY (`user_id`)
		REFERENCES `users` (`id`)
		ON DELETE CASCADE,
	INDEX `elearning_users_FI_2` (`elearning_id`),
	CONSTRAINT `elearning_users_FK_2`
		FOREIGN KEY (`elearning_id`)
		REFERENCES `elearning` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- elearning_answers
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `elearning_answers`;


CREATE TABLE `elearning_answers`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`description` VARCHAR(150),
	`question_id` INTEGER  NOT NULL,
	PRIMARY KEY (`id`),
	INDEX `elearning_answers_FI_1` (`question_id`),
	CONSTRAINT `elearning_answers_FK_1`
		FOREIGN KEY (`question_id`)
		REFERENCES `elearning_questions` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- elearning_questions
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `elearning_questions`;


CREATE TABLE `elearning_questions`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`description` VARCHAR(150)  NOT NULL,
	`elearning_id` INTEGER  NOT NULL,
	`answer_id` INTEGER,
	`created_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `elearning_questions_FI_1` (`elearning_id`),
	CONSTRAINT `elearning_questions_FK_1`
		FOREIGN KEY (`elearning_id`)
		REFERENCES `elearning` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- elearning_checkouts
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `elearning_checkouts`;


CREATE TABLE `elearning_checkouts`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`user_id` INTEGER  NOT NULL,
	`question_id` INTEGER  NOT NULL,
	`answer_id` INTEGER  NOT NULL,
	PRIMARY KEY (`id`),
	INDEX `elearning_checkouts_FI_1` (`user_id`),
	CONSTRAINT `elearning_checkouts_FK_1`
		FOREIGN KEY (`user_id`)
		REFERENCES `users` (`id`)
		ON DELETE CASCADE,
	INDEX `elearning_checkouts_FI_2` (`question_id`),
	CONSTRAINT `elearning_checkouts_FK_2`
		FOREIGN KEY (`question_id`)
		REFERENCES `elearning_questions` (`id`)
		ON DELETE CASCADE,
	INDEX `elearning_checkouts_FI_3` (`answer_id`),
	CONSTRAINT `elearning_checkouts_FK_3`
		FOREIGN KEY (`answer_id`)
		REFERENCES `elearning_answers` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- exhibitors
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `exhibitors`;


CREATE TABLE `exhibitors`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(150)  NOT NULL,
	`channel_id` INTEGER  NOT NULL,
	`created_at` DATETIME,
	`deleted_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `exhibitors_FI_1` (`channel_id`),
	CONSTRAINT `exhibitors_FK_1`
		FOREIGN KEY (`channel_id`)
		REFERENCES `channels` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- exhibitor_nodes
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `exhibitor_nodes`;


CREATE TABLE `exhibitor_nodes`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`node_id` INTEGER,
	`exhibitor_id` INTEGER,
	`brand_id` INTEGER,
	`state_id` INTEGER,
	`value` INTEGER default 0,
	`updated_by` INTEGER  NOT NULL,
	`updated_at` DATETIME,
	`created_at` DATETIME,
	`deleted_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `exhibitor_nodes_FI_1` (`node_id`),
	CONSTRAINT `exhibitor_nodes_FK_1`
		FOREIGN KEY (`node_id`)
		REFERENCES `nodes` (`id`)
		ON DELETE CASCADE,
	INDEX `exhibitor_nodes_FI_2` (`exhibitor_id`),
	CONSTRAINT `exhibitor_nodes_FK_2`
		FOREIGN KEY (`exhibitor_id`)
		REFERENCES `exhibitors` (`id`)
		ON DELETE CASCADE,
	INDEX `exhibitor_nodes_FI_3` (`brand_id`),
	CONSTRAINT `exhibitor_nodes_FK_3`
		FOREIGN KEY (`brand_id`)
		REFERENCES `brands` (`id`)
		ON DELETE CASCADE,
	INDEX `exhibitor_nodes_FI_4` (`updated_by`),
	CONSTRAINT `exhibitor_nodes_FK_4`
		FOREIGN KEY (`updated_by`)
		REFERENCES `users` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- exhibitor_states
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `exhibitor_states`;


CREATE TABLE `exhibitor_states`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100),
	PRIMARY KEY (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- clusters
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `clusters`;


CREATE TABLE `clusters`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(100),
	PRIMARY KEY (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- channel_formats_clusters
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `channel_formats_clusters`;


CREATE TABLE `channel_formats_clusters`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`channel_format_id` INTEGER  NOT NULL,
	`cluster_id` INTEGER  NOT NULL,
	PRIMARY KEY (`id`),
	INDEX `channel_formats_clusters_FI_1` (`channel_format_id`),
	CONSTRAINT `channel_formats_clusters_FK_1`
		FOREIGN KEY (`channel_format_id`)
		REFERENCES `channel_formats` (`id`)
		ON DELETE CASCADE,
	INDEX `channel_formats_clusters_FI_2` (`cluster_id`),
	CONSTRAINT `channel_formats_clusters_FK_2`
		FOREIGN KEY (`cluster_id`)
		REFERENCES `clusters` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- menu_items
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `menu_items`;


CREATE TABLE `menu_items`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`menu_item_id` INTEGER,
	`user_rol_id` INTEGER  NOT NULL,
	`name` VARCHAR(100)  NOT NULL,
	`url` VARCHAR(100)  NOT NULL,
	`module` VARCHAR(100)  NOT NULL,
	`action` VARCHAR(100)  NOT NULL,
	`has_submenu` INTEGER default 0,
	`icon` VARCHAR(100)  NOT NULL,
	`ordering` INTEGER default 0,
	`active` INTEGER default 1,
	PRIMARY KEY (`id`),
	INDEX `menu_items_FI_1` (`menu_item_id`),
	CONSTRAINT `menu_items_FK_1`
		FOREIGN KEY (`menu_item_id`)
		REFERENCES `menu_items` (`id`)
		ON DELETE CASCADE,
	INDEX `menu_items_FI_2` (`user_rol_id`),
	CONSTRAINT `menu_items_FK_2`
		FOREIGN KEY (`user_rol_id`)
		REFERENCES `user_rols` (`id`)
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- user_presenteeism
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `user_presenteeism`;


CREATE TABLE `user_presenteeism`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`user_id` INTEGER  NOT NULL,
	`value` INTEGER,
	`date` DATETIME,
	`comments` VARCHAR(250),
	`created_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `user_presenteeism_FI_1` (`user_id`),
	CONSTRAINT `user_presenteeism_FK_1`
		FOREIGN KEY (`user_id`)
		REFERENCES `users` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

#-----------------------------------------------------------------------------
#-- user_replacement
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `user_replacement`;


CREATE TABLE `user_replacement`
(
	`id` INTEGER  NOT NULL AUTO_INCREMENT,
	`user_id` INTEGER  NOT NULL,
	`user_presenteeism_id` INTEGER  NOT NULL,
	`value` INTEGER,
	`covered_hours` DOUBLE,
	`created_at` DATETIME,
	PRIMARY KEY (`id`),
	INDEX `user_replacement_FI_1` (`user_id`),
	CONSTRAINT `user_replacement_FK_1`
		FOREIGN KEY (`user_id`)
		REFERENCES `users` (`id`)
		ON DELETE CASCADE,
	INDEX `user_replacement_FI_2` (`user_presenteeism_id`),
	CONSTRAINT `user_replacement_FK_2`
		FOREIGN KEY (`user_presenteeism_id`)
		REFERENCES `user_presenteeism` (`id`)
		ON DELETE CASCADE
)Type=InnoDB;

# This restores the fkey checks, after having unset them earlier
SET FOREIGN_KEY_CHECKS = 1;