Revision 8621
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_bin;
|
|
| 19 |
DEFAULT CHARACTER SET = utf8
|
|
| 20 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 54 |
DEFAULT CHARACTER SET = utf8
|
|
| 55 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 74 |
DEFAULT CHARACTER SET = utf8
|
|
| 75 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 105 |
DEFAULT CHARACTER SET = utf8
|
|
| 106 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 133 |
DEFAULT CHARACTER SET = utf8
|
|
| 134 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 158 |
DEFAULT CHARACTER SET = utf8
|
|
| 159 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 176 |
DEFAULT CHARACTER SET = utf8
|
|
| 177 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 208 |
DEFAULT CHARACTER SET = utf8
|
|
| 209 |
COLLATE = utf8_bin;
|
|
| 210 | 210 |
|
| 211 | 211 |
|
| 212 | 212 |
-- ----------------------------------------------------- |
| ... | ... | |
| 218 | 218 |
`longitude_deg` VARBINARY(767) NULL , |
| 219 | 219 |
PRIMARY KEY (`id`) ) |
| 220 | 220 |
ENGINE = InnoDB |
| 221 |
DEFAULT CHARACTER SET = latin1
|
|
| 222 |
COLLATE = latin1_bin;
|
|
| 221 |
DEFAULT CHARACTER SET = utf8
|
|
| 222 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 238 |
DEFAULT CHARACTER SET = utf8
|
|
| 239 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 276 |
DEFAULT CHARACTER SET = utf8
|
|
| 277 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 293 |
DEFAULT CHARACTER SET = utf8
|
|
| 294 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 332 |
DEFAULT CHARACTER SET = utf8
|
|
| 333 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 365 |
DEFAULT CHARACTER SET = utf8
|
|
| 366 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 397 |
DEFAULT CHARACTER SET = utf8
|
|
| 398 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 442 |
DEFAULT CHARACTER SET = utf8
|
|
| 443 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 458 |
DEFAULT CHARACTER SET = utf8
|
|
| 459 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 475 |
DEFAULT CHARACTER SET = utf8
|
|
| 476 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 521 |
DEFAULT CHARACTER SET = utf8
|
|
| 522 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 539 |
DEFAULT CHARACTER SET = utf8
|
|
| 540 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 563 |
DEFAULT CHARACTER SET = utf8
|
|
| 564 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 586 |
DEFAULT CHARACTER SET = utf8
|
|
| 587 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 618 |
DEFAULT CHARACTER SET = utf8
|
|
| 619 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 641 |
DEFAULT CHARACTER SET = utf8
|
|
| 642 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 664 |
DEFAULT CHARACTER SET = utf8
|
|
| 665 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 702 |
DEFAULT CHARACTER SET = utf8
|
|
| 703 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 720 |
DEFAULT CHARACTER SET = utf8
|
|
| 721 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 738 |
DEFAULT CHARACTER SET = utf8
|
|
| 739 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 780 |
DEFAULT CHARACTER SET = utf8
|
|
| 781 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 797 |
DEFAULT CHARACTER SET = utf8
|
|
| 798 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 816 |
DEFAULT CHARACTER SET = utf8
|
|
| 817 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 834 |
DEFAULT CHARACTER SET = utf8
|
|
| 835 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 860 |
DEFAULT CHARACTER SET = utf8
|
|
| 861 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 878 |
DEFAULT CHARACTER SET = utf8
|
|
| 879 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 894 |
DEFAULT CHARACTER SET = utf8
|
|
| 895 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 917 |
DEFAULT CHARACTER SET = utf8
|
|
| 918 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 933 |
DEFAULT CHARACTER SET = utf8
|
|
| 934 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 951 |
DEFAULT CHARACTER SET = utf8
|
|
| 952 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 974 |
DEFAULT CHARACTER SET = utf8
|
|
| 975 |
COLLATE = utf8_bin;
|
|
| 976 | 976 |
|
| 977 | 977 |
|
| 978 | 978 |
-- ----------------------------------------------------- |
| ... | ... | |
| 982 | 982 |
`id` VARBINARY(767) NOT NULL , |
| 983 | 983 |
PRIMARY KEY (`id`) ) |
| 984 | 984 |
ENGINE = InnoDB |
| 985 |
DEFAULT CHARACTER SET = latin1
|
|
| 986 |
COLLATE = latin1_bin;
|
|
| 985 |
DEFAULT CHARACTER SET = utf8
|
|
| 986 |
COLLATE = utf8_bin;
|
|
| 987 | 987 |
|
| 988 | 988 |
|
| 989 | 989 |
-- ----------------------------------------------------- |
| ... | ... | |
| 993 | 993 |
`id` VARBINARY(767) NOT NULL , |
| 994 | 994 |
PRIMARY KEY (`id`) ) |
| 995 | 995 |
ENGINE = InnoDB |
| 996 |
DEFAULT CHARACTER SET = latin1
|
|
| 997 |
COLLATE = latin1_bin;
|
|
| 996 |
DEFAULT CHARACTER SET = utf8
|
|
| 997 |
COLLATE = utf8_bin;
|
|
| 998 | 998 |
|
| 999 | 999 |
|
| 1000 | 1000 |
-- ----------------------------------------------------- |
| ... | ... | |
| 1004 | 1004 |
`id` VARBINARY(767) NOT NULL , |
| 1005 | 1005 |
PRIMARY KEY (`id`) ) |
| 1006 | 1006 |
ENGINE = InnoDB |
| 1007 |
DEFAULT CHARACTER SET = latin1
|
|
| 1008 |
COLLATE = latin1_bin;
|
|
| 1007 |
DEFAULT CHARACTER SET = utf8
|
|
| 1008 |
COLLATE = utf8_bin;
|
|
| 1009 | 1009 |
|
| 1010 | 1010 |
|
| 1011 | 1011 |
-- ----------------------------------------------------- |
| ... | ... | |
| 1015 | 1015 |
`id` VARBINARY(767) NOT NULL , |
| 1016 | 1016 |
PRIMARY KEY (`id`) ) |
| 1017 | 1017 |
ENGINE = InnoDB |
| 1018 |
DEFAULT CHARACTER SET = latin1
|
|
| 1019 |
COLLATE = latin1_bin;
|
|
| 1018 |
DEFAULT CHARACTER SET = utf8
|
|
| 1019 |
COLLATE = utf8_bin;
|
|
| 1020 | 1020 |
|
| 1021 | 1021 |
|
| 1022 | 1022 |
-- ----------------------------------------------------- |
| ... | ... | |
| 1026 | 1026 |
`id` VARBINARY(767) NOT NULL , |
| 1027 | 1027 |
PRIMARY KEY (`id`) ) |
| 1028 | 1028 |
ENGINE = InnoDB |
| 1029 |
DEFAULT CHARACTER SET = latin1
|
|
| 1030 |
COLLATE = latin1_bin;
|
|
| 1029 |
DEFAULT CHARACTER SET = utf8
|
|
| 1030 |
COLLATE = utf8_bin;
|
|
| 1031 | 1031 |
|
| 1032 | 1032 |
|
| 1033 | 1033 |
-- ----------------------------------------------------- |
| ... | ... | |
| 1037 | 1037 |
`id` VARBINARY(767) NOT NULL , |
| 1038 | 1038 |
PRIMARY KEY (`id`) ) |
| 1039 | 1039 |
ENGINE = InnoDB |
| 1040 |
DEFAULT CHARACTER SET = latin1
|
|
| 1041 |
COLLATE = latin1_bin;
|
|
| 1040 |
DEFAULT CHARACTER SET = utf8
|
|
| 1041 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 1059 |
DEFAULT CHARACTER SET = utf8
|
|
| 1060 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 1079 |
DEFAULT CHARACTER SET = utf8
|
|
| 1080 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 1102 |
DEFAULT CHARACTER SET = utf8
|
|
| 1103 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 1127 |
DEFAULT CHARACTER SET = utf8
|
|
| 1128 |
COLLATE = utf8_bin;
|
|
| 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_bin;
|
|
| 1152 |
DEFAULT CHARACTER SET = utf8
|
|
| 1153 |
COLLATE = utf8_bin;
|
|
| 1154 | 1154 |
|
| 1155 | 1155 |
|
| 1156 | 1156 |
|
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: changed encoding back to utf8/utf8_bin now that latin1 isn't needed to make the key columns satisfy the index length limits. note that the connection encoding must be utf8 on import so that the correct byte sequence is stored in the VARBINARY columns.