EZU complete

CREATE TABLE `api__users` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `username` varchar(250) NOT NULL,
  `desc` text,
  `api_key` varchar(250) NOT NULL,
  `api_secret` varchar(250) NOT NULL,
  `source` varchar(255) NOT NULL,
  `status` varchar(25) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `app_modules__app_module_models` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `app_module_id` int(11) NOT NULL,
  `model_plugin` varchar(20) NOT NULL,
  `model_name` varchar(50) NOT NULL,
  `entity_type` varchar(20) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `app_modules__app_modules` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `module` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `frontend_routes` varchar(200) NOT NULL,
  `status` varchar(20) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `application_states__application_states` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `app` varchar(15) NOT NULL,
  `state` varchar(50) NOT NULL,
  `ips` text NOT NULL,
  `modified` datetime NOT NULL,
  `created` datetime NOT NULL
);

CREATE TABLE `areas__area_app_modules` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `area_id` int(11) NOT NULL,
  `app_module_id` int(11) NOT NULL,
  `app_module` varchar(50) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `areas__areas` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `short_name` varchar(50) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `asset_compress__asset_compress_build_resources` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `asset_compress_build_id` int(11) NOT NULL,
  `compress` int(1) DEFAULT "1",
  `assetize` int(1) DEFAULT "1",
  `file` text,
  `resource` text
);

CREATE TABLE `asset_compress__asset_compress_builds` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `app` varchar(25) NOT NULL,
  `hash` varchar(40) NOT NULL,
  `version` varchar(25) NOT NULL,
  `status` varchar(25) NOT NULL,
  `type` varchar(25) NOT NULL,
  `is_inline` int(1) DEFAULT "0",
  `inline_content` text,
  `created` datetime NOT NULL
);

CREATE TABLE `attribute_rules__attribute_rules` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `attribute_id` int(11) NOT NULL,
  `plugin` varchar(50) NOT NULL,
  `rule_key` varchar(80) NOT NULL,
  `rule_value` varchar(150) NOT NULL
);

CREATE TABLE `balthazar__acos` (
  `id` int(10) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
  `foreign_key` int(10) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `label` varchar(100) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `lft` int(10) DEFAULT NULL,
  `rght` int(10) DEFAULT NULL
);

CREATE TABLE `balthazar__aros` (
  `id` int(10) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
  `foreign_key` int(10) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `lft` int(10) DEFAULT NULL,
  `rght` int(10) DEFAULT NULL
);

CREATE TABLE `balthazar__aros_acos` (
  `id` int(10) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `aro_id` int(10) NOT NULL,
  `aco_id` int(10) NOT NULL,
  `_create` varchar(2) NOT NULL DEFAULT "0",
  `_read` varchar(2) NOT NULL DEFAULT "0",
  `_update` varchar(2) NOT NULL DEFAULT "0",
  `_delete` varchar(2) NOT NULL DEFAULT "0"
);

