Project

General

Profile

« Previous | Next » 

Revision 8615

schemas/VegCore/VegCore.ERD.mwb: set all tables to use utf8/utf8_unicode_ci rather than latin1/latin1_swedish_ci because our DB is in UTF-8. utf8_unicode_ci is better than utf8_general_ci because it supports international characters better (http://forums.mysql.com/read.php?103,187048,188748)

View differences:

schemas/VegCore/VegCore.my.sql
16 16
    ON DELETE CASCADE
17 17
    ON UPDATE CASCADE)
18 18
ENGINE = InnoDB
19
DEFAULT CHARACTER SET = latin1
20
COLLATE = latin1_swedish_ci;
19
DEFAULT CHARACTER SET = utf8
20
COLLATE = utf8_unicode_ci;
21 21

  
22 22

  
23 23
-- -----------------------------------------------------
......
51 51
    ON DELETE CASCADE
52 52
    ON UPDATE CASCADE)
53 53
ENGINE = InnoDB
54
DEFAULT CHARACTER SET = latin1
55
COLLATE = latin1_swedish_ci;
54
DEFAULT CHARACTER SET = utf8
55
COLLATE = utf8_unicode_ci;
56 56

  
57 57

  
58 58
-- -----------------------------------------------------
......
71 71
    ON DELETE CASCADE
72 72
    ON UPDATE CASCADE)
73 73
ENGINE = InnoDB
74
DEFAULT CHARACTER SET = latin1
75
COLLATE = latin1_swedish_ci;
74
DEFAULT CHARACTER SET = utf8
75
COLLATE = utf8_unicode_ci;
76 76

  
77 77

  
78 78
-- -----------------------------------------------------
......
102 102
    ON DELETE CASCADE
103 103
    ON UPDATE CASCADE)
104 104
ENGINE = InnoDB
105
DEFAULT CHARACTER SET = latin1
106
COLLATE = latin1_swedish_ci;
105
DEFAULT CHARACTER SET = utf8
106
COLLATE = utf8_unicode_ci;
107 107

  
108 108

  
109 109
-- -----------------------------------------------------
......
130 130
    ON DELETE CASCADE
131 131
    ON UPDATE CASCADE)
132 132
ENGINE = InnoDB
133
DEFAULT CHARACTER SET = latin1
134
COLLATE = latin1_swedish_ci;
133
DEFAULT CHARACTER SET = utf8
134
COLLATE = utf8_unicode_ci;
135 135

  
136 136

  
137 137
-- -----------------------------------------------------
......
155 155
    ON DELETE CASCADE
156 156
    ON UPDATE CASCADE)
157 157
ENGINE = InnoDB
158
DEFAULT CHARACTER SET = latin1
159
COLLATE = latin1_swedish_ci;
158
DEFAULT CHARACTER SET = utf8
159
COLLATE = utf8_unicode_ci;
160 160

  
161 161

  
162 162
-- -----------------------------------------------------
......
173 173
    ON DELETE CASCADE
174 174
    ON UPDATE CASCADE)
175 175
ENGINE = InnoDB
176
DEFAULT CHARACTER SET = latin1
177
COLLATE = latin1_swedish_ci;
176
DEFAULT CHARACTER SET = utf8
177
COLLATE = utf8_unicode_ci;
178 178

  
179 179

  
180 180
-- -----------------------------------------------------
......
205 205
    ON DELETE CASCADE
206 206
    ON UPDATE CASCADE)
207 207
ENGINE = InnoDB
208
DEFAULT CHARACTER SET = latin1
209
COLLATE = latin1_swedish_ci;
208
DEFAULT CHARACTER SET = utf8
209
COLLATE = utf8_unicode_ci;
210 210

  
211 211

  
212 212
-- -----------------------------------------------------
......
218 218
  `longitude_deg` TEXT NULL ,
219 219
  PRIMARY KEY (`id`) )
220 220
ENGINE = InnoDB
221
DEFAULT CHARACTER SET = latin1
222
COLLATE = latin1_swedish_ci;
221
DEFAULT CHARACTER SET = utf8
222
COLLATE = utf8_unicode_ci;
223 223

  
224 224

  
225 225
-- -----------------------------------------------------
......
235 235
  `ranks` SET('hstore') NULL ,
