11:46:03	CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_explanation` (   `m_explanationID` INT(11) NOT NULL AUTO_INCREMENT,   `m_type` VARCHAR(45) NULL COMMENT 'possible values' /* comment truncated */ /*table field webpage */,   `m_sourceID` INT(11) NULL,   `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,   UNIQUE INDEX `m_source_typeUQ` (`m_type` ASC, `m_sourceID` ASC),   PRIMARY KEY (`m_explanationID`),   CONSTRAINT `fk_m_explanation_mm_string_type1`     FOREIGN KEY (`m_type`)     REFERENCES `ezbuildrental`.`mm_string_type` (`mm_type`)     ON DELETE NO ACTION     ON UPDATE NO ACTION) ENGINE = InnoDB	Error Code: 1005. Can't create table 'ezbuildrental.m_explanation' (errno: 150)	0.015 sec
11:46:03	CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_stringez` (   `m_stringezID` INT(11) NOT NULL AUTO_INCREMENT,   `m_sourceID` INT(11) NOT NULL,   `m_type` VARCHAR(45) NOT NULL COMMENT 'table_name,' /* comment truncated */ /*item_name, itemgroup tooltip webpage_title label */,   `udpated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,   PRIMARY KEY (`m_stringezID`),   UNIQUE INDEX `sourceID_m_type` (`m_sourceID` ASC, `m_type` ASC),   INDEX `fk_m_stringez_mm_string_type1_idx` (`m_type` ASC),   CONSTRAINT `fk_m_stringez_m_webpage1`     FOREIGN KEY (`m_sourceID`)     REFERENCES `ezbuildrental`.`m_webpage` (`m_webpageID`)     ON DELETE NO ACTION     ON UPDATE NO ACTION,   CONSTRAINT `fk_m_stringez_m_table1`     FOREIGN KEY (`m_sourceID`)     REFERENCES `ezbuildrental`.`m_table` (`m_tableID`)     ON DELETE NO ACTION     ON UPDATE NO ACTION,   CONSTRAINT `fk_m_stringez_mm_string_type1`     FOREIGN KEY (`m_type`)     REFERENCES `ezbuildrental`.`mm_string_type` (`mm_type`)     ON DELETE NO ACTION     ON UPDATE NO ACTION) ENGINE = InnoDB	Error Code: 1005. Can't create table 'ezbuildrental.m_stringez' (errno: 150)	0.015 sec

SET FOREIGN_KEY_CHECKS=0;
use ezbuildrental;

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
-- -----------------------------------------------------
-- Schema ezbuildrental
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `ezbuildrental` DEFAULT CHARACTER SET utf8 ;
USE `ezbuildrental` ;

-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_code`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_code` (
  `m_codeID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_code` MEDIUMTEXT NULL DEFAULT NULL,
  `m_javascript` INT(4) NULL DEFAULT '0' COMMENT '1 = js code',
  `m_php` INT(4) NULL DEFAULT '0' COMMENT '1 = phpcode',
  `m_include` INT(4) NULL DEFAULT NULL,
  `m_path` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`m_codeID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`mm_string_type`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`mm_string_type` (
  `mm_string_typeID` INT(11) NOT NULL AUTO_INCREMENT,
  `mm_type` VARCHAR(45) NULL COMMENT 'webpage_title' /* comment truncated */ /*webpage_explanation
field_label
table_name*/,
  PRIMARY KEY (`mm_string_typeID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_explanation`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_explanation` (
  `m_explanationID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_type` VARCHAR(45) NULL COMMENT 'possible values' /* comment truncated */ /*table
field
webpage
*/,
  `m_sourceID` INT(11) NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE INDEX `m_source_typeUQ` (`m_type` ASC, `m_sourceID` ASC),
  PRIMARY KEY (`m_explanationID`),
  CONSTRAINT `fk_m_explanation_mm_string_type1`
    FOREIGN KEY (`m_type`)
    REFERENCES `ezbuildrental`.`mm_string_type` (`mm_type`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_table`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_table` (
  `m_tableID` INT(11) NOT NULL,
  `m_prefix` VARCHAR(3) NULL DEFAULT NULL,
  `name` VARCHAR(255) NULL DEFAULT NULL COMMENT 'mnemonic This string is translated using m_stringez',
  `is_view` TINYINT(4) NULL,
  `is_masterdata` TINYINT(4) NULL DEFAULT 0,
  `is_hierarchical` TINYINT(4) NULL,
  `is_relationtable` TINYINT(4) NULL,
  `unique_column` MEDIUMTEXT NULL COMMENT 'used for tables with history where column must be unique',
  `history` TINYINT(4) NULL COMMENT 'Does the table contains history?',
  `history_done` TINYINT(4) NULL COMMENT 'Is history implemented',
  `description` MEDIUMTEXT NULL COMMENT 'Meaning and purpose of the described table. A bit similar like explanation but explanation is for the user and this field is for the modeller.',
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  CONSTRAINT `fk_m_table_m_explanation1`
    FOREIGN KEY (`m_tableID`)
    REFERENCES `ezbuildrental`.`m_explanation` (`m_sourceID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 22
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`mm_fieldtype`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`mm_fieldtype` (
  `mm_fieldtypeID` INT(11) NOT NULL AUTO_INCREMENT,
  `mm_name` VARCHAR(255) NULL DEFAULT NULL COMMENT 'possible values' /* comment truncated */ /*varchar
tinytint
int
mediumtext
longtext
blob*/,
  PRIMARY KEY (`mm_fieldtypeID`))
ENGINE = InnoDB
AUTO_INCREMENT = 13
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_logical_fieldtype`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_logical_fieldtype` (
  `m_logical_fieldtypeID` INT(11) NOT NULL AUTO_INCREMENT,
  `mm_name` VARCHAR(255) NULL DEFAULT NULL,
  `mask` VARCHAR(255) NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_logical_fieldtypeID`))
ENGINE = InnoDB
AUTO_INCREMENT = 337
DEFAULT CHARACTER SET = utf8
COMMENT = 'Meta meta information';


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_webpage_html_header`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_webpage_html_header` (
  `m_webpage_html_headerID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_name` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`m_webpage_html_headerID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_webpage`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_webpage` (
  `m_webpageID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_description` VARCHAR(255) NULL DEFAULT NULL,
  `m_helpID` INT(11) NULL DEFAULT NULL,
  `m_encoding` INT(4) NULL DEFAULT NULL COMMENT '1=utf',
  `m_webpage_titeID` INT(11) NULL DEFAULT NULL COMMENT 'pointer to m_string',
  `m_templete` VARCHAR(255) NULL,
  `js_code` MEDIUMTEXT NULL,
  `m_mnemonic` VARCHAR(35) NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_webpageID`),
  UNIQUE INDEX `m_mnemonic_UNIQUE` (`m_mnemonic` ASC),
  CONSTRAINT `fk_m_webpage_m_webpage_html_header1`
    FOREIGN KEY (`m_webpageID`)
    REFERENCES `ezbuildrental`.`m_webpage_html_header` (`m_webpage_html_headerID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_webpage_m_explanation1`
    FOREIGN KEY (`m_webpageID`)
    REFERENCES `ezbuildrental`.`m_explanation` (`m_sourceID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_stringez`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_stringez` (
  `m_stringezID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_sourceID` INT(11) NOT NULL,
  `m_type` VARCHAR(45) NOT NULL COMMENT 'table_name,' /* comment truncated */ /*item_name,
itemgroup
tooltip
webpage_title
label
*/,
  `udpated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_stringezID`),
  UNIQUE INDEX `sourceID_m_type` (`m_sourceID` ASC, `m_type` ASC),
  INDEX `fk_m_stringez_mm_string_type1_idx` (`m_type` ASC),
  CONSTRAINT `fk_m_stringez_m_webpage1`
    FOREIGN KEY (`m_sourceID`)
    REFERENCES `ezbuildrental`.`m_webpage` (`m_webpageID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_stringez_m_table1`
    FOREIGN KEY (`m_sourceID`)
    REFERENCES `ezbuildrental`.`m_table` (`m_tableID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_stringez_mm_string_type1`
    FOREIGN KEY (`m_type`)
    REFERENCES `ezbuildrental`.`mm_string_type` (`mm_type`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_field`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_field` (
  `m_fieldID` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL COMMENT 'This string is translated using m_stringez',
  `m_decimals` TINYINT(4) NULL DEFAULT NULL,
  `m_description` VARCHAR(255) NULL DEFAULT NULL,
  `mm_fieldtypeID` INT(11) NULL DEFAULT NULL,
  `m_length` INT(4) NULL DEFAULT NULL,
  `m_logical_fieldtypeID` INT(11) NULL,
  `m_prefix` VARCHAR(5) NULL,
  `m_postfix` VARCHAR(5) NULL,
  `m_remark` VARCHAR(255) NULL DEFAULT NULL,
  `min` FLOAT NULL,
  `max` FLOAT NULL,
  `description` MEDIUMTEXT NULL COMMENT 'Remarks for the designer',
  `target_data_mustbe_translated` TINYINT(4) NULL DEFAULT 0,
  `key_sequence` TINYINT(4) NULL DEFAULT 0 COMMENT 'If part of the key number must be filled',
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  INDEX `fk_m_item_mm_fieldtype1_idx` (`mm_fieldtypeID` ASC),
  INDEX `fk_m_item_mm_logical_fieldtype1_idx` (`m_logical_fieldtypeID` ASC),
  UNIQUE INDEX `m_mnemonic_UNIQUE` (`name` ASC),
  CONSTRAINT `fk_m_item_mm_fieldtype1`
    FOREIGN KEY (`mm_fieldtypeID`)
    REFERENCES `ezbuildrental`.`mm_fieldtype` (`mm_fieldtypeID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_item_mm_logical_fieldtype1`
    FOREIGN KEY (`m_logical_fieldtypeID`)
    REFERENCES `ezbuildrental`.`m_logical_fieldtype` (`m_logical_fieldtypeID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_field_m_stringez1`
    FOREIGN KEY (`m_fieldID`)
    REFERENCES `ezbuildrental`.`m_stringez` (`m_sourceID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_field_m_explanation1`
    FOREIGN KEY (`m_fieldID`)
    REFERENCES `ezbuildrental`.`m_explanation` (`m_sourceID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 327
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_relation`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_relation` (
  `m_relationID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_tableID` INT(11) NOT NULL COMMENT 'The number of the relation table',
  `table1ID` INT(11) NOT NULL COMMENT 'Pointer to m_table',
  `m_item1ID` INT(11) NOT NULL,
  `table2ID` INT(11) NOT NULL COMMENT 'Pointer to m_table',
  `m_item2ID` INT(11) NOT NULL,
  `cardinality` ENUM('1:N','1:1','N:1','N:N') NOT NULL DEFAULT '1:1' COMMENT '(\'\'1:N\'\', \'\'1:1\'\', \'\'N:1\'\', \'\'N:N\'\')\',',
  `m_mnemonic` VARCHAR(35) NULL,
  `table1_optional` TINYINT(4) NULL DEFAULT 0,
  `table2_optional` TINYINT(4) NULL DEFAULT 0,
  `coupletable_name` VARCHAR(255) NULL COMMENT '\'The table name of the couple table e.g _z_rel_insured_location__destination\',',
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_relationID`),
  INDEX `fk_m_couple_m_entitytype1_idx` (`table1ID` ASC),
  INDEX `fk_m_couple_m_entitytype2_idx` (`table2ID` ASC),
  INDEX `fk_m_couple_m_item1_idx` (`m_item1ID` ASC),
  INDEX `fk_m_couple_m_item2_idx` (`m_item2ID` ASC),
  INDEX `fk_m_relation_m_table1_idx` (`m_tableID` ASC),
  CONSTRAINT `fk_m_couple_m_entitytype1`
    FOREIGN KEY (`table1ID`)
    REFERENCES `ezbuildrental`.`m_table` (`m_tableID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_couple_m_entitytype2`
    FOREIGN KEY (`table2ID`)
    REFERENCES `ezbuildrental`.`m_table` (`m_tableID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_couple_m_item1`
    FOREIGN KEY (`m_item1ID`)
    REFERENCES `ezbuildrental`.`m_field` (`m_fieldID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_couple_m_item2`
    FOREIGN KEY (`m_item2ID`)
    REFERENCES `ezbuildrental`.`m_field` (`m_fieldID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_relation_m_table1`
    FOREIGN KEY (`m_tableID`)
    REFERENCES `ezbuildrental`.`m_table` (`m_tableID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8
COMMENT = 'Relations between tables are described with m_relation entries.' /* comment truncated */ /*
Naming convention for a relation:
_z_rel_<table1 name>__<table2 name>

This ensures that all relation tables are grouped within your working even (e.g mysql workbench)*/;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_table_m_field`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_table_m_field` (
  `m_tableID` INT(11) NOT NULL,
  `m_fieldID` INT(11) NOT NULL,
  `m_xpathID` INT(11) NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_tableID`, `m_fieldID`),
  INDEX `fk_m_entitytype_item_m_item1_idx` (`m_fieldID` ASC),
  CONSTRAINT `fk_m_entitytype_item_m_entitytype1`
    FOREIGN KEY (`m_tableID`)
    REFERENCES `ezbuildrental`.`m_table` (`m_tableID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_entitytype_item_m_item1`
    FOREIGN KEY (`m_fieldID`)
    REFERENCES `ezbuildrental`.`m_field` (`m_fieldID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_help`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_help` (
  `m_helpID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_name` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`m_helpID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_itemgroup`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_itemgroup` (
  `m_itemgroupID` INT(11) NOT NULL AUTO_INCREMENT,
  `open_at_pageload` TINYINT(4) NULL,
  `js_code` MEDIUMTEXT NULL,
  `name` VARCHAR(255) NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_itemgroupID`),
  CONSTRAINT `fk_m_itemgroup_m_stringez1`
    FOREIGN KEY (`m_itemgroupID`)
    REFERENCES `ezbuildrental`.`m_stringez` (`m_sourceID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 9
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_itemgroup_entitytype`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_itemgroup_entitytype` (
  `m_itemgroupID` INT(11) NOT NULL,
  `m_entitytypeID` INT(11) NOT NULL,
  PRIMARY KEY (`m_itemgroupID`, `m_entitytypeID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_widget`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_widget` (
  `m_widgetID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_widget_name` VARCHAR(255) NULL,
  PRIMARY KEY (`m_widgetID`))
ENGINE = InnoDB
COMMENT = 'Meta meta information';


-- -----------------------------------------------------
-- Table `ezbuildrental`.`mm_widget`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`mm_widget` (
  `mm_widgetID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_widget_name` VARCHAR(255) NULL DEFAULT NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`mm_widgetID`))
ENGINE = InnoDB
AUTO_INCREMENT = 5
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_itemgroup_m_field`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_itemgroup_m_field` (
  `m_tableID` INT(11) NOT NULL,
  `m_itemgroupID` INT(11) NOT NULL,
  `m_fieldID` INT(11) NOT NULL,
  `mm_widgetID` INT(11) NULL,
  `js_code_onchange` MEDIUMTEXT NULL,
  `js_code_script_item` MEDIUMTEXT NULL,
  `m_sequence` INT(11) NULL,
  `m_initial_hidden` TINYINT(4) NULL DEFAULT 0,
  `m_remark` MEDIUMTEXT NULL,
  `name` VARCHAR(255) NULL COMMENT 'mnemonic of field name',
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_tableID`, `m_itemgroupID`, `m_fieldID`),
  INDEX `fk_m_itemgroup_item_m_item1_idx` (`m_fieldID` ASC),
  INDEX `fk_m_itemgroup_m_field_page_m_widget1_idx` (`mm_widgetID` ASC),
  INDEX `fk_m_itemgroup_m_field_m_table1_idx` (`m_tableID` ASC),
  CONSTRAINT `fk_m_itemgroup_item_m_itemgroup1`
    FOREIGN KEY (`m_itemgroupID`)
    REFERENCES `ezbuildrental`.`m_itemgroup` (`m_itemgroupID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_itemgroup_item_m_item1`
    FOREIGN KEY (`m_fieldID`)
    REFERENCES `ezbuildrental`.`m_field` (`m_fieldID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_itemgroup_m_field_page_m_widget1`
    FOREIGN KEY (`mm_widgetID`)
    REFERENCES `ezbuildrental`.`m_widget` (`m_widgetID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_itemgroup_m_field_m_table1`
    FOREIGN KEY (`m_tableID`)
    REFERENCES `ezbuildrental`.`m_table` (`m_tableID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_itemgroup_m_field_mm_widget1`
    FOREIGN KEY (`mm_widgetID`)
    REFERENCES `ezbuildrental`.`mm_widget` (`mm_widgetID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_itemgroup_m_field_m_stringez1`
    FOREIGN KEY (`m_fieldID`)
    REFERENCES `ezbuildrental`.`m_stringez` (`m_sourceID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_language`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_language` (
  `m_languageID` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL DEFAULT NULL,
  `prefix` VARCHAR(2) NOT NULL,
  `updated` TIMESTAMP NULL,
  PRIMARY KEY (`m_languageID`),
  UNIQUE INDEX `mm_language_code_UNIQUE` (`prefix` ASC))
ENGINE = InnoDB
AUTO_INCREMENT = 5
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_language_help`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_language_help` (
  `m_helpID` INT(11) NOT NULL,
  `m_languageID` INT(11) NOT NULL,
  `m_lhelptext` MEDIUMTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`m_helpID`, `m_languageID`),
  INDEX `fk_m_language_help_mm_language1_idx` (`m_languageID` ASC),
  CONSTRAINT `fk_m_language_help_mm_language1`
    FOREIGN KEY (`m_languageID`)
    REFERENCES `ezbuildrental`.`m_language` (`m_languageID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_language_help_mm_language2`
    FOREIGN KEY (`m_languageID`)
    REFERENCES `ezbuildrental`.`m_language` (`m_languageID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_language_help_m_help1`
    FOREIGN KEY (`m_helpID`)
    REFERENCES `ezbuildrental`.`m_help` (`m_helpID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_language_item`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_language_item` (
  `m_itemID` INT(11) NOT NULL,
  `m_languageID` INT(11) NOT NULL,
  `m_name` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`m_itemID`, `m_languageID`),
  INDEX `fk_m_language_item_mm_language1_idx` (`m_languageID` ASC),
  CONSTRAINT `fk_m_language_item_mm_language1`
    FOREIGN KEY (`m_languageID`)
    REFERENCES `ezbuildrental`.`m_language` (`m_languageID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_language_item_m_item1`
    FOREIGN KEY (`m_itemID`)
    REFERENCES `ezbuildrental`.`m_field` (`m_fieldID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_language_itemgroup`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_language_itemgroup` (
  `m_languageID` INT(11) NOT NULL,
  `m_itemgroupID` INT(11) NOT NULL,
  `m_name` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`m_languageID`, `m_itemgroupID`),
  INDEX `fk_m_language_itemgroup_m_itemgroup1_idx` (`m_itemgroupID` ASC),
  CONSTRAINT `fk_m_language_itemgroup_m_itemgroup1`
    FOREIGN KEY (`m_itemgroupID`)
    REFERENCES `ezbuildrental`.`m_itemgroup` (`m_itemgroupID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_language_itemgroup_mm_language1`
    FOREIGN KEY (`m_languageID`)
    REFERENCES `ezbuildrental`.`m_language` (`m_languageID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_page`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_page` (
  `m_pageID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_main_entitytypeID` INT(11) NULL DEFAULT NULL,
  `m_name` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`m_pageID`))
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_language_page`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_language_page` (
  `m_languageID` INT(11) NOT NULL,
  `m_page` INT(11) NOT NULL,
  `m_name` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`m_languageID`, `m_page`),
  INDEX `fk_m_language_page_m_page1_idx` (`m_page` ASC),
  CONSTRAINT `fk_m_language_page_mm_language1`
    FOREIGN KEY (`m_languageID`)
    REFERENCES `ezbuildrental`.`m_language` (`m_languageID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_language_page_m_page1`
    FOREIGN KEY (`m_page`)
    REFERENCES `ezbuildrental`.`m_page` (`m_pageID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_language_stringez`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_language_stringez` (
  `m_languageID` INT(11) NOT NULL,
  `m_stringezID` INT(11) NOT NULL,
  `m_name` TEXT NULL DEFAULT NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_languageID`, `m_stringezID`),
  CONSTRAINT `fk_m_language_string_mm_language1`
    FOREIGN KEY (`m_languageID`)
    REFERENCES `ezbuildrental`.`m_language` (`m_languageID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_language_string_m_string2`
    FOREIGN KEY (`m_stringezID`)
    REFERENCES `ezbuildrental`.`m_stringez` (`m_stringezID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_metamodel`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_metamodel` (
  `m_metamodelID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_name` VARCHAR(255) NULL DEFAULT NULL,
  `m_description` MEDIUMTEXT NULL DEFAULT NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_metamodelID`))
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_metamodel_m_table`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_metamodel_m_table` (
  `m_metamodelID` INT(11) NOT NULL DEFAULT '0',
  `m_tableID` INT(11) NOT NULL DEFAULT '0',
  `updated` TIMESTAMP NULL DEFAULT 'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP',
  PRIMARY KEY (`m_metamodelID`, `m_tableID`),
  INDEX `fk_m_metamodel_entitytype_m_entitytype1_idx` (`m_tableID` ASC),
  CONSTRAINT `fk_m_metamodel_entitytype_m_metamodel`
    FOREIGN KEY (`m_metamodelID`)
    REFERENCES `ezbuildrental`.`m_metamodel` (`m_metamodelID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_metamodel_entitytype_m_entitytype1`
    FOREIGN KEY (`m_tableID`)
    REFERENCES `ezbuildrental`.`m_table` (`m_tableID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_person`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_person` (
  `m_personID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_first_name` VARCHAR(45) NULL DEFAULT NULL,
  `m_insertion` VARCHAR(15) NULL DEFAULT NULL,
  `m_christian_name` VARCHAR(45) NULL DEFAULT NULL,
  `m_birth_date` DATE NULL DEFAULT NULL,
  `m_phone1` VARCHAR(45) NULL DEFAULT NULL,
  `m_phone2` VARCHAR(45) NULL DEFAULT NULL,
  `m_email_address1` VARCHAR(45) NULL DEFAULT NULL,
  `m_email_address2` VARCHAR(45) NULL DEFAULT NULL,
  `m_bankaccount` VARCHAR(13) NULL DEFAULT NULL,
  `m_BIC` VARCHAR(15) NULL DEFAULT NULL,
  `m_IBAN` VARCHAR(45) NULL DEFAULT NULL,
  `m_street` VARCHAR(255) NULL DEFAULT NULL,
  `m_house_number` VARCHAR(15) NULL DEFAULT NULL,
  `m_postal_code` VARCHAR(10) NULL DEFAULT NULL,
  `m_city` VARCHAR(255) NULL DEFAULT 'NUll',
  `m_identificationID` VARCHAR(45) NULL DEFAULT NULL,
  `m_male` TINYINT(4) NULL DEFAULT '1',
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_personID`))
ENGINE = InnoDB
AUTO_INCREMENT = 48653
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_role`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_role` (
  `m_roleID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_name` VARCHAR(255) NULL DEFAULT NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_roleID`))
ENGINE = InnoDB
AUTO_INCREMENT = 4
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_session`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_session` (
  `m_sessionID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_metamodelID` INT(11) NULL DEFAULT NULL,
  `m_session_name` VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`m_sessionID`))
ENGINE = InnoDB
AUTO_INCREMENT = 4
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_session_page`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_session_page` (
  `m_pageID` INT(11) NOT NULL,
  `m_sessionID` INT(11) NOT NULL,
  PRIMARY KEY (`m_pageID`, `m_sessionID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_user`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_user` (
  `m_userID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_email` VARCHAR(255) NULL DEFAULT NULL,
  `m_password` VARCHAR(45) NULL DEFAULT NULL,
  `m_active` INT(4) NULL DEFAULT NULL,
  `m_hash` VARCHAR(255) NULL DEFAULT NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_userID`),
  CONSTRAINT `fk_m_user_m_person1`
    FOREIGN KEY (`m_userID`)
    REFERENCES `ezbuildrental`.`m_person` (`m_personID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_usergroup`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_usergroup` (
  `m_usergroupID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_name` VARCHAR(255) NULL DEFAULT NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_usergroupID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_usergroup_m_user_m_role`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_usergroup_m_user_m_role` (
  `m_usergroupID` INT(11) NOT NULL,
  `m_userID` INT(11) NOT NULL,
  `m_roleID` INT(11) NOT NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_usergroupID`, `m_userID`),
  INDEX `fk_m_usergroup_iuser_m_user1_idx` (`m_userID` ASC),
  INDEX `fk_m_usergroup_user_m_role1_idx` (`m_roleID` ASC),
  CONSTRAINT `fk_m_usergroup_iuser_m_usergroup1`
    FOREIGN KEY (`m_usergroupID`)
    REFERENCES `ezbuildrental`.`m_usergroup` (`m_usergroupID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_usergroup_iuser_m_user1`
    FOREIGN KEY (`m_userID`)
    REFERENCES `ezbuildrental`.`m_user` (`m_userID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_usergroup_user_m_role1`
    FOREIGN KEY (`m_roleID`)
    REFERENCES `ezbuildrental`.`m_role` (`m_roleID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_webpage_element`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_webpage_element` (
  `m_webpage_elementID` INT(11) NOT NULL,
  `m_html_node` VARCHAR(255) NULL DEFAULT NULL,
  `m_css` VARCHAR(255) NULL DEFAULT NULL,
  `m_class` VARCHAR(255) NULL DEFAULT NULL,
  `m_phpcodeID` INT(11) NULL DEFAULT NULL,
  `m_javascriptID` INT(11) NULL DEFAULT NULL,
  `m_icon` VARCHAR(20) NULL DEFAULT NULL,
  `m_role` VARCHAR(45) NULL DEFAULT NULL,
  `m_button` INT(4) NULL DEFAULT '0' COMMENT '1 = button',
  PRIMARY KEY (`m_webpage_elementID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_webpage_header`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_webpage_header` (
  `m_webpage_headerID` INT(11) NOT NULL,
  `m_header` INT(4) NULL DEFAULT '1' COMMENT '1 = header 0 = footer',
  `m_webpage_header_titleID` INT(11) NULL DEFAULT NULL,
  `m_buttonleftID` INT(11) NULL DEFAULT NULL COMMENT 'pointer to m_webpage_element',
  `m_buttonrightID` INT(11) NULL DEFAULT NULL COMMENT 'pointer to m_webpage_element',
  `m_navbarsetID` INT(11) NULL DEFAULT NULL,
  PRIMARY KEY (`m_webpage_headerID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_webpage_header_title`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_webpage_header_title` (
  `m_webpage_header_titleID` INT(11) NOT NULL,
  `m_name` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`m_webpage_header_titleID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_webpage_title`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_webpage_title` (
  `m_webpage_titleID` INT(11) NOT NULL,
  `m_name` VARCHAR(255) NULL DEFAULT NULL,
  PRIMARY KEY (`m_webpage_titleID`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`mm_crud`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`mm_crud` (
  `mm_crudID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_right` ENUM('Create','Read','Update','Delete','Select') NULL COMMENT 'enum(\"Create\",\"Read\",\"Update\",\"Delete\",S\"elect\",',
  PRIMARY KEY (`mm_crudID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_role_m_table`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_role_m_table` (
  `m_roleID` INT(11) NOT NULL,
  `m_tableID` INT(11) NOT NULL,
  `mm_crudID` INT(11) NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_roleID`, `m_tableID`),
  INDEX `fk_m_role_entitytype_m_entitytype1_idx` (`m_tableID` ASC),
  INDEX `fk_m_role_m_table_mm_crud1_idx` (`mm_crudID` ASC),
  CONSTRAINT `fk_m_role_entitytype_m_entitytype1`
    FOREIGN KEY (`m_tableID`)
    REFERENCES `ezbuildrental`.`m_table` (`m_tableID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_role_entitytype_m_role1`
    FOREIGN KEY (`m_roleID`)
    REFERENCES `ezbuildrental`.`m_role` (`m_roleID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_role_m_table_mm_crud1`
    FOREIGN KEY (`mm_crudID`)
    REFERENCES `ezbuildrental`.`mm_crud` (`mm_crudID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_role_m_field`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_role_m_field` (
  `m_roleID` INT(11) NOT NULL,
  `m_fieldID` INT(11) NOT NULL,
  `mm_crudID` INT(11) NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_roleID`, `m_fieldID`),
  INDEX `fk_m_role_item_m_item1_idx` (`m_fieldID` ASC),
  INDEX `fk_m_role_m_field_mm_crud1_idx` (`mm_crudID` ASC),
  CONSTRAINT `fk_m_role_item_m_item1`
    FOREIGN KEY (`m_fieldID`)
    REFERENCES `ezbuildrental`.`m_field` (`m_fieldID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_role_item_m_role1`
    FOREIGN KEY (`m_roleID`)
    REFERENCES `ezbuildrental`.`m_role` (`m_roleID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_role_m_field_mm_crud1`
    FOREIGN KEY (`mm_crudID`)
    REFERENCES `ezbuildrental`.`mm_crud` (`mm_crudID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_role_m_itemgroup`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_role_m_itemgroup` (
  `m_roleID` INT(11) NOT NULL,
  `m_itemgroupID` INT(11) NOT NULL,
  `mm_crudID` INT(11) NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_roleID`, `m_itemgroupID`),
  INDEX `fk_m_role_itemgroup_m_itemgroup1_idx` (`m_itemgroupID` ASC),
  CONSTRAINT `fk_m_role_itemgroup_m_itemgroup1`
    FOREIGN KEY (`m_itemgroupID`)
    REFERENCES `ezbuildrental`.`m_itemgroup` (`m_itemgroupID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_role_itemgroup_m_role1`
    FOREIGN KEY (`m_roleID`)
    REFERENCES `ezbuildrental`.`m_role` (`m_roleID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_role_m_itemgroup_mm_crud1`
    FOREIGN KEY (`m_roleID`)
    REFERENCES `ezbuildrental`.`mm_crud` (`mm_crudID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_json_provider`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_json_provider` (
  `m_json_providerID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_sql` MEDIUMTEXT NULL,
  `m_post` INT(4) NULL DEFAULT 1,
  `m_code` MEDIUMTEXT NULL,
  PRIMARY KEY (`m_json_providerID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_parameter`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_parameter` (
  `m_parameterID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_session` INT(4) NULL DEFAULT 0,
  `m_name` VARCHAR(255) NULL,
  `m_post` INT(4) NULL DEFAULT 1,
  PRIMARY KEY (`m_parameterID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_jsonprovider_parameter`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_jsonprovider_parameter` (
  `m_json_providerID` INT(11) NOT NULL,
  `m_parameterID` INT(11) NOT NULL,
  PRIMARY KEY (`m_json_providerID`, `m_parameterID`),
  INDEX `fk_m_m_jsonprovider_parameter_m_parameter1_idx` (`m_parameterID` ASC),
  CONSTRAINT `fk_m_m_jsonprovider_parameter_m_parameter_1`
    FOREIGN KEY (`m_parameterID`)
    REFERENCES `ezbuildrental`.`m_parameter` (`m_parameterID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_m_jsonprovider_parameter_m_json_provider_1`
    FOREIGN KEY (`m_json_providerID`)
    REFERENCES `ezbuildrental`.`m_json_provider` (`m_json_providerID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_session_parameter`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_session_parameter` (
  `m_parameterID` INT(11) NOT NULL,
  `m_sessionID` INT(11) NOT NULL,
  PRIMARY KEY (`m_parameterID`, `m_sessionID`),
  INDEX `fk_m_session_parameter_m_session1_idx` (`m_sessionID` ASC),
  CONSTRAINT `fk_m_session_parameter_m_session1`
    FOREIGN KEY (`m_sessionID`)
    REFERENCES `ezbuildrental`.`m_session` (`m_sessionID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_session_parameter_m_parameter1`
    FOREIGN KEY (`m_parameterID`)
    REFERENCES `ezbuildrental`.`m_parameter` (`m_parameterID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_role_webpage`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_role_webpage` (
  `m_roleID` INT(11) NOT NULL,
  `m_webpageID` INT(11) NOT NULL,
  PRIMARY KEY (`m_roleID`, `m_webpageID`),
  INDEX `fk_m_role_webpage_m_webpage1_idx` (`m_webpageID` ASC),
  CONSTRAINT `fk_m_role_webpage_m_webpage1`
    FOREIGN KEY (`m_webpageID`)
    REFERENCES `ezbuildrental`.`m_webpage` (`m_webpageID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_role_webpage_m_role1`
    FOREIGN KEY (`m_roleID`)
    REFERENCES `ezbuildrental`.`m_role` (`m_roleID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_html_headerelement`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_html_headerelement` (
  `m_html_headerelementID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_name` VARCHAR(255) NULL,
  `m_code` MEDIUMTEXT NULL,
  `m_path` VARCHAR(255) NULL,
  `m_css` INT(4) NULL DEFAULT 0,
  `m_javascript` INT(4) NULL DEFAULT 1,
  PRIMARY KEY (`m_html_headerelementID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_webpage_headerelement`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_webpage_headerelement` (
  `m_webpageID` INT(11) NOT NULL,
  `m_html_headerelementID` INT(11) NOT NULL,
  `m_sequence` INT(4) NOT NULL,
  PRIMARY KEY (`m_webpageID`, `m_html_headerelementID`, `m_sequence`),
  INDEX `fk_m_webpage_headerelement_m_html_headerelement1_idx` (`m_html_headerelementID` ASC),
  CONSTRAINT `fk_m_webpage_headerelement_m_webpage1`
    FOREIGN KEY (`m_webpageID`)
    REFERENCES `ezbuildrental`.`m_webpage` (`m_webpageID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_webpage_headerelement_m_html_headerelement1`
    FOREIGN KEY (`m_html_headerelementID`)
    REFERENCES `ezbuildrental`.`m_html_headerelement` (`m_html_headerelementID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_jquery_header`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_jquery_header` (
  `m_navbarset_navbaritemID` INT(11) NOT NULL,
  `m_jquery_headerID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_header` INT(4) NULL DEFAULT 1,
  `m_title` VARCHAR(255) NULL,
  `m_leftbuttonID` INT(11) NULL,
  `m_rightbuttonID` INT(11) NULL,
  PRIMARY KEY (`m_jquery_headerID`, `m_navbarset_navbaritemID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_webpage_jqueryheader`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_webpage_jqueryheader` (
  `m_webpageID` INT(11) NOT NULL,
  `m_jquery_headerID` INT(11) NOT NULL,
  PRIMARY KEY (`m_webpageID`, `m_jquery_headerID`),
  INDEX `fk_m_webpage_jqueryheader_m_jquery_header1_idx` (`m_jquery_headerID` ASC),
  CONSTRAINT `fk_m_webpage_jqueryheader_m_jquery_header1`
    FOREIGN KEY (`m_jquery_headerID`)
    REFERENCES `ezbuildrental`.`m_jquery_header` (`m_jquery_headerID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_webpage_jqueryheader_m_webpage1`
    FOREIGN KEY (`m_webpageID`)
    REFERENCES `ezbuildrental`.`m_webpage` (`m_webpageID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_class`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_class` (
  `m_classID` INT(11) NOT NULL,
  `m_name` VARCHAR(255) NULL,
  PRIMARY KEY (`m_classID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_jquery_button`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_jquery_button` (
  `m_jquery_buttonID` INT(11) NOT NULL,
  `m_stringID` INT(11) NULL,
  `m_jclassID` INT(11) NOT NULL,
  `m_iconID` INT(11) NULL,
  PRIMARY KEY (`m_jquery_buttonID`, `m_jclassID`),
  INDEX `fk_m_jquery_button_m_class1_idx` (`m_jclassID` ASC),
  CONSTRAINT `fk_m_jquery_button_m_class1`
    FOREIGN KEY (`m_jclassID`)
    REFERENCES `ezbuildrental`.`m_class` (`m_classID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_jquery_button_header`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_jquery_button_header` (
  `m_jquery_buttonID` INT(11) NOT NULL,
  `m_jquery_headerID` INT(11) NOT NULL,
  PRIMARY KEY (`m_jquery_buttonID`, `m_jquery_headerID`),
  INDEX `fk_m_jquery_button_header_m_jquery_header1_idx` (`m_jquery_headerID` ASC),
  CONSTRAINT `fk_m_jquery_button_header_m_jquery_header1`
    FOREIGN KEY (`m_jquery_headerID`)
    REFERENCES `ezbuildrental`.`m_jquery_header` (`m_jquery_headerID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_jquery_button_header_m_jquery_button1`
    FOREIGN KEY (`m_jquery_buttonID`)
    REFERENCES `ezbuildrental`.`m_jquery_button` (`m_jquery_buttonID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_jquery_element`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_jquery_element` (
  `m_query_elementID` INT(11) NOT NULL,
  `m_name` VARCHAR(45) NULL,
  PRIMARY KEY (`m_query_elementID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_jquery_elementparameter`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_jquery_elementparameter` (
  `m_query_elementID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_jquery_elementparameterID` INT(11) NULL,
  `m_data_element` VARCHAR(255) NULL,
  PRIMARY KEY (`m_query_elementID`),
  CONSTRAINT `fk_m_jquery_elementparameter_m_jquery_element1`
    FOREIGN KEY (`m_query_elementID`)
    REFERENCES `ezbuildrental`.`m_jquery_element` (`m_query_elementID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_querystring_parameter`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_querystring_parameter` (
  `m_querystring_parameterID` INT(11) NOT NULL,
  `m_name` VARCHAR(255) NULL,
  PRIMARY KEY (`m_querystring_parameterID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_webpage_querystringparameter`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_webpage_querystringparameter` (
  `m_webpageID` INT(11) NOT NULL,
  `m_querystring_parameterID` INT(11) NOT NULL,
  PRIMARY KEY (`m_webpageID`, `m_querystring_parameterID`),
  INDEX `fk_m_webpage_querystringparameter_m_querystring_parameter1_idx` (`m_querystring_parameterID` ASC),
  CONSTRAINT `fk_m_webpage_querystringparameter_m_webpage1`
    FOREIGN KEY (`m_webpageID`)
    REFERENCES `ezbuildrental`.`m_webpage` (`m_webpageID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_webpage_querystringparameter_m_querystring_parameter1`
    FOREIGN KEY (`m_querystring_parameterID`)
    REFERENCES `ezbuildrental`.`m_querystring_parameter` (`m_querystring_parameterID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_querystring_parameter`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_querystring_parameter` (
  `m_querystring_parameterID` INT(11) NOT NULL,
  `m_name` VARCHAR(255) NULL,
  PRIMARY KEY (`m_querystring_parameterID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_webpage_querystring_parameter`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_webpage_querystring_parameter` (
  `m_webpageID` INT(11) NOT NULL,
  `m_querystring_parameterID` INT(11) NOT NULL,
  PRIMARY KEY (`m_querystring_parameterID`, `m_webpageID`),
  INDEX `fk_m_webpage_querystring_parameter_m_webpage1_idx` (`m_webpageID` ASC),
  CONSTRAINT `fk_m_webpage_querystring_parameter_m_webpage1`
    FOREIGN KEY (`m_webpageID`)
    REFERENCES `ezbuildrental`.`m_webpage` (`m_webpageID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_webpage_querystring_parameter_m_querystring_parameter1`
    FOREIGN KEY (`m_querystring_parameterID`)
    REFERENCES `ezbuildrental`.`m_querystring_parameter` (`m_querystring_parameterID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_jquery_navbarset`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_jquery_navbarset` (
  `m_jquery_navbarsetID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_description` VARCHAR(45) NULL,
  PRIMARY KEY (`m_jquery_navbarsetID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_jquery_navbaritem`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_jquery_navbaritem` (
  `m_jquery_navbaritemID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_jquery_navbarsetID` INT(11) NULL,
  `m_name` VARCHAR(255) NULL,
  `m_nameID` INT(11) NULL,
  PRIMARY KEY (`m_jquery_navbaritemID`),
  INDEX `fk_m_jquery_navbaritem_m_jquery_navbarset1_idx` (`m_jquery_navbarsetID` ASC),
  CONSTRAINT `fk_m_jquery_navbaritem_m_jquery_navbarset1`
    FOREIGN KEY (`m_jquery_navbarsetID`)
    REFERENCES `ezbuildrental`.`m_jquery_navbarset` (`m_jquery_navbarsetID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_multiple_choice_option`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_multiple_choice_option` (
  `m_multiple_choice_optionID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_value_numeric` FLOAT NULL,
  `m_multiple_choiceID` INT(11) NOT NULL,
  `m_value_date` DATETIME NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_multiple_choice_optionID`),
  CONSTRAINT `fk_m_multiple_choice_option_m_stringez1`
    FOREIGN KEY (`m_multiple_choice_optionID`)
    REFERENCES `ezbuildrental`.`m_stringez` (`m_sourceID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_string_copy1`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_string_copy1` (
  `m_stringID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_name` VARCHAR(255) NULL DEFAULT NULL,
  `m_languageID` INT(11) NOT NULL,
  PRIMARY KEY (`m_stringID`, `m_languageID`),
  INDEX `fk_m_string_mm_language1_idx` (`m_languageID` ASC),
  CONSTRAINT `fk_m_string_mm_language10`
    FOREIGN KEY (`m_languageID`)
    REFERENCES `ezbuildrental`.`m_language` (`m_languageID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_multiple_choice`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_multiple_choice` (
  `m_multiple_choiceID` INT(11) NOT NULL AUTO_INCREMENT,
  `m_default_optionID` INT(11) NULL,
  `m_boolean` TINYINT(4) NULL DEFAULT 0,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_multiple_choiceID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_language_m_string_explanation`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_language_m_string_explanation` (
  `m_languageID` INT(11) NOT NULL,
  `m_explanationID` INT(11) NOT NULL,
  `m_name` MEDIUMTEXT NULL DEFAULT NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_languageID`, `m_explanationID`),
  INDEX `fk_m_language_string_copy1_m_explanation1_idx` (`m_explanationID` ASC),
  CONSTRAINT `fk_m_language_string_mm_language10`
    FOREIGN KEY (`m_languageID`)
    REFERENCES `ezbuildrental`.`m_language` (`m_languageID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_language_string_copy1_m_explanation1`
    FOREIGN KEY (`m_explanationID`)
    REFERENCES `ezbuildrental`.`m_explanation` (`m_explanationID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_relation_m_field`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_relation_m_field` (
  `m_relationID` INT(11) NOT NULL,
  `m_fieldID` INT(11) NOT NULL,
  `m_sequence` INT(11) NULL,
  `updated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_relationID`, `m_fieldID`),
  INDEX `fk_m_couple_item_m_item1_idx` (`m_fieldID` ASC),
  CONSTRAINT `fk_m_couple_item_m_couple1`
    FOREIGN KEY (`m_relationID`)
    REFERENCES `ezbuildrental`.`m_relation` (`m_relationID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_couple_item_m_item1`
    FOREIGN KEY (`m_fieldID`)
    REFERENCES `ezbuildrental`.`m_field` (`m_fieldID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_metamodel_m_language`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_metamodel_m_language` (
  `m_metamodelID` INT(11) NOT NULL,
  `m_languageID` INT(11) NOT NULL,
  `udpated` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_metamodelID`, `m_languageID`),
  INDEX `fk_m_metamodel_m_language_m_language1_idx` (`m_languageID` ASC),
  CONSTRAINT `fk_m_metamodel_m_table_m_metamodel1`
    FOREIGN KEY (`m_metamodelID`)
    REFERENCES `ezbuildrental`.`m_metamodel` (`m_metamodelID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_metamodel_m_language_m_language1`
    FOREIGN KEY (`m_languageID`)
    REFERENCES `ezbuildrental`.`m_language` (`m_languageID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = 'Determine the active languages for a specific metal model.';


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_webpage_m_itemgroup`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_webpage_m_itemgroup` (
  `m_webpageID` INT(11) NOT NULL,
  `m_itemgroupID` INT(11) NOT NULL,
  `m_sequence` INT(11) NULL,
  PRIMARY KEY (`m_webpageID`, `m_itemgroupID`),
  INDEX `fk_m_webpage_m_itemgroup_m_itemgroup1_idx` (`m_itemgroupID` ASC),
  CONSTRAINT `fk_m_webpage_m_itemgroup_m_webpage1`
    FOREIGN KEY (`m_webpageID`)
    REFERENCES `ezbuildrental`.`m_webpage` (`m_webpageID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_webpage_m_itemgroup_m_itemgroup1`
    FOREIGN KEY (`m_itemgroupID`)
    REFERENCES `ezbuildrental`.`m_itemgroup` (`m_itemgroupID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `ezbuildrental`.`m_field_m_multiple_choice`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ezbuildrental`.`m_field_m_multiple_choice` (
  `m_fieldID` INT(11) NOT NULL,
  `m_multiple_choiceID` INT(11) NOT NULL,
  PRIMARY KEY (`m_fieldID`, `m_multiple_choiceID`),
  INDEX `fk_m_field_m_multiple_choice_m_multiple_choice1_idx` (`m_multiple_choiceID` ASC),
  CONSTRAINT `fk_m_field_m_multiple_choice_m_field1`
    FOREIGN KEY (`m_fieldID`)
    REFERENCES `ezbuildrental`.`m_field` (`m_fieldID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_m_field_m_multiple_choice_m_multiple_choice1`
    FOREIGN KEY (`m_multiple_choiceID`)
    REFERENCES `ezbuildrental`.`m_multiple_choice` (`m_multiple_choiceID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;