CREATE TABLE `def_datamodel` (
`Package` varchar(100) NOT NULL,
`DataModel` varchar(255) NOT NULL,
`Description` text DEFAULT NULL,
`Notes` text DEFAULT NULL,
PRIMARY KEY (`Package`, `DataModel`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4
COLLATE={collation}
CREATE TABLE `def_datamodel_tables` (
`Package` varchar(100) NOT NULL,
`DataModel` varchar(255) NOT NULL,
`TableName` varchar(255) NOT NULL,
`Notes` text DEFAULT NULL,
PRIMARY KEY (`Package`, `DataModel`, `TableName`),
KEY `idx_table` (`TableName`),
KEY `idx_model` (`DataModel`, `Package`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4
COLLATE={collation}