236 236
  PRIMARY KEY (`id`) )
237 237
ENGINE = InnoDB
238
DEFAULT CHARACTER SET = latin1
239
COLLATE = latin1_swedish_ci;
238
DEFAULT CHARACTER SET = utf8
239
COLLATE = utf8_unicode_ci;
240 240

  
241 241

  
242 242
-- -----------------------------------------------------
......
273 273
    ON DELETE CASCADE
274 274
    ON UPDATE CASCADE)
275 275
ENGINE = InnoDB
276
DEFAULT CHARACTER SET = latin1
277
COLLATE = latin1_swedish_ci;
276
DEFAULT CHARACTER SET = utf8
277
COLLATE = utf8_unicode_ci;
278 278

  
279 279

  
280 280
-- -----------------------------------------------------
......
290 290
    ON DELETE CASCADE
291 291
    ON UPDATE CASCADE)
292 292
ENGINE = InnoDB
293
DEFAULT CHARACTER SET = latin1
294
COLLATE = latin1_swedish_ci;
293
DEFAULT CHARACTER SET = utf8
294
COLLATE = utf8_unicode_ci;
295 295

  
296 296

  
297 297
-- -----------------------------------------------------
......
329 329
    ON DELETE CASCADE
330 330
    ON UPDATE CASCADE)
331 331
ENGINE = InnoDB
332
DEFAULT CHARACTER SET = latin1
333
COLLATE = latin1_swedish_ci;
332
DEFAULT CHARACTER SET = utf8
333
COLLATE = utf8_unicode_ci;
334 334

  
335 335

  
336 336
-- -----------------------------------------------------
......
362 362
    ON DELETE CASCADE
363 363
    ON UPDATE CASCADE)
364 364
ENGINE = InnoDB
365
DEFAULT CHARACTER SET = latin1
366
COLLATE = latin1_swedish_ci;
365
DEFAULT CHARACTER SET = utf8
366
COLLATE = utf8_unicode_ci;
367 367

  
368 368

  
369 369
-- -----------------------------------------------------
......
394 394
    ON DELETE CASCADE
395 395
    ON UPDATE CASCADE)
396 396
ENGINE = InnoDB
397
DEFAULT CHARACTER SET = latin1
398
COLLATE = latin1_swedish_ci;
397
DEFAULT CHARACTER SET = utf8
398
COLLATE = utf8_unicode_ci;
399 399

  
400 400

  
401 401
-- -----------------------------------------------------
......
439 439
    ON DELETE CASCADE
440 440
    ON UPDATE CASCADE)
441 441
ENGINE = InnoDB
442
DEFAULT CHARACTER SET = latin1
443
COLLATE = latin1_swedish_ci;
442
DEFAULT CHARACTER SET = utf8
443
COLLATE = utf8_unicode_ci;
444 444

  
445 445

  
446 446
-- -----------------------------------------------------
......
455 455
    ON DELETE CASCADE
456 456
    ON UPDATE CASCADE)
457 457
ENGINE = InnoDB
458
DEFAULT CHARACTER SET = latin1
459
COLLATE = latin1_swedish_ci;
458
DEFAULT CHARACTER SET = utf8
459
COLLATE = utf8_unicode_ci;
460 460

  
461 461

  
462 462
-- -----------------------------------------------------
......
472 472
    ON DELETE CASCADE
473 473
    ON UPDATE CASCADE)
474 474
ENGINE = InnoDB
475
DEFAULT CHARACTER SET = latin1
476
COLLATE = latin1_swedish_ci;
475
DEFAULT CHARACTER SET = utf8
476
COLLATE = utf8_unicode_ci;
477 477

  
478 478

  
479 479
-- -----------------------------------------------------
......
518 518
    ON DELETE CASCADE
519 519
    ON UPDATE CASCADE)
520 520
ENGINE = InnoDB
521
DEFAULT CHARACTER SET = latin1
522
COLLATE = latin1_swedish_ci;
521
DEFAULT CHARACTER SET = utf8
522
COLLATE = utf8_unicode_ci;
523 523

  
524 524

  
525 525
-- -----------------------------------------------------
......
536 536
    ON DELETE CASCADE
537 537
    ON UPDATE CASCADE)