CREATE TABLE `balthazar__attribute_group_items` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `attribute_group_id` int(11) NOT NULL,
  `attribute_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL,
  `required` int(11) DEFAULT NULL
);

CREATE TABLE `balthazar__attribute_groups` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `key` varchar(150) NOT NULL,
  `origin_locale` varchar(3) DEFAULT NULL,
  `name` varchar(150) NOT NULL,
  `description` text,
  `model` varchar(50) NOT NULL,
  `subtype` int(11) DEFAULT NULL,
  `sort` int(11) NOT NULL,
  `status` varchar(20) NOT NULL,
  `customer_edit` int(11) NOT NULL DEFAULT "1",
  `domain_id` int(4) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `balthazar__attribute_groups_i18n` (
  `id` int(10) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `locale` varchar(6) NOT NULL,
  `model` varchar(255) NOT NULL,
  `foreign_key` int(10) NOT NULL,
  `field` varchar(255) NOT NULL,
  `content` text
);

CREATE TABLE `balthazar__attribute_options` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `attribute_id` int(11) NOT NULL,
  `key` varchar(50) NOT NULL,
  `label` varchar(150) NOT NULL,
  `image` int(11) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `default` int(11) DEFAULT "0",
  `origin_locale` varchar(3) DEFAULT NULL,
  `sort` int(11) NOT NULL
);

CREATE TABLE `balthazar__attribute_options_i18n` (
  `id` int(10) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `locale` varchar(6) NOT NULL,
  `model` varchar(255) NOT NULL,
  `foreign_key` int(10) NOT NULL,
  `field` varchar(255) NOT NULL,
  `content` text
);

CREATE TABLE `balthazar__attributes` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `key` varchar(150) NOT NULL,
  `origin_locale` varchar(3) DEFAULT NULL,
  `name` varchar(150) NOT NULL,
  `type` varchar(32) NOT NULL,
  `default_value` varchar(250) DEFAULT NULL,
  `validation` varchar(50) DEFAULT NULL,
  `empty_text` varchar(250) DEFAULT NULL,
  `options` varchar(250) NOT NULL,
  `status` varchar(15) NOT NULL,
  `visible` tinyint(1) NOT NULL DEFAULT "1",
  `description` varchar(250) NOT NULL,
  `model` varchar(50) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `balthazar__attributes_i18n` (
  `id` int(10) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `locale` varchar(6) NOT NULL,
  `model` varchar(255) NOT NULL,
  `foreign_key` int(10) NOT NULL,
  `field` varchar(255) NOT NULL,
  `content` text
);

CREATE TABLE `balthazar__backend_jobs` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `function` varchar(250) NOT NULL,
  `instance` int(11) DEFAULT NULL,
  `batch_count` int(11) DEFAULT NULL,
  `params` text,
  `status` varchar(25) NOT NULL,
  `created` datetime DEFAULT NULL,
  `processing` datetime DEFAULT NULL,
  `completed` datetime DEFAULT NULL
);

CREATE TABLE `balthazar__captcha_codes` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `ip` varchar(20) DEFAULT NULL,
  `plugin` varchar(100) DEFAULT NULL,
  `controller` varchar(100) DEFAULT NULL,
  `action` varchar(100) DEFAULT NULL,
  `model` varchar(100) DEFAULT NULL,
  `foreign_key` int(11) DEFAULT NULL,
  `code` varchar(32) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `balthazar__countries` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `sort_name` varchar(250) NOT NULL,
  `iso2` varchar(2) NOT NULL,
  `iso3` varchar(3) NOT NULL,
  `num` int(11) NOT NULL,
  `custom_code` varchar(5) NOT NULL,
  `currency_id` int(11) NOT NULL,
  `status` varchar(20) NOT NULL
);

CREATE TABLE `balthazar__country_calling_codes` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `country_id` int(11) NOT NULL,
  `call_code` varchar(7) NOT NULL,
  `description` varchar(150) NOT NULL,
  `default` tinyint(1) NOT NULL DEFAULT "0"
);

CREATE TABLE `balthazar__country_ip_ranges` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `country_id` int(11) DEFAULT NULL,
  `ip_from` varchar(50) NOT NULL,
  `ip_to` varchar(50) NOT NULL,
  `country` varchar(100) NOT NULL
);

CREATE TABLE `balthazar__country_states` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `country_id` int(11) NOT NULL,
  `name` varchar(250) NOT NULL,
  `code` varchar(5) DEFAULT NULL
);

CREATE TABLE `balthazar__currencies` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `iso3` varchar(3) NOT NULL,
  `iso_num` int(11) NOT NULL,
  `name` varchar(250) NOT NULL,
  `short_name` varchar(50) NOT NULL,
  `special_code` varchar(5) NOT NULL,
  `decimals_length` int(11) DEFAULT "2",
  `status` varchar(20) NOT NULL,
  `conversion_rate` decimal(10, 4) DEFAULT NULL
);

CREATE TABLE `balthazar__file_action_items` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `file_action_id` int(11) NOT NULL,
  `type` varchar(25) NOT NULL,
  `key` varchar(25) NOT NULL,
  `params` text NOT NULL,
  `sort` int(11) NOT NULL
);

CREATE TABLE `balthazar__file_actions` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `key` varchar(150) NOT NULL,
  `type` varchar(50) NOT NULL,
  `cache_expires` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `balthazar__file_restriction_sources` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `file_restriction_id` int(11) NOT NULL,
  `model` varchar(250) NOT NULL,
  `foreign_id` int(11) NOT NULL,
  `field` varchar(250) NOT NULL
);

CREATE TABLE `balthazar__file_restrictions` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `file_id` int(11) NOT NULL,
  `type` varchar(25) NOT NULL,
  `app` varchar(100) DEFAULT NULL,
  `model` varchar(250) DEFAULT NULL,
  `foreign_id` int(11) DEFAULT NULL
);

CREATE TABLE `balthazar__file_types` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `key` varchar(150) NOT NULL,
  `label` varchar(250) NOT NULL,
  `description` varchar(500) NOT NULL,
  `type` varchar(50) NOT NULL,
  `required` int(11) NOT NULL,
  `multiple` int(11) NOT NULL,
  `model` varchar(150) NOT NULL,
  `subtype` int(11) DEFAULT NULL,
  `min_size` float(10, 3) NOT NULL,
  `max_size` float(10, 3) NOT NULL,
  `sort` int(11) NOT NULL,
  `can_delete` int(11) NOT NULL DEFAULT "1",
  `status` varchar(25) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `balthazar__files` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `app` varchar(100) NOT NULL,
  `path` varchar(250) NOT NULL,
  `filename` varchar(150) NOT NULL,
  `extension` varchar(25) NOT NULL,
  `label` varchar(250) DEFAULT NULL,
  `code` varchar(50) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `mime_type` varchar(250) NOT NULL,
  `size` decimal(20, 3) NOT NULL,
  `restricted` int(1) NOT NULL DEFAULT "0",
  `text_lines_count` int(11) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `balthazar__files_aros_acos` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `aro_id` int(11) NOT NULL,
  `file_id` int(11) NOT NULL,
  `_create` varchar(2) NOT NULL,
  `_read` varchar(2) NOT NULL,
  `_update` varchar(2) NOT NULL,
  `_delete` varchar(2) NOT NULL
);

CREATE TABLE `balthazar__groups` (
  `id` int(10) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `login_redirect` varchar(25) DEFAULT NULL,
  `key` varchar(150) NOT NULL,
  `description` text NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `balthazar__languages` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `iso2` varchar(2) DEFAULT NULL,
  `iso3` varchar(3) NOT NULL,
  `code` varchar(5) NOT NULL,
  `url_key` varchar(10) NOT NULL,
  `status` varchar(20) NOT NULL,
  `default` int(11) NOT NULL DEFAULT "0"
);

CREATE TABLE `balthazar__login_attempts` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `model` varchar(100) NOT NULL,
  `foreign_key` int(11) DEFAULT NULL,
  `ip` varchar(20) NOT NULL,
  `attempts` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `balthazar__meta_tables` (
  `table` varchar(100) PRIMARY KEY NOT NULL,
  `key` varchar(25) PRIMARY KEY NOT NULL,
  `value_int` int(11) DEFAULT NULL,
  `value_char` varchar(250) DEFAULT NULL
);

CREATE TABLE `balthazar__model_keys` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `model` varchar(150) NOT NULL,
  `namespace` varchar(150) NOT NULL,
  `last_id` int(255) NOT NULL DEFAULT "1"
);

CREATE TABLE `balthazar__schema_migrations` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `class` varchar(255) NOT NULL,
  `type` varchar(50) NOT NULL,
  `created` datetime NOT NULL
);

CREATE TABLE `balthazar__sent_email_attributes` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `sent_email_id` int(11) NOT NULL,
  `key` varchar(255) NOT NULL,
  `value` varchar(500) DEFAULT NULL
);

CREATE TABLE `balthazar__sent_emails` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `app` varchar(50) NOT NULL,
  `email_id` varchar(250) NOT NULL,
  `msg_id` varchar(250) DEFAULT NULL,
  `status` varchar(25) NOT NULL,
  `from_addr` varchar(250) NOT NULL,
  `to_addr` text NOT NULL,
  `cc_addr` text,
  `return_path` varchar(255) NOT NULL,
  `subject` text NOT NULL,
  `html_content` blob,
  `text_content` blob,
  `sent_datetime` datetime DEFAULT NULL,
  `delivered_datetime` datetime DEFAULT NULL,
  `bounced_datetime` datetime DEFAULT NULL,
  `complained_datetime` datetime DEFAULT NULL,
  `sent_msg` text,
  `delivered_msg` text,
  `bounced_msg` text,
  `complained_msg` text,
  `notified` int(1) NOT NULL DEFAULT "0",
  `notified_datetime` datetime NOT NULL
);

CREATE TABLE `balthazar__sessions` (
  `id` varchar(255) PRIMARY KEY NOT NULL,
  `data` longtext,
  `expires` int(11) DEFAULT NULL
);

CREATE TABLE `balthazar__settings` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `key` varchar(250) NOT NULL,
  `value` varchar(250) NOT NULL,
  `type` varchar(15) NOT NULL,
  `label` varchar(250) NOT NULL,
  `main_segment` varchar(250) NOT NULL,
  `sub_segment` varchar(250) NOT NULL,
  `internal` int(11) NOT NULL,
  `changed` int(11) NOT NULL DEFAULT "0",
  `sort` int(11) NOT NULL,
  `options` text NOT NULL,
  `description` text NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `balthazar__urls` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `url` varchar(255) NOT NULL,
  `hash` varchar(65) NOT NULL,
  `redirect_to` int(11) DEFAULT NULL,
  `plugin` varchar(35) NOT NULL,
  `controller` varchar(25) NOT NULL,
  `action` varchar(15) NOT NULL,
  `model` varchar(15) NOT NULL,
  `foreign_key` int(11) DEFAULT NULL,
  `foreign_model` varchar(15) DEFAULT NULL,
  `foreign_model_key` int(11) DEFAULT NULL,
  `lang` varchar(5) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `domain_id` int(4) NOT NULL
);

CREATE TABLE `balthazar__user_activities` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `remote_ip` varchar(40) DEFAULT NULL,
  `user_agent` varchar(500) DEFAULT NULL,
  `app` varchar(50) NOT NULL,
  `plugin` varchar(50) DEFAULT NULL,
  `controller` varchar(50) NOT NULL,
  `action` varchar(50) NOT NULL,
  `pass` varchar(500) DEFAULT NULL,
  `form` text,
  `named` varchar(500) DEFAULT NULL,
  `created` datetime NOT NULL
);

CREATE TABLE `balthazar__user_sessions` (
  `id` varchar(36) PRIMARY KEY NOT NULL,
  `user_id` int(11) NOT NULL,
  `app` varchar(25) NOT NULL,
  `session_id` varchar(250) NOT NULL,
  `started` datetime NOT NULL,
  `expires` datetime NOT NULL,
  `token` varchar(250) DEFAULT NULL,
  `remote_ip` varchar(15) DEFAULT NULL,
  `user_agent` text,
  `data` text
);

CREATE TABLE `balthazar__users` (
  `id` int(10) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `ext_id` int(10) DEFAULT NULL,
  `group_id` int(10) NOT NULL,
  `code` varchar(25) NOT NULL,
  `email` varchar(250) NOT NULL,
  `password` varchar(40) NOT NULL,
  `firstname` varchar(150) NOT NULL,
  `lastname` varchar(150) NOT NULL,
  `nickname` varchar(250) DEFAULT NULL,
  `status` varchar(25) NOT NULL,
  `password_reset` varchar(40) DEFAULT NULL,
  `default` int(11) NOT NULL DEFAULT "0",
  `source` varchar(25) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `deleted` datetime DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
);

CREATE TABLE `clients__api_users` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `clients_client_id` varchar(32) NOT NULL,
  `username` varchar(250) NOT NULL,
  `desc` text,
  `api_key` varchar(250) NOT NULL,
  `api_secret` varchar(250) NOT NULL,
  `source` varchar(255) NOT NULL,
  `status` varchar(25) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `clients__clients` (
  `id` varchar(32) PRIMARY KEY NOT NULL,
  `code` varchar(10) NOT NULL,
  `prefix` varchar(2) DEFAULT NULL,
  `name` varchar(250) NOT NULL,
  `shortname` varchar(250) NOT NULL,
  `domain` varchar(250) NOT NULL,
  `custom_domain` varchar(253) DEFAULT NULL,
  `provisioned` int(11) NOT NULL DEFAULT "0",
  `logo` int(11) DEFAULT NULL,
  `timezone` varchar(125) NOT NULL,
  `fcom_user_id` int(11) NOT NULL,
  `db_pass` varchar(255) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `codes__aa_types` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `status` varchar(25) NOT NULL,
  `sort` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `codes__comment_categories` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `key` varchar(50) NOT NULL,
  `status` varchar(25) NOT NULL,
  `sort` int(11) NOT NULL,
  `sort_filter` tinyint(11) NOT NULL DEFAULT "100",
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified` datetime NOT NULL,
  `modified_by` int(11) NOT NULL,
  `deleted` datetime DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `codes__hourly_rates` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `status` varchar(25) NOT NULL,
  `legal_subject_id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `rate` decimal(10, 4) NOT NULL,
  `year` int(11) NOT NULL,
  `sort` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `codes__impact_on_subjects` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `codes__io_types` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `status` varchar(25) NOT NULL,
  `sort` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `codes__legal_subjects` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `description` text,
  `show_in_report` int(11) NOT NULL,
  `sort` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `codes__life_events` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `description` varchar(500) DEFAULT NULL,
  `sort` int(11) NOT NULL,
  `status` varchar(25) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `codes__priority_areas` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `status` varchar(25) NOT NULL,
  `name` varchar(150) NOT NULL,
  `key` varchar(50) NOT NULL,
  `sort` int(11) NOT NULL,
  `sort_filter` tinyint(11) NOT NULL DEFAULT "100",
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified` datetime NOT NULL,
  `modified_by` int(11) NOT NULL,
  `deleted` datetime DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `codes__regulation_categories` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `status` varchar(25) NOT NULL,
  `sort` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `long_name` varchar(150) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `codes__smju_inop_categories` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `key` varchar(30) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `codes__smju_inops` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `smju_inop_category_id` int(11) NOT NULL,
  `number` varchar(20) DEFAULT NULL,
  `name` text NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `codes__smju_mju_internal_participants` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `shortname` varchar(20) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `codes__smju_zeps` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `url` varchar(255) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `codes__ukrepi_an_sjus` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL,
  `rght` int(11) NOT NULL,
  `lft` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `shortname` varchar(100) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `codes__ukrepi_cilji` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `shortname` varchar(20) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `codes__ukrepi_opzg_areas` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `shortname` varchar(100) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `codes__ukrepi_viri` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `shortname` varchar(20) NOT NULL,
  `description` text,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `codes__ukrepi_wb_areas` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `shortname` varchar(20) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `comments__comment_milestones` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `comment_id` int(11) NOT NULL,
  `milestone_date` date NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified` datetime NOT NULL,
  `modified_by` int(11) NOT NULL,
  `deleted` datetime DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
);

CREATE TABLE `comments__comment_ministries` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `comment_id` int(11) NOT NULL,
  `ministry_id` int(11) NOT NULL,
  `institution_id` int(11) DEFAULT NULL
);

CREATE TABLE `comments__comment_ministry_contacts` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `comment_id` int(11) NOT NULL,
  `ministry_contact_id` int(11) NOT NULL,
  `institution_contact_id` int(11) DEFAULT NULL,
  `sent_first` int(11) NOT NULL DEFAULT "0",
  `sent_first_date` datetime DEFAULT NULL,
  `sent_second` int(11) NOT NULL DEFAULT "0",
  `sent_second_date` datetime DEFAULT NULL
);

CREATE TABLE `comments__comment_replies` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `comment_id` int(11) NOT NULL,
  `institution_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `reply` text NOT NULL,
  `file_id` int(11) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `comments__comment_reply_confirmations` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `comment_reply_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_type` varchar(20) DEFAULT NULL,
  `confirmation_status` varchar(20) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `comments__comment_responsibles` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `comment_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
);

CREATE TABLE `comments__comment_sent_emails` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `comment_id` int(11) NOT NULL,
  `type` varchar(30) NOT NULL,
  `recipient_type` varchar(20) NOT NULL,
  `institution_contact_ids` varchar(255) DEFAULT NULL,
  `from_email` varchar(100) DEFAULT NULL,
  `email_subject` varchar(255) DEFAULT NULL,
  `email_content` text,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL
);

CREATE TABLE `comments__comments` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `email` varchar(250) NOT NULL,
  `postal_code` varchar(10) DEFAULT NULL,
  `priority_area_id` int(11) DEFAULT NULL,
  `legislation_id` int(11) DEFAULT NULL,
  `acquired_from` varchar(25) NOT NULL,
  `title` varchar(500) DEFAULT NULL,
  `content` text NOT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `original_attachment` varchar(255) DEFAULT NULL,
  `comment_category_id` int(11) DEFAULT NULL,
  `issue_no` varchar(250) DEFAULT NULL,
  `institution` varchar(250) DEFAULT NULL,
  `institution_id` int(11) DEFAULT NULL,
  `original_institution_id` int(11) DEFAULT NULL,
  `responsible` varchar(250) DEFAULT NULL,
  `publish_status` varchar(25) NOT NULL,
  `reply_status` varchar(25) NOT NULL,
  `reply` text,
  `mju_pov` text,
  `mju_pov_publised` tinyint(4) DEFAULT NULL,
  `follow_up` text,
  `email_comment` text,
  `decline_reason` text,
  `in_progress_text` text,
  `reply_status_concluded_text` text,
  `examining_reminder` text,
  `legislation_change` int(11) NOT NULL DEFAULT "0",
  `in_progress` int(11) NOT NULL DEFAULT "0",
  `examining` tinyint(1) DEFAULT NULL,
  `publish_to_min25` tinyint(4) DEFAULT NULL,
  `publish_to_ekc` tinyint(4) DEFAULT NULL,
  `publish_to_psos` tinyint(4) DEFAULT NULL,
  `forwarded_to` varchar(50) DEFAULT NULL,
  `submitted_date` datetime NOT NULL,
  `published_date` datetime DEFAULT NULL,
  `declined_date` datetime DEFAULT NULL,
  `waiting_date` datetime DEFAULT NULL,
  `forwarded_date` datetime DEFAULT NULL,
  `acquired_date` datetime DEFAULT NULL,
  `mju_pov_date` datetime DEFAULT NULL,
  `reply_pending_date` datetime DEFAULT NULL,
  `reply_submitted_date` datetime DEFAULT NULL,
  `reply_sent_1_date` datetime DEFAULT NULL,
  `reply_sent_2_date` datetime DEFAULT NULL,
  `reply_received_date` datetime DEFAULT NULL,
  `reply_notexpected_date` datetime DEFAULT NULL,
  `examining_date` datetime DEFAULT NULL,
  `examining_to_date` datetime DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `meta_description` varchar(255) NOT NULL,
  `meta_keywords` varchar(255) NOT NULL,
  `newsletter` tinyint(1) DEFAULT NULL,
  `sent_to_ezu` tinyint(1) DEFAULT NULL,
  `sent_to_ezu_date` date DEFAULT NULL,
  `ezu_measure_id` int(11) DEFAULT NULL,
  `confirmed_in_ezu` tinyint(4) DEFAULT NULL,
  `confirmed_in_ezu_date` date DEFAULT NULL
);

CREATE TABLE `comments__institutions` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `status` varchar(25) NOT NULL,
  `sort` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `short_name` varchar(50) NOT NULL,
  `sort_filter` tinyint(11) NOT NULL DEFAULT "100",
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `comments__ministries` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `status` varchar(25) NOT NULL,
  `sort` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `short_name` varchar(50) NOT NULL,
  `short_name_ezu` varchar(50) DEFAULT NULL,
  `sort_filter` tinyint(11) NOT NULL DEFAULT "100",
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `comments__ministry_contacts` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `institution_contact_id` int(11) DEFAULT NULL,
  `ministry_id` int(11) NOT NULL,
  `institution_id` int(11) DEFAULT NULL,
  `type` varchar(25) NOT NULL,
  `name` varchar(250) NOT NULL,
  `email` varchar(250) NOT NULL
);

CREATE TABLE `comments__practise_milestones` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `practise_id` int(11) NOT NULL,
  `milestone_date` date NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified` datetime NOT NULL,
  `modified_by` int(11) NOT NULL,
  `deleted` datetime DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
);

