Revision 8617
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 17 | 17 |
ON UPDATE CASCADE) |
| 18 | 18 |
ENGINE = InnoDB |
| 19 | 19 |
DEFAULT CHARACTER SET = utf8 |
| 20 |
COLLATE = utf8_unicode_ci;
|
|
| 20 |
COLLATE = utf8_bin;
|
|
| 21 | 21 |
|
| 22 | 22 |
|
| 23 | 23 |
-- ----------------------------------------------------- |
| ... | ... | |
| 52 | 52 |
ON UPDATE CASCADE) |
| 53 | 53 |
ENGINE = InnoDB |
| 54 | 54 |
DEFAULT CHARACTER SET = utf8 |
| 55 |
COLLATE = utf8_unicode_ci;
|
|
| 55 |
COLLATE = utf8_bin;
|
|
| 56 | 56 |
|
| 57 | 57 |
|
| 58 | 58 |
-- ----------------------------------------------------- |
| ... | ... | |
| 72 | 72 |
ON UPDATE CASCADE) |
| 73 | 73 |
ENGINE = InnoDB |
| 74 | 74 |
DEFAULT CHARACTER SET = utf8 |
| 75 |
COLLATE = utf8_unicode_ci;
|
|
| 75 |
COLLATE = utf8_bin;
|
|
| 76 | 76 |
|
| 77 | 77 |
|
| 78 | 78 |
-- ----------------------------------------------------- |
| ... | ... | |
| 103 | 103 |
ON UPDATE CASCADE) |
| 104 | 104 |
ENGINE = InnoDB |
| 105 | 105 |
DEFAULT CHARACTER SET = utf8 |
| 106 |
COLLATE = utf8_unicode_ci;
|
|
| 106 |
COLLATE = utf8_bin;
|
|
| 107 | 107 |
|
| 108 | 108 |
|
| 109 | 109 |
-- ----------------------------------------------------- |
| ... | ... | |
| 131 | 131 |
ON UPDATE CASCADE) |
| 132 | 132 |
ENGINE = InnoDB |
| 133 | 133 |
DEFAULT CHARACTER SET = utf8 |
| 134 |
COLLATE = utf8_unicode_ci;
|
|
| 134 |
COLLATE = utf8_bin;
|
|
| 135 | 135 |
|
| 136 | 136 |
|
| 137 | 137 |
-- ----------------------------------------------------- |
| ... | ... | |
| 156 | 156 |
ON UPDATE CASCADE) |
| 157 | 157 |
ENGINE = InnoDB |
| 158 | 158 |
DEFAULT CHARACTER SET = utf8 |
| 159 |
COLLATE = utf8_unicode_ci;
|
|
| 159 |
COLLATE = utf8_bin;
|
|
| 160 | 160 |
|
| 161 | 161 |
|
| 162 | 162 |
-- ----------------------------------------------------- |
| ... | ... | |
| 174 | 174 |
ON UPDATE CASCADE) |
| 175 | 175 |
ENGINE = InnoDB |
| 176 | 176 |
DEFAULT CHARACTER SET = utf8 |
| 177 |
COLLATE = utf8_unicode_ci;
|
|
| 177 |
COLLATE = utf8_bin;
|
|
| 178 | 178 |
|
| 179 | 179 |
|
| 180 | 180 |
-- ----------------------------------------------------- |
| ... | ... | |
| 206 | 206 |
ON UPDATE CASCADE) |
| 207 | 207 |
ENGINE = InnoDB |
| 208 | 208 |
DEFAULT CHARACTER SET = utf8 |
| 209 |
COLLATE = utf8_unicode_ci;
|
|
| 209 |
COLLATE = utf8_bin;
|
|
| 210 | 210 |
|
| 211 | 211 |
|
| 212 | 212 |
-- ----------------------------------------------------- |
| ... | ... | |
| 219 | 219 |
PRIMARY KEY (`id`) ) |
| 220 | 220 |
ENGINE = InnoDB |
| 221 | 221 |
DEFAULT CHARACTER SET = utf8 |
| 222 |
COLLATE = utf8_unicode_ci;
|
|
| 222 |
COLLATE = utf8_bin;
|
|
| 223 | 223 |
|
| 224 | 224 |
|
| 225 | 225 |
-- ----------------------------------------------------- |
| ... | ... | |
| 236 | 236 |
PRIMARY KEY (`id`) ) |
| 237 | 237 |
ENGINE = InnoDB |
| 238 | 238 |
DEFAULT CHARACTER SET = utf8 |
| 239 |
COLLATE = utf8_unicode_ci;
|
|
| 239 |
COLLATE = utf8_bin;
|
|
| 240 | 240 |
|
| 241 | 241 |
|
| 242 | 242 |
-- ----------------------------------------------------- |
| ... | ... | |
| 274 | 274 |
ON UPDATE CASCADE) |
| 275 | 275 |
ENGINE = InnoDB |
| 276 | 276 |
DEFAULT CHARACTER SET = utf8 |
| 277 |
COLLATE = utf8_unicode_ci;
|
|
| 277 |
COLLATE = utf8_bin;
|
|
| 278 | 278 |
|
| 279 | 279 |
|
| 280 | 280 |
-- ----------------------------------------------------- |
| ... | ... | |
| 291 | 291 |
ON UPDATE CASCADE) |
| 292 | 292 |
ENGINE = InnoDB |
| 293 | 293 |
DEFAULT CHARACTER SET = utf8 |
| 294 |
COLLATE = utf8_unicode_ci;
|
|
| 294 |
COLLATE = utf8_bin;
|
|
| 295 | 295 |
|
| 296 | 296 |
|
| 297 | 297 |
-- ----------------------------------------------------- |
| ... | ... | |
| 330 | 330 |
ON UPDATE CASCADE) |
| 331 | 331 |
ENGINE = InnoDB |
| 332 | 332 |
DEFAULT CHARACTER SET = utf8 |
| 333 |
COLLATE = utf8_unicode_ci;
|
|
| 333 |
COLLATE = utf8_bin;
|
|
| 334 | 334 |
|
| 335 | 335 |
|
| 336 | 336 |
-- ----------------------------------------------------- |
| ... | ... | |
| 363 | 363 |
ON UPDATE CASCADE) |
| 364 | 364 |
ENGINE = InnoDB |
| 365 | 365 |
DEFAULT CHARACTER SET = utf8 |
| 366 |
COLLATE = utf8_unicode_ci;
|
|
| 366 |
COLLATE = utf8_bin;
|
|
| 367 | 367 |
|
| 368 | 368 |
|
| 369 | 369 |
-- ----------------------------------------------------- |
| ... | ... | |
| 395 | 395 |
ON UPDATE CASCADE) |
| 396 | 396 |
ENGINE = InnoDB |
| 397 | 397 |
DEFAULT CHARACTER SET = utf8 |
| 398 |
COLLATE = utf8_unicode_ci;
|
|
| 398 |
COLLATE = utf8_bin;
|
|
| 399 | 399 |
|
| 400 | 400 |
|
| 401 | 401 |
-- ----------------------------------------------------- |
| ... | ... | |
| 440 | 440 |
ON UPDATE CASCADE) |
| 441 | 441 |
ENGINE = InnoDB |
| 442 | 442 |
DEFAULT CHARACTER SET = utf8 |
| 443 |
COLLATE = utf8_unicode_ci;
|
|
| 443 |
COLLATE = utf8_bin;
|
|
| 444 | 444 |
|
| 445 | 445 |
|
| 446 | 446 |
-- ----------------------------------------------------- |
| ... | ... | |
| 456 | 456 |
ON UPDATE CASCADE) |
| 457 | 457 |
ENGINE = InnoDB |
| 458 | 458 |
DEFAULT CHARACTER SET = utf8 |
| 459 |
COLLATE = utf8_unicode_ci;
|
|
| 459 |
COLLATE = utf8_bin;
|
|
| 460 | 460 |
|
| 461 | 461 |
|
| 462 | 462 |
-- ----------------------------------------------------- |
| ... | ... | |
| 473 | 473 |
ON UPDATE CASCADE) |
| 474 | 474 |
ENGINE = InnoDB |
| 475 | 475 |
DEFAULT CHARACTER SET = utf8 |
| 476 |
COLLATE = utf8_unicode_ci;
|
|
| 476 |
COLLATE = utf8_bin;
|
|
| 477 | 477 |
|
| 478 | 478 |
|
| 479 | 479 |
-- ----------------------------------------------------- |
| ... | ... | |
| 519 | 519 |
ON UPDATE CASCADE) |
| 520 | 520 |
ENGINE = InnoDB |
| 521 | 521 |
DEFAULT CHARACTER SET = utf8 |
| 522 |
COLLATE = utf8_unicode_ci;
|
|
| 522 |
COLLATE = utf8_bin;
|
|
| 523 | 523 |
|
| 524 | 524 |
|
| 525 | 525 |
-- ----------------------------------------------------- |
| ... | ... | |
| 537 | 537 |
ON UPDATE CASCADE) |
| 538 | 538 |
ENGINE = InnoDB |
| 539 | 539 |
DEFAULT CHARACTER SET = utf8 |
| 540 |
COLLATE = utf8_unicode_ci;
|
|
| 540 |
COLLATE = utf8_bin;
|
|
| 541 | 541 |
|
| 542 | 542 |
|
| 543 | 543 |
-- ----------------------------------------------------- |
| ... | ... | |
| 561 | 561 |
ON UPDATE CASCADE) |
| 562 | 562 |
ENGINE = InnoDB |
| 563 | 563 |
DEFAULT CHARACTER SET = utf8 |
| 564 |
COLLATE = utf8_unicode_ci;
|
|
| 564 |
COLLATE = utf8_bin;
|
|
| 565 | 565 |
|
| 566 | 566 |
|
| 567 | 567 |
-- ----------------------------------------------------- |
| ... | ... | |
| 584 | 584 |
ON UPDATE CASCADE) |
| 585 | 585 |
ENGINE = InnoDB |
| 586 | 586 |
DEFAULT CHARACTER SET = utf8 |
| 587 |
COLLATE = utf8_unicode_ci;
|
|
| 587 |
COLLATE = utf8_bin;
|
|
| 588 | 588 |
|
| 589 | 589 |
|
| 590 | 590 |
-- ----------------------------------------------------- |
| ... | ... | |
| 616 | 616 |
ON UPDATE CASCADE) |
| 617 | 617 |
ENGINE = InnoDB |
| 618 | 618 |
DEFAULT CHARACTER SET = utf8 |
| 619 |
COLLATE = utf8_unicode_ci;
|
|
| 619 |
COLLATE = utf8_bin;
|
|
| 620 | 620 |
|
| 621 | 621 |
|
| 622 | 622 |
-- ----------------------------------------------------- |
| ... | ... | |
| 639 | 639 |
ON UPDATE CASCADE) |
| 640 | 640 |
ENGINE = InnoDB |
| 641 | 641 |
DEFAULT CHARACTER SET = utf8 |
| 642 |
COLLATE = utf8_unicode_ci;
|
|
| 642 |
COLLATE = utf8_bin;
|
|
| 643 | 643 |
|
| 644 | 644 |
|
| 645 | 645 |
-- ----------------------------------------------------- |
| ... | ... | |
| 662 | 662 |
ON UPDATE CASCADE) |
| 663 | 663 |
ENGINE = InnoDB |
| 664 | 664 |
DEFAULT CHARACTER SET = utf8 |
| 665 |
COLLATE = utf8_unicode_ci;
|
|
| 665 |
COLLATE = utf8_bin;
|
|
| 666 | 666 |
|
| 667 | 667 |
|
| 668 | 668 |
-- ----------------------------------------------------- |
| ... | ... | |
| 700 | 700 |
ON UPDATE CASCADE) |
| 701 | 701 |
ENGINE = InnoDB |
| 702 | 702 |
DEFAULT CHARACTER SET = utf8 |
| 703 |
COLLATE = utf8_unicode_ci;
|
|
| 703 |
COLLATE = utf8_bin;
|
|
| 704 | 704 |
|
| 705 | 705 |
|
| 706 | 706 |
-- ----------------------------------------------------- |
| ... | ... | |
| 718 | 718 |
ON UPDATE CASCADE) |
| 719 | 719 |
ENGINE = InnoDB |
| 720 | 720 |
DEFAULT CHARACTER SET = utf8 |
| 721 |
COLLATE = utf8_unicode_ci;
|
|
| 721 |
COLLATE = utf8_bin;
|
|
| 722 | 722 |
|
| 723 | 723 |
|
| 724 | 724 |
-- ----------------------------------------------------- |
| ... | ... | |
| 736 | 736 |
ON UPDATE CASCADE) |
| 737 | 737 |
ENGINE = InnoDB |
| 738 | 738 |
DEFAULT CHARACTER SET = utf8 |
| 739 |
COLLATE = utf8_unicode_ci;
|
|
| 739 |
COLLATE = utf8_bin;
|
|
| 740 | 740 |
|
| 741 | 741 |
|
| 742 | 742 |
-- ----------------------------------------------------- |
| ... | ... | |
| 778 | 778 |
ON UPDATE CASCADE) |
| 779 | 779 |
ENGINE = InnoDB |
| 780 | 780 |
DEFAULT CHARACTER SET = utf8 |
| 781 |
COLLATE = utf8_unicode_ci;
|
|
| 781 |
COLLATE = utf8_bin;
|
|
| 782 | 782 |
|
| 783 | 783 |
|
| 784 | 784 |
-- ----------------------------------------------------- |
| ... | ... | |
| 795 | 795 |
ON UPDATE CASCADE) |
| 796 | 796 |
ENGINE = InnoDB |
| 797 | 797 |
DEFAULT CHARACTER SET = utf8 |
| 798 |
COLLATE = utf8_unicode_ci;
|
|
| 798 |
COLLATE = utf8_bin;
|
|
| 799 | 799 |
|
| 800 | 800 |
|
| 801 | 801 |
-- ----------------------------------------------------- |
| ... | ... | |
| 814 | 814 |
ON UPDATE CASCADE) |
| 815 | 815 |
ENGINE = InnoDB |
| 816 | 816 |
DEFAULT CHARACTER SET = utf8 |
| 817 |
COLLATE = utf8_unicode_ci;
|
|
| 817 |
COLLATE = utf8_bin;
|
|
| 818 | 818 |
|
| 819 | 819 |
|
| 820 | 820 |
-- ----------------------------------------------------- |
| ... | ... | |
| 832 | 832 |
ON UPDATE CASCADE) |
| 833 | 833 |
ENGINE = InnoDB |
| 834 | 834 |
DEFAULT CHARACTER SET = utf8 |
| 835 |
COLLATE = utf8_unicode_ci;
|
|
| 835 |
COLLATE = utf8_bin;
|
|
| 836 | 836 |
|
| 837 | 837 |
|
| 838 | 838 |
-- ----------------------------------------------------- |
| ... | ... | |
| 858 | 858 |
ON UPDATE CASCADE) |
| 859 | 859 |
ENGINE = InnoDB |
| 860 | 860 |
DEFAULT CHARACTER SET = utf8 |
| 861 |
COLLATE = utf8_unicode_ci;
|
|
| 861 |
COLLATE = utf8_bin;
|
|
| 862 | 862 |
|
| 863 | 863 |
|
| 864 | 864 |
-- ----------------------------------------------------- |
| ... | ... | |
| 876 | 876 |
ON UPDATE CASCADE) |
| 877 | 877 |
ENGINE = InnoDB |
| 878 | 878 |
DEFAULT CHARACTER SET = utf8 |
| 879 |
COLLATE = utf8_unicode_ci;
|
|
| 879 |
COLLATE = utf8_bin;
|
|
| 880 | 880 |
|
| 881 | 881 |
|
| 882 | 882 |
-- ----------------------------------------------------- |
| ... | ... | |
| 892 | 892 |
ON UPDATE CASCADE) |
| 893 | 893 |
ENGINE = InnoDB |
| 894 | 894 |
DEFAULT CHARACTER SET = utf8 |
| 895 |
COLLATE = utf8_unicode_ci;
|
|
| 895 |
COLLATE = utf8_bin;
|
|
| 896 | 896 |
|
| 897 | 897 |
|
| 898 | 898 |
-- ----------------------------------------------------- |
| ... | ... | |
| 915 | 915 |
ON UPDATE CASCADE) |
| 916 | 916 |
ENGINE = InnoDB |
| 917 | 917 |
DEFAULT CHARACTER SET = utf8 |
| 918 |
COLLATE = utf8_unicode_ci;
|
|
| 918 |
COLLATE = utf8_bin;
|
|
| 919 | 919 |
|
| 920 | 920 |
|
| 921 | 921 |
-- ----------------------------------------------------- |
| ... | ... | |
| 931 | 931 |
ON UPDATE CASCADE) |
| 932 | 932 |
ENGINE = InnoDB |
| 933 | 933 |
DEFAULT CHARACTER SET = utf8 |
| 934 |
COLLATE = utf8_unicode_ci;
|
|
| 934 |
COLLATE = utf8_bin;
|
|
| 935 | 935 |
|
| 936 | 936 |
|
| 937 | 937 |
-- ----------------------------------------------------- |
| ... | ... | |
| 949 | 949 |
ON UPDATE CASCADE) |
| 950 | 950 |
ENGINE = InnoDB |
| 951 | 951 |
DEFAULT CHARACTER SET = utf8 |
| 952 |
COLLATE = utf8_unicode_ci;
|
|
| 952 |
COLLATE = utf8_bin;
|
|
| 953 | 953 |
|
| 954 | 954 |
|
| 955 | 955 |
-- ----------------------------------------------------- |
| ... | ... | |
| 972 | 972 |
ON UPDATE CASCADE) |
| 973 | 973 |
ENGINE = InnoDB |
| 974 | 974 |
DEFAULT CHARACTER SET = utf8 |
| 975 |
COLLATE = utf8_unicode_ci;
|
|
| 975 |
COLLATE = utf8_bin;
|
|
| 976 | 976 |
|
| 977 | 977 |
|
| 978 | 978 |
-- ----------------------------------------------------- |
| ... | ... | |
| 983 | 983 |
PRIMARY KEY (`id`) ) |
| 984 | 984 |
ENGINE = InnoDB |
| 985 | 985 |
DEFAULT CHARACTER SET = utf8 |
| 986 |
COLLATE = utf8_unicode_ci;
|
|
| 986 |
COLLATE = utf8_bin;
|
|
| 987 | 987 |
|
| 988 | 988 |
|
| 989 | 989 |
-- ----------------------------------------------------- |
| ... | ... | |
| 994 | 994 |
PRIMARY KEY (`id`) ) |
| 995 | 995 |
ENGINE = InnoDB |
| 996 | 996 |
DEFAULT CHARACTER SET = utf8 |
| 997 |
COLLATE = utf8_unicode_ci;
|
|
| 997 |
COLLATE = utf8_bin;
|
|
| 998 | 998 |
|
| 999 | 999 |
|
| 1000 | 1000 |
-- ----------------------------------------------------- |
| ... | ... | |
| 1005 | 1005 |
PRIMARY KEY (`id`) ) |
| 1006 | 1006 |
ENGINE = InnoDB |
| 1007 | 1007 |
DEFAULT CHARACTER SET = utf8 |
| 1008 |
COLLATE = utf8_unicode_ci;
|
|
| 1008 |
COLLATE = utf8_bin;
|
|
| 1009 | 1009 |
|
| 1010 | 1010 |
|
| 1011 | 1011 |
-- ----------------------------------------------------- |
| ... | ... | |
| 1016 | 1016 |
PRIMARY KEY (`id`) ) |
| 1017 | 1017 |
ENGINE = InnoDB |
| 1018 | 1018 |
DEFAULT CHARACTER SET = utf8 |
| 1019 |
COLLATE = utf8_unicode_ci;
|
|
| 1019 |
COLLATE = utf8_bin;
|
|
| 1020 | 1020 |
|
| 1021 | 1021 |
|
| 1022 | 1022 |
-- ----------------------------------------------------- |
| ... | ... | |
| 1027 | 1027 |
PRIMARY KEY (`id`) ) |
| 1028 | 1028 |
ENGINE = InnoDB |
| 1029 | 1029 |
DEFAULT CHARACTER SET = utf8 |
| 1030 |
COLLATE = utf8_unicode_ci;
|
|
| 1030 |
COLLATE = utf8_bin;
|
|
| 1031 | 1031 |
|
| 1032 | 1032 |
|
| 1033 | 1033 |
-- ----------------------------------------------------- |
| ... | ... | |
| 1038 | 1038 |
PRIMARY KEY (`id`) ) |
| 1039 | 1039 |
ENGINE = InnoDB |
| 1040 | 1040 |
DEFAULT CHARACTER SET = utf8 |
| 1041 |
COLLATE = utf8_unicode_ci;
|
|
| 1041 |
COLLATE = utf8_bin;
|
|
| 1042 | 1042 |
|
| 1043 | 1043 |
|
| 1044 | 1044 |
-- ----------------------------------------------------- |
| ... | ... | |
| 1057 | 1057 |
ON UPDATE CASCADE) |
| 1058 | 1058 |
ENGINE = InnoDB |
| 1059 | 1059 |
DEFAULT CHARACTER SET = utf8 |
| 1060 |
COLLATE = utf8_unicode_ci;
|
|
| 1060 |
COLLATE = utf8_bin;
|
|
| 1061 | 1061 |
|
| 1062 | 1062 |
|
| 1063 | 1063 |
-- ----------------------------------------------------- |
| ... | ... | |
| 1077 | 1077 |
ON UPDATE CASCADE) |
| 1078 | 1078 |
ENGINE = InnoDB |
| 1079 | 1079 |
DEFAULT CHARACTER SET = utf8 |
| 1080 |
COLLATE = utf8_unicode_ci;
|
|
| 1080 |
COLLATE = utf8_bin;
|
|
| 1081 | 1081 |
|
| 1082 | 1082 |
|
| 1083 | 1083 |
-- ----------------------------------------------------- |
| ... | ... | |
| 1100 | 1100 |
ON UPDATE CASCADE) |
| 1101 | 1101 |
ENGINE = InnoDB |
| 1102 | 1102 |
DEFAULT CHARACTER SET = utf8 |
| 1103 |
COLLATE = utf8_unicode_ci;
|
|
| 1103 |
COLLATE = utf8_bin;
|
|
| 1104 | 1104 |
|
| 1105 | 1105 |
|
| 1106 | 1106 |
-- ----------------------------------------------------- |
| ... | ... | |
| 1125 | 1125 |
ON UPDATE CASCADE) |
| 1126 | 1126 |
ENGINE = InnoDB |
| 1127 | 1127 |
DEFAULT CHARACTER SET = utf8 |
| 1128 |
COLLATE = utf8_unicode_ci;
|
|
| 1128 |
COLLATE = utf8_bin;
|
|
| 1129 | 1129 |
|
| 1130 | 1130 |
|
| 1131 | 1131 |
-- ----------------------------------------------------- |
| ... | ... | |
| 1150 | 1150 |
ON UPDATE CASCADE) |
| 1151 | 1151 |
ENGINE = InnoDB |
| 1152 | 1152 |
DEFAULT CHARACTER SET = utf8 |
| 1153 |
COLLATE = utf8_unicode_ci;
|
|
| 1153 |
COLLATE = utf8_bin;
|
|
| 1154 | 1154 |
|
| 1155 | 1155 |
|
| 1156 | 1156 |
|
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: changed collation to utf8_bin to avoid case-*in*sensitive comparison of case-sensitive strings. (utf8_bin is also much faster than encoding-aware collations because it uses the raw bytes.)