538 538
ENGINE = InnoDB
539
DEFAULT CHARACTER SET = latin1
540
COLLATE = latin1_swedish_ci;
539
DEFAULT CHARACTER SET = utf8
540
COLLATE = utf8_unicode_ci;
541 541

  
542 542

  
543 543
-- -----------------------------------------------------
......
560 560
    ON DELETE CASCADE
561 561
    ON UPDATE CASCADE)
562 562
ENGINE = InnoDB
563
DEFAULT CHARACTER SET = latin1
564
COLLATE = latin1_swedish_ci;
563
DEFAULT CHARACTER SET = utf8
564
COLLATE = utf8_unicode_ci;
565 565

  
566 566

  
567 567
-- -----------------------------------------------------
......
583 583
    ON DELETE CASCADE
584 584
    ON UPDATE CASCADE)
585 585
ENGINE = InnoDB
586
DEFAULT CHARACTER SET = latin1
587
COLLATE = latin1_swedish_ci;
586
DEFAULT CHARACTER SET = utf8
587
COLLATE = utf8_unicode_ci;
588 588

  
589 589

  
590 590
-- -----------------------------------------------------
......
615 615
    ON DELETE CASCADE
616 616
    ON UPDATE CASCADE)
617 617
ENGINE = InnoDB
618
DEFAULT CHARACTER SET = latin1
619
COLLATE = latin1_swedish_ci;
618
DEFAULT CHARACTER SET = utf8
619
COLLATE = utf8_unicode_ci;
620 620

  
621 621

  
622 622
-- -----------------------------------------------------
......
638 638
    ON DELETE CASCADE
639 639
    ON UPDATE CASCADE)
640 640
ENGINE = InnoDB
641
DEFAULT CHARACTER SET = latin1
642
COLLATE = latin1_swedish_ci;
641
DEFAULT CHARACTER SET = utf8
642
COLLATE = utf8_unicode_ci;
643 643

  
644 644

  
645 645
-- -----------------------------------------------------
......
661 661
    ON DELETE CASCADE
662 662
    ON UPDATE CASCADE)
663 663
ENGINE = InnoDB
664
DEFAULT CHARACTER SET = latin1
665
COLLATE = latin1_swedish_ci;
664
DEFAULT CHARACTER SET = utf8
665
COLLATE = utf8_unicode_ci;
666 666

  
667 667

  
668 668
-- -----------------------------------------------------
......
699 699
    ON DELETE CASCADE
700 700
    ON UPDATE CASCADE)
701 701
ENGINE = InnoDB
702
DEFAULT CHARACTER SET = latin1
703
COLLATE = latin1_swedish_ci;
702
DEFAULT CHARACTER SET = utf8
703
COLLATE = utf8_unicode_ci;
704 704

  
705 705

  
706 706
-- -----------------------------------------------------
......
717 717
    ON DELETE CASCADE
718 718
    ON UPDATE CASCADE)
719 719
ENGINE = InnoDB
720
DEFAULT CHARACTER SET = latin1
721
COLLATE = latin1_swedish_ci;
720
DEFAULT CHARACTER SET = utf8
721
COLLATE = utf8_unicode_ci;
722 722

  
723 723

  
724 724
-- -----------------------------------------------------
......
735 735
    ON DELETE CASCADE
736 736
    ON UPDATE CASCADE)
737 737
ENGINE = InnoDB
738
DEFAULT CHARACTER SET = latin1
739
COLLATE = latin1_swedish_ci;
738
DEFAULT CHARACTER SET = utf8
739
COLLATE = utf8_unicode_ci;
740 740

  
741 741

  
742 742
-- -----------------------------------------------------
......
777 777
    ON DELETE CASCADE
778 778
    ON UPDATE CASCADE)
779 779
ENGINE = InnoDB
780
DEFAULT CHARACTER SET = latin1
781
COLLATE = latin1_swedish_ci;
780
DEFAULT CHARACTER SET = utf8
781
COLLATE = utf8_unicode_ci;
782 782

  
783 783

  
784 784
-- -----------------------------------------------------
......
794 794
    ON DELETE CASCADE
795 795
    ON UPDATE CASCADE)