CREATE TABLE `comments__practise_ministries` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `practise_id` int(11) NOT NULL,
  `ministry_id` int(11) NOT NULL,
  `institution_id` int(11) DEFAULT NULL
);

CREATE TABLE `comments__practise_ministry_contacts` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `practise_id` int(11) NOT NULL,
  `ministry_contact_id` int(11) NOT NULL,
  `institution_contact_id` int(11) DEFAULT NULL,
  `sent_first` int(11) NOT NULL DEFAULT "0",
  `sent_first_date` datetime DEFAULT NULL,
  `sent_second` int(11) NOT NULL DEFAULT "0",
  `sent_second_date` datetime DEFAULT NULL
);

CREATE TABLE `comments__practises` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `comment_id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `email` varchar(250) NOT NULL,
  `postal_code` varchar(10) DEFAULT NULL,
  `priority_area_id` int(11) DEFAULT NULL,
  `legislation_id` int(11) DEFAULT NULL,
  `acquired_from` varchar(25) NOT NULL,
  `title` varchar(500) DEFAULT NULL,
  `content` text NOT NULL,
  `attachment` varchar(255) NOT NULL,
  `comment_category_id` int(11) DEFAULT NULL,
  `issue_no` varchar(250) DEFAULT NULL,
  `institution` varchar(250) DEFAULT NULL,
  `institution_id` int(11) DEFAULT NULL,
  `original_institution_id` int(11) DEFAULT NULL,
  `responsible` varchar(250) DEFAULT NULL,
  `status` varchar(25) NOT NULL,
  `exposed` varchar(25) NOT NULL,
  `reply` text,
  `mju_pov` text,
  `follow_up` text,
  `legislation_change` int(11) NOT NULL DEFAULT "0",
  `publish_to_min25` tinyint(4) DEFAULT NULL,
  `publish_to_ekc` tinyint(4) DEFAULT NULL,
  `publish_to_psos` tinyint(4) DEFAULT NULL,
  `forwarded_to` varchar(50) DEFAULT NULL,
  `submitted_date` datetime NOT NULL,
  `published_date` datetime DEFAULT NULL,
  `declined_date` datetime DEFAULT NULL,
  `waiting_date` datetime DEFAULT NULL,
  `forwarded_date` datetime DEFAULT NULL,
  `acquired_date` datetime DEFAULT NULL,
  `reply_pending_date` datetime DEFAULT NULL,
  `reply_submitted_date` datetime DEFAULT NULL,
  `reply_sent_1_date` datetime DEFAULT NULL,
  `reply_sent_2_date` datetime DEFAULT NULL,
  `reply_received_date` datetime DEFAULT NULL,
  `reply_notexpected_date` datetime DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `meta_description` varchar(255) NOT NULL,
  `meta_keywords` varchar(255) NOT NULL,
  `sent_to_ezu` tinyint(1) DEFAULT NULL,
  `ezu_measure_id` int(11) DEFAULT NULL,
  `confirmed_in_ezu` int(11) DEFAULT NULL,
  `confirmed_in_ezu_date` date DEFAULT NULL,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified` datetime NOT NULL,
  `modified_by` int(11) NOT NULL,
  `deleted` datetime DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
);

CREATE TABLE `comments__sent_comments` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `first_sent_count` int(11) NOT NULL,
  `second_sent_count` int(11) NOT NULL,
  `first_sent` text NOT NULL,
  `second_sent` text NOT NULL,
  `created` datetime NOT NULL
);

CREATE TABLE `ezu_contents__contents` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `app_module_id` int(11) DEFAULT NULL,
  `key` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `form_help__form_help` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `model_alias` varchar(255) NOT NULL,
  `field` varchar(255) NOT NULL,
  `key` varchar(255) DEFAULT NULL,
  `segment` varchar(255) DEFAULT NULL,
  `status` varchar(25) NOT NULL,
  `label` varchar(255) NOT NULL,
  `text` text NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `form_help__form_help_params` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `form_help_id` int(11) NOT NULL,
  `key` varchar(250) NOT NULL,
  `value` varchar(500) NOT NULL
);

CREATE TABLE `front_users__user_namespaces` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `app_module_id` int(11) NOT NULL,
  `app_module` varchar(30) DEFAULT NULL,
  `namespace` varchar(32) NOT NULL,
  `pin` varchar(10) DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `front_users__users` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `status` varchar(25) NOT NULL,
  `group_id` int(11) NOT NULL DEFAULT "1",
  `institution_id` int(11) NOT NULL,
  `owner_id` int(11) DEFAULT NULL,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `email` varchar(250) NOT NULL,
  `email_confirmed` int(6) NOT NULL DEFAULT "0",
  `username` varchar(250) NOT NULL,
  `password` varchar(50) DEFAULT NULL,
  `r_email_confirm_code` varchar(40) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `institutions__institution_app_modules` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `institution_id` int(11) NOT NULL,
  `app_module_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `institutions__institution_contact_app_modules` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `institution_contact_id` int(11) NOT NULL,
  `app_module_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `institutions__institution_contacts` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `institution_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `position` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `type` varchar(25) DEFAULT NULL,
  `status` varchar(20) NOT NULL,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified` datetime NOT NULL,
  `modified_by` int(11) NOT NULL,
  `deleted` datetime DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
);

CREATE TABLE `institutions__institution_namespaces` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `institution_id` int(11) NOT NULL,
  `app_module_id` int(11) NOT NULL,
  `app_module` varchar(30) DEFAULT NULL,
  `namespace` varchar(32) NOT NULL,
  `pin` varchar(10) DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `institutions__institution_types` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `institutions__institutions` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `institution_type_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `short_name` varchar(50) NOT NULL,
  `namespace` varchar(50) NOT NULL,
  `pin` int(4) NOT NULL,
  `status` varchar(20) NOT NULL,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified` datetime NOT NULL,
  `modified_by` int(11) NOT NULL,
  `deleted` datetime DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
);

