Project

General

Profile

« Previous | Next » 

Revision 8594

schemas/VegCore/VegCore.ERD.mwb: added organization

View differences:

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