796 796
ENGINE = InnoDB
797
DEFAULT CHARACTER SET = latin1
798
COLLATE = latin1_swedish_ci;
797
DEFAULT CHARACTER SET = utf8
798
COLLATE = utf8_unicode_ci;
799 799

  
800 800

  
801 801
-- -----------------------------------------------------
......
813 813
    ON DELETE CASCADE
814 814
    ON UPDATE CASCADE)
815 815
ENGINE = InnoDB
816
DEFAULT CHARACTER SET = latin1
817
COLLATE = latin1_swedish_ci;
816
DEFAULT CHARACTER SET = utf8
817
COLLATE = utf8_unicode_ci;
818 818

  
819 819

  
820 820
-- -----------------------------------------------------
......
831 831
    ON DELETE CASCADE
832 832
    ON UPDATE CASCADE)
833 833
ENGINE = InnoDB
834
DEFAULT CHARACTER SET = latin1
835
COLLATE = latin1_swedish_ci;
834
DEFAULT CHARACTER SET = utf8
835
COLLATE = utf8_unicode_ci;
836 836

  
837 837

  
838 838
-- -----------------------------------------------------
......
857 857
    ON DELETE CASCADE
858 858
    ON UPDATE CASCADE)
859 859
ENGINE = InnoDB
860
DEFAULT CHARACTER SET = latin1
861
COLLATE = latin1_swedish_ci;
860
DEFAULT CHARACTER SET = utf8
861
COLLATE = utf8_unicode_ci;
862 862

  
863 863

  
864 864
-- -----------------------------------------------------
......
875 875
    ON DELETE CASCADE
876 876
    ON UPDATE CASCADE)
877 877
ENGINE = InnoDB
878
DEFAULT CHARACTER SET = latin1
879
COLLATE = latin1_swedish_ci;
878
DEFAULT CHARACTER SET = utf8
879
COLLATE = utf8_unicode_ci;
880 880

  
881 881

  
882 882
-- -----------------------------------------------------
......
891 891
    ON DELETE CASCADE
892 892
    ON UPDATE CASCADE)
893 893
ENGINE = InnoDB
894
DEFAULT CHARACTER SET = latin1
895
COLLATE = latin1_swedish_ci;
894
DEFAULT CHARACTER SET = utf8
895
COLLATE = utf8_unicode_ci;
896 896

  
897 897

  
898 898
-- -----------------------------------------------------
......
914 914
    ON DELETE CASCADE
915 915
    ON UPDATE CASCADE)
916 916
ENGINE = InnoDB
917
DEFAULT CHARACTER SET = latin1
918
COLLATE = latin1_swedish_ci;
917
DEFAULT CHARACTER SET = utf8
918
COLLATE = utf8_unicode_ci;
919 919

  
920 920

  
921 921
-- -----------------------------------------------------
......
930 930
    ON DELETE CASCADE
931 931
    ON UPDATE CASCADE)
932 932
ENGINE = InnoDB
933
DEFAULT CHARACTER SET = latin1
934
COLLATE = latin1_swedish_ci;
933
DEFAULT CHARACTER SET = utf8
934
COLLATE = utf8_unicode_ci;
935 935

  
936 936

  
937 937
-- -----------------------------------------------------
......
948 948
    ON DELETE CASCADE
949 949
    ON UPDATE CASCADE)
950 950
ENGINE = InnoDB
951
DEFAULT CHARACTER SET = latin1
952
COLLATE = latin1_swedish_ci;
951
DEFAULT CHARACTER SET = utf8
952
COLLATE = utf8_unicode_ci;
953 953

  
954 954

  
955 955
-- -----------------------------------------------------
......
971 971
    ON DELETE CASCADE
972 972
    ON UPDATE CASCADE)
973 973
ENGINE = InnoDB
974
DEFAULT CHARACTER SET = latin1
975
COLLATE = latin1_swedish_ci;
974
DEFAULT CHARACTER SET = utf8
975
COLLATE = utf8_unicode_ci;
976 976

  
977 977

  
978 978
-- -----------------------------------------------------
......
983 983
  PRIMARY KEY (`id`) )
984 984
ENGINE = InnoDB
985 985
DEFAULT CHARACTER SET = utf8
986
COLLATE = utf8_general_ci;
986
COLLATE = utf8_unicode_ci;
987 987

  
988 988

  
989 989
-- -----------------------------------------------------
......
994 994
  PRIMARY KEY (`id`) )