CREATE TABLE `legislations__administrative_activities` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `revision_id` int(11) NOT NULL,
  `has_changed` int(11) NOT NULL,
  `added` int(11) NOT NULL,
  `name` varchar(1000) NOT NULL,
  `information_obligation_id` int(11) NOT NULL,
  `aa_type_id` int(11) NOT NULL,
  `article` varchar(150) DEFAULT NULL,
  `online_enabled` int(11) NOT NULL,
  `hourly_rate_id` int(11) NOT NULL,
  `population_desc` text,
  `population` int(11) NOT NULL,
  `frequency_desc` text,
  `frequency` decimal(20, 4) NOT NULL,
  `time_desc` text,
  `time` decimal(20, 4) NOT NULL,
  `costs_desc` text,
  `costs` decimal(20, 4) NOT NULL,
  `external_costs_desc` text,
  `external_costs` decimal(20, 4) NOT NULL,
  `correctional_factor_desc` text,
  `correctional_factor` decimal(20, 4) NOT NULL,
  `price` decimal(20, 4) NOT NULL,
  `qty` decimal(20, 4) NOT NULL,
  `qty_hours` decimal(20, 4) NOT NULL,
  `administrative_costs` decimal(20, 4) NOT NULL,
  `administrative_burden` decimal(20, 4) NOT NULL,
  `comments` text,
  `rev_comments` text,
  `created` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `legislations__administrative_activities_deletes` (
  `delete_id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `delete_created` datetime NOT NULL,
  `valid` int(11) NOT NULL,
  `id` int(11) NOT NULL,
  `revision_id` int(11) NOT NULL,
  `has_changed` int(11) NOT NULL,
  `added` int(11) NOT NULL,
  `name` varchar(1000) NOT NULL,
  `information_obligation_id` int(11) NOT NULL,
  `aa_type_id` int(11) NOT NULL,
  `article` varchar(150) DEFAULT NULL,
  `online_enabled` int(11) NOT NULL,
  `hourly_rate_id` int(11) NOT NULL,
  `population_desc` text,
  `population` int(11) NOT NULL,
  `frequency_desc` text,
  `frequency` decimal(20, 4) NOT NULL,
  `time_desc` text,
  `time` decimal(20, 4) NOT NULL,
  `costs_desc` text,
  `costs` decimal(20, 4) NOT NULL,
  `external_costs_desc` text,
  `external_costs` decimal(20, 4) NOT NULL,
  `correctional_factor_desc` text,
  `correctional_factor` decimal(20, 4) NOT NULL,
  `price` decimal(20, 4) NOT NULL,
  `qty` decimal(20, 4) NOT NULL,
  `qty_hours` decimal(20, 4) NOT NULL,
  `administrative_costs` decimal(20, 4) NOT NULL,
  `administrative_burden` decimal(20, 4) NOT NULL,
  `comments` text,
  `rev_comments` text NOT NULL,
  `created` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `legislations__administrative_activities_revs` (
  `version_id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `version_created` datetime NOT NULL,
  `id` int(11) NOT NULL,
  `revision_id` int(11) NOT NULL,
  `has_changed` int(11) NOT NULL,
  `added` int(11) NOT NULL,
  `name` varchar(1000) NOT NULL,
  `information_obligation_id` int(11) NOT NULL,
  `aa_type_id` int(11) NOT NULL,
  `article` varchar(150) DEFAULT NULL,
  `online_enabled` int(11) NOT NULL,
  `hourly_rate_id` int(11) NOT NULL,
  `population_desc` text,
  `population` int(11) NOT NULL,
  `frequency_desc` text,
  `frequency` decimal(20, 4) NOT NULL,
  `time_desc` text,
  `time` decimal(20, 4) NOT NULL,
  `costs_desc` text,
  `costs` decimal(20, 4) NOT NULL,
  `external_costs_desc` text,
  `external_costs` decimal(20, 4) NOT NULL,
  `correctional_factor_desc` text,
  `correctional_factor` decimal(20, 4) NOT NULL,
  `price` decimal(20, 4) NOT NULL,
  `qty` decimal(20, 4) NOT NULL,
  `qty_hours` decimal(20, 4) NOT NULL,
  `administrative_costs` decimal(20, 4) NOT NULL,
  `administrative_burden` decimal(20, 4) NOT NULL,
  `comments` text,
  `rev_comments` text NOT NULL,
  `created` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `legislations__information_obligations` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `revision_id` int(11) NOT NULL,
  `has_changed` int(11) NOT NULL,
  `added` int(11) NOT NULL,
  `legislation_id` int(11) DEFAULT NULL,
  `sublegislation_act_id` int(11) DEFAULT NULL,
  `name` varchar(1000) NOT NULL,
  `article` varchar(250) NOT NULL,
  `legislation_article` varchar(250) DEFAULT NULL,
  `io_type_id` int(11) NOT NULL,
  `regulation_category_id` int(11) NOT NULL,
  `life_event_id` int(11) DEFAULT NULL,
  `comments` text,
  `rev_comments` text,
  `created` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `legislations__information_obligations_deletes` (
  `delete_id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `delete_created` datetime NOT NULL,
  `valid` int(11) NOT NULL,
  `id` int(11) NOT NULL,
  `revision_id` int(11) NOT NULL,
  `has_changed` int(11) NOT NULL,
  `added` int(11) NOT NULL,
  `legislation_id` int(11) DEFAULT NULL,
  `sublegislation_act_id` int(11) DEFAULT NULL,
  `name` varchar(1000) NOT NULL,
  `article` varchar(250) NOT NULL,
  `legislation_article` varchar(250) DEFAULT NULL,
  `io_type_id` int(11) NOT NULL,
  `regulation_category_id` int(11) NOT NULL,
  `life_event_id` int(11) DEFAULT NULL,
  `administrative_costs` decimal(20, 4) NOT NULL,
  `administrative_burden` decimal(20, 4) NOT NULL,
  `count_aas` int(11) NOT NULL,
  `comments` text,
  `rev_comments` text NOT NULL,
  `created` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `legislations__information_obligations_revs` (
  `version_id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `version_created` datetime NOT NULL,
  `id` int(11) NOT NULL,
  `revision_id` int(11) NOT NULL,
  `has_changed` int(11) NOT NULL,
  `added` int(11) NOT NULL,
  `legislation_id` int(11) DEFAULT NULL,
  `sublegislation_act_id` int(11) DEFAULT NULL,
  `name` varchar(1000) NOT NULL,
  `article` varchar(250) NOT NULL,
  `legislation_article` varchar(250) DEFAULT NULL,
  `io_type_id` int(11) NOT NULL,
  `regulation_category_id` int(11) NOT NULL,
  `life_event_id` int(11) DEFAULT NULL,
  `administrative_costs` decimal(20, 4) NOT NULL,
  `administrative_burden` decimal(20, 4) NOT NULL,
  `count_aas` int(11) NOT NULL,
  `comments` text,
  `rev_comments` text NOT NULL,
  `created` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `legislations__legislations` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `revision_id` int(11) NOT NULL,
  `has_changed` int(11) NOT NULL,
  `added` int(11) NOT NULL,
  `name` varchar(1000) NOT NULL,
  `short_name` varchar(50) DEFAULT NULL,
  `issue_number` varchar(250) NOT NULL,
  `in_force_date` date DEFAULT NULL,
  `ministry_id` int(11) NOT NULL,
  `institution_id` int(11) DEFAULT NULL,
  `priority_area_id` int(11) NOT NULL,
  `comments` text,
  `rev_comments` text,
  `created` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `legislations__legislations_deletes` (
  `delete_id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `delete_created` datetime NOT NULL,
  `valid` int(11) NOT NULL,
  `id` int(11) NOT NULL,
  `revision_id` int(11) NOT NULL,
  `has_changed` int(11) NOT NULL,
  `added` int(11) NOT NULL,
  `name` varchar(1000) NOT NULL,
  `short_name` varchar(50) DEFAULT NULL,
  `issue_number` varchar(250) NOT NULL,
  `in_force_date` date DEFAULT NULL,
  `ministry_id` int(11) NOT NULL,
  `institution_id` int(11) DEFAULT NULL,
  `priority_area_id` int(11) NOT NULL,
  `administrative_legislations_costs` decimal(20, 4) NOT NULL,
  `administrative_sublegislation_acts_costs` decimal(20, 4) NOT NULL,
  `administrative_legislations_burden` decimal(20, 4) NOT NULL,
  `administrative_sublegislation_acts_burden` decimal(20, 4) NOT NULL,
  `count_sublegislation_acts` int(11) NOT NULL,
  `count_legislations_ios` int(11) NOT NULL,
  `count_sublegislation_acts_ios` int(11) NOT NULL,
  `count_legislations_aas` int(11) NOT NULL,
  `count_sublegislation_acts_aas` int(11) NOT NULL,
  `comments` text,
  `rev_comments` text NOT NULL,
  `created` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `legislations__legislations_revs` (
  `version_id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `version_created` datetime NOT NULL,
  `id` int(11) NOT NULL,
  `revision_id` int(11) NOT NULL,
  `has_changed` int(11) NOT NULL,
  `added` int(11) NOT NULL,
  `name` varchar(1000) NOT NULL,
  `short_name` varchar(50) DEFAULT NULL,
  `issue_number` varchar(250) NOT NULL,
  `in_force_date` date DEFAULT NULL,
  `ministry_id` int(11) NOT NULL,
  `institution_id` int(11) DEFAULT NULL,
  `priority_area_id` int(11) NOT NULL,
  `administrative_legislations_costs` decimal(20, 4) NOT NULL,
  `administrative_sublegislation_acts_costs` decimal(20, 4) NOT NULL,
  `administrative_legislations_burden` decimal(20, 4) NOT NULL,
  `administrative_sublegislation_acts_burden` decimal(20, 4) NOT NULL,
  `count_sublegislation_acts` int(11) NOT NULL,
  `count_legislations_ios` int(11) NOT NULL,
  `count_sublegislation_acts_ios` int(11) NOT NULL,
  `count_legislations_aas` int(11) NOT NULL,
  `count_sublegislation_acts_aas` int(11) NOT NULL,
  `comments` text,
  `rev_comments` text NOT NULL,
  `created` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `legislations__revisions` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `description` text NOT NULL,
  `published_date` date NOT NULL,
  `lock` int(11) NOT NULL DEFAULT "0",
  `active` int(11) NOT NULL DEFAULT "0",
  `copy_from` int(11) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `legislations__sublegislation_acts` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `revision_id` int(11) NOT NULL,
  `has_changed` int(11) NOT NULL,
  `added` int(11) NOT NULL,
  `legislation_id` int(11) NOT NULL,
  `name` varchar(1000) NOT NULL,
  `issue_number` varchar(250) NOT NULL,
  `in_force_date` date DEFAULT NULL,
  `ministry_id` int(11) NOT NULL,
  `institution_id` int(11) DEFAULT NULL,
  `priority_area_id` int(11) NOT NULL,
  `comments` text,
  `rev_comments` text,
  `created` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `legislations__sublegislation_acts_deletes` (
  `delete_id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `delete_created` datetime NOT NULL,
  `valid` int(11) NOT NULL,
  `id` int(11) NOT NULL,
  `revision_id` int(11) NOT NULL,
  `has_changed` int(11) NOT NULL,
  `added` int(11) NOT NULL,
  `legislation_id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `issue_number` varchar(250) NOT NULL,
  `in_force_date` date DEFAULT NULL,
  `ministry_id` int(11) NOT NULL,
  `institution_id` int(11) DEFAULT NULL,
  `priority_area_id` int(11) NOT NULL,
  `administrative_costs` decimal(20, 4) NOT NULL,
  `administrative_burden` decimal(20, 4) NOT NULL,
  `count_ios` int(11) NOT NULL,
  `count_aas` int(11) NOT NULL,
  `comments` text,
  `rev_comments` text NOT NULL,
  `created` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `legislations__sublegislation_acts_revs` (
  `version_id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `version_created` datetime NOT NULL,
  `id` int(11) NOT NULL,
  `revision_id` int(11) NOT NULL,
  `has_changed` int(11) NOT NULL,
  `added` int(11) NOT NULL,
  `legislation_id` int(11) NOT NULL,
  `name` varchar(1000) NOT NULL,
  `issue_number` varchar(250) NOT NULL,
  `in_force_date` date DEFAULT NULL,
  `ministry_id` int(11) NOT NULL,
  `institution_id` int(11) DEFAULT NULL,
  `priority_area_id` int(11) NOT NULL,
  `administrative_costs` decimal(20, 4) NOT NULL,
  `administrative_burden` decimal(20, 4) NOT NULL,
  `count_ios` int(11) NOT NULL,
  `count_aas` int(11) NOT NULL,
  `comments` text,
  `rev_comments` text NOT NULL,
  `created` datetime NOT NULL,
  `user_id` int(11) NOT NULL
);

CREATE TABLE `locales__holidays` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `name` varchar(500) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `domain_id` int(11) NOT NULL
);

CREATE TABLE `measures__activity_participants` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `app_module_id` int(11) NOT NULL,
  `activity_id` int(11) NOT NULL,
  `participant_id` int(11) NOT NULL,
  `participant_type` varchar(10) NOT NULL
);

CREATE TABLE `measures__activity_responsibles` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `app_module_id` int(11) NOT NULL,
  `activity_id` int(11) NOT NULL,
  `responsible_id` int(11) NOT NULL,
  `responsible_type` varchar(10) NOT NULL
);

CREATE TABLE `measures__coordinator_institutions` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `front_user_id` int(11) NOT NULL,
  `institution_id` int(11) NOT NULL
);

CREATE TABLE `measures__coordinator_ukrepi_an_sjus` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `front_user_id` int(11) NOT NULL,
  `ukrepi_an_sju_id` int(11) NOT NULL
);

CREATE TABLE `measures__coordinator_ukrepi_opzg_areas` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `front_user_id` int(11) NOT NULL,
  `ukrepi_opzg_area_id` int(11) NOT NULL
);

CREATE TABLE `measures__entity_changes` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `entity_id` int(11) NOT NULL,
  `entity_model` varchar(50) NOT NULL,
  `entity_type` varchar(10) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `owner_type` varchar(20) NOT NULL,
  `data` text NOT NULL,
  `original_data` text,
  `status` varchar(20) DEFAULT NULL,
  `reviewed` tinyint(1) NOT NULL,
  `published` tinyint(1) NOT NULL,
  `date` datetime NOT NULL,
  `date_published` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__entity_period_statuses` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `entity_id` int(11) NOT NULL,
  `entity_alias` varchar(50) NOT NULL,
  `entity_type` varchar(10) NOT NULL,
  `period_id` int(11) NOT NULL,
  `status` varchar(10) NOT NULL,
  `priority` int(11) DEFAULT NULL,
  `date` date NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__entity_status_histories` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `entity_id` int(11) NOT NULL,
  `entity_alias` varchar(50) NOT NULL,
  `entity_type` varchar(10) NOT NULL,
  `period_id` int(11) NOT NULL,
  `status` varchar(10) NOT NULL,
  `priority` int(11) DEFAULT NULL,
  `date` date NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__external_measures` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `source` varchar(20) NOT NULL,
  `source_id` int(11) NOT NULL,
  `measure_id` int(11) DEFAULT NULL,
  `title` varchar(500) DEFAULT NULL,
  `content` text NOT NULL,
  `category` varchar(200) DEFAULT NULL,
  `priority_area` varchar(200) DEFAULT NULL,
  `institutions` varchar(200) NOT NULL,
  `reply` text NOT NULL,
  `status` varchar(20) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__jfp_objective_objective_types` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `objective_id` int(11) NOT NULL,
  `jfp_objective_type_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__jfp_objective_types` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__jfp_objectives` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT "0",
  `owner_id` int(11) NOT NULL,
  `owner_type` varchar(20) NOT NULL,
  `lft` int(11) NOT NULL,
  `rght` int(11) NOT NULL,
  `status` varchar(20) NOT NULL,
  `status_date` date DEFAULT NULL,
  `progress` int(11) NOT NULL,
  `important` int(11) NOT NULL,
  `permanent` int(1) NOT NULL DEFAULT "0",
  `title` varchar(500) NOT NULL,
  `description` text NOT NULL,
  `priority` int(11) NOT NULL,
  `date_start` date DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `deadline` date DEFAULT NULL,
  `confirmed` tinyint(1) NOT NULL DEFAULT "0",
  `objective_type` int(4) NOT NULL,
  `final_state` text,
  `implementation_status` varchar(2) DEFAULT NULL,
  `implementation_stage` text,
  `eu_cofinancing` int(4) DEFAULT NULL,
  `internal_responsibles` text,
  `internal_participants` text,
  `external_contractors` text,
  `costs` decimal(9, 2) DEFAULT NULL,
  `costs_argument` text,
  `costs_document` text,
  `financial_effects` int(1) DEFAULT NULL,
  `type` varchar(20) NOT NULL,
  `proposer` varchar(200) DEFAULT NULL,
  `step` varchar(100) DEFAULT NULL,
  `regulation_regulated` text,
  `regulation_modified` text,
  `state_budget_income` decimal(10, 2) DEFAULT NULL,
  `state_budget_outcome` decimal(10, 2) DEFAULT NULL,
  `municipal_budget_income` decimal(10, 2) DEFAULT NULL,
  `municipal_budget_outcome` decimal(10, 2) DEFAULT NULL,
  `municipal_increased_eval_income` decimal(10, 0) DEFAULT NULL,
  `short_term_eval_savings` decimal(10, 2) DEFAULT NULL,
  `long_term_eval_savings` decimal(10, 2) DEFAULT NULL,
  `annual_level_eval_savings` decimal(10, 0) DEFAULT NULL,
  `state_annual_level_eval_savings` decimal(10, 0) DEFAULT NULL,
  `municipal_annual_level_eval_savings` decimal(10, 0) DEFAULT NULL,
  `decision_maker` varchar(200) DEFAULT NULL,
  `drafter` varchar(200) DEFAULT NULL,
  `comment` text NOT NULL,
  `public_report` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__jfp_status_reports` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `entity_id` int(11) NOT NULL,
  `entity_alias` varchar(50) NOT NULL,
  `entity_type` varchar(10) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `owner_type` varchar(20) NOT NULL,
  `period_id` int(11) NOT NULL,
  `status` varchar(100) NOT NULL,
  `priority` int(11) DEFAULT NULL,
  `description` text NOT NULL,
  `municipal_savings` decimal(10, 2) DEFAULT NULL,
  `state_savings` decimal(10, 2) DEFAULT NULL,
  `date` date NOT NULL,
  `date_published` datetime DEFAULT NULL,
  `confirmed` int(1) NOT NULL,
  `published` int(1) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__jfp_tasks` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT "0",
  `lft` int(11) NOT NULL,
  `rght` int(11) NOT NULL,
  `objective_id` int(11) NOT NULL,
  `title` varchar(500) NOT NULL,
  `description` text NOT NULL,
  `status` varchar(20) NOT NULL,
  `progress` int(11) NOT NULL,
  `permanent` int(1) NOT NULL DEFAULT "0",
  `priority` int(11) NOT NULL,
  `date_start` date NOT NULL,
  `date_end` date NOT NULL,
  `deadline` date DEFAULT NULL,
  `final_state` text,
  `implementation_status` int(11) NOT NULL,
  `implementation_stage` text,
  `eu_cofinancing` int(4) DEFAULT NULL,
  `internal_responsibles` text,
  `internal_participants` text,
  `external_contractors` text,
  `costs` decimal(9, 2) DEFAULT NULL,
  `costs_argument` text,
  `costs_document` text,
  `financial_effects` text,
  `result` text NOT NULL,
  `report_type` varchar(30) NOT NULL,
  `public_report` int(11) NOT NULL,
  `transferred` int(11) NOT NULL,
  `estimated_savings` decimal(10, 4) DEFAULT NULL,
  `achieved_savings` decimal(10, 4) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__measure_ukrepi_an_sjus` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `measure_id` int(11) NOT NULL,
  `ukrepi_an_sju_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__measure_ukrepi_cilji` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `measure_id` int(11) NOT NULL,
  `ukrepi_cilj_id` int(11) NOT NULL
);

CREATE TABLE `measures__measure_ukrepi_viri` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `measure_id` int(11) NOT NULL,
  `ukrepi_vir_id` int(11) NOT NULL,
  `value` varchar(1000) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__measure_ukrepi_wb_areas` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `measure_id` int(11) NOT NULL,
  `ukrepi_wb_area_id` int(11) NOT NULL
);

CREATE TABLE `measures__measures` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  `sprejemljivost` int(1) NOT NULL DEFAULT "1",
  `pomembno` int(1) NOT NULL DEFAULT "0",
  `priority_rs` int(4) NOT NULL DEFAULT "0",
  `permanent` tinyint(1) NOT NULL,
  `area_id` int(11) NOT NULL,
  `naziv_ukrepa` text NOT NULL,
  `opis_ukrepa` text,
  `comment` text,
  `potencialni_prihranki` decimal(10, 2) DEFAULT NULL,
  `ukrepi_opzg_area_id` int(11) DEFAULT NULL,
  `deadline` date DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `confirmed` int(1) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `owner_id` int(11) DEFAULT NULL,
  `owner_type` varchar(20) DEFAULT NULL
);

CREATE TABLE `measures__objective_areas` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `objective_id` int(11) NOT NULL,
  `area_id` int(11) NOT NULL,
  `module_id` int(11) NOT NULL
);

CREATE TABLE `measures__objective_participants` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `app_module_id` int(11) NOT NULL,
  `objective_id` int(11) NOT NULL,
  `institution_id` int(11) NOT NULL
);

CREATE TABLE `measures__objective_responsible_users` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `app_module_id` int(11) NOT NULL,
  `objective_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__objective_responsibles` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `app_module_id` int(11) NOT NULL,
  `objective_id` int(11) NOT NULL,
  `institution_id` int(11) NOT NULL
);

