
-- -----------------------------------------------------
-- Data for table `GroundworkActivity`
-- -----------------------------------------------------
START TRANSACTION;
USE `gardennotebook`;
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'pruning', NULL, DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'spraying', NULL, DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'manuring', NULL, DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'weeding', NULL, DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'clearing', NULL, DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'digging', NULL, DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'plant support', 'Erecting any form of plant support', DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'mulching', NULL, DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'greenhouse', 'Any work on a greenhouse, e.g. cleaning', DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'pest control', 'Any activity concerned with pest control', DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'compost', NULL, DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'liming', 'Applying garden lime to the soil to reduce acidity', DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'mowing', NULL, DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'hedge trimming', NULL, DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'cloche', NULL, DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'watering', NULL, DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'soil conditioning', 'Applying any form of soil treatment, specifically chemical (e.g. potash)', DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'scarify', 'Rake out the \'thatch\' in a lawn', DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'aerate', 'Make (many) small holes in a lawn to improve drainage', DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'feeding', 'Any activity to feed established plants', DEFAULT, DEFAULT);
INSERT INTO `groundworkactivity` (`groundWorkActivityId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'strimming', 'Use of strimmer, e.g. to tidy round edge of lawn', DEFAULT, DEFAULT);

COMMIT;


-- -----------------------------------------------------
-- Data for table `CropRotationGroup`
-- -----------------------------------------------------
START TRANSACTION;
USE `gardennotebook`;
INSERT INTO `croprotationgroup` (`cropRotationGroupId`, `subsequentCropGroupId`, `name`, `description`, `lastUpdated`, `created`) VALUES (6, NULL, 'Fillers', 'Crops less susceptible to disease build up', DEFAULT, DEFAULT);
INSERT INTO `croprotationgroup` (`cropRotationGroupId`, `subsequentCropGroupId`, `name`, `description`, `lastUpdated`, `created`) VALUES (5, null, 'Alliums', 'Garlic, leeks, onions, shallots', DEFAULT, DEFAULT);
INSERT INTO `croprotationgroup` (`cropRotationGroupId`, `subsequentCropGroupId`, `name`, `description`, `lastUpdated`, `created`) VALUES (4, 5, 'Root vegetables', 'Beetroot, carrot, celeriac, celery, parsley, parsnip, etc', DEFAULT, DEFAULT);
INSERT INTO `croprotationgroup` (`cropRotationGroupId`, `subsequentCropGroupId`, `name`, `description`, `lastUpdated`, `created`) VALUES (3, 4, 'Potatoes', NULL, DEFAULT, DEFAULT);
INSERT INTO `croprotationgroup` (`cropRotationGroupId`, `subsequentCropGroupId`, `name`, `description`, `lastUpdated`, `created`) VALUES (2, 3, 'Brassicas', 'Brussels sprouts, cabbage, cauliflower, kale, oriental greens, kohl-rabi, radish, swede, turnips', DEFAULT, DEFAULT);
INSERT INTO `croprotationgroup` (`cropRotationGroupId`, `subsequentCropGroupId`, `name`, `description`, `lastUpdated`, `created`) VALUES (1, 2, 'Legumes', 'Peas and all beans', DEFAULT, DEFAULT);

UPDATE `croprotationgroup` SET `subsequentCropGroupId` = 1 WHERE `cropRotationGroupId` = 5;

COMMIT;

-- -----------------------------------------------------
-- Data for table `Location`
-- -----------------------------------------------------
START TRANSACTION;
USE `gardennotebook`;
INSERT INTO `location` (`locationId`, `parentLocationId`, `name`, `description`, `underCover`, `geometry`, `lastUpdated`, `created`) VALUES (1, NULL, 'The Garden', '', DEFAULT, ST_GeomFromText("POLYGON((0 0, 0 100, 100 100, 100 0, 0 0))"), DEFAULT, DEFAULT);

COMMIT;


-- -----------------------------------------------------
-- Data for table `ProductCategory`
-- -----------------------------------------------------
START TRANSACTION;
USE `gardennotebook`;
INSERT INTO `productcategory` (`productCategoryId`, `name`, `description`, `plantLike`, `lastUpdated`, `created`) VALUES (DEFAULT,  'potted plants', NULL, 1, DEFAULT, DEFAULT);
INSERT INTO `productcategory` (`productCategoryId`, `name`, `description`, `plantLike`, `lastUpdated`, `created`) VALUES (DEFAULT,  'sundries', 'anything not covered elsewhere', 0, DEFAULT, DEFAULT);
INSERT INTO `productcategory` (`productCategoryId`, `name`, `description`, `plantLike`, `lastUpdated`, `created`) VALUES (DEFAULT,  'tubers', 'tubers, bulbs, corms, etc', 1, DEFAULT, DEFAULT);
INSERT INTO `productcategory` (`productCategoryId`, `name`, `description`, `plantLike`, `lastUpdated`, `created`) VALUES (DEFAULT,  'seed', NULL, 1, DEFAULT, DEFAULT);
INSERT INTO `productcategory` (`productCategoryId`, `name`, `description`, `plantLike`, `lastUpdated`, `created`) VALUES (DEFAULT,  'planting media', 'compost, etc', 0, DEFAULT, DEFAULT);
INSERT INTO `productcategory` (`productCategoryId`, `name`, `description`, `plantLike`, `lastUpdated`, `created`) VALUES (DEFAULT,  'plug plants', 'also plants in strips', 1, DEFAULT, DEFAULT);
INSERT INTO `productcategory` (`productCategoryId`, `name`, `description`, `plantLike`, `lastUpdated`, `created`) VALUES (DEFAULT,  'fertilisers', 'Growmore, manure, compost accelerators', 0, DEFAULT, DEFAULT);
INSERT INTO `productcategory` (`productCategoryId`, `name`, `description`, `plantLike`, `lastUpdated`, `created`) VALUES (DEFAULT,  'pest control', 'animal, fungal, etc', 0, DEFAULT, DEFAULT);
INSERT INTO `productcategory` (`productCategoryId`, `name`, `description`, `plantLike`, `lastUpdated`, `created`) VALUES (DEFAULT,  'tools', NULL, 0, DEFAULT, DEFAULT);
INSERT INTO `productcategory` (`productCategoryId`, `name`, `description`, `plantLike`, `lastUpdated`, `created`) VALUES (DEFAULT,  'labour', NULL, 0, DEFAULT, DEFAULT);
INSERT INTO `productcategory` (`productCategoryId`, `name`, `description`, `plantLike`, `lastUpdated`, `created`) VALUES (DEFAULT,  'bare root plants', NULL, 1, DEFAULT, DEFAULT);
INSERT INTO `productcategory` (`productCategoryId`, `name`, `description`, `plantLike`, `lastUpdated`, `created`) VALUES (DEFAULT,  'root ball plants', 'plants supplied in a root ball', 1, DEFAULT, DEFAULT);

COMMIT;


-- -----------------------------------------------------
-- Data for table `HusbandryClass`
-- -----------------------------------------------------
START TRANSACTION;
USE `gardennotebook`;
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'sow', 'when seeds are sown', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'pot up', 'when seedlings are transferred to their first pot', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'pot on', 'when a plant is repotted in a larger pot', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'germination', 'when seeds are seen to germinate, usually use \'emergence\'', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'emergence', 'when seedlings first appear above ground', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'plant out', 'when plants are moved to their final position', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'harden off', 'the hardening off process for new plants', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'flowering', 'when a plant flowers', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'fruiting', 'when a plant sets fruit', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'harvest', 'when a crop is taken from a plant', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'bud break', 'leaf or flower bud', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'observation', 'an observation on the progress of a crop', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'chit', 'usually for potatoes, when a tuber is brought into growth before planting', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'failure', 'when one or more plants fails to thrive or grow', 1, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'abandoned', 'when one or more plants are discarded, possibly due to failure or being surplus', 1, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'earth up', 'usually for potatoes', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'thin out', 'reducing fruit load on a plant or reducing overcrowding of plants', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'transplant', NULL, DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'prune', 'removing excess growth from a plant, usually fruit trees', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'prick out', 'when seedlings are transferred to their first pot (see pot up)', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'repot', 'when a potted plant is moved to a new pot', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'discarded', 'when plants are discarded as unwanted (e.g. excess sown)', 1, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'death', 'to record the death of a plant for whatever reason', 1, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'heel in', 'when a new plant, usually bare-root, cannot be properly planted, loosely plant it in a convenient bed or pot', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'collect seed', 'collect the seed either to eat (e.g. fennel) or to sow for a new crop (e.g. tomatoes)', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'take cutting', 'make a cutting of some sort for propagation', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'cut back', 'reduce size of a plant for a variety of reasons', DEFAULT, DEFAULT, DEFAULT);
INSERT INTO `husbandryclass` (`husbandryClassId`, `name`, `description`, `terminal`, `lastUpdated`, `created`) VALUES (DEFAULT, 'pinch out', 'remove the growing tip from a young plant to encourage bushy growth', DEFAULT, DEFAULT, DEFAULT);


COMMIT;


-- -----------------------------------------------------
-- Data for table `AfflictionClass`
-- -----------------------------------------------------
START TRANSACTION;
USE `gardennotebook`;
INSERT INTO `afflictionclass` (`afflictionClassId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'pest', 'any insect or animal which harms the crop', DEFAULT, DEFAULT);
INSERT INTO `afflictionclass` (`afflictionClassId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'disease', 'any pathogen of the plant, fungal, viral, etc', DEFAULT, DEFAULT);
INSERT INTO `afflictionclass` (`afflictionClassId`, `name`, `description`, `lastUpdated`, `created`) VALUES (DEFAULT, 'death', 'any cause of death', DEFAULT, DEFAULT);

COMMIT;


COMMIT;