995 995
ENGINE = InnoDB
996 996
DEFAULT CHARACTER SET = utf8
997
COLLATE = utf8_general_ci;
997
COLLATE = utf8_unicode_ci;
998 998

  
999 999

  
1000 1000
-- -----------------------------------------------------
......
1005 1005
  PRIMARY KEY (`id`) )
1006 1006
ENGINE = InnoDB
1007 1007
DEFAULT CHARACTER SET = utf8
1008
COLLATE = utf8_general_ci;
1008
COLLATE = utf8_unicode_ci;
1009 1009

  
1010 1010

  
1011 1011
-- -----------------------------------------------------
......
1016 1016
  PRIMARY KEY (`id`) )
1017 1017
ENGINE = InnoDB
1018 1018
DEFAULT CHARACTER SET = utf8
1019
COLLATE = utf8_general_ci;
1019
COLLATE = utf8_unicode_ci;
1020 1020

  
1021 1021

  
1022 1022
-- -----------------------------------------------------
......
1027 1027
  PRIMARY KEY (`id`) )
1028 1028
ENGINE = InnoDB
1029 1029
DEFAULT CHARACTER SET = utf8
1030
COLLATE = utf8_general_ci;
1030
COLLATE = utf8_unicode_ci;
1031 1031

  
1032 1032

  
1033 1033
-- -----------------------------------------------------
......
1037 1037
  `id` TEXT NOT NULL ,
1038 1038
  PRIMARY KEY (`id`) )
1039 1039
ENGINE = InnoDB
1040
DEFAULT CHARACTER SET = latin1
1041
COLLATE = latin1_swedish_ci;
1040
DEFAULT CHARACTER SET = utf8
1041
COLLATE = utf8_unicode_ci;
1042 1042

  
1043 1043

  
1044 1044
-- -----------------------------------------------------
......
1056 1056
    ON DELETE CASCADE
1057 1057
    ON UPDATE CASCADE)
1058 1058
ENGINE = InnoDB
1059
DEFAULT CHARACTER SET = latin1
1060
COLLATE = latin1_swedish_ci;
1059
DEFAULT CHARACTER SET = utf8
1060
COLLATE = utf8_unicode_ci;
1061 1061

  
1062 1062

  
1063 1063
-- -----------------------------------------------------
......
1076 1076
    ON DELETE CASCADE
1077 1077
    ON UPDATE CASCADE)
1078 1078
ENGINE = InnoDB
1079
DEFAULT CHARACTER SET = latin1
1080
COLLATE = latin1_swedish_ci;
1079
DEFAULT CHARACTER SET = utf8
1080
COLLATE = utf8_unicode_ci;
1081 1081

  
1082 1082

  
1083 1083
-- -----------------------------------------------------
......
1099 1099
    ON DELETE CASCADE
1100 1100
    ON UPDATE CASCADE)
1101 1101
ENGINE = InnoDB
1102
DEFAULT CHARACTER SET = latin1
1103
COLLATE = latin1_swedish_ci;
1102
DEFAULT CHARACTER SET = utf8
1103
COLLATE = utf8_unicode_ci;
1104 1104

  
1105 1105

  
1106 1106
-- -----------------------------------------------------
......
1124 1124
    ON DELETE CASCADE
1125 1125
    ON UPDATE CASCADE)
1126 1126
ENGINE = InnoDB
1127
DEFAULT CHARACTER SET = latin1
1128
COLLATE = latin1_swedish_ci;
1127
DEFAULT CHARACTER SET = utf8
1128
COLLATE = utf8_unicode_ci;
1129 1129

  
1130 1130

  
1131 1131
-- -----------------------------------------------------
......
1149 1149
    ON DELETE CASCADE
1150 1150
    ON UPDATE CASCADE)
1151 1151
ENGINE = InnoDB
1152
DEFAULT CHARACTER SET = latin1
1153
COLLATE = latin1_swedish_ci;
1152
DEFAULT CHARACTER SET = utf8
1153
COLLATE = utf8_unicode_ci;
1154 1154

  
1155 1155

  
1156 1156

  

Also available in: Unified diff