CREATE TABLE `gmcropdatabase_companies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `countryId` int(11) NOT NULL,
  `code` varchar(64) NOT NULL DEFAULT '',
  `name` varchar(128) NOT NULL,
  `address1` varchar(50) DEFAULT NULL,
  `address2` varchar(50) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `zip` varchar(50) DEFAULT NULL,
  `telephone` varchar(50) DEFAULT NULL,
  `facsimile` varchar(50) DEFAULT NULL,
  `contact` varchar(50) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `web` varchar(50) DEFAULT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `code` (`code`),
  KEY `countryId` (`countryId`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_countries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(64) NOT NULL,
  `name` varchar(50) NOT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `code` (`code`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_countries_authorities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `countryId` int(11) NOT NULL,
  `name` varchar(128) DEFAULT NULL,
  `address1` varchar(128) DEFAULT NULL,
  `address2` varchar(128) DEFAULT NULL,
  `city` varchar(64) DEFAULT NULL,
  `state` varchar(16) DEFAULT NULL,
  `zip` varchar(16) DEFAULT NULL,
  `telephone` varchar(32) DEFAULT NULL,
  `facsimile` varchar(32) DEFAULT NULL,
  `email` varchar(128) DEFAULT NULL,
  `contact` varchar(128) DEFAULT NULL,
  `web` varchar(128) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `countryId` (`countryId`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_donors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(64) NOT NULL,
  `name` varchar(128) DEFAULT NULL,
  `pathogenicity` text,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `geneCode` varchar(64) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `code` (`code`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL,
  `uniqueCode` varchar(255) DEFAULT NULL,
  `trialCode` varchar(50) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `hostId` int(11) DEFAULT NULL,
  `varietyId` int(11) DEFAULT NULL,
  `traitId` int(11) DEFAULT NULL,
  `timId` int(11) DEFAULT NULL,
  `usageId` int(11) DEFAULT NULL,
  `showAbstract` enum('Y','N') DEFAULT 'N',
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `developerId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `code` (`code`),
  KEY `hostId` (`hostId`),
  KEY `varietyId` (`varietyId`),
  KEY `traitId` (`traitId`),
  KEY `timId` (`timId`),
  KEY `usageId` (`usageId`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_events_authorizations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eventId` int(11) NOT NULL,
  `countryId` int(11) NOT NULL,
  `environment` datetime DEFAULT NULL,
  `foodfeed` datetime DEFAULT NULL,
  `food` datetime DEFAULT NULL,
  `feed` datetime DEFAULT NULL,
  `marketing` datetime DEFAULT NULL,
  `pending` datetime DEFAULT NULL,
  `notes` varchar(500) DEFAULT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `eventId` (`eventId`),
  KEY `countryId` (`countryId`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_events_bibliography` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eventId` int(11) NOT NULL,
  `bibliographyId` int(11) NOT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `eventId` (`eventId`),
  KEY `bibliographyId` (`bibliographyId`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_events_companies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eventId` int(11) NOT NULL,
  `companyId` int(11) NOT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `eventId` (`eventId`),
  KEY `companyId` (`companyId`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_events_descriptions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eventId` int(11) NOT NULL,
  `short` text,
  `long` longtext,
  `source` varchar(255) DEFAULT NULL,
  `trialCode` varchar(20) DEFAULT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `eventId` (`eventId`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_events_documents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eventId` int(11) NOT NULL,
  `type` enum('Document','Figure','Detection','Biological') DEFAULT 'Document',
  `description` varchar(255) NOT NULL,
  `content` varchar(255) NOT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `eventId` (`eventId`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_events_esafeties` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eventId` int(11) NOT NULL,
  `description` longtext NOT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `eventId` (`eventId`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_events_execsummaries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eventId` int(11) NOT NULL,
  `description` longtext NOT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `eventId` (`eventId`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_events_fsafeties` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eventId` int(11) NOT NULL,
  `description` longtext NOT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `eventId` (`eventId`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_events_genes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eventId` int(11) NOT NULL,
  `code` varchar(64) NOT NULL,
  `abbrCode` varchar(50) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(50) DEFAULT NULL,
  `lType` varchar(50) DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  `promoter` varchar(255) DEFAULT NULL,
  `effector` varchar(255) DEFAULT NULL,
  `terminator` varchar(255) DEFAULT NULL,
  `copies` varchar(50) DEFAULT NULL,
  `form` varchar(255) DEFAULT NULL,
  `srcCode` varchar(64) DEFAULT NULL,
  `eCLink` varchar(255) DEFAULT NULL,
  `description` text,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `eventId` (`eventId`),
  KEY `code` (`code`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_events_introductions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eventId` int(11) NOT NULL,
  `description` longtext NOT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `eventId` (`eventId`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_events_links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eventId` int(11) DEFAULT NULL,
  `countryId` int(11) DEFAULT NULL,
  `category` varchar(255) NOT NULL,
  `description` varchar(500) NOT NULL,
  `link` varchar(255) NOT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `eventId` (`eventId`),
  KEY `countryId` (`countryId`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_events_modifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eventId` int(11) NOT NULL,
  `description` longtext NOT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `eventId` (`eventId`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_events_properties` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eventId` int(11) NOT NULL,
  `description` longtext NOT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `eventId` (`eventId`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_hosts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(64) NOT NULL DEFAULT '',
  `latin` varchar(64) DEFAULT NULL,
  `common` varchar(64) DEFAULT NULL,
  `biology` text,
  `origin` text,
  `diversity` text,
  `toxins` text,
  `allergens` text,
  `about` text,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `code` (`code`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_tims` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(64) NOT NULL,
  `description` varchar(128) NOT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `code` (`code`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_traits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(64) NOT NULL,
  `shortDesc` varchar(50) DEFAULT NULL,
  `description` text,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `code` (`code`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_usages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(64) NOT NULL,
  `description` varchar(255) NOT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `code` (`code`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `gmcropdatabase_varieties` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(64) NOT NULL,
  `name` varchar(50) NOT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `code` (`code`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;






INSERT INTO `page_pages` ( `parentId`, `keyword`, `status`, `type`, `route`, `template`, `created`, `updated`) VALUES
(0, 'GMCropDatabase', 'Enabled', 'Module', 'gmcropdatabase', 'inner', NOW(), NOW());
INSERT INTO `page_pages_i18n` (`id`, `label`, `content`, `header`, `metaTitle`, `metaDescr`, `metaKeywords`, `locale`) VALUES 
(LAST_INSERT_ID(), 'GM Crop Database', 'GM Crop Database', 'GM Crop Database', 'GM Crop Database', 'GM Crop Database', 'GM Crop Database', 'en_US');

INSERT INTO `page_pages` ( `parentId`, `keyword`, `status`, `type`, `route`, `template`, `created`, `updated`) VALUES
(0, 'GMCropDatabaseResult', 'Enabled', 'Module', 'gmcropdatabaseresult', 'inner', NOW(), NOW());
INSERT INTO `page_pages_i18n` (`id`, `label`, `content`, `header`, `metaTitle`, `metaDescr`, `metaKeywords`, `locale`) VALUES 
(LAST_INSERT_ID(), 'GM Crop Database Result', 'GM Crop Database Result', 'GM Crop Database Result', 'GM Crop Database Result', 'GM Crop Database Result', 'GM Crop Database Result', 'en_US');

INSERT INTO `page_pages` ( `parentId`, `keyword`, `status`, `type`, `route`, `template`, `created`, `updated`) VALUES
(0, 'GMCropDatabaseEvent', 'Enabled', 'Module', 'gmcropdatabaseevent', 'inner', NOW(), NOW());
INSERT INTO `page_pages_i18n` (`id`, `label`, `content`, `header`, `metaTitle`, `metaDescr`, `metaKeywords`, `locale`) VALUES 
(LAST_INSERT_ID(), 'Gm Crop Database Event', 'GM Crop Database Event', 'GM Crop Database Event', 'GM Crop Database Event', 'GM Crop Database Event', 'GM Crop Database Event', 'en_US');


INSERT INTO `widget_widgets` ( `block`, `layout`, `template`, `view`, `order`, `available`) VALUES ( 'widgets', 'inner', 'cera', 'widget/template/type-two', 0, 'specific');
INSERT INTO `widget_widgets_i18n` (`id`, `title`, `content`, `image`, `locale`) VALUES (LAST_INSERT_ID(), 'Output Options', '<p> </p>\n\n<div class="embedded" contenteditable="false" data-dafault-params="" data-disable-reload="false" data-embedded="gmcropdatabase-outputoptions" embedded-id="0" id="embedded" title="GM Crop Database / Product Output Options">\n<p id="embedded-text" style="background: none repeat scroll 0px 0px rgb(80, 140, 255); border-radius: 3px 3px 3px 3px; height: 28px; line-height: 28px; padding: 0px 16px; margin: 5px 0px; display: block; color: rgb(255, 255, 255); font-size: 12px; font-weight: bold;">GM Crop Database / Product Output Options</p>\n</div>', '', 'en_US');
INSERT INTO `widget_widgetPages` (`widgetId`, `pageId`) VALUES (LAST_INSERT_ID(), (SELECT id FROM `page_pages` WHERE `route` LIKE 'gmcropdatabaseevent' OR `route` LIKE 'gmcropdatabaseresult'));

INSERT INTO `widget_widgets` ( `block`, `layout`, `template`, `view`, `order`, `available`) VALUES ( 'widgets', 'inner', 'cera', 'widget/template/default', 1, 'specific');
INSERT INTO `widget_widgets_i18n` (`id`, `title`, `content`, `image`, `locale`) VALUES (LAST_INSERT_ID(), 'Product Related Info', '<div class="embedded" contenteditable="false" data-dafault-params="" data-disable-reload="false" data-embedded="gmcropdatabase-relatedproducts" embedded-id="0" id="embedded" title="GM Crop Database / Product Related Info">\n<p id="embedded-text" style="background: none repeat scroll 0px 0px rgb(80, 140, 255); border-radius: 3px 3px 3px 3px; height: 28px; line-height: 28px; padding: 0px 16px; margin: 5px 0px; display: block; color: rgb(255, 255, 255); font-size: 12px; font-weight: bold;">GM Crop Database / Product Related Info</p>\n</div>\n\n<p>&nbsp;</p>', '', 'en_US');
INSERT INTO `widget_widgetPages` (`widgetId`, `pageId`) VALUES (LAST_INSERT_ID(), (SELECT id FROM `page_pages` WHERE `route` LIKE 'gmcropdatabaseevent'));

INSERT INTO `widget_widgets` ( `block`, `layout`, `template`, `view`, `order`, `available`) VALUES ( 'widgets', 'inner', 'cera', 'widget/template/default', 2, 'specific');
INSERT INTO `widget_widgets_i18n` (`id`, `title`, `content`, `image`, `locale`) VALUES (LAST_INSERT_ID(), 'Synopsis', '<p> </p>\n\n<p><a href="/GmCropDatabase/synopsis">Overview of all products in database</a></p>', '', 'en_US');
INSERT INTO `widget_widgetPages` (`widgetId`, `pageId`) VALUES (LAST_INSERT_ID(), (SELECT id FROM `page_pages` WHERE `route` LIKE 'gmcropdatabase' OR `route` LIKE 'gmcropdatabaseresult'));

INSERT INTO `widget_widgets` ( `block`, `layout`, `template`, `view`, `order`, `available`) VALUES ( 'widgets', 'inner', 'cera', 'widget/template/default', 3, 'specific');
INSERT INTO `widget_widgets_i18n` (`id`, `title`, `content`, `image`, `locale`) VALUES (LAST_INSERT_ID(), 'Query Options', '<p> </p>\n\n<div class="embedded" contenteditable="false" data-dafault-params="" data-disable-reload="false" data-embedded="gmcropdatabase-gotoevent" embedded-id="0" id="embedded" title="GM Crop Database / Go To Event">\n<p id="embedded-text" style="background: none repeat scroll 0px 0px rgb(80, 140, 255); border-radius: 3px 3px 3px 3px; height: 28px; line-height: 28px; padding: 0px 16px; margin: 5px 0px; display: block; color: rgb(255, 255, 255); font-size: 12px; font-weight: bold;">GM Crop Database / Go To Event</p>\n</div>\n\n<p> </p>', '', 'en_US');
INSERT INTO `widget_widgetPages` (`widgetId`, `pageId`) VALUES (LAST_INSERT_ID(), (SELECT id FROM `page_pages` WHERE `route` LIKE 'gmcropdatabase' OR `route` LIKE 'gmcropdatabaseresult');

INSERT INTO `widget_widgets` ( `block`, `layout`, `template`, `view`, `order`, `available`) VALUES ( 'widgets', 'inner', 'cera', 'widget/template/default', 4, 'specific');
INSERT INTO `widget_widgets_i18n` (`id`, `title`, `content`, `image`, `locale`) VALUES (LAST_INSERT_ID(), 'Help', '<p> </p>\n\n<p><span class="text"><a class="lightBox-block" data-element="lightBox" data-text="%3Cdiv%20class%3D%22document-content%22%3E%0A%3Cp%3E%3Cb%3ECERA%26%2339%3Bs%20database%20of%20safety%20information%3C/b%3E%20%28formerly%20hosted%20by%20AGBIOS%29%20includes%20not%20only%20plants%20produced%20using%20recombinant%20DNA%20technologies%20%28e.g.%2C%20genetically%20engineered%20or%20transgenic%20plants%29%2C%20but%20also%20plants%20with%20novel%20traits%20that%20may%20have%20been%20produced%20using%20more%20traditional%20methods%2C%20such%20as%20accelerated%20mutagenesis%20or%20plant%20breeding.%20These%20latter%20plants%20are%20only%20regulated%20in%20Canada.%3C/p%3E%0A%0A%3Cp%3EAlso%2C%20please%20note%20that%20regulatory%20approval%20should%20not%20be%20interpreted%20as%20an%20indication%20that%20the%20product%20is%20in%20commercial%20production.%20There%20are%20many%20examples%20of%20products%20that%20were%20granted%20regulatory%20approval%20but%20were%20never%20commercialized%2C%20or%20if%20they%20were%2C%20have%20been%20subsequently%20discontinued.%3C/p%3E%0A%0A%3Cp%3EBy%20setting%20conditions%20for%20more%20than%20one%20criterion%20from%20the%20options%20below%2C%20you%20can%20construct%20boolean%20queries.%20For%20example%2C%20selecting%20%26quot%3Bmaize%26quot%3B%20as%20the%20crop%20plant%20and%20%26quot%3Bherbicide%20tolerance%26quot%3B%20as%20the%20trait%20will%20display%20a%20listing%20of%20herbicide%20tolerant%20maize%20products.%3C/p%3E%0A%0A%3Cp%3EThe%20values%20in%20the%20Event%20Name%20selection%20box%2C%20below%2C%20correspond%20to%20the%20identifiers%20commonly%20used%20by%20regulatory%20authorities%20and%20international%20organizations%2C%20such%20as%20the%20Organization%20for%20Economic%20Cooperation%20and%20Development%20%28OECD%29.%3C/p%3E%0A%0A%3Cp%3E%3Cb%3ECitation%20for%20the%20database%3C/b%3E%3A%20CERA.%20%282012%29.%20GM%20Crop%20Database.%20Center%20for%20Environmental%20Risk%20Assessment%20%28CERA%29%2C%20ILSI%20Research%20Foundation%2C%20Washington%20D.C.%3C/p%3E%0A%3C/div%3E%0A" href="#%20How%20To%20Use%20the%20GM%20Crop%20Database">How To Use the GM Crop Database</a></span></p>\n\n<p> </p>\n\n<p><span class="text"><img alt="" src="/themes/cera/images/pages/606392.jpg" style="width: 206px; height: 294px;" /></span></p>', '', 'en_US');
INSERT INTO `widget_widgetPages` (`widgetId`, `pageId`) VALUES (LAST_INSERT_ID(), (SELECT id FROM `page_pages` WHERE `route` LIKE 'gmcropdatabase' OR `route` LIKE 'gmcropdatabaseresult'));


