Project

General

Profile

« Previous | Next » 

Revision 8623

schemas/VegCore/VegCore.ERD.mwb: re-synced with VegCore.my.sql: step 1: table order changed

View differences:

schemas/VegCore/VegCore.my.sql
4 4

  
5 5

  
6 6
-- -----------------------------------------------------
7
-- Table `party`
8
-- -----------------------------------------------------
9
CREATE  TABLE IF NOT EXISTS `party` (
10
  `id` VARBINARY(767) NOT NULL ,
11
  `info` SET('hstore') NULL ,
12
  PRIMARY KEY (`id`) ,
13
  CONSTRAINT `fk_collection_source10`
14
    FOREIGN KEY (`id` )
15
    REFERENCES `record` (`id` )
16
    ON DELETE CASCADE
17
    ON UPDATE CASCADE)
18
ENGINE = InnoDB
19
DEFAULT CHARACTER SET = utf8
20
COLLATE = utf8_bin;
21

  
22

  
23
-- -----------------------------------------------------
24 7
-- Table `source`
25 8
-- -----------------------------------------------------
26 9
CREATE  TABLE IF NOT EXISTS `source` (
......
76 59

  
77 60

  
78 61
-- -----------------------------------------------------
62
-- Table `party`
63
-- -----------------------------------------------------
64
CREATE  TABLE IF NOT EXISTS `party` (
65
  `id` VARBINARY(767) NOT NULL ,
66
  `info` SET('hstore') NULL ,
67
  PRIMARY KEY (`id`) ,
68
  CONSTRAINT `fk_collection_source10`
69
    FOREIGN KEY (`id` )
70
    REFERENCES `record` (`id` )
71
    ON DELETE CASCADE
72
    ON UPDATE CASCADE)
73
ENGINE = InnoDB
74
DEFAULT CHARACTER SET = utf8
75
COLLATE = utf8_bin;
76

  
77

  
78
-- -----------------------------------------------------
79 79
-- Table `relationship`
80 80
-- -----------------------------------------------------
81 81
CREATE  TABLE IF NOT EXISTS `relationship` (
......
107 107

  
108 108

  
109 109
-- -----------------------------------------------------
110
-- Table `taxon_name`
110
-- Table `collection`
111 111
-- -----------------------------------------------------
112
CREATE  TABLE IF NOT EXISTS `taxon_name` (
112
CREATE  TABLE IF NOT EXISTS `collection` (
113 113
  `id` VARBINARY(767) NOT NULL ,
114
  `unique_name` VARBINARY(767) NOT NULL ,
115
  `formal_name` VARBINARY(767) NULL ,
116
  `taxon_name` VARBINARY(767) NULL ,
117
  `author` VARBINARY(767) NULL ,
118
  `common_name` VARBINARY(767) NULL ,
119
  `rank` VARBINARY(767) NULL ,
120 114
  PRIMARY KEY (`id`) ,
121
  INDEX `fk_taxon_concept_taxon_string10_idx` (`unique_name` ASC) ,
122
  CONSTRAINT `fk_taxon_record10`
115
  CONSTRAINT `fk_collection_source1`
123 116
    FOREIGN KEY (`id` )
117
    REFERENCES `source` (`id` )
118
    ON DELETE CASCADE
119
    ON UPDATE CASCADE)
120
ENGINE = InnoDB
121
DEFAULT CHARACTER SET = utf8
122
COLLATE = utf8_bin;
123

  
124

  
125
-- -----------------------------------------------------
126
-- Table `taxon_assertion`
127
-- -----------------------------------------------------
128
CREATE  TABLE IF NOT EXISTS `taxon_assertion` (
129
  `id` VARBINARY(767) NOT NULL ,
130
  `string` VARBINARY(767) NOT NULL ,
131
  `taxon` VARBINARY(767) NULL ,
132
  `cf_aff` VARBINARY(767) NULL ,
133
  `annotations` SET('hstore') NULL ,
134
  PRIMARY KEY (`id`) ,
135
  INDEX `fk_taxon_assertion_taxon_string1_idx` (`string` ASC) ,
136
  INDEX `fk_taxon_assertion_taxon_name1_idx` (`taxon` ASC) ,
137
  CONSTRAINT `fk_qualified_taxon_record1`
138
    FOREIGN KEY (`id` )
124 139
    REFERENCES `record` (`id` )
125 140
    ON DELETE CASCADE
126 141
    ON UPDATE CASCADE,
127
  CONSTRAINT `fk_taxon_concept_taxon_string10`
128
    FOREIGN KEY (`unique_name` )
142
  CONSTRAINT `fk_taxon_assertion_taxon_string1`
143
    FOREIGN KEY (`string` )
129 144
    REFERENCES `taxon_string` (`string` )
130 145
    ON DELETE CASCADE
146
    ON UPDATE CASCADE,
147
  CONSTRAINT `fk_taxon_assertion_taxon_name1`
148
    FOREIGN KEY (`taxon` )
149
    REFERENCES `taxon_name` (`id` )
150
    ON DELETE CASCADE
131 151
    ON UPDATE CASCADE)
132 152
ENGINE = InnoDB
133 153
DEFAULT CHARACTER SET = utf8
......
178 198

  
179 199

  
180 200
-- -----------------------------------------------------
181
-- Table `taxon_assertion`
201
-- Table `taxon_name`
182 202
-- -----------------------------------------------------
183
CREATE  TABLE IF NOT EXISTS `taxon_assertion` (
203
CREATE  TABLE IF NOT EXISTS `taxon_name` (
184 204
  `id` VARBINARY(767) NOT NULL ,
185
  `string` VARBINARY(767) NOT NULL ,
186
  `taxon` VARBINARY(767) NULL ,
187
  `cf_aff` VARBINARY(767) NULL ,
188
  `annotations` SET('hstore') NULL ,
205
  `unique_name` VARBINARY(767) NOT NULL ,
206
  `formal_name` VARBINARY(767) NULL ,
207
  `taxon_name` VARBINARY(767) NULL ,
208
  `author` VARBINARY(767) NULL ,
209
  `common_name` VARBINARY(767) NULL ,
210
  `rank` VARBINARY(767) NULL ,
189 211
  PRIMARY KEY (`id`) ,
190
  INDEX `fk_taxon_assertion_taxon_string1_idx` (`string` ASC) ,
191
  INDEX `fk_taxon_assertion_taxon_name1_idx` (`taxon` ASC) ,
192
  CONSTRAINT `fk_qualified_taxon_record1`
212
  INDEX `fk_taxon_concept_taxon_string10_idx` (`unique_name` ASC) ,
213
  CONSTRAINT `fk_taxon_record10`
193 214
    FOREIGN KEY (`id` )
194 215
    REFERENCES `record` (`id` )
195 216
    ON DELETE CASCADE
196 217
    ON UPDATE CASCADE,
197
  CONSTRAINT `fk_taxon_assertion_taxon_string1`
198
    FOREIGN KEY (`string` )
218
  CONSTRAINT `fk_taxon_concept_taxon_string10`
219
    FOREIGN KEY (`unique_name` )
199 220
    REFERENCES `taxon_string` (`string` )
200 221
    ON DELETE CASCADE
201
    ON UPDATE CASCADE,
202
  CONSTRAINT `fk_taxon_assertion_taxon_name1`
203
    FOREIGN KEY (`taxon` )
204
    REFERENCES `taxon_name` (`id` )
205
    ON DELETE CASCADE
206 222
    ON UPDATE CASCADE)
207 223
ENGINE = InnoDB
208 224
DEFAULT CHARACTER SET = utf8
......
334 350

  
335 351

  
336 352
-- -----------------------------------------------------
353
-- Table `organization`
354
-- -----------------------------------------------------
355
CREATE  TABLE IF NOT EXISTS `organization` (
356
  `id` VARBINARY(767) NOT NULL ,
357
  `info` SET('hstore') NULL ,
358
  PRIMARY KEY (`id`) ,
359
  CONSTRAINT `fk_organization_party1`
360
    FOREIGN KEY (`id` )
361
    REFERENCES `party` (`id` )
362
    ON DELETE CASCADE
363
    ON UPDATE CASCADE)
364
ENGINE = InnoDB
365
DEFAULT CHARACTER SET = utf8
366
COLLATE = utf8_bin;
367

  
368

  
369
-- -----------------------------------------------------
370
-- Table `specimen`
371
-- -----------------------------------------------------
372
CREATE  TABLE IF NOT EXISTS `specimen` (
373
  `id` VARBINARY(767) NOT NULL ,
374
  `collection` VARBINARY(767) NULL ,
375
  `stamping_institution` VARBINARY(767) NULL ,
376
  `donor_institution` VARBINARY(767) NULL ,
377
  `owner` VARBINARY(767) NULL ,
378
  `barcode` VARBINARY(767) NULL ,
379
  `accession_number` VARBINARY(767) NULL ,
380
  PRIMARY KEY (`id`) ,
381
  INDEX `fk_specimen_collection1_idx` (`collection` ASC) ,
382
  INDEX `fk_specimen_organization1_idx` (`stamping_institution` ASC) ,
383
  INDEX `fk_specimen_organization2_idx` (`donor_institution` ASC) ,
384
  INDEX `fk_specimen_organization3_idx` (`owner` ASC) ,
385
  CONSTRAINT `fk_specimen_taxon_occurrence1`
386
    FOREIGN KEY (`id` )
387
    REFERENCES `taxon_occurrence` (`id` )
388
    ON DELETE CASCADE
389
    ON UPDATE CASCADE,
390
  CONSTRAINT `fk_specimen_collection1`
391
    FOREIGN KEY (`collection` )
392
    REFERENCES `collection` (`id` )
393
    ON DELETE CASCADE
394
    ON UPDATE CASCADE,
395
  CONSTRAINT `fk_specimen_organization1`
396
    FOREIGN KEY (`stamping_institution` )
397
    REFERENCES `organization` (`id` )
398
    ON DELETE CASCADE
399
    ON UPDATE CASCADE,
400
  CONSTRAINT `fk_specimen_organization2`
401
    FOREIGN KEY (`donor_institution` )
402
    REFERENCES `organization` (`id` )
403
    ON DELETE CASCADE
404
    ON UPDATE CASCADE,
405
  CONSTRAINT `fk_specimen_organization3`
406
    FOREIGN KEY (`owner` )
407
    REFERENCES `organization` (`id` )
408
    ON DELETE CASCADE
409
    ON UPDATE CASCADE)
410
ENGINE = InnoDB
411
DEFAULT CHARACTER SET = utf8
412
COLLATE = utf8_bin;
413

  
414

  
415
-- -----------------------------------------------------
337 416
-- Table `taxon_observation`
338 417
-- -----------------------------------------------------
339 418
CREATE  TABLE IF NOT EXISTS `taxon_observation` (
......
444 523

  
445 524

  
446 525
-- -----------------------------------------------------
447
-- Table `collection`
448
-- -----------------------------------------------------
449
CREATE  TABLE IF NOT EXISTS `collection` (
450
  `id` VARBINARY(767) NOT NULL ,
451
  PRIMARY KEY (`id`) ,
452
  CONSTRAINT `fk_collection_source1`
453
    FOREIGN KEY (`id` )
454
    REFERENCES `source` (`id` )
455
    ON DELETE CASCADE
456
    ON UPDATE CASCADE)
457
ENGINE = InnoDB
458
DEFAULT CHARACTER SET = utf8
459
COLLATE = utf8_bin;
460

  
461

  
462
-- -----------------------------------------------------
463
-- Table `organization`
464
-- -----------------------------------------------------
465
CREATE  TABLE IF NOT EXISTS `organization` (
466
  `id` VARBINARY(767) NOT NULL ,
467
  `info` SET('hstore') NULL ,
468
  PRIMARY KEY (`id`) ,
469
  CONSTRAINT `fk_organization_party1`
470
    FOREIGN KEY (`id` )
471
    REFERENCES `party` (`id` )
472
    ON DELETE CASCADE
473
    ON UPDATE CASCADE)
474
ENGINE = InnoDB
475
DEFAULT CHARACTER SET = utf8
476
COLLATE = utf8_bin;
477

  
478

  
479
-- -----------------------------------------------------
480
-- Table `specimen`
481
-- -----------------------------------------------------
482
CREATE  TABLE IF NOT EXISTS `specimen` (
483
  `id` VARBINARY(767) NOT NULL ,
484
  `collection` VARBINARY(767) NULL ,
485
  `stamping_institution` VARBINARY(767) NULL ,
486
  `donor_institution` VARBINARY(767) NULL ,
487
  `owner` VARBINARY(767) NULL ,
488
  `barcode` VARBINARY(767) NULL ,
489
  `accession_number` VARBINARY(767) NULL ,
490
  PRIMARY KEY (`id`) ,
491
  INDEX `fk_specimen_collection1_idx` (`collection` ASC) ,
492
  INDEX `fk_specimen_organization1_idx` (`stamping_institution` ASC) ,
493
  INDEX `fk_specimen_organization2_idx` (`donor_institution` ASC) ,
494
  INDEX `fk_specimen_organization3_idx` (`owner` ASC) ,
495
  CONSTRAINT `fk_specimen_taxon_occurrence1`
496
    FOREIGN KEY (`id` )
497
    REFERENCES `taxon_occurrence` (`id` )
498
    ON DELETE CASCADE
499
    ON UPDATE CASCADE,
500
  CONSTRAINT `fk_specimen_collection1`
501
    FOREIGN KEY (`collection` )
502
    REFERENCES `collection` (`id` )
503
    ON DELETE CASCADE
504
    ON UPDATE CASCADE,
505
  CONSTRAINT `fk_specimen_organization1`
506
    FOREIGN KEY (`stamping_institution` )
507
    REFERENCES `organization` (`id` )
508
    ON DELETE CASCADE
509
    ON UPDATE CASCADE,
510
  CONSTRAINT `fk_specimen_organization2`
511
    FOREIGN KEY (`donor_institution` )
512
    REFERENCES `organization` (`id` )
513
    ON DELETE CASCADE
514
    ON UPDATE CASCADE,
515
  CONSTRAINT `fk_specimen_organization3`
516
    FOREIGN KEY (`owner` )
517
    REFERENCES `organization` (`id` )
518
    ON DELETE CASCADE
519
    ON UPDATE CASCADE)
520
ENGINE = InnoDB
521
DEFAULT CHARACTER SET = utf8
522
COLLATE = utf8_bin;
523

  
524

  
525
-- -----------------------------------------------------
526 526
-- Table `individual`
527 527
-- -----------------------------------------------------
528 528
CREATE  TABLE IF NOT EXISTS `individual` (
......
541 541

  
542 542

  
543 543
-- -----------------------------------------------------
544
-- Table `individual_observation`
545
-- -----------------------------------------------------
546
CREATE  TABLE IF NOT EXISTS `individual_observation` (
547
  `id` VARBINARY(767) NOT NULL ,
548
  `individual` VARBINARY(767) NOT NULL ,
549
  `traits` SET('hstore') NULL ,
550
  PRIMARY KEY (`id`) ,
551
  INDEX `fk_individual_observation_individual1_idx` (`individual` ASC) ,
552
  CONSTRAINT `fk_individual_observation_taxon_occurrence1`
553
    FOREIGN KEY (`id` )
554
    REFERENCES `taxon_observation` (`id` )
555
    ON DELETE CASCADE
556
    ON UPDATE CASCADE,
557
  CONSTRAINT `fk_individual_observation_individual1`
558
    FOREIGN KEY (`individual` )
559
    REFERENCES `individual` (`id` )
560
    ON DELETE CASCADE
561
    ON UPDATE CASCADE)
562
ENGINE = InnoDB
563
DEFAULT CHARACTER SET = utf8
564
COLLATE = utf8_bin;
565

  
566

  
567
-- -----------------------------------------------------
568
-- Table `stem`
569
-- -----------------------------------------------------
570
CREATE  TABLE IF NOT EXISTS `stem` (
571
  `id` VARBINARY(767) NOT NULL ,
572
  `individual` VARBINARY(767) NOT NULL ,
573
  PRIMARY KEY (`id`) ,
574
  INDEX `fk_stem_individual1_idx` (`individual` ASC) ,
575
  CONSTRAINT `fk_stem_individual1`
576
    FOREIGN KEY (`individual` )
577
    REFERENCES `individual` (`id` )
578
    ON DELETE CASCADE
579
    ON UPDATE CASCADE,
580
  CONSTRAINT `fk_stem_individual2`
581
    FOREIGN KEY (`id` )
582
    REFERENCES `individual` (`id` )
583
    ON DELETE CASCADE
584
    ON UPDATE CASCADE)
585
ENGINE = InnoDB
586
DEFAULT CHARACTER SET = utf8
587
COLLATE = utf8_bin;
588

  
589

  
590
-- -----------------------------------------------------
591
-- Table `stem_observation`
592
-- -----------------------------------------------------
593
CREATE  TABLE IF NOT EXISTS `stem_observation` (
594
  `id` VARBINARY(767) NOT NULL ,
595
  `individual_observation` VARBINARY(767) NOT NULL ,
596
  `stem` VARBINARY(767) NOT NULL ,
597
  `traits` SET('hstore') NULL ,
598
  PRIMARY KEY (`id`) ,
599
  INDEX `fk_stem_observation_individual_observation1_idx` (`individual_observation` ASC) ,
600
  INDEX `fk_stem_observation_stem1_idx` (`stem` ASC) ,
601
  UNIQUE INDEX `stem_observation_unique` (`individual_observation` ASC, `stem` ASC) ,
602
  CONSTRAINT `fk_stem_observation_individual_observation1`
603
    FOREIGN KEY (`individual_observation` )
604
    REFERENCES `individual_observation` (`id` )
605
    ON DELETE CASCADE
606
    ON UPDATE CASCADE,
607
  CONSTRAINT `fk_stem_observation_stem1`
608
    FOREIGN KEY (`stem` )
609
    REFERENCES `stem` (`id` )
610
    ON DELETE CASCADE
611
    ON UPDATE CASCADE,
612
  CONSTRAINT `fk_stem_observation_individual_observation2`
613
    FOREIGN KEY (`id` )
614
    REFERENCES `individual_observation` (`id` )
615
    ON DELETE CASCADE
616
    ON UPDATE CASCADE)
617
ENGINE = InnoDB
618
DEFAULT CHARACTER SET = utf8
619
COLLATE = utf8_bin;
620

  
621

  
622
-- -----------------------------------------------------
623 544
-- Table `aggregate_observation`
624 545
-- -----------------------------------------------------
625 546
CREATE  TABLE IF NOT EXISTS `aggregate_observation` (
......
862 783

  
863 784

  
864 785
-- -----------------------------------------------------
786
-- Table `individual_observation`
787
-- -----------------------------------------------------
788
CREATE  TABLE IF NOT EXISTS `individual_observation` (
789
  `id` VARBINARY(767) NOT NULL ,
790
  `individual` VARBINARY(767) NOT NULL ,
791
  `traits` SET('hstore') NULL ,
792
  PRIMARY KEY (`id`) ,
793
  INDEX `fk_individual_observation_individual1_idx` (`individual` ASC) ,
794
  CONSTRAINT `fk_individual_observation_taxon_occurrence1`
795
    FOREIGN KEY (`id` )
796
    REFERENCES `taxon_observation` (`id` )
797
    ON DELETE CASCADE
798
    ON UPDATE CASCADE,
799
  CONSTRAINT `fk_individual_observation_individual1`
800
    FOREIGN KEY (`individual` )
801
    REFERENCES `individual` (`id` )
802
    ON DELETE CASCADE
803
    ON UPDATE CASCADE)
804
ENGINE = InnoDB
805
DEFAULT CHARACTER SET = utf8
806
COLLATE = utf8_bin;
807

  
808

  
809
-- -----------------------------------------------------
810
-- Table `stem`
811
-- -----------------------------------------------------
812
CREATE  TABLE IF NOT EXISTS `stem` (
813
  `id` VARBINARY(767) NOT NULL ,
814
  `individual` VARBINARY(767) NOT NULL ,
815
  PRIMARY KEY (`id`) ,
816
  INDEX `fk_stem_individual1_idx` (`individual` ASC) ,
817
  CONSTRAINT `fk_stem_individual1`
818
    FOREIGN KEY (`individual` )
819
    REFERENCES `individual` (`id` )
820
    ON DELETE CASCADE
821
    ON UPDATE CASCADE,
822
  CONSTRAINT `fk_stem_individual2`
823
    FOREIGN KEY (`id` )
824
    REFERENCES `individual` (`id` )
825
    ON DELETE CASCADE
826
    ON UPDATE CASCADE)
827
ENGINE = InnoDB
828
DEFAULT CHARACTER SET = utf8
829
COLLATE = utf8_bin;
830

  
831

  
832
-- -----------------------------------------------------
833
-- Table `stem_observation`
834
-- -----------------------------------------------------
835
CREATE  TABLE IF NOT EXISTS `stem_observation` (
836
  `id` VARBINARY(767) NOT NULL ,
837
  `individual_observation` VARBINARY(767) NOT NULL ,
838
  `stem` VARBINARY(767) NOT NULL ,
839
  `traits` SET('hstore') NULL ,
840
  PRIMARY KEY (`id`) ,
841
  INDEX `fk_stem_observation_individual_observation1_idx` (`individual_observation` ASC) ,
842
  INDEX `fk_stem_observation_stem1_idx` (`stem` ASC) ,
843
  UNIQUE INDEX `stem_observation_unique` (`individual_observation` ASC, `stem` ASC) ,
844
  CONSTRAINT `fk_stem_observation_individual_observation1`
845
    FOREIGN KEY (`individual_observation` )
846
    REFERENCES `individual_observation` (`id` )
847
    ON DELETE CASCADE
848
    ON UPDATE CASCADE,
849
  CONSTRAINT `fk_stem_observation_stem1`
850
    FOREIGN KEY (`stem` )
851
    REFERENCES `stem` (`id` )
852
    ON DELETE CASCADE
853
    ON UPDATE CASCADE,
854
  CONSTRAINT `fk_stem_observation_individual_observation2`
855
    FOREIGN KEY (`id` )
856
    REFERENCES `individual_observation` (`id` )
857
    ON DELETE CASCADE
858
    ON UPDATE CASCADE)
859
ENGINE = InnoDB
860
DEFAULT CHARACTER SET = utf8
861
COLLATE = utf8_bin;
862

  
863

  
864
-- -----------------------------------------------------
865 865
-- Table `project`
866 866
-- -----------------------------------------------------
867 867
CREATE  TABLE IF NOT EXISTS `project` (
......
953 953

  
954 954

  
955 955
-- -----------------------------------------------------
956
-- Table `plot_stratum`
956
-- Table `1. verbatim`
957 957
-- -----------------------------------------------------
958
CREATE  TABLE IF NOT EXISTS `plot_stratum` (
958
CREATE  TABLE IF NOT EXISTS `1. verbatim` (
959 959
  `id` VARBINARY(767) NOT NULL ,
960
  `stratum` VARBINARY(767) NOT NULL ,
961
  PRIMARY KEY (`id`) ,
962
  INDEX `fk_plot_stratum_stratum1_idx` (`stratum` ASC) ,
963
  CONSTRAINT `fk_subplot_place10`
964
    FOREIGN KEY (`id` )
965
    REFERENCES `place` (`id` )
966
    ON DELETE CASCADE
967
    ON UPDATE CASCADE,
968
  CONSTRAINT `fk_plot_stratum_stratum1`
969
    FOREIGN KEY (`stratum` )
970
    REFERENCES `stratum` (`id` )
971
    ON DELETE CASCADE
972
    ON UPDATE CASCADE)
960
  PRIMARY KEY (`id`) )
973 961
ENGINE = InnoDB
974 962
DEFAULT CHARACTER SET = utf8
975 963
COLLATE = utf8_bin;
976 964

  
977 965

  
978 966
-- -----------------------------------------------------
979
-- Table `1. verbatim`
967
-- Table `2. concatenated`
980 968
-- -----------------------------------------------------
981
CREATE  TABLE IF NOT EXISTS `1. verbatim` (
969
CREATE  TABLE IF NOT EXISTS `2. concatenated` (
982 970
  `id` VARBINARY(767) NOT NULL ,
983 971
  PRIMARY KEY (`id`) )
984 972
ENGINE = InnoDB
......
987 975

  
988 976

  
989 977
-- -----------------------------------------------------
990
-- Table `2. concatenated`
978
-- Table `3. parsed`
991 979
-- -----------------------------------------------------
992
CREATE  TABLE IF NOT EXISTS `2. concatenated` (
980
CREATE  TABLE IF NOT EXISTS `3. parsed` (
993 981
  `id` VARBINARY(767) NOT NULL ,
994 982
  PRIMARY KEY (`id`) )
995 983
ENGINE = InnoDB
......
998 986

  
999 987

  
1000 988
-- -----------------------------------------------------
1001
-- Table `3. parsed`
989
-- Table `plot_stratum`
1002 990
-- -----------------------------------------------------
1003
CREATE  TABLE IF NOT EXISTS `3. parsed` (
991
CREATE  TABLE IF NOT EXISTS `plot_stratum` (
1004 992
  `id` VARBINARY(767) NOT NULL ,
1005
  PRIMARY KEY (`id`) )
993
  `stratum` VARBINARY(767) NOT NULL ,
994
  PRIMARY KEY (`id`) ,
995
  INDEX `fk_plot_stratum_stratum1_idx` (`stratum` ASC) ,
996
  CONSTRAINT `fk_subplot_place10`
997
    FOREIGN KEY (`id` )
998
    REFERENCES `place` (`id` )
999
    ON DELETE CASCADE
1000
    ON UPDATE CASCADE,
1001
  CONSTRAINT `fk_plot_stratum_stratum1`
1002
    FOREIGN KEY (`stratum` )
1003
    REFERENCES `stratum` (`id` )
1004
    ON DELETE CASCADE
1005
    ON UPDATE CASCADE)
1006 1006
ENGINE = InnoDB
1007 1007
DEFAULT CHARACTER SET = utf8
1008 1008
COLLATE = utf8_bin;

Also available in: Unified diff