CREATE TABLE `measures__participants` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `institution_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL
);

CREATE TABLE `measures__responsibles` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `institution_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL
);

CREATE TABLE `measures__smju_an_strategies` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `smju_an_strategy_category_id` int(11) NOT NULL,
  `number` varchar(20) DEFAULT NULL,
  `name` text NOT NULL,
  `key` varchar(30) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__smju_an_strategy_categories` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `key` varchar(30) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__smju_indicator_categories` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `key` varchar(10) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__smju_indicators` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `smju_indicator_category_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `key` varchar(5) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__smju_objective_an_strategies` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `objective_id` int(11) NOT NULL,
  `smju_an_strategy_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__smju_objective_inops` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `objective_id` int(11) NOT NULL,
  `smju_inop_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__smju_objective_internal_colaborators` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `objective_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__smju_objective_internal_participants` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `objective_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__smju_objective_mju_internal_participants` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `objective_id` int(11) NOT NULL,
  `smju_mju_internal_participant_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__smju_objective_objective_types` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `objective_id` int(11) NOT NULL,
  `smju_objective_type_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__smju_objective_sju_strategies` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `objective_id` int(11) NOT NULL,
  `smju_sju_strategy_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__smju_objective_zeps` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `objective_id` int(11) NOT NULL,
  `smju_zep_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__smju_objectives` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT "0",
  `owner_id` int(11) NOT NULL,
  `owner_type` varchar(20) NOT NULL,
  `lft` int(11) NOT NULL,
  `rght` int(11) NOT NULL,
  `status` varchar(20) NOT NULL,
  `status_date` date DEFAULT NULL,
  `progress` int(11) NOT NULL,
  `important` int(11) NOT NULL,
  `permanent` int(1) NOT NULL DEFAULT "0",
  `title` varchar(500) NOT NULL,
  `description` text NOT NULL,
  `priority` int(11) NOT NULL,
  `date_start` date DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `deadline` date DEFAULT NULL,
  `confirmed` tinyint(1) NOT NULL DEFAULT "0",
  `objective_type` int(4) NOT NULL,
  `final_state` text,
  `implementation_status` varchar(100) DEFAULT NULL,
  `implementation_stage` text,
  `eu_cofinancing` int(4) DEFAULT NULL,
  `internal_responsibles` text,
  `internal_participants` text,
  `external_contractors` text,
  `costs` decimal(9, 2) DEFAULT NULL,
  `costs_argument` text,
  `costs_document` text,
  `financial_effects` text,
  `type` varchar(20) DEFAULT NULL,
  `comment` text NOT NULL,
  `public_report` int(11) NOT NULL,
  `st` varchar(30) DEFAULT NULL,
  `st_st` varchar(30) DEFAULT NULL,
  `internal_collaborators` text,
  `mju_internal_participants` text,
  `termin_zacetka` date DEFAULT NULL,
  `termin_zakljucka` date DEFAULT NULL,
  `official_document` text,
  `expected_implementation_duration` text,
  `time_conditioning` text,
  `priority_estimate` text,
  `zep` varchar(155) DEFAULT NULL,
  `zep_termin_zacetka` date DEFAULT NULL,
  `rez_1a` varchar(255) DEFAULT NULL,
  `rez_2a` varchar(255) DEFAULT NULL,
  `rez_3d` date DEFAULT NULL,
  `extra1` varchar(255) DEFAULT NULL,
  `extra2` int(11) DEFAULT NULL,
  `inop_st_ukrepa` text,
  `inop_op` text,
  `inop_operacija` text,
  `inop_kazalniki_rezultata` text,
  `inop_kazalniki_ucinka` text,
  `inop_naziv_projekta` text,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__smju_sju_strategies` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `smju_sju_strategy_category_id` int(11) NOT NULL,
  `number` varchar(20) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `key` varchar(30) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__smju_sju_strategy_categories` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `key` varchar(30) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__status_confirmations` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `status_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_type` varchar(20) DEFAULT NULL,
  `confirmation_status` varchar(20) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__status_report_history` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `status_id` int(11) NOT NULL,
  `entity_period_status_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__status_reports` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `entity_id` int(11) NOT NULL,
  `entity_alias` varchar(50) NOT NULL,
  `entity_type` varchar(10) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `owner_type` varchar(20) NOT NULL,
  `period_id` int(11) NOT NULL,
  `status` varchar(10) NOT NULL,
  `priority` int(11) DEFAULT NULL,
  `description` text NOT NULL,
  `date` date NOT NULL,
  `date_published` datetime DEFAULT NULL,
  `confirmed` int(1) NOT NULL,
  `published` int(1) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__statuses` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `confirmed` int(1) NOT NULL DEFAULT "0",
  `published` tinyint(1) NOT NULL DEFAULT "0",
  `task_id` int(11) NOT NULL,
  `period_id` int(11) NOT NULL,
  `institution_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `status` varchar(50) NOT NULL,
  `opis_statusa` text NOT NULL,
  `measure_priority` int(11) DEFAULT NULL,
  `date` date NOT NULL,
  `date_published` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__task_impact_on_subjects` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `task_id` int(11) NOT NULL,
  `impact_on_subject_id` int(4) NOT NULL
);

CREATE TABLE `measures__task_participants` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `app_module_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL,
  `participant_id` int(11) NOT NULL,
  `participant_type` varchar(10) NOT NULL
);

CREATE TABLE `measures__task_responsibles` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `app_module_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL,
  `responsible_id` int(11) NOT NULL,
  `responsible_type` varchar(10) NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
);

CREATE TABLE `measures__task_ukrepi_an_sjus` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `task_id` int(11) NOT NULL,
  `ukrepi_an_sju_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `measures__tasks` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `enable_editing` int(1) NOT NULL,
  `sprejemljivost` int(1) NOT NULL DEFAULT "1",
  `sprememba_sprejemljivost_potrjena` int(1) NOT NULL DEFAULT "1",
  `opomba_sprejemljivosti` text NOT NULL,
  `measure_id` int(11) NOT NULL,
  `naziv_naloge` text NOT NULL,
  `opis_naloge` text NOT NULL,
  `zakonodaja` varchar(500) NOT NULL,
  `dodatna_pojasnila` text NOT NULL,
  `potencialni_prihranki` decimal(10, 2) DEFAULT NULL,
  `nacelo_sba` varchar(500) NOT NULL,
  `zahteve_slovenske_obrti` varchar(255) NOT NULL,
  `agenda_46` varchar(255) NOT NULL,
  `agenda_mg` varchar(255) NOT NULL,
  `trgovinska_zbornica` varchar(255) NOT NULL,
  `akt_za_mala_podjetja` varchar(255) NOT NULL,
  `ovire_za_tni` varchar(255) NOT NULL,
  `program_25` varchar(255) NOT NULL,
  `paket_ukrepov_za_spodbujanje_gospodatstva` varchar(255) NOT NULL,
  `obvladovanje_sive_ekonomije` varchar(255) NOT NULL,
  `kisik_za_gospodarstvo` varchar(255) NOT NULL,
  `pogodba_med_delom_in_kapitalom` varchar(255) NOT NULL,
  `rok_za_realizacijo` date NOT NULL,
  `stalna_naloga` int(11) NOT NULL,
  `status` varchar(50) NOT NULL,
  `datum_statusa` date NOT NULL,
  `priority` int(11) DEFAULT NULL,
  `priority_date` date DEFAULT NULL,
  `impact_on_subjects` text,
  `ukrepi_opzg_area_id` int(11) DEFAULT NULL,
  `confirmed` int(1) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `notifications__notifications` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `title` varchar(500) NOT NULL,
  `note` text,
  `from_name` varchar(250) NOT NULL,
  `reply_to_email` varchar(250) NOT NULL,
  `status` varchar(25) NOT NULL,
  `note_date` datetime NOT NULL,
  `received_date` datetime NOT NULL,
  `opened_date` datetime DEFAULT NULL
);

CREATE TABLE `periods__period_email_sent` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `period_email_id` int(11) NOT NULL,
  `recipient_email` varchar(100) NOT NULL,
  `date` datetime NOT NULL,
  `status` varchar(20) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `periods__period_emails` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `period_id` int(11) NOT NULL,
  `type` varchar(20) NOT NULL,
  `send_offset` int(11) NOT NULL,
  `periodic` varchar(20) NOT NULL,
  `repeat_period` int(11) NOT NULL,
  `status` varchar(20) NOT NULL,
  `sender_email` varchar(100) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

CREATE TABLE `periods__periods` (
  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `app_module` varchar(30) NOT NULL,
  `active` int(1) NOT NULL,
  `published` int(1) NOT NULL,
  `start` date NOT NULL,
  `end` date NOT NULL,
  `report_start` date NOT NULL,
  `report_end` date NOT NULL,
  `must_report_all` int(1) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
);

ALTER TABLE `measures__tasks` ADD FOREIGN KEY (`measure_id`) REFERENCES `measures__measures` (`id`);

ALTER TABLE `measures__measure_ukrepi_viri` ADD FOREIGN KEY (`measure_id`) REFERENCES `measures__measures` (`id`);

ALTER TABLE `measures__statuses` ADD FOREIGN KEY (`task_id`) REFERENCES `measures__tasks` (`id`);

ALTER TABLE `measures__statuses` ADD FOREIGN KEY (`period_id`) REFERENCES `periods__periods` (`id`);

ALTER TABLE `measures__task_impact_on_subjects` ADD FOREIGN KEY (`task_id`) REFERENCES `measures__tasks` (`id`);

ALTER TABLE `measures__participants` ADD FOREIGN KEY (`task_id`) REFERENCES `measures__tasks` (`id`);

ALTER TABLE `measures__participants` ADD FOREIGN KEY (`institution_id`) REFERENCES `institutions__institutions` (`id`);

ALTER TABLE `measures__statuses` ADD FOREIGN KEY (`institution_id`) REFERENCES `institutions__institutions` (`id`);

ALTER TABLE `measures__task_ukrepi_an_sjus` ADD FOREIGN KEY (`task_id`) REFERENCES `measures__tasks` (`id`);

ALTER TABLE `measures__measure_ukrepi_cilji` ADD FOREIGN KEY (`measure_id`) REFERENCES `measures__measures` (`id`);

ALTER TABLE `areas__area_app_modules` ADD FOREIGN KEY (`app_module_id`) REFERENCES `app_modules__app_modules` (`id`);

ALTER TABLE `areas__area_app_modules` ADD FOREIGN KEY (`area_id`) REFERENCES `areas__areas` (`id`);

ALTER TABLE `balthazar__attribute_options` ADD FOREIGN KEY (`attribute_id`) REFERENCES `balthazar__attributes` (`id`);

ALTER TABLE `measures__statuses` ADD FOREIGN KEY (`user_id`) REFERENCES `front_users__users` (`id`);

ALTER TABLE `front_users__users` ADD FOREIGN KEY (`institution_id`) REFERENCES `institutions__institutions` (`id`);

ALTER TABLE `measures__responsibles` ADD FOREIGN KEY (`task_id`) REFERENCES `measures__tasks` (`id`);

ALTER TABLE `measures__responsibles` ADD FOREIGN KEY (`institution_id`) REFERENCES `institutions__institutions` (`id`);

ALTER TABLE `measures__measure_ukrepi_an_sjus` ADD FOREIGN KEY (`measure_id`) REFERENCES `measures__measures` (`id`);

ALTER TABLE `institutions__institution_app_modules` ADD FOREIGN KEY (`institution_id`) REFERENCES `institutions__institutions` (`id`);

ALTER TABLE `institutions__institution_app_modules` ADD FOREIGN KEY (`app_module_id`) REFERENCES `app_modules__app_modules` (`id`);

ALTER TABLE `institutions__institution_contacts` ADD FOREIGN KEY (`institution_id`) REFERENCES `institutions__institutions` (`id`);

ALTER TABLE `institutions__institution_contacts` ADD FOREIGN KEY (`user_id`) REFERENCES `front_users__users` (`id`);

ALTER TABLE `institutions__institution_contact_app_modules` ADD FOREIGN KEY (`institution_contact_id`) REFERENCES `institutions__institution_contacts` (`id`);

ALTER TABLE `institutions__institution_contact_app_modules` ADD FOREIGN KEY (`app_module_id`) REFERENCES `app_modules__app_modules` (`id`);

ALTER TABLE `institutions__institution_types` ADD FOREIGN KEY (`id`) REFERENCES `institutions__institutions` (`institution_type_id`);

ALTER TABLE `legislations__administrative_activities` ADD FOREIGN KEY (`aa_type_id`) REFERENCES `codes__aa_types` (`id`);

ALTER TABLE `legislations__administrative_activities_deletes` ADD FOREIGN KEY (`aa_type_id`) REFERENCES `codes__aa_types` (`id`);

ALTER TABLE `legislations__administrative_activities_revs` ADD FOREIGN KEY (`aa_type_id`) REFERENCES `codes__aa_types` (`id`);

ALTER TABLE `comments__comments` ADD FOREIGN KEY (`comment_category_id`) REFERENCES `codes__comment_categories` (`id`);

ALTER TABLE `comments__practises` ADD FOREIGN KEY (`comment_category_id`) REFERENCES `codes__comment_categories` (`id`);

ALTER TABLE `legislations__administrative_activities` ADD FOREIGN KEY (`hourly_rate_id`) REFERENCES `codes__hourly_rates` (`id`);

ALTER TABLE `legislations__administrative_activities_deletes` ADD FOREIGN KEY (`hourly_rate_id`) REFERENCES `codes__hourly_rates` (`id`);

ALTER TABLE `legislations__administrative_activities_revs` ADD FOREIGN KEY (`hourly_rate_id`) REFERENCES `codes__hourly_rates` (`id`);

ALTER TABLE `measures__task_impact_on_subjects` ADD FOREIGN KEY (`impact_on_subject_id`) REFERENCES `codes__impact_on_subjects` (`id`);

ALTER TABLE `legislations__information_obligations` ADD FOREIGN KEY (`io_type_id`) REFERENCES `codes__io_types` (`id`);

ALTER TABLE `legislations__information_obligations_deletes` ADD FOREIGN KEY (`io_type_id`) REFERENCES `codes__io_types` (`id`);

ALTER TABLE `legislations__information_obligations_revs` ADD FOREIGN KEY (`io_type_id`) REFERENCES `codes__io_types` (`id`);

ALTER TABLE `codes__hourly_rates` ADD FOREIGN KEY (`legal_subject_id`) REFERENCES `codes__legal_subjects` (`id`);

ALTER TABLE `legislations__information_obligations` ADD FOREIGN KEY (`life_event_id`) REFERENCES `codes__life_events` (`id`);

ALTER TABLE `legislations__information_obligations_deletes` ADD FOREIGN KEY (`life_event_id`) REFERENCES `codes__life_events` (`id`);

ALTER TABLE `legislations__information_obligations_revs` ADD FOREIGN KEY (`life_event_id`) REFERENCES `codes__life_events` (`id`);

ALTER TABLE `comments__comments` ADD FOREIGN KEY (`priority_area_id`) REFERENCES `codes__priority_areas` (`id`);

ALTER TABLE `comments__practises` ADD FOREIGN KEY (`priority_area_id`) REFERENCES `codes__priority_areas` (`id`);

ALTER TABLE `legislations__legislations` ADD FOREIGN KEY (`priority_area_id`) REFERENCES `codes__priority_areas` (`id`);

ALTER TABLE `legislations__legislations_deletes` ADD FOREIGN KEY (`priority_area_id`) REFERENCES `codes__priority_areas` (`id`);

ALTER TABLE `legislations__legislations_revs` ADD FOREIGN KEY (`priority_area_id`) REFERENCES `codes__priority_areas` (`id`);

ALTER TABLE `legislations__sublegislation_acts` ADD FOREIGN KEY (`priority_area_id`) REFERENCES `codes__priority_areas` (`id`);

ALTER TABLE `legislations__sublegislation_acts_deletes` ADD FOREIGN KEY (`priority_area_id`) REFERENCES `codes__priority_areas` (`id`);

ALTER TABLE `legislations__sublegislation_acts_revs` ADD FOREIGN KEY (`priority_area_id`) REFERENCES `codes__priority_areas` (`id`);

ALTER TABLE `legislations__information_obligations` ADD FOREIGN KEY (`regulation_category_id`) REFERENCES `codes__regulation_categories` (`id`);

ALTER TABLE `legislations__information_obligations_deletes` ADD FOREIGN KEY (`regulation_category_id`) REFERENCES `codes__regulation_categories` (`id`);

ALTER TABLE `legislations__information_obligations_revs` ADD FOREIGN KEY (`regulation_category_id`) REFERENCES `codes__regulation_categories` (`id`);

ALTER TABLE `codes__smju_inops` ADD FOREIGN KEY (`smju_inop_category_id`) REFERENCES `codes__smju_inop_categories` (`id`);

ALTER TABLE `measures__smju_objective_inops` ADD FOREIGN KEY (`smju_inop_id`) REFERENCES `codes__smju_inops` (`id`);

ALTER TABLE `measures__smju_objective_mju_internal_participants` ADD FOREIGN KEY (`smju_mju_internal_participant_id`) REFERENCES `codes__smju_mju_internal_participants` (`id`);

ALTER TABLE `measures__smju_objective_zeps` ADD FOREIGN KEY (`smju_zep_id`) REFERENCES `codes__smju_zeps` (`id`);

ALTER TABLE `measures__coordinator_ukrepi_an_sjus` ADD FOREIGN KEY (`ukrepi_an_sju_id`) REFERENCES `codes__ukrepi_an_sjus` (`id`);

ALTER TABLE `measures__measure_ukrepi_an_sjus` ADD FOREIGN KEY (`ukrepi_an_sju_id`) REFERENCES `codes__ukrepi_an_sjus` (`id`);

ALTER TABLE `measures__task_ukrepi_an_sjus` ADD FOREIGN KEY (`ukrepi_an_sju_id`) REFERENCES `codes__ukrepi_an_sjus` (`id`);

ALTER TABLE `measures__measure_ukrepi_cilji` ADD FOREIGN KEY (`ukrepi_cilj_id`) REFERENCES `codes__ukrepi_cilji` (`id`);

ALTER TABLE `measures__coordinator_ukrepi_opzg_areas` ADD FOREIGN KEY (`ukrepi_opzg_area_id`) REFERENCES `codes__ukrepi_opzg_areas` (`id`);

ALTER TABLE `measures__measures` ADD FOREIGN KEY (`ukrepi_opzg_area_id`) REFERENCES `codes__ukrepi_opzg_areas` (`id`);

ALTER TABLE `measures__tasks` ADD FOREIGN KEY (`ukrepi_opzg_area_id`) REFERENCES `codes__ukrepi_opzg_areas` (`id`);

ALTER TABLE `measures__measure_ukrepi_viri` ADD FOREIGN KEY (`ukrepi_vir_id`) REFERENCES `codes__ukrepi_viri` (`id`);

ALTER TABLE `measures__measure_ukrepi_wb_areas` ADD FOREIGN KEY (`ukrepi_wb_area_id`) REFERENCES `codes__ukrepi_wb_areas` (`id`);

CREATE UNIQUE INDEX `apikey_indx` ON `api__users` (`api_key`);

CREATE UNIQUE INDEX `username_indx` ON `api__users` (`username`);

CREATE UNIQUE INDEX `module` ON `app_modules__app_modules` (`module`);

CREATE INDEX `app` ON `application_states__application_states` (`app`);

CREATE UNIQUE INDEX `area_id` ON `areas__area_app_modules` (`area_id`, `app_module_id`);

CREATE INDEX `rule_key` ON `attribute_rules__attribute_rules` (`rule_key`);

CREATE INDEX `parent_indx` ON `balthazar__acos` (`parent_id`);

CREATE INDEX `alias_indx` ON `balthazar__acos` (`alias`);

CREATE INDEX `model_foreign_key_indx` ON `balthazar__acos` (`model`, `foreign_key`);

CREATE INDEX `lft_right_indx` ON `balthazar__acos` (`lft`, `rght`);

CREATE INDEX `parent_indx` ON `balthazar__aros` (`parent_id`);

CREATE INDEX `alias_indx` ON `balthazar__aros` (`alias`);

CREATE INDEX `model_foreign_key_indx` ON `balthazar__aros` (`model`, `foreign_key`);

CREATE INDEX `lft_right_indx` ON `balthazar__aros` (`lft`, `rght`);

CREATE UNIQUE INDEX `ARO_ACO_KEY` ON `balthazar__aros_acos` (`aro_id`, `aco_id`);

CREATE UNIQUE INDEX `attribute_group_indx` ON `balthazar__attribute_group_items` (`attribute_group_id`, `attribute_id`);

CREATE INDEX `model` ON `balthazar__attribute_groups` (`model`);

CREATE INDEX `status` ON `balthazar__attribute_groups` (`status`);

CREATE INDEX `domain_id` ON `balthazar__attribute_groups` (`domain_id`);

CREATE INDEX `key` ON `balthazar__attribute_groups` (`key`);

CREATE INDEX `subtype` ON `balthazar__attribute_groups` (`subtype`);

CREATE INDEX `subtype_model` ON `balthazar__attribute_groups` (`model`, `subtype`);

CREATE INDEX `locale` ON `balthazar__attribute_groups_i18n` (`locale`);

CREATE INDEX `model` ON `balthazar__attribute_groups_i18n` (`model`);

CREATE INDEX `row_id` ON `balthazar__attribute_groups_i18n` (`foreign_key`);

CREATE INDEX `field` ON `balthazar__attribute_groups_i18n` (`field`);

CREATE INDEX `att_indx` ON `balthazar__attribute_options` (`attribute_id`);

CREATE INDEX `locale` ON `balthazar__attribute_options_i18n` (`locale`);

CREATE INDEX `model` ON `balthazar__attribute_options_i18n` (`model`);

CREATE INDEX `row_id` ON `balthazar__attribute_options_i18n` (`foreign_key`);

CREATE INDEX `field` ON `balthazar__attribute_options_i18n` (`field`);

CREATE INDEX `key` ON `balthazar__attributes` (`key`);

CREATE INDEX `status` ON `balthazar__attributes` (`status`);

CREATE INDEX `locale` ON `balthazar__attributes_i18n` (`locale`);

CREATE INDEX `model` ON `balthazar__attributes_i18n` (`model`);

CREATE INDEX `row_id` ON `balthazar__attributes_i18n` (`foreign_key`);

CREATE INDEX `field` ON `balthazar__attributes_i18n` (`field`);

CREATE INDEX `status_indx` ON `balthazar__countries` (`status`);

CREATE INDEX `sort_name_indx` ON `balthazar__countries` (`sort_name`);

CREATE INDEX `iso2_indx` ON `balthazar__countries` (`iso2`);

CREATE INDEX `country_id` ON `balthazar__country_ip_ranges` (`country_id`);

CREATE INDEX `IpIndex` ON `balthazar__country_ip_ranges` (`ip_from`, `ip_to`);

CREATE INDEX `indx_country` ON `balthazar__country_states` (`country_id`);

CREATE INDEX `action_indx` ON `balthazar__file_action_items` (`file_action_id`);

CREATE UNIQUE INDEX `key_uniq` ON `balthazar__file_actions` (`key`);

CREATE UNIQUE INDEX `uniq` ON `balthazar__file_restriction_sources` (`field`, `file_restriction_id`, `model`, `foreign_id`);

CREATE UNIQUE INDEX `uniq` ON `balthazar__file_restrictions` (`file_id`, `type`, `app`, `model`, `foreign_id`);

CREATE INDEX `indx` ON `balthazar__file_restrictions` (`file_id`);

CREATE UNIQUE INDEX `key_uniq` ON `balthazar__file_types` (`key`);

CREATE INDEX `model_indx` ON `balthazar__file_types` (`model`);

CREATE INDEX `file_indx` ON `balthazar__files` (`filename`);

CREATE INDEX `path_indx` ON `balthazar__files` (`path`);

CREATE UNIQUE INDEX `uniq` ON `balthazar__files_aros_acos` (`aro_id`, `file_id`);

CREATE UNIQUE INDEX `model_nmspace` ON `balthazar__model_keys` (`model`, `namespace`);

CREATE INDEX `sent_email_indx` ON `balthazar__sent_email_attributes` (`sent_email_id`);

CREATE INDEX `name` ON `balthazar__sent_email_attributes` (`key`);

CREATE INDEX `key` ON `balthazar__sent_email_attributes` (`key`);

CREATE INDEX `msg_id_indx` ON `balthazar__sent_emails` (`msg_id`);

CREATE INDEX `email_id_indx` ON `balthazar__sent_emails` (`email_id`);

CREATE INDEX `app` ON `balthazar__sent_emails` (`app`);

CREATE UNIQUE INDEX `key_unq` ON `balthazar__settings` (`key`);

CREATE INDEX `domain_id` ON `balthazar__urls` (`domain_id`);

CREATE INDEX `indx_user` ON `balthazar__user_activities` (`user_id`);

CREATE UNIQUE INDEX `user_session` ON `balthazar__user_sessions` (`user_id`, `app`, `session_id`);

CREATE INDEX `active_sessions` ON `balthazar__user_sessions` (`expires`);

CREATE INDEX `session_id` ON `balthazar__user_sessions` (`session_id`);

CREATE INDEX `valid_session` ON `balthazar__user_sessions` (`session_id`, `expires`);

CREATE INDEX `app_active_sessions` ON `balthazar__user_sessions` (`app`, `expires`);

CREATE INDEX `user_id` ON `balthazar__user_sessions` (`user_id`);

CREATE INDEX `token` ON `balthazar__user_sessions` (`token`);

CREATE INDEX `expires` ON `balthazar__user_sessions` (`expires`);

CREATE INDEX `app` ON `balthazar__user_sessions` (`app`);

CREATE UNIQUE INDEX `UNQ_email` ON `balthazar__users` (`email`);

CREATE INDEX `FK_admin_groups` ON `balthazar__users` (`group_id`);

CREATE INDEX `admin_user_code_indx` ON `balthazar__users` (`code`);

CREATE INDEX `admin_user_nickname_indx` ON `balthazar__users` (`nickname`);

CREATE UNIQUE INDEX `apikey_indx` ON `clients__api_users` (`api_key`);

CREATE UNIQUE INDEX `username_indx` ON `clients__api_users` (`username`);

CREATE UNIQUE INDEX `uniq_code` ON `clients__clients` (`code`);

CREATE INDEX `domain` ON `clients__clients` (`domain`);

CREATE UNIQUE INDEX `comment_user_id` ON `comments__comment_responsibles` (`comment_id`, `user_id`);

CREATE INDEX `model` ON `form_help__form_help` (`model_alias`, `field`);

CREATE INDEX `model_key` ON `form_help__form_help` (`model_alias`, `field`, `key`);

CREATE UNIQUE INDEX `uniq` ON `form_help__form_help_params` (`form_help_id`, `key`);

CREATE UNIQUE INDEX `institution_id` ON `institutions__institution_app_modules` (`institution_id`, `app_module_id`);

CREATE UNIQUE INDEX `institution_contact_id` ON `institutions__institution_contact_app_modules` (`institution_contact_id`, `app_module_id`);

CREATE INDEX `io_indx` ON `legislations__administrative_activities` (`information_obligation_id`);

CREATE INDEX `aa_type_indx` ON `legislations__administrative_activities` (`aa_type_id`);

CREATE INDEX `hourly_rate_indx` ON `legislations__administrative_activities` (`hourly_rate_id`);

CREATE INDEX `indx_created` ON `legislations__administrative_activities` (`created`);

CREATE INDEX `io_indx` ON `legislations__administrative_activities_deletes` (`information_obligation_id`);

CREATE INDEX `aa_type_indx` ON `legislations__administrative_activities_deletes` (`aa_type_id`);

CREATE INDEX `hourly_rate_indx` ON `legislations__administrative_activities_deletes` (`hourly_rate_id`);

CREATE INDEX `id_rev_indx` ON `legislations__administrative_activities_deletes` (`id`, `revision_id`);

CREATE INDEX `io_indx` ON `legislations__administrative_activities_revs` (`information_obligation_id`);

CREATE INDEX `aa_type_indx` ON `legislations__administrative_activities_revs` (`aa_type_id`);

CREATE INDEX `hourly_rate_indx` ON `legislations__administrative_activities_revs` (`hourly_rate_id`);

CREATE INDEX `id_rev_indx` ON `legislations__administrative_activities_revs` (`id`, `revision_id`);

CREATE INDEX `subact_indx` ON `legislations__information_obligations` (`sublegislation_act_id`);

CREATE INDEX `io_type_indx` ON `legislations__information_obligations` (`io_type_id`);

CREATE INDEX `regcat_indx` ON `legislations__information_obligations` (`regulation_category_id`);

CREATE INDEX `legislation_indx` ON `legislations__information_obligations` (`legislation_id`);

CREATE INDEX `life_indx` ON `legislations__information_obligations` (`life_event_id`);

CREATE INDEX `indx_created` ON `legislations__information_obligations` (`created`);

CREATE INDEX `subact_indx` ON `legislations__information_obligations_deletes` (`sublegislation_act_id`);

CREATE INDEX `io_type_indx` ON `legislations__information_obligations_deletes` (`io_type_id`);

CREATE INDEX `regcat_indx` ON `legislations__information_obligations_deletes` (`regulation_category_id`);

CREATE INDEX `legislation_indx` ON `legislations__information_obligations_deletes` (`legislation_id`);

CREATE INDEX `life_indx` ON `legislations__information_obligations_deletes` (`life_event_id`);

CREATE INDEX `id_rev_indx` ON `legislations__information_obligations_deletes` (`id`, `revision_id`);

CREATE INDEX `subact_indx` ON `legislations__information_obligations_revs` (`sublegislation_act_id`);

CREATE INDEX `io_type_indx` ON `legislations__information_obligations_revs` (`io_type_id`);

CREATE INDEX `regcat_indx` ON `legislations__information_obligations_revs` (`regulation_category_id`);

CREATE INDEX `legislation_indx` ON `legislations__information_obligations_revs` (`legislation_id`);

CREATE INDEX `life_indx` ON `legislations__information_obligations_revs` (`life_event_id`);

CREATE INDEX `id_rev_indx` ON `legislations__information_obligations_revs` (`id`, `revision_id`);

CREATE INDEX `ministry_indx` ON `legislations__legislations` (`ministry_id`);

CREATE INDEX `prio_indx` ON `legislations__legislations` (`priority_area_id`);

CREATE INDEX `institution_id` ON `legislations__legislations` (`institution_id`);

CREATE INDEX `ministry_indx` ON `legislations__legislations_deletes` (`ministry_id`);

CREATE INDEX `prio_indx` ON `legislations__legislations_deletes` (`priority_area_id`);

CREATE INDEX `id_rev_indx` ON `legislations__legislations_deletes` (`id`, `revision_id`);

CREATE INDEX `institution_id` ON `legislations__legislations_deletes` (`institution_id`);

CREATE INDEX `ministry_indx` ON `legislations__legislations_revs` (`ministry_id`);

CREATE INDEX `prio_indx` ON `legislations__legislations_revs` (`priority_area_id`);

CREATE INDEX `id_rev_indx` ON `legislations__legislations_revs` (`id`, `revision_id`);

CREATE INDEX `institution_id` ON `legislations__legislations_revs` (`institution_id`);

CREATE INDEX `legislation_indx` ON `legislations__sublegislation_acts` (`legislation_id`);

CREATE INDEX `ministry_indx` ON `legislations__sublegislation_acts` (`ministry_id`);

CREATE INDEX `prio_indx` ON `legislations__sublegislation_acts` (`priority_area_id`);

CREATE INDEX `legislation_indx` ON `legislations__sublegislation_acts_deletes` (`legislation_id`);

CREATE INDEX `ministry_indx` ON `legislations__sublegislation_acts_deletes` (`ministry_id`);

CREATE INDEX `prio_indx` ON `legislations__sublegislation_acts_deletes` (`priority_area_id`);

CREATE INDEX `id_rev_indx` ON `legislations__sublegislation_acts_deletes` (`id`, `revision_id`);

CREATE INDEX `institution_id` ON `legislations__sublegislation_acts_deletes` (`institution_id`);

CREATE INDEX `legislation_indx` ON `legislations__sublegislation_acts_revs` (`legislation_id`);

CREATE INDEX `ministry_indx` ON `legislations__sublegislation_acts_revs` (`ministry_id`);

CREATE INDEX `prio_indx` ON `legislations__sublegislation_acts_revs` (`priority_area_id`);

CREATE INDEX `id_rev_indx` ON `legislations__sublegislation_acts_revs` (`id`, `revision_id`);

CREATE UNIQUE INDEX `date` ON `locales__holidays` (`date`);

CREATE INDEX `domain_id` ON `locales__holidays` (`domain_id`);

CREATE UNIQUE INDEX `app_module_id` ON `measures__activity_participants` (`app_module_id`, `activity_id`, `participant_id`, `participant_type`);

CREATE UNIQUE INDEX `app_module_id` ON `measures__activity_responsibles` (`app_module_id`, `activity_id`, `responsible_id`, `responsible_type`);

CREATE UNIQUE INDEX `front_user_id` ON `measures__coordinator_institutions` (`front_user_id`, `institution_id`);

CREATE UNIQUE INDEX `front_user_id` ON `measures__coordinator_ukrepi_an_sjus` (`front_user_id`, `ukrepi_an_sju_id`);

CREATE UNIQUE INDEX `front_user_id` ON `measures__coordinator_ukrepi_opzg_areas` (`front_user_id`, `ukrepi_opzg_area_id`);

CREATE UNIQUE INDEX `measure_id` ON `measures__measure_ukrepi_an_sjus` (`measure_id`, `ukrepi_an_sju_id`);

CREATE UNIQUE INDEX `measure_id` ON `measures__measure_ukrepi_cilji` (`measure_id`, `ukrepi_cilj_id`);

CREATE UNIQUE INDEX `measure_id` ON `measures__measure_ukrepi_wb_areas` (`measure_id`, `ukrepi_wb_area_id`);

CREATE UNIQUE INDEX `objective_id` ON `measures__objective_areas` (`objective_id`, `area_id`, `module_id`);

CREATE UNIQUE INDEX `app_module_id` ON `measures__objective_participants` (`app_module_id`, `objective_id`, `institution_id`);

CREATE UNIQUE INDEX `app_module_id` ON `measures__objective_responsible_users` (`app_module_id`, `objective_id`, `user_id`);

CREATE UNIQUE INDEX `app_module_id` ON `measures__objective_responsibles` (`app_module_id`, `objective_id`, `institution_id`);

CREATE UNIQUE INDEX `institution_id` ON `measures__participants` (`institution_id`, `task_id`);

CREATE UNIQUE INDEX `institution_id` ON `measures__responsibles` (`institution_id`, `task_id`);

CREATE UNIQUE INDEX `task_id` ON `measures__task_impact_on_subjects` (`task_id`, `impact_on_subject_id`);

CREATE UNIQUE INDEX `app_module_id` ON `measures__task_participants` (`app_module_id`, `task_id`, `participant_id`, `participant_type`);

CREATE UNIQUE INDEX `app_module_id` ON `measures__task_responsibles` (`app_module_id`, `task_id`, `responsible_id`, `responsible_type`);

CREATE UNIQUE INDEX `measure_id` ON `measures__task_ukrepi_an_sjus` (`task_id`, `ukrepi_an_sju_id`);