CREATE TABLE `annotation` (
`modelelement_e_id` bigint(20) NOT NULL,
`source` varchar(255) DEFAULT NULL,
`annotation_modelelement_e_id` bigint(20) DEFAULT NULL,
`modelelement_annotations_idx` int(11) DEFAULT NULL,
PRIMARY KEY (`modelelement_e_id`),
KEY `annotation_modelelement` (`annotation_modelelement_e_id`),
KEY `FKA34FEB2F784157F4` (`modelelement_e_id`),
KEY `ModelElement_annotations` (`annotation_modelelement_e_id`),
CONSTRAINT `FKA34FEB2F784157F4` FOREIGN KEY (`modelelement_e_id`) REFERENCES `modelelement` (`idcol`),
CONSTRAINT `annotation_modelelement` FOREIGN KEY (`annotation_modelelement_e_id`) REFERENCES `modelelement` (`idcol`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `annotationcontents` (
`annotation_e_id` bigint(20) NOT NULL,
`contents_type` varchar(255) DEFAULT NULL,
`contents_id` bigint(20) DEFAULT NULL,
`annotationcontents_idx` int(11) NOT NULL,
PRIMARY KEY (`annotation_e_id`,`annotationcontents_idx`),
KEY `annotationcontents` (`annotation_e_id`),
CONSTRAINT `annotationcontents` FOREIGN KEY (`annotation_e_id`) REFERENCES `annotation` (`modelelement_e_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `annotation_details` (
`annotation_details_e_id` bigint(20) NOT NULL,
`elt` varchar(255) DEFAULT NULL,
`annotation_details_idx` int(11) NOT NULL,
PRIMARY KEY (`annotation_details_e_id`,`annotation_details_idx`),
KEY `FKD82DE53276976571` (`annotation_details_e_id`),
KEY `Annotation_details` (`annotation_details_e_id`),
CONSTRAINT `FKD82DE53276976571` FOREIGN KEY (`annotation_details_e_id`) REFERENCES `annotation` (`modelelement_e_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `annotation_references` (
`annotation_e_id` bigint(20) NOT NULL,
`references_type` varchar(255) DEFAULT NULL,
`references_id` bigint(20) DEFAULT NULL,
`annotation_references_idx` int(11) NOT NULL,
PRIMARY KEY (`annotation_e_id`,`annotation_references_idx`),
KEY `annotation_references` (`annotation_e_id`),
CONSTRAINT `annotation_references` FOREIGN KEY (`annotation_e_id`) REFERENCES `annotation` (`modelelement_e_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `baseorder` (
`idcol` bigint(20) NOT NULL AUTO_INCREMENT,
`resource_id` varchar(255) DEFAULT NULL,
`container_id` varchar(255) DEFAULT NULL,
`version` int(11) DEFAULT NULL,
`commit_TimeStamp` bigint(20) DEFAULT NULL,
PRIMARY KEY (`idcol`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `category` (
`name` varchar(255) NOT NULL,
`resource_id` varchar(255) DEFAULT NULL,
`container_id` varchar(255) DEFAULT NULL,
`version` int(11) DEFAULT NULL,
`commit_TimeStamp` bigint(20) DEFAULT NULL,
`company_categories_e_id` bigint(20) DEFAULT NULL,
`company_categories_idx` int(11) DEFAULT NULL,
`category_categories_name` varchar(255) DEFAULT NULL,
`category_categories_idx` int(11) DEFAULT NULL,
PRIMARY KEY (`name`),
KEY `company_categories` (`company_categories_e_id`),
KEY `category_categories` (`category_categories_name`),
CONSTRAINT `category_categories` FOREIGN KEY (`category_categories_name`) REFERENCES `category` (`name`),
CONSTRAINT `company_categories` FOREIGN KEY (`company_categories_e_id`) REFERENCES `company` (`addressable_e_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `cdoresourcecontents` (
`cdoresource_e_id` bigint(20) NOT NULL,
`contents_type` varchar(255) DEFAULT NULL,
`contents_id` varchar(255) DEFAULT NULL,
`cdoresourcecontents_idx` int(11) NOT NULL,
PRIMARY KEY (`cdoresource_e_id`,`cdoresourcecontents_idx`),
KEY `cdoresourcecontents` (`cdoresource_e_id`),
CONSTRAINT `cdoresourcecontents` FOREIGN KEY (`cdoresource_e_id`) REFERENCES `cdoresourcenode` (`e_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `cdoresourcenode` (
`e_id` bigint(20) NOT NULL AUTO_INCREMENT,
`dtype` varchar(255) NOT NULL,
`e_version` int(11) DEFAULT NULL,
`resource_id` varchar(255) DEFAULT NULL,
`container_id` varchar(255) DEFAULT NULL,
`cdoresourcenode_folder_e_id` bigint(20) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`cdoresourcefolder_nodes_idx` int(11) DEFAULT NULL,
PRIMARY KEY (`e_id`),
UNIQUE KEY `container_id` (`container_id`,`name`),
KEY `cdoresourcenode_folder` (`cdoresourcenode_folder_e_id`),
CONSTRAINT `cdoresourcenode_folder` FOREIGN KEY (`cdoresourcenode_folder_e_id`) REFERENCES `cdoresourcenode` (`e_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
CREATE TABLE `cdo_lob` (
`id` varchar(255) NOT NULL,
`c_lob` longtext,
`b_lob` longblob,
`lobsize` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `cdo_package_info` (
`packageURI` varchar(255) NOT NULL,
`parentURI` varchar(255) DEFAULT NULL,
`cdo_package_unit_id` varchar(255) DEFAULT NULL,
`idx` int(11) DEFAULT NULL,
PRIMARY KEY (`packageURI`),
KEY `FK5702C978798F06A8` (`cdo_package_unit_id`),
CONSTRAINT `FK5702C978798F06A8` FOREIGN KEY (`cdo_package_unit_id`) REFERENCES `cdo_package_unit` (`nsUri`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `cdo_package_unit` (
`nsUri` varchar(255) NOT NULL,
`originalType` tinyblob,
`timeStamp` bigint(20) DEFAULT NULL,
`EPackageBlob` longblob,
PRIMARY KEY (`nsUri`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `cdo_system_information` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`creationTime` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
CREATE TABLE `cdo_system_property` (
`name` varchar(255) NOT NULL,
`value` longtext,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `company` (
`addressable_e_id` bigint(20) NOT NULL,
PRIMARY KEY (`addressable_e_id`),
KEY `FK38A73C7DB2241CB4` (`addressable_e_id`),
CONSTRAINT `FK38A73C7DB2241CB4` FOREIGN KEY (`addressable_e_id`) REFERENCES `theaddresstable` (`idcol`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `customer` (
`addressable_e_id` bigint(20) NOT NULL,
`company_customers_e_id` bigint(20) DEFAULT NULL,
`company_customers_idx` int(11) DEFAULT NULL,
PRIMARY KEY (`addressable_e_id`),
KEY `company_customers` (`company_customers_e_id`),
KEY `FK24217FDEB2241CB4` (`addressable_e_id`),
CONSTRAINT `FK24217FDEB2241CB4` FOREIGN KEY (`addressable_e_id`) REFERENCES `theaddresstable` (`idcol`),
CONSTRAINT `company_customers` FOREIGN KEY (`company_customers_e_id`) REFERENCES `company` (`addressable_e_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `customer_salesorders` (
`customer_e_id` bigint(20) NOT NULL,
`salesorder_e_id` bigint(20) NOT NULL,
`customer_salesorders_idx` int(11) NOT NULL,
PRIMARY KEY (`customer_e_id`,`customer_salesorders_idx`),
KEY `FK2DF8B410A82FB2F4` (`customer_e_id`),
KEY `FK2DF8B41087204954` (`salesorder_e_id`),
KEY `Customer_salesOrders` (`customer_e_id`,`salesorder_e_id`),
CONSTRAINT `FK2DF8B41087204954` FOREIGN KEY (`salesorder_e_id`) REFERENCES `salesorder` (`baseorder_e_id`),
CONSTRAINT `FK2DF8B410A82FB2F4` FOREIGN KEY (`customer_e_id`) REFERENCES `customer` (`addressable_e_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `modelelement` (
`idcol` bigint(20) NOT NULL AUTO_INCREMENT,
`resource_id` varchar(255) DEFAULT NULL,
`container_id` varchar(255) DEFAULT NULL,
`version` int(11) DEFAULT NULL,
`commit_TimeStamp` bigint(20) DEFAULT NULL,
PRIMARY KEY (`idcol`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `orderdetail` (
`idcol` bigint(20) NOT NULL AUTO_INCREMENT,
`resource_id` varchar(255) DEFAULT NULL,
`container_id` varchar(255) DEFAULT NULL,
`version` int(11) DEFAULT NULL,
`commit_TimeStamp` bigint(20) DEFAULT NULL,
`orderdetail_order_e_id` bigint(20) DEFAULT NULL,
`product` varchar(255) DEFAULT NULL,
`price` float DEFAULT NULL,
`order_orderdetails_idx` int(11) DEFAULT NULL,
PRIMARY KEY (`idcol`),
KEY `orderdetail_order` (`orderdetail_order_e_id`),
KEY `orderdetail_product` (`product`),
KEY `BaseOrder_orderDetails` (`orderdetail_order_e_id`),
CONSTRAINT `orderdetail_product` FOREIGN KEY (`product`) REFERENCES `product` (`name`),
CONSTRAINT `orderdetail_order` FOREIGN KEY (`orderdetail_order_e_id`) REFERENCES `baseorder` (`idcol`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `product` (
`name` varchar(255) NOT NULL,
`resource_id` varchar(255) DEFAULT NULL,
`container_id` varchar(255) DEFAULT NULL,
`version` int(11) DEFAULT NULL,
`commit_TimeStamp` bigint(20) DEFAULT NULL,
`vat` varchar(255) NOT NULL,
`price` float DEFAULT NULL,
`category_products_name` varchar(255) DEFAULT NULL,
`category_products_idx` int(11) DEFAULT NULL,
PRIMARY KEY (`name`),
KEY `category_products` (`category_products_name`),
CONSTRAINT `category_products` FOREIGN KEY (`category_products_name`) REFERENCES `category` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `product_orderdetails` (
`product_name` varchar(255) NOT NULL,
`orderdetail_e_id` bigint(20) NOT NULL,
`product_orderdetails_idx` int(11) NOT NULL,
PRIMARY KEY (`product_name`,`product_orderdetails_idx`),
KEY `FK8B9990848D3C88AA` (`product_name`),
KEY `FK8B999084C35B0374` (`orderdetail_e_id`),
KEY `Product_orderDetails` (`product_name`,`orderdetail_e_id`),
CONSTRAINT `FK8B999084C35B0374` FOREIGN KEY (`orderdetail_e_id`) REFERENCES `orderdetail` (`idcol`),
CONSTRAINT `FK8B9990848D3C88AA` FOREIGN KEY (`product_name`) REFERENCES `product` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `purchaseorder` (
`baseorder_e_id` bigint(20) NOT NULL,
`date` datetime DEFAULT NULL,
`supplier` bigint(20) DEFAULT NULL,
`company_purchaseorders_e_id` bigint(20) DEFAULT NULL,
`company_purchaseorders_idx` int(11) DEFAULT NULL,
PRIMARY KEY (`baseorder_e_id`),
KEY `FKB1F87AED40EEADF4` (`baseorder_e_id`),
KEY `company_purchaseorders` (`company_purchaseorders_e_id`),
KEY `purchaseorder_supplier` (`supplier`),
CONSTRAINT `purchaseorder_supplier` FOREIGN KEY (`supplier`) REFERENCES `supplier` (`addressable_e_id`),
CONSTRAINT `company_purchaseorders` FOREIGN KEY (`company_purchaseorders_e_id`) REFERENCES `company` (`addressable_e_id`),
CONSTRAINT `FKB1F87AED40EEADF4` FOREIGN KEY (`baseorder_e_id`) REFERENCES `baseorder` (`idcol`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `salesorder` (
`baseorder_e_id` bigint(20) NOT NULL,
`id` int(11) DEFAULT NULL,
`customer` bigint(20) DEFAULT NULL,
`company_salesorders_e_id` bigint(20) DEFAULT NULL,
`company_salesorders_idx` int(11) DEFAULT NULL,
PRIMARY KEY (`baseorder_e_id`),
KEY `company_salesorders` (`company_salesorders_e_id`),
KEY `FK674F05C240EEADF4` (`baseorder_e_id`),
KEY `salesorder_customer` (`customer`),
CONSTRAINT `salesorder_customer` FOREIGN KEY (`customer`) REFERENCES `customer` (`addressable_e_id`),
CONSTRAINT `company_salesorders` FOREIGN KEY (`company_salesorders_e_id`) REFERENCES `company` (`addressable_e_id`),
CONSTRAINT `FK674F05C240EEADF4` FOREIGN KEY (`baseorder_e_id`) REFERENCES `baseorder` (`idcol`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `supplier` (
`addressable_e_id` bigint(20) NOT NULL,
`preferred` tinyint(1) DEFAULT NULL,
`company_suppliers_e_id` bigint(20) DEFAULT NULL,
`company_suppliers_idx` int(11) DEFAULT NULL,
PRIMARY KEY (`addressable_e_id`),
KEY `company_suppliers` (`company_suppliers_e_id`),
KEY `FK9CDBF9CCB2241CB4` (`addressable_e_id`),
CONSTRAINT `FK9CDBF9CCB2241CB4` FOREIGN KEY (`addressable_e_id`) REFERENCES `theaddresstable` (`idcol`),
CONSTRAINT `company_suppliers` FOREIGN KEY (`company_suppliers_e_id`) REFERENCES `company` (`addressable_e_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `supplier_purchaseorders` (
`supplier_e_id` bigint(20) NOT NULL,
`purchaseorder_e_id` bigint(20) NOT NULL,
`supplier_purchaseorders_idx` int(11) NOT NULL,
PRIMARY KEY (`supplier_e_id`,`supplier_purchaseorders_idx`),
KEY `FK385305F971EF1FF4` (`purchaseorder_e_id`),
KEY `FK385305F91CF4B7B4` (`supplier_e_id`),
KEY `Supplier_purchaseOrders` (`supplier_e_id`,`purchaseorder_e_id`),
CONSTRAINT `FK385305F91CF4B7B4` FOREIGN KEY (`supplier_e_id`) REFERENCES `supplier` (`addressable_e_id`),
CONSTRAINT `FK385305F971EF1FF4` FOREIGN KEY (`purchaseorder_e_id`) REFERENCES `purchaseorder` (`baseorder_e_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `theaddresstable` (
`idcol` bigint(20) NOT NULL AUTO_INCREMENT,
`resource_id` varchar(255) DEFAULT NULL,
`container_id` varchar(255) DEFAULT NULL,
`version` int(11) DEFAULT NULL,
`commit_TimeStamp` bigint(20) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`street` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
PRIMARY KEY (`idcol`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1
CDOResource
1
lhttp://www.eclipse.org/emf/CDO/Eresource/4.0.0#CDOResource#1
NULL
NULL
NULL
NULL
http://www.eclipse.org/emf/2002/Ecore
NULL
http://www.eclipse.org/emf/2002/Ecore
0
http://www.eclipse.org/emf/CDO/Eresource/4.0.0
NULL
http://www.eclipse.org/emf/CDO/Eresource/4.0.0
0
http://www.eclipse.org/emf/CDO/Etypes/4.0.0
NULL
http://www.eclipse.org/emf/CDO/Etypes/4.0.0
0
http://www.eclipse.org/emf/CDO/examples/company/1.0.0
NULL
http://www.eclipse.org/emf/CDO/examples/company/1.0.0
0
http://www.eclipse.org/emf/2002/Ecore
1343295660923
http://www.eclipse.org/emf/CDO/Eresource/4.0.0
1343295660923
http://www.eclipse.org/emf/CDO/Etypes/4.0.0
1343295660923
http://www.eclipse.org/emf/CDO/examples/company/1.0.0
1343295716783