Revision 8615
Added by Aaron Marcuse-Kubitza over 11 years ago
| 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
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)