Revision 8532
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 662 | 662 |
|
| 663 | 663 |
|
| 664 | 664 |
-- ----------------------------------------------------- |
| 665 |
-- Table `subplot`
|
|
| 665 |
-- Table `plot` |
|
| 666 | 666 |
-- ----------------------------------------------------- |
| 667 |
CREATE TABLE IF NOT EXISTS `subplot` (
|
|
| 667 |
CREATE TABLE IF NOT EXISTS `plot` ( |
|
| 668 | 668 |
`id` TEXT NOT NULL , |
| 669 | 669 |
PRIMARY KEY (`id`) , |
| 670 | 670 |
CONSTRAINT `fk_subplot_location1` |
| ... | ... | |
| 678 | 678 |
|
| 679 | 679 |
|
| 680 | 680 |
-- ----------------------------------------------------- |
| 681 |
-- Table `subplot` |
|
| 682 |
-- ----------------------------------------------------- |
|
| 683 |
CREATE TABLE IF NOT EXISTS `subplot` ( |
|
| 684 |
`id` TEXT NOT NULL , |
|
| 685 |
PRIMARY KEY (`id`) , |
|
| 686 |
CONSTRAINT `fk_subplot_plot1` |
|
| 687 |
FOREIGN KEY (`id` ) |
|
| 688 |
REFERENCES `plot` (`id` ) |
|
| 689 |
ON DELETE CASCADE |
|
| 690 |
ON UPDATE CASCADE) |
|
| 691 |
ENGINE = InnoDB |
|
| 692 |
DEFAULT CHARACTER SET = latin1 |
|
| 693 |
COLLATE = latin1_swedish_ci; |
|
| 694 |
|
|
| 695 |
|
|
| 696 |
-- ----------------------------------------------------- |
|
| 681 | 697 |
-- Table `geovalidation` |
| 682 | 698 |
-- ----------------------------------------------------- |
| 683 | 699 |
CREATE TABLE IF NOT EXISTS `geovalidation` ( |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: added plot subclass of location