ALTER TABLE `gmcropdatabase_events_genes` MODIFY `srcCode` varchar(64) DEFAULT NULL;
ALTER TABLE `gmcropdatabase_donors` ADD `geneCode` varchar(64) NOT NULL;
ALTER TABLE `gmcropdatabase_donors` DROP KEY `geneId`;
ALTER TABLE `gmcropdatabase_donors` DROP COLUMN `geneId`;

TRUNCATE gmcropdatabase_donors;

INSERT INTO `gmcropdatabase_donors` (`id`, `code`, `name`, `pathogenicity`, `created`, `updated`, `geneCode`) VALUES
(1, 'BTK', '<I>Bacillus thuringiensis</I> subsp. <I>kurstaki</I>', 'While target insects are susceptible to oral doses of <i>Bt</i> proteins, no evidence of toxic effects in laboratory mammals or birds given up to 10 µg protein/g body weight.', NULL, NULL, 'cry1Ab'),
(2, 'SVIR', '<I>Streptomyces viridochromogenes</I>', '<i>S. viridochromogenes</i> is ubiquitous in the soil. The spore chains are Spirales and the spore surface is spiny. The spore mass is blue, the reverse is green and its pigments are pH sensistive. It exhibits very slight antimicrobial activity, is inhibited by streptomycin, and there have been no reports of adverse affects on humans, animals, or plants.', NULL, NULL, 'pat'),
(3, 'BTKC', '<I>Bacillus thuringiensis</I> subsp. <I>kurstaki</I>', 'Although target insects are susceptible to oral doses of <i>Bt</i> proteins, there is no evidence of toxic effects in laboratory mammals or birds given up to 10 µg protein / g body wt. There are no significant mammalian toxins or allergens associated with the host organism.', NULL, NULL, 'cry1Ac'),
(4, 'SHYG', '<I>Streptomyces hygroscopicus</I>', '<i>S. hygroscopicus</i> is ubiquitous in the soil and there have been no reports of adverse affects on humans, animals, or plants.', NULL, NULL, 'bar'),
(5, 'CR9C', '<I>Bacillus thuringiensis</I> subsp. <I>tolworthi</I>', 'While target insects are susceptible to oral doses of <i>Bt</i> proteins, no evidence of acute toxicity in laboratory mammals, birds, or non-target beneficial insects has been reported. The Cry9C protein is resistant to heat and proteolytic degradation and may have allergenic potential', NULL, NULL, 'cry9c'),
(6, 'CP4EPS', '<I>Agrobacterium tumefaciens</I> strain CP4', '<i>A. tumefaciens</i> is a common soil bacterium that is responsible for causing crown gall disease in susceptible plants. There have been no reports of adverse affects on humans or animals.', NULL, NULL, 'CP4 epsps'),
(7, 'BT3A', '<I>Bacillus thuringiensis</I> subsp. <I>Tenebrionis</I>', 'While beetles and other coleopterans are susceptible to oral doses of Cry3A protein, there is no evidence of toxic effects in laboratory mammals or birds. There are no significant mammalian toxins or allergens associated with the host organism.', NULL, NULL, 'cry3A'),
(8, 'BTA', '<I>Bacillus thuringiensis</I> var. <I>aizawai</I>', 'While target insects are susceptible to oral doses of <i>Bt</i> proteins, no evidence of toxic effects in laboratory mammals or birds.', NULL, NULL, 'cry1F'),
(9, 'BT3B', '<i>Bacillus thuringiensis</i> subsp. <i>kumamotoensis</i>', 'While coleopterans are susceptible to oral doses of Cry3Bb1 protein, there is no evidence of toxic effects in laboratory mammals or birds. There are no significant mammalian toxins or allergens associated with the host organism.', NULL, NULL, 'cry3Bb1'),
(10, 'BXN', '<i>Klebsiella ozaenae</i>', 'Member of the <i>Enterobacteriaceae</i>, a group of facultative gramnegative bacteria, classified as a Class 2 microorganism. This class contains microorganisms that could potentially cause disease in humans, however no known pathogenicity exists for the subspecies <i>ozaenae</i>. <i>Klebsiella</i> bacteria are widely distributed in nature, occurring naturally in the soil, water and in grain and are normal inhabitants of the intestinal tract', NULL, NULL, 'bxn'),
(11, 'BTK2', '<I>Bacillus thuringiensis</I> subsp. <I>kurstaki</I>', 'While target insects are susceptible to oral doses of <i>Bt</i> proteins, no evidence of toxic effects in laboratory mammals or birds given up to 10 µg protein/g body weight.', NULL, NULL, 'cry2Ab2'),
(12, 'BTPS', '<i>Bacillus thuringiensis</i> strain PS149B1', 'While target insects are susceptible to oral doses of <i>Bt</i> proteins, there is no evidence of toxic effects in laboratory mammals, in birds or in non-target arthropods.', NULL, NULL, 'cry34Ab1/cry35Ab1'),
(13, 'BTVIP', '<i>Bacillus thuringiensis</i> strain AB88', 'While target lepidopteran insects are susceptible to oral doses of VIP proteins, there is no evidence of toxic effects in laboratory mammals, in birds, and in non-target arthropods, including beneficial insects.', NULL, NULL, 'vip3A'),
(14, 'STUB', '<i>Solanum tuberosum</i>', 'The <i>gbss</i> gene fragment sequences introduced to suppress endogenous GBSS expression have no homology with known toxins.', NULL, NULL, 'gbss');

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(), 'GmCropDatabaseEvent', 'GmCropDatabaseEvent', 'GmCropDatabaseEvent', 'GmCropDatabaseEvent', 'GmCropDatabaseEvent', 'GmCropDatabaseEvent', 'en_US');

