Revision 8594
Added by Aaron Marcuse-Kubitza over 11 years ago
schemas/VegCore/VegCore.my.sql | ||
---|---|---|
1119 | 1119 |
COLLATE = latin1_swedish_ci; |
1120 | 1120 |
|
1121 | 1121 |
|
1122 |
-- ----------------------------------------------------- |
|
1123 |
-- Table `organization` |
|
1124 |
-- ----------------------------------------------------- |
|
1125 |
CREATE TABLE IF NOT EXISTS `organization` ( |
|
1126 |
`id` TEXT NOT NULL , |
|
1127 |
`info` SET('hstore') NULL , |
|
1128 |
PRIMARY KEY (`id`) , |
|
1129 |
CONSTRAINT `fk_organization_party1` |
|
1130 |
FOREIGN KEY (`id` ) |
|
1131 |
REFERENCES `party` (`id` ) |
|
1132 |
ON DELETE CASCADE |
|
1133 |
ON UPDATE CASCADE) |
|
1134 |
ENGINE = InnoDB |
|
1135 |
DEFAULT CHARACTER SET = latin1 |
|
1136 |
COLLATE = latin1_swedish_ci; |
|
1122 | 1137 |
|
1138 |
|
|
1139 |
|
|
1123 | 1140 |
SET SQL_MODE=@OLD_SQL_MODE; |
1124 | 1141 |
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; |
1125 | 1142 |
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: added organization