create database if not exists `FeedDatabase`;

USE `FeedDatabase`;

/*Table structure for table `tbl_attribgroups` */
DROP TABLE IF EXISTS `tbl_attribgroups`;
CREATE TABLE `tbl_attribgroups` (
  `ID_tbl_AttribGroups` int(10) unsigned NOT NULL auto_increment,
  `AG_Name_D` varchar(45) character set latin1 collate latin1_german1_ci default NULL,
  `AG_Name_F` varchar(45) character set latin1 collate latin1_german1_ci default NULL,
  `AG_Name_E` varchar(45) character set latin1 collate latin1_german1_ci default NULL,
  `AG_SourceType` char(1) character set latin1 collate latin1_german1_ci default NULL,
  PRIMARY KEY  (`ID_tbl_AttribGroups`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;


/*Table structure for table `tbl_attributes` */
DROP TABLE IF EXISTS `tbl_attributes`;
CREATE TABLE `tbl_attributes` (
  `ID_tbl_Attributes` int(10) unsigned NOT NULL auto_increment,
  `ref_AttribGroups` int(10) unsigned NOT NULL default '0',
  `A_Name_D` varchar(45) character set latin1 collate latin1_german1_ci default NULL,
  `A_Name_F` varchar(45) character set latin1 collate latin1_german1_ci default NULL,
  `A_Name_E` varchar(45) character set latin1 collate latin1_german1_ci default NULL,
  PRIMARY KEY  (`ID_tbl_Attributes`),
  KEY `tbl_Attributes_FKIndex1` (`ref_AttribGroups`)
) ENGINE=MyISAM AUTO_INCREMENT=252 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;


/*Table structure for table `tbl_componentgroups` */
DROP TABLE IF EXISTS `tbl_componentgroups`;
CREATE TABLE `tbl_componentgroups` (
  `ID_tbl_ComponentGroups` int(10) unsigned NOT NULL auto_increment,
  `CG_Name_D` varchar(120) character set latin1 collate latin1_german1_ci default NULL,
  `CG_Name_F` varchar(120) character set latin1 collate latin1_german1_ci default NULL,
  `CG_Name_E` varchar(120) character set latin1 collate latin1_german1_ci default NULL,
  `ref_Species` int(10) unsigned default NULL,
  `CG_outputorder` int(3) default NULL,
  PRIMARY KEY  (`ID_tbl_ComponentGroups`),
  KEY `tbl_ComponentGroups_FKIndex1` (`ref_Species`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;


/*Table structure for table `tbl_components` */

/* !!!!!!!!!! in this table nutrient types are stored !!!!!!!!!!!!!!!! */

DROP TABLE IF EXISTS `tbl_components`;
CREATE TABLE `tbl_components` (
  `ID_tbl_Components` int(10) unsigned NOT NULL auto_increment,
  `ref_ComponentGroups` int(10) unsigned NOT NULL,
  `C_Name_D` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
  `C_Name_F` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
  `C_Name_E` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
  `C_Token_D` varchar(45) character set latin1 collate latin1_german1_ci default NULL,
  `C_Token_F` varchar(45) character set latin1 collate latin1_german1_ci default NULL,
  `C_Token_E` varchar(45) character set latin1 collate latin1_german1_ci default NULL,
  `C_std_decimalplace` int(1) default NULL,
  `C_PlausibilityCheckFormula` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
  `ref_terms` int(10) unsigned default NULL,
  `C_OutputOrder` int(11) default NULL,
  PRIMARY KEY  (`ID_tbl_Components`),
  KEY `tblComponents_FKIndex2` (`ref_ComponentGroups`)
) ENGINE=MyISAM AUTO_INCREMENT=252 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;

/*Table structure for table `tbl_compprofiles` */
DROP TABLE IF EXISTS `tbl_compprofiles`;
CREATE TABLE `tbl_compprofiles` (
  `ref_Components` int(11) NOT NULL,
  `ref_Profiles` int(11) NOT NULL,
  KEY `ref_Components` (`ref_Components`,`ref_Profiles`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;


/*Table structure for table `tbl_datainput` */
DROP TABLE IF EXISTS `tbl_datainput`;
CREATE TABLE `tbl_datainput` (
  `ID_tbl_DataInput` int(10) unsigned NOT NULL auto_increment,
  `ref_FeedSpecNr` int(10) unsigned NOT NULL,
  `DI_SourceType` int(2) unsigned NOT NULL,
  `ref_tbl_Formulas` varchar(50) character set latin1 collate latin1_german1_ci default NULL,
  `ref_Components` int(10) unsigned default NULL,
  `ref_Units` int(10) unsigned default NULL,
  `DI_Value` varchar(20) character set latin1 collate latin1_german1_ci default NULL,
  `DI_Range` varchar(50) character set latin1 collate latin1_german1_ci default NULL,
  `DI_decimalplace` int(1) unsigned default NULL,
  `DI_SD` float default NULL,
  `DI_NumberOfValues` int(10) default NULL,
  `ref_terms` int(10) unsigned default NULL,
  `DI_timestamp` timestamp NULL default NULL,
  PRIMARY KEY  (`ID_tbl_DataInput`),
  KEY `tbl_DataInput_FKIndex2` (`ref_tbl_Formulas`),
  KEY `tbl_DataInput_FKIndex1` (`ref_FeedSpecNr`)
) ENGINE=MyISAM AUTO_INCREMENT=244772 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


/*Table structure for table `tbl_feed` */
DROP TABLE IF EXISTS `tbl_feed`;
CREATE TABLE `tbl_feed` (
  `F_FeedSpecNr` int(10) unsigned NOT NULL,
  `ref_FeedGroup` int(10) unsigned NOT NULL default '0',
  `F_Name_D` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
  `F_Name_F` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
  `F_Name_E` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
  `ref_terms` int(10) unsigned default NULL,
  PRIMARY KEY  (`F_FeedSpecNr`),
  KEY `tblFeed_FKIndex1` (`ref_FeedGroup`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;


/*Table structure for table `tbl_feedattributes` */
DROP TABLE IF EXISTS `tbl_feedattributes`;
CREATE TABLE `tbl_feedattributes` (
  `ID_tbl_FeedAttributes` int(10) unsigned NOT NULL auto_increment,
  `ref_Feed` int(10) unsigned NOT NULL default '0',
  `ref_Attributes` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ID_tbl_FeedAttributes`),
  KEY `tbl_FeedAttributes_FKIndex1` (`ref_Attributes`),
  KEY `tbl_FeedAttributes_FKIndex2` (`ref_Feed`)
) ENGINE=MyISAM AUTO_INCREMENT=731 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;

/*Table structure for table `tbl_feedcomponents` */

/*!!!!!!!!!! in this table aggregated measures are stored  !!!!!!!!!!!*/

DROP TABLE IF EXISTS `tbl_feedcomponents`;
CREATE TABLE `tbl_feedcomponents` (
  `ID_tbl_FeedComponents` int(10) unsigned NOT NULL auto_increment,
  `ref_Units` int(11) NOT NULL,
  `ref_QualityParameter` int(10) unsigned NOT NULL,
  `ref_Feed` int(10) unsigned NOT NULL default '0',
  `ref_Components` int(10) unsigned NOT NULL default '0',
  `FC_Value` varchar(128) character set latin1 collate latin1_german1_ci default NULL,
  `FC_Value_notrounded` float default NULL,
  PRIMARY KEY  (`ID_tbl_FeedComponents`),
  KEY `tbl_FeedComponents_FKIndex3` (`ref_Components`),
  KEY `tbl_FeedComponents_FKIndex6` (`ref_QualityParameter`),
  KEY `tbl_FeedComponents_FKIndex4` (`ref_Units`),
  KEY `tbl_FeedComponents_FKIndex5` (`ref_Feed`)
) ENGINE=MyISAM AUTO_INCREMENT=344270 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;


/*Table structure for table `tbl_feedgroup` */
DROP TABLE IF EXISTS `tbl_feedgroup`;
CREATE TABLE `tbl_feedgroup` (
  `ID_tbl_FeedGroup` int(10) unsigned NOT NULL auto_increment,
  `FG_Name_D` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
  `FG_Name_F` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
  `FG_Name_E` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
  `FG_ParentGroup` int(10) unsigned default NULL,
  `FG_OutputLine` int(10) unsigned default NULL,
  `FG_OutputLevel` int(10) unsigned default NULL,
  PRIMARY KEY  (`ID_tbl_FeedGroup`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;


/*Table structure for table `tbl_formulas` */
DROP TABLE IF EXISTS `tbl_formulas`;
CREATE TABLE `tbl_formulas` (
  `ID_tbl_Formulas` varchar(50) character set latin1 collate latin1_german1_ci NOT NULL,
  `F_Expression` varchar(5120) character set latin1 collate latin1_german1_ci default NULL,
  `F_Runlevel` int(10) unsigned default '1',
  `F_Description` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
  PRIMARY KEY  (`ID_tbl_Formulas`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;


/*Table structure for table `tbl_profiles` */
DROP TABLE IF EXISTS `tbl_profiles`;
CREATE TABLE `tbl_profiles` (
  `ID_tbl_Profiles` int(11) NOT NULL auto_increment,
  `P_Name_D` varchar(255) collate latin1_german1_ci default NULL,
  `P_Name_F` varchar(255) collate latin1_german1_ci default NULL,
  `P_Name_E` varchar(255) collate latin1_german1_ci default NULL,
  `P_public` tinyint(1) default '1',
  PRIMARY KEY  (`ID_tbl_Profiles`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;


/*Table structure for table `tbl_qualityparameter` */
DROP TABLE IF EXISTS `tbl_qualityparameter`;
CREATE TABLE `tbl_qualityparameter` (
  `ID_tbl_QualityParameter` int(10) unsigned NOT NULL auto_increment,
  `QP_SD` float default NULL,
  `QP_NumberOfValues` int(10) unsigned default NULL,
  `QP_Decimalplaces` int(1) default NULL,
  `QP_ValueType` int(10) unsigned default NULL,
  `QP_Formula` varchar(255) character set latin1 collate latin1_german1_ci default NULL,
  `QP_ModificationDate` varchar(30) character set latin1 collate latin1_german1_ci default NULL,
  `QP_autoRemarks` varchar(512) character set latin1 collate latin1_german1_ci default NULL,
  `ref_terms` int(10) unsigned default NULL,
  PRIMARY KEY  (`ID_tbl_QualityParameter`)
) ENGINE=MyISAM AUTO_INCREMENT=344270 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


/*Table structure for table `tbl_species` */
DROP TABLE IF EXISTS `tbl_species`;
CREATE TABLE `tbl_species` (
  `ID_tbl_Species` int(10) unsigned NOT NULL auto_increment,
  `S_Name_D` varchar(45) character set latin1 collate latin1_german1_ci default NULL,
  `S_Name_F` varchar(45) character set latin1 collate latin1_german1_ci default NULL,
  `S_Name_E` varchar(45) character set latin1 collate latin1_german1_ci default NULL,
  PRIMARY KEY  (`ID_tbl_Species`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;

/*Table structure for table `tbl_unitgroups` */
DROP TABLE IF EXISTS `tbl_unitgroups`;
CREATE TABLE `tbl_unitgroups` (
  `ID_tbl_UnitGroups` int(10) unsigned NOT NULL auto_increment,
  `UG_Name_D` varchar(45) collate latin1_german1_ci default NULL,
  `UG_Name_F` varchar(45) collate latin1_german1_ci default NULL,
  `UG_Name_E` varchar(45) collate latin1_german1_ci default NULL,
  PRIMARY KEY  (`ID_tbl_UnitGroups`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

/*Table structure for table `tbl_units` */
DROP TABLE IF EXISTS `tbl_units`;
CREATE TABLE `tbl_units` (
  `ID_tbl_Units` int(11) NOT NULL auto_increment,
  `ref_UnitGroups` int(10) unsigned NOT NULL,
  `U_token_D` varchar(45) collate latin1_german1_ci default NULL,
  `U_token_F` varchar(45) collate latin1_german1_ci default NULL,
  `U_token_E` varchar(45) collate latin1_german1_ci default NULL,
  `U_kgConverter` int(10) unsigned default NULL,
  PRIMARY KEY  (`ID_tbl_Units`),
  KEY `tbl_Units_FKIndex1` (`ref_UnitGroups`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;