| [ Index ] |
|
Code source de eZ Publish 3.9.0 |
1 2 3 4 5 6 7 8 9 10 11 12 CREATE SEQUENCE ezapprove_items_s 13 START 1 14 INCREMENT 1 15 MAXVALUE 9223372036854775807 16 MINVALUE 1 17 CACHE 1; 18 19 20 21 22 23 24 25 CREATE SEQUENCE ezbasket_s 26 START 1 27 INCREMENT 1 28 MAXVALUE 9223372036854775807 29 MINVALUE 1 30 CACHE 1; 31 32 33 34 35 36 37 38 CREATE SEQUENCE ezcollab_group_s 39 START 1 40 INCREMENT 1 41 MAXVALUE 9223372036854775807 42 MINVALUE 1 43 CACHE 1; 44 45 46 47 48 49 50 51 CREATE SEQUENCE ezcollab_item_s 52 START 1 53 INCREMENT 1 54 MAXVALUE 9223372036854775807 55 MINVALUE 1 56 CACHE 1; 57 58 59 60 61 62 63 64 CREATE SEQUENCE ezcollab_item_message_link_s 65 START 1 66 INCREMENT 1 67 MAXVALUE 9223372036854775807 68 MINVALUE 1 69 CACHE 1; 70 71 72 73 74 75 76 77 CREATE SEQUENCE ezcollab_notification_rule_s 78 START 1 79 INCREMENT 1 80 MAXVALUE 9223372036854775807 81 MINVALUE 1 82 CACHE 1; 83 84 85 86 87 88 89 90 CREATE SEQUENCE ezcollab_profile_s 91 START 1 92 INCREMENT 1 93 MAXVALUE 9223372036854775807 94 MINVALUE 1 95 CACHE 1; 96 97 98 99 100 101 102 103 CREATE SEQUENCE ezcollab_simple_message_s 104 START 1 105 INCREMENT 1 106 MAXVALUE 9223372036854775807 107 MINVALUE 1 108 CACHE 1; 109 110 111 112 113 114 115 116 CREATE SEQUENCE ezcontentbrowsebookmark_s 117 START 1 118 INCREMENT 1 119 MAXVALUE 9223372036854775807 120 MINVALUE 1 121 CACHE 1; 122 123 124 125 126 127 128 129 CREATE SEQUENCE ezcontentbrowserecent_s 130 START 1 131 INCREMENT 1 132 MAXVALUE 9223372036854775807 133 MINVALUE 1 134 CACHE 1; 135 136 137 138 139 140 141 142 CREATE SEQUENCE ezcontentclass_s 143 START 1 144 INCREMENT 1 145 MAXVALUE 9223372036854775807 146 MINVALUE 1 147 CACHE 1; 148 149 150 151 152 153 154 155 CREATE SEQUENCE ezcontentclass_attribute_s 156 START 1 157 INCREMENT 1 158 MAXVALUE 9223372036854775807 159 MINVALUE 1 160 CACHE 1; 161 162 163 164 165 166 167 168 CREATE SEQUENCE ezcontentclassgroup_s 169 START 1 170 INCREMENT 1 171 MAXVALUE 9223372036854775807 172 MINVALUE 1 173 CACHE 1; 174 175 176 177 178 179 180 181 CREATE SEQUENCE ezcontentobject_s 182 START 1 183 INCREMENT 1 184 MAXVALUE 9223372036854775807 185 MINVALUE 1 186 CACHE 1; 187 188 189 190 191 192 193 194 CREATE SEQUENCE ezcontentobject_attribute_s 195 START 1 196 INCREMENT 1 197 MAXVALUE 9223372036854775807 198 MINVALUE 1 199 CACHE 1; 200 201 202 203 204 205 206 207 CREATE SEQUENCE ezcontentobject_link_s 208 START 1 209 INCREMENT 1 210 MAXVALUE 9223372036854775807 211 MINVALUE 1 212 CACHE 1; 213 214 215 216 217 218 219 220 CREATE SEQUENCE ezcontentobject_tree_s 221 START 1 222 INCREMENT 1 223 MAXVALUE 9223372036854775807 224 MINVALUE 1 225 CACHE 1; 226 227 228 229 230 231 232 233 CREATE SEQUENCE ezcontentobject_version_s 234 START 1 235 INCREMENT 1 236 MAXVALUE 9223372036854775807 237 MINVALUE 1 238 CACHE 1; 239 240 241 242 243 244 245 246 CREATE SEQUENCE ezcurrencydata_s 247 START 1 248 INCREMENT 1 249 MAXVALUE 9223372036854775807 250 MINVALUE 1 251 CACHE 1; 252 253 254 255 256 257 258 259 CREATE SEQUENCE ezdiscountrule_s 260 START 1 261 INCREMENT 1 262 MAXVALUE 9223372036854775807 263 MINVALUE 1 264 CACHE 1; 265 266 267 268 269 270 271 272 CREATE SEQUENCE ezdiscountsubrule_s 273 START 1 274 INCREMENT 1 275 MAXVALUE 9223372036854775807 276 MINVALUE 1 277 CACHE 1; 278 279 280 281 282 283 284 285 CREATE SEQUENCE ezenumvalue_s 286 START 1 287 INCREMENT 1 288 MAXVALUE 9223372036854775807 289 MINVALUE 1 290 CACHE 1; 291 292 293 294 295 296 297 298 CREATE SEQUENCE ezforgot_password_s 299 START 1 300 INCREMENT 1 301 MAXVALUE 9223372036854775807 302 MINVALUE 1 303 CACHE 1; 304 305 306 307 308 309 310 311 CREATE SEQUENCE ezgeneral_digest_user_settings_s 312 START 1 313 INCREMENT 1 314 MAXVALUE 9223372036854775807 315 MINVALUE 1 316 CACHE 1; 317 318 319 320 321 322 323 324 CREATE SEQUENCE ezimagefile_s 325 START 1 326 INCREMENT 1 327 MAXVALUE 9223372036854775807 328 MINVALUE 1 329 CACHE 1; 330 331 332 333 334 335 336 337 CREATE SEQUENCE ezinfocollection_s 338 START 1 339 INCREMENT 1 340 MAXVALUE 9223372036854775807 341 MINVALUE 1 342 CACHE 1; 343 344 345 346 347 348 349 350 CREATE SEQUENCE ezinfocollection_attribute_s 351 START 1 352 INCREMENT 1 353 MAXVALUE 9223372036854775807 354 MINVALUE 1 355 CACHE 1; 356 357 358 359 360 361 362 363 CREATE SEQUENCE ezkeyword_s 364 START 1 365 INCREMENT 1 366 MAXVALUE 9223372036854775807 367 MINVALUE 1 368 CACHE 1; 369 370 371 372 373 374 375 376 CREATE SEQUENCE ezkeyword_attribute_link_s 377 START 1 378 INCREMENT 1 379 MAXVALUE 9223372036854775807 380 MINVALUE 1 381 CACHE 1; 382 383 384 385 386 387 388 389 CREATE SEQUENCE ezmessage_s 390 START 1 391 INCREMENT 1 392 MAXVALUE 9223372036854775807 393 MINVALUE 1 394 CACHE 1; 395 396 397 398 399 400 401 402 CREATE SEQUENCE ezmodule_run_s 403 START 1 404 INCREMENT 1 405 MAXVALUE 9223372036854775807 406 MINVALUE 1 407 CACHE 1; 408 409 410 411 412 413 414 415 CREATE SEQUENCE ezmultipricedata_s 416 START 1 417 INCREMENT 1 418 MAXVALUE 9223372036854775807 419 MINVALUE 1 420 CACHE 1; 421 422 423 424 425 426 427 428 CREATE SEQUENCE eznode_assignment_s 429 START 1 430 INCREMENT 1 431 MAXVALUE 9223372036854775807 432 MINVALUE 1 433 CACHE 1; 434 435 436 437 438 439 440 441 CREATE SEQUENCE eznotificationcollection_s 442 START 1 443 INCREMENT 1 444 MAXVALUE 9223372036854775807 445 MINVALUE 1 446 CACHE 1; 447 448 449 450 451 452 453 454 CREATE SEQUENCE eznotificationcollection_item_s 455 START 1 456 INCREMENT 1 457 MAXVALUE 9223372036854775807 458 MINVALUE 1 459 CACHE 1; 460 461 462 463 464 465 466 467 CREATE SEQUENCE eznotificationevent_s 468 START 1 469 INCREMENT 1 470 MAXVALUE 9223372036854775807 471 MINVALUE 1 472 CACHE 1; 473 474 475 476 477 478 479 480 CREATE SEQUENCE ezoperation_memento_s 481 START 1 482 INCREMENT 1 483 MAXVALUE 9223372036854775807 484 MINVALUE 1 485 CACHE 1; 486 487 488 489 490 491 492 493 CREATE SEQUENCE ezorder_s 494 START 1 495 INCREMENT 1 496 MAXVALUE 9223372036854775807 497 MINVALUE 1 498 CACHE 1; 499 500 501 502 503 504 505 506 CREATE SEQUENCE ezorder_item_s 507 START 1 508 INCREMENT 1 509 MAXVALUE 9223372036854775807 510 MINVALUE 1 511 CACHE 1; 512 513 514 515 516 517 518 519 CREATE SEQUENCE ezorder_status_s 520 START 1 521 INCREMENT 1 522 MAXVALUE 9223372036854775807 523 MINVALUE 1 524 CACHE 1; 525 526 527 528 529 530 531 532 CREATE SEQUENCE ezorder_status_history_s 533 START 1 534 INCREMENT 1 535 MAXVALUE 9223372036854775807 536 MINVALUE 1 537 CACHE 1; 538 539 540 541 542 543 544 545 CREATE SEQUENCE ezpackage_s 546 START 1 547 INCREMENT 1 548 MAXVALUE 9223372036854775807 549 MINVALUE 1 550 CACHE 1; 551 552 553 554 555 556 557 558 CREATE SEQUENCE ezpaymentobject_s 559 START 1 560 INCREMENT 1 561 MAXVALUE 9223372036854775807 562 MINVALUE 1 563 CACHE 1; 564 565 566 567 568 569 570 571 CREATE SEQUENCE ezpdf_export_s 572 START 1 573 INCREMENT 1 574 MAXVALUE 9223372036854775807 575 MINVALUE 1 576 CACHE 1; 577 578 579 580 581 582 583 584 CREATE SEQUENCE ezpolicy_s 585 START 1 586 INCREMENT 1 587 MAXVALUE 9223372036854775807 588 MINVALUE 1 589 CACHE 1; 590 591 592 593 594 595 596 597 CREATE SEQUENCE ezpolicy_limitation_s 598 START 1 599 INCREMENT 1 600 MAXVALUE 9223372036854775807 601 MINVALUE 1 602 CACHE 1; 603 604 605 606 607 608 609 610 CREATE SEQUENCE ezpolicy_limitation_value_s 611 START 1 612 INCREMENT 1 613 MAXVALUE 9223372036854775807 614 MINVALUE 1 615 CACHE 1; 616 617 618 619 620 621 622 623 CREATE SEQUENCE ezpreferences_s 624 START 1 625 INCREMENT 1 626 MAXVALUE 9223372036854775807 627 MINVALUE 1 628 CACHE 1; 629 630 631 632 633 634 635 636 CREATE SEQUENCE ezproductcategory_s 637 START 1 638 INCREMENT 1 639 MAXVALUE 9223372036854775807 640 MINVALUE 1 641 CACHE 1; 642 643 644 645 646 647 648 649 CREATE SEQUENCE ezproductcollection_s 650 START 1 651 INCREMENT 1 652 MAXVALUE 9223372036854775807 653 MINVALUE 1 654 CACHE 1; 655 656 657 658 659 660 661 662 CREATE SEQUENCE ezproductcollection_item_s 663 START 1 664 INCREMENT 1 665 MAXVALUE 9223372036854775807 666 MINVALUE 1 667 CACHE 1; 668 669 670 671 672 673 674 675 CREATE SEQUENCE ezproductcollection_item_opt_s 676 START 1 677 INCREMENT 1 678 MAXVALUE 9223372036854775807 679 MINVALUE 1 680 CACHE 1; 681 682 683 684 685 686 687 688 CREATE SEQUENCE ezrole_s 689 START 1 690 INCREMENT 1 691 MAXVALUE 9223372036854775807 692 MINVALUE 1 693 CACHE 1; 694 695 696 697 698 699 700 701 CREATE SEQUENCE ezrss_export_s 702 START 1 703 INCREMENT 1 704 MAXVALUE 9223372036854775807 705 MINVALUE 1 706 CACHE 1; 707 708 709 710 711 712 713 714 CREATE SEQUENCE ezrss_export_item_s 715 START 1 716 INCREMENT 1 717 MAXVALUE 9223372036854775807 718 MINVALUE 1 719 CACHE 1; 720 721 722 723 724 725 726 727 CREATE SEQUENCE ezrss_import_s 728 START 1 729 INCREMENT 1 730 MAXVALUE 9223372036854775807 731 MINVALUE 1 732 CACHE 1; 733 734 735 736 737 738 739 740 CREATE SEQUENCE ezsearch_object_word_link_s 741 START 1 742 INCREMENT 1 743 MAXVALUE 9223372036854775807 744 MINVALUE 1 745 CACHE 1; 746 747 748 749 750 751 752 753 CREATE SEQUENCE ezsearch_return_count_s 754 START 1 755 INCREMENT 1 756 MAXVALUE 9223372036854775807 757 MINVALUE 1 758 CACHE 1; 759 760 761 762 763 764 765 766 CREATE SEQUENCE ezsearch_search_phrase_s 767 START 1 768 INCREMENT 1 769 MAXVALUE 9223372036854775807 770 MINVALUE 1 771 CACHE 1; 772 773 774 775 776 777 778 779 CREATE SEQUENCE ezsearch_word_s 780 START 1 781 INCREMENT 1 782 MAXVALUE 9223372036854775807 783 MINVALUE 1 784 CACHE 1; 785 786 787 788 789 790 791 792 CREATE SEQUENCE ezsection_s 793 START 1 794 INCREMENT 1 795 MAXVALUE 9223372036854775807 796 MINVALUE 1 797 CACHE 1; 798 799 800 801 802 803 804 805 CREATE SEQUENCE ezsubtree_notification_rule_s 806 START 1 807 INCREMENT 1 808 MAXVALUE 9223372036854775807 809 MINVALUE 1 810 CACHE 1; 811 812 813 814 815 816 817 818 CREATE SEQUENCE eztrigger_s 819 START 1 820 INCREMENT 1 821 MAXVALUE 9223372036854775807 822 MINVALUE 1 823 CACHE 1; 824 825 826 827 828 829 830 831 CREATE SEQUENCE ezurl_s 832 START 1 833 INCREMENT 1 834 MAXVALUE 9223372036854775807 835 MINVALUE 1 836 CACHE 1; 837 838 839 840 841 842 843 844 CREATE SEQUENCE ezurlalias_s 845 START 1 846 INCREMENT 1 847 MAXVALUE 9223372036854775807 848 MINVALUE 1 849 CACHE 1; 850 851 852 853 854 855 856 857 CREATE SEQUENCE ezuser_accountkey_s 858 START 1 859 INCREMENT 1 860 MAXVALUE 9223372036854775807 861 MINVALUE 1 862 CACHE 1; 863 864 865 866 867 868 869 870 CREATE SEQUENCE ezuser_discountrule_s 871 START 1 872 INCREMENT 1 873 MAXVALUE 9223372036854775807 874 MINVALUE 1 875 CACHE 1; 876 877 878 879 880 881 882 883 CREATE SEQUENCE ezuser_role_s 884 START 1 885 INCREMENT 1 886 MAXVALUE 9223372036854775807 887 MINVALUE 1 888 CACHE 1; 889 890 891 892 893 894 895 896 CREATE SEQUENCE ezvatrule_s 897 START 1 898 INCREMENT 1 899 MAXVALUE 9223372036854775807 900 MINVALUE 1 901 CACHE 1; 902 903 904 905 906 907 908 909 CREATE SEQUENCE ezvattype_s 910 START 1 911 INCREMENT 1 912 MAXVALUE 9223372036854775807 913 MINVALUE 1 914 CACHE 1; 915 916 917 918 919 920 921 922 CREATE SEQUENCE ezwaituntildatevalue_s 923 START 1 924 INCREMENT 1 925 MAXVALUE 9223372036854775807 926 MINVALUE 1 927 CACHE 1; 928 929 930 931 932 933 934 935 CREATE SEQUENCE ezwishlist_s 936 START 1 937 INCREMENT 1 938 MAXVALUE 9223372036854775807 939 MINVALUE 1 940 CACHE 1; 941 942 943 944 945 946 947 948 CREATE SEQUENCE ezworkflow_s 949 START 1 950 INCREMENT 1 951 MAXVALUE 9223372036854775807 952 MINVALUE 1 953 CACHE 1; 954 955 956 957 958 959 960 961 CREATE SEQUENCE ezworkflow_assign_s 962 START 1 963 INCREMENT 1 964 MAXVALUE 9223372036854775807 965 MINVALUE 1 966 CACHE 1; 967 968 969 970 971 972 973 974 CREATE SEQUENCE ezworkflow_event_s 975 START 1 976 INCREMENT 1 977 MAXVALUE 9223372036854775807 978 MINVALUE 1 979 CACHE 1; 980 981 982 983 984 985 986 987 CREATE SEQUENCE ezworkflow_group_s 988 START 1 989 INCREMENT 1 990 MAXVALUE 9223372036854775807 991 MINVALUE 1 992 CACHE 1; 993 994 995 996 997 998 999 1000 CREATE SEQUENCE ezworkflow_process_s 1001 START 1 1002 INCREMENT 1 1003 MAXVALUE 9223372036854775807 1004 MINVALUE 1 1005 CACHE 1; 1006 1007 1008 1009 1010 1011 1012 1013 CREATE TABLE ezapprove_items ( 1014 collaboration_id integer DEFAULT 0 NOT NULL, 1015 id integer DEFAULT nextval('ezapprove_items_s'::text) NOT NULL, 1016 workflow_process_id integer DEFAULT 0 NOT NULL 1017 ); 1018 1019 1020 1021 1022 1023 1024 1025 CREATE TABLE ezbasket ( 1026 id integer DEFAULT nextval('ezbasket_s'::text) NOT NULL, 1027 order_id integer DEFAULT 0 NOT NULL, 1028 productcollection_id integer DEFAULT 0 NOT NULL, 1029 session_id character varying(255) DEFAULT ''::character varying NOT NULL 1030 ); 1031 1032 1033 1034 1035 1036 1037 1038 CREATE TABLE ezbinaryfile ( 1039 contentobject_attribute_id integer DEFAULT 0 NOT NULL, 1040 download_count integer DEFAULT 0 NOT NULL, 1041 filename character varying(255) DEFAULT ''::character varying NOT NULL, 1042 mime_type character varying(50) DEFAULT ''::character varying NOT NULL, 1043 original_filename character varying(255) DEFAULT ''::character varying NOT NULL, 1044 "version" integer DEFAULT 0 NOT NULL 1045 ); 1046 1047 1048 1049 1050 1051 1052 1053 CREATE TABLE ezcollab_group ( 1054 created integer DEFAULT 0 NOT NULL, 1055 depth integer DEFAULT 0 NOT NULL, 1056 id integer DEFAULT nextval('ezcollab_group_s'::text) NOT NULL, 1057 is_open integer DEFAULT 1 NOT NULL, 1058 modified integer DEFAULT 0 NOT NULL, 1059 parent_group_id integer DEFAULT 0 NOT NULL, 1060 path_string character varying(255) DEFAULT ''::character varying NOT NULL, 1061 priority integer DEFAULT 0 NOT NULL, 1062 title character varying(255) DEFAULT ''::character varying NOT NULL, 1063 user_id integer DEFAULT 0 NOT NULL 1064 ); 1065 1066 1067 1068 1069 1070 1071 1072 CREATE TABLE ezcollab_item ( 1073 created integer DEFAULT 0 NOT NULL, 1074 creator_id integer DEFAULT 0 NOT NULL, 1075 data_float1 double precision DEFAULT 0::double precision NOT NULL, 1076 data_float2 double precision DEFAULT 0::double precision NOT NULL, 1077 data_float3 double precision DEFAULT 0::double precision NOT NULL, 1078 data_int1 integer DEFAULT 0 NOT NULL, 1079 data_int2 integer DEFAULT 0 NOT NULL, 1080 data_int3 integer DEFAULT 0 NOT NULL, 1081 data_text1 text NOT NULL, 1082 data_text2 text NOT NULL, 1083 data_text3 text NOT NULL, 1084 id integer DEFAULT nextval('ezcollab_item_s'::text) NOT NULL, 1085 modified integer DEFAULT 0 NOT NULL, 1086 status integer DEFAULT 1 NOT NULL, 1087 type_identifier character varying(40) DEFAULT ''::character varying NOT NULL 1088 ); 1089 1090 1091 1092 1093 1094 1095 1096 CREATE TABLE ezcollab_item_group_link ( 1097 collaboration_id integer DEFAULT 0 NOT NULL, 1098 created integer DEFAULT 0 NOT NULL, 1099 group_id integer DEFAULT 0 NOT NULL, 1100 is_active integer DEFAULT 1 NOT NULL, 1101 is_read integer DEFAULT 0 NOT NULL, 1102 last_read integer DEFAULT 0 NOT NULL, 1103 modified integer DEFAULT 0 NOT NULL, 1104 user_id integer DEFAULT 0 NOT NULL 1105 ); 1106 1107 1108 1109 1110 1111 1112 1113 CREATE TABLE ezcollab_item_message_link ( 1114 collaboration_id integer DEFAULT 0 NOT NULL, 1115 created integer DEFAULT 0 NOT NULL, 1116 id integer DEFAULT nextval('ezcollab_item_message_link_s'::text) NOT NULL, 1117 message_id integer DEFAULT 0 NOT NULL, 1118 message_type integer DEFAULT 0 NOT NULL, 1119 modified integer DEFAULT 0 NOT NULL, 1120 participant_id integer DEFAULT 0 NOT NULL 1121 ); 1122 1123 1124 1125 1126 1127 1128 1129 CREATE TABLE ezcollab_item_participant_link ( 1130 collaboration_id integer DEFAULT 0 NOT NULL, 1131 created integer DEFAULT 0 NOT NULL, 1132 is_active integer DEFAULT 1 NOT NULL, 1133 is_read integer DEFAULT 0 NOT NULL, 1134 last_read integer DEFAULT 0 NOT NULL, 1135 modified integer DEFAULT 0 NOT NULL, 1136 participant_id integer DEFAULT 0 NOT NULL, 1137 participant_role integer DEFAULT 1 NOT NULL, 1138 participant_type integer DEFAULT 1 NOT NULL 1139 ); 1140 1141 1142 1143 1144 1145 1146 1147 CREATE TABLE ezcollab_item_status ( 1148 collaboration_id integer DEFAULT 0 NOT NULL, 1149 is_active integer DEFAULT 1 NOT NULL, 1150 is_read integer DEFAULT 0 NOT NULL, 1151 last_read integer DEFAULT 0 NOT NULL, 1152 user_id integer DEFAULT 0 NOT NULL 1153 ); 1154 1155 1156 1157 1158 1159 1160 1161 CREATE TABLE ezcollab_notification_rule ( 1162 collab_identifier character varying(255) DEFAULT ''::character varying NOT NULL, 1163 id integer DEFAULT nextval('ezcollab_notification_rule_s'::text) NOT NULL, 1164 user_id character varying(255) DEFAULT ''::character varying NOT NULL 1165 ); 1166 1167 1168 1169 1170 1171 1172 1173 CREATE TABLE ezcollab_profile ( 1174 created integer DEFAULT 0 NOT NULL, 1175 data_text1 text NOT NULL, 1176 id integer DEFAULT nextval('ezcollab_profile_s'::text) NOT NULL, 1177 main_group integer DEFAULT 0 NOT NULL, 1178 modified integer DEFAULT 0 NOT NULL, 1179 user_id integer DEFAULT 0 NOT NULL 1180 ); 1181 1182 1183 1184 1185 1186 1187 1188 CREATE TABLE ezcollab_simple_message ( 1189 created integer DEFAULT 0 NOT NULL, 1190 creator_id integer DEFAULT 0 NOT NULL, 1191 data_float1 double precision DEFAULT 0::double precision NOT NULL, 1192 data_float2 double precision DEFAULT 0::double precision NOT NULL, 1193 data_float3 double precision DEFAULT 0::double precision NOT NULL, 1194 data_int1 integer DEFAULT 0 NOT NULL, 1195 data_int2 integer DEFAULT 0 NOT NULL, 1196 data_int3 integer DEFAULT 0 NOT NULL, 1197 data_text1 text NOT NULL, 1198 data_text2 text NOT NULL, 1199 data_text3 text NOT NULL, 1200 id integer DEFAULT nextval('ezcollab_simple_message_s'::text) NOT NULL, 1201 message_type character varying(40) DEFAULT ''::character varying NOT NULL, 1202 modified integer DEFAULT 0 NOT NULL 1203 ); 1204 1205 1206 1207 1208 1209 1210 1211 CREATE TABLE ezcontent_language ( 1212 disabled integer DEFAULT 0 NOT NULL, 1213 id integer DEFAULT 0 NOT NULL, 1214 locale character varying(20) DEFAULT ''::character varying NOT NULL, 1215 name character varying(255) DEFAULT ''::character varying NOT NULL 1216 ); 1217 1218 1219 1220 1221 1222 1223 1224 CREATE TABLE ezcontentbrowsebookmark ( 1225 id integer DEFAULT nextval('ezcontentbrowsebookmark_s'::text) NOT NULL, 1226 name character varying(255) DEFAULT ''::character varying NOT NULL, 1227 node_id integer DEFAULT 0 NOT NULL, 1228 user_id integer DEFAULT 0 NOT NULL 1229 ); 1230 1231 1232 1233 1234 1235 1236 1237 CREATE TABLE ezcontentbrowserecent ( 1238 created integer DEFAULT 0 NOT NULL, 1239 id integer DEFAULT nextval('ezcontentbrowserecent_s'::text) NOT NULL, 1240 name character varying(255) DEFAULT ''::character varying NOT NULL, 1241 node_id integer DEFAULT 0 NOT NULL, 1242 user_id integer DEFAULT 0 NOT NULL 1243 ); 1244 1245 1246 1247 1248 1249 1250 1251 CREATE TABLE ezcontentclass ( 1252 always_available integer DEFAULT 0 NOT NULL, 1253 contentobject_name character varying(255), 1254 created integer DEFAULT 0 NOT NULL, 1255 creator_id integer DEFAULT 0 NOT NULL, 1256 id integer DEFAULT nextval('ezcontentclass_s'::text) NOT NULL, 1257 identifier character varying(50) DEFAULT ''::character varying NOT NULL, 1258 initial_language_id integer DEFAULT 0 NOT NULL, 1259 is_container integer DEFAULT 0 NOT NULL, 1260 language_mask integer DEFAULT 0 NOT NULL, 1261 modified integer DEFAULT 0 NOT NULL, 1262 modifier_id integer DEFAULT 0 NOT NULL, 1263 remote_id character varying(100) DEFAULT ''::character varying NOT NULL, 1264 serialized_name_list character varying(255), 1265 sort_field integer DEFAULT 1 NOT NULL, 1266 sort_order integer DEFAULT 1 NOT NULL, 1267 "version" integer DEFAULT 0 NOT NULL 1268 ); 1269 1270 1271 1272 1273 1274 1275 1276 CREATE TABLE ezcontentclass_attribute ( 1277 can_translate integer DEFAULT 1, 1278 contentclass_id integer DEFAULT 0 NOT NULL, 1279 data_float1 double precision, 1280 data_float2 double precision, 1281 data_float3 double precision, 1282 data_float4 double precision, 1283 data_int1 integer, 1284 data_int2 integer, 1285 data_int3 integer, 1286 data_int4 integer, 1287 data_text1 character varying(50), 1288 data_text2 character varying(50), 1289 data_text3 character varying(50), 1290 data_text4 character varying(255), 1291 data_text5 text, 1292 data_type_string character varying(50) DEFAULT ''::character varying NOT NULL, 1293 id integer DEFAULT nextval('ezcontentclass_attribute_s'::text) NOT NULL, 1294 identifier character varying(50) DEFAULT ''::character varying NOT NULL, 1295 is_information_collector integer DEFAULT 0 NOT NULL, 1296 is_required integer DEFAULT 0 NOT NULL, 1297 is_searchable integer DEFAULT 0 NOT NULL, 1298 placement integer DEFAULT 0 NOT NULL, 1299 serialized_name_list character varying(255) DEFAULT ''::character varying NOT NULL, 1300 "version" integer DEFAULT 0 NOT NULL 1301 ); 1302 1303 1304 1305 1306 1307 1308 1309 CREATE TABLE ezcontentclass_classgroup ( 1310 contentclass_id integer DEFAULT 0 NOT NULL, 1311 contentclass_version integer DEFAULT 0 NOT NULL, 1312 group_id integer DEFAULT 0 NOT NULL, 1313 group_name character varying(255) 1314 ); 1315 1316 1317 1318 1319 1320 1321 1322 CREATE TABLE ezcontentclass_name ( 1323 contentclass_id integer DEFAULT 0 NOT NULL, 1324 contentclass_version integer DEFAULT 0 NOT NULL, 1325 language_id integer DEFAULT 0 NOT NULL, 1326 language_locale character varying(20) DEFAULT ''::character varying NOT NULL, 1327 name character varying(255) DEFAULT ''::character varying NOT NULL 1328 ); 1329 1330 1331 1332 1333 1334 1335 1336 CREATE TABLE ezcontentclassgroup ( 1337 created integer DEFAULT 0 NOT NULL, 1338 creator_id integer DEFAULT 0 NOT NULL, 1339 id integer DEFAULT nextval('ezcontentclassgroup_s'::text) NOT NULL, 1340 modified integer DEFAULT 0 NOT NULL, 1341 modifier_id integer DEFAULT 0 NOT NULL, 1342 name character varying(255) 1343 ); 1344 1345 1346 1347 1348 1349 1350 1351 CREATE TABLE ezcontentobject ( 1352 contentclass_id integer DEFAULT 0 NOT NULL, 1353 current_version integer, 1354 id integer DEFAULT nextval('ezcontentobject_s'::text) NOT NULL, 1355 initial_language_id integer DEFAULT 0 NOT NULL, 1356 is_published integer, 1357 language_mask integer DEFAULT 0 NOT NULL, 1358 modified integer DEFAULT 0 NOT NULL, 1359 name character varying(255), 1360 owner_id integer DEFAULT 0 NOT NULL, 1361 published integer DEFAULT 0 NOT NULL, 1362 remote_id character varying(100), 1363 section_id integer DEFAULT 0 NOT NULL, 1364 status integer DEFAULT 0 1365 ); 1366 1367 1368 1369 1370 1371 1372 1373 CREATE TABLE ezcontentobject_attribute ( 1374 attribute_original_id integer DEFAULT 0, 1375 contentclassattribute_id integer DEFAULT 0 NOT NULL, 1376 contentobject_id integer DEFAULT 0 NOT NULL, 1377 data_float double precision, 1378 data_int integer, 1379 data_text text, 1380 data_type_string character varying(50) DEFAULT ''::character varying, 1381 id integer DEFAULT nextval('ezcontentobject_attribute_s'::text) NOT NULL, 1382 language_code character varying(20) DEFAULT ''::character varying NOT NULL, 1383 language_id integer DEFAULT 0 NOT NULL, 1384 sort_key_int integer DEFAULT 0 NOT NULL, 1385 sort_key_string character varying(255) DEFAULT ''::character varying NOT NULL, 1386 "version" integer DEFAULT 0 NOT NULL 1387 ); 1388 1389 1390 1391 1392 1393 1394 1395 CREATE TABLE ezcontentobject_link ( 1396 contentclassattribute_id integer DEFAULT 0 NOT NULL, 1397 from_contentobject_id integer DEFAULT 0 NOT NULL, 1398 from_contentobject_version integer DEFAULT 0 NOT NULL, 1399 id integer DEFAULT nextval('ezcontentobject_link_s'::text) NOT NULL, 1400 op_code integer DEFAULT 0 NOT NULL, 1401 relation_type integer DEFAULT 1 NOT NULL, 1402 to_contentobject_id integer DEFAULT 0 NOT NULL 1403 ); 1404 1405 1406 1407 1408 1409 1410 1411 CREATE TABLE ezcontentobject_name ( 1412 content_translation character varying(20) DEFAULT ''::character varying NOT NULL, 1413 content_version integer DEFAULT 0 NOT NULL, 1414 contentobject_id integer DEFAULT 0 NOT NULL, 1415 language_id integer DEFAULT 0 NOT NULL, 1416 name character varying(255), 1417 real_translation character varying(20) 1418 ); 1419 1420 1421 1422 1423 1424 1425 1426 CREATE TABLE ezcontentobject_trash ( 1427 contentobject_id integer, 1428 contentobject_version integer, 1429 depth integer DEFAULT 0 NOT NULL, 1430 is_hidden integer DEFAULT 0 NOT NULL, 1431 is_invisible integer DEFAULT 0 NOT NULL, 1432 main_node_id integer, 1433 modified_subnode integer DEFAULT 0, 1434 node_id integer DEFAULT 0 NOT NULL, 1435 parent_node_id integer DEFAULT 0 NOT NULL, 1436 path_identification_string text, 1437 path_string character varying(255) DEFAULT ''::character varying NOT NULL, 1438 priority integer DEFAULT 0 NOT NULL, 1439 remote_id character varying(100) DEFAULT ''::character varying NOT NULL, 1440 sort_field integer DEFAULT 1, 1441 sort_order integer DEFAULT 1 1442 ); 1443 1444 1445 1446 1447 1448 1449 1450 CREATE TABLE ezcontentobject_tree ( 1451 contentobject_id integer, 1452 contentobject_is_published integer, 1453 contentobject_version integer, 1454 depth integer DEFAULT 0 NOT NULL, 1455 is_hidden integer DEFAULT 0 NOT NULL, 1456 is_invisible integer DEFAULT 0 NOT NULL, 1457 main_node_id integer, 1458 modified_subnode integer DEFAULT 0, 1459 node_id integer DEFAULT nextval('ezcontentobject_tree_s'::text) NOT NULL, 1460 parent_node_id integer DEFAULT 0 NOT NULL, 1461 path_identification_string text, 1462 path_string character varying(255) DEFAULT ''::character varying NOT NULL, 1463 priority integer DEFAULT 0 NOT NULL, 1464 remote_id character varying(100) DEFAULT ''::character varying NOT NULL, 1465 sort_field integer DEFAULT 1, 1466 sort_order integer DEFAULT 1 1467 ); 1468 1469 1470 1471 1472 1473 1474 1475 CREATE TABLE ezcontentobject_version ( 1476 contentobject_id integer, 1477 created integer DEFAULT 0 NOT NULL, 1478 creator_id integer DEFAULT 0 NOT NULL, 1479 id integer DEFAULT nextval('ezcontentobject_version_s'::text) NOT NULL, 1480 initial_language_id integer DEFAULT 0 NOT NULL, 1481 language_mask integer DEFAULT 0 NOT NULL, 1482 modified integer DEFAULT 0 NOT NULL, 1483 status integer DEFAULT 0 NOT NULL, 1484 user_id integer DEFAULT 0 NOT NULL, 1485 "version" integer DEFAULT 0 NOT NULL, 1486 workflow_event_pos integer DEFAULT 0 1487 ); 1488 1489 1490 1491 1492 1493 1494 1495 CREATE TABLE ezcurrencydata ( 1496 auto_rate_value numeric(10,5) DEFAULT '0.00000' NOT NULL, 1497 code character varying(4) DEFAULT ''::character varying NOT NULL, 1498 custom_rate_value numeric(10,5) DEFAULT '0.00000' NOT NULL, 1499 id integer DEFAULT nextval('ezcurrencydata_s'::text) NOT NULL, 1500 locale character varying(255) DEFAULT ''::character varying NOT NULL, 1501 rate_factor numeric(10,5) DEFAULT '1.00000' NOT NULL, 1502 status integer DEFAULT 1 NOT NULL, 1503 symbol character varying(255) DEFAULT ''::character varying NOT NULL 1504 ); 1505 1506 1507 1508 1509 1510 1511 1512 CREATE TABLE ezdiscountrule ( 1513 id integer DEFAULT nextval('ezdiscountrule_s'::text) NOT NULL, 1514 name character varying(255) DEFAULT ''::character varying NOT NULL 1515 ); 1516 1517 1518 1519 1520 1521 1522 1523 CREATE TABLE ezdiscountsubrule ( 1524 discount_percent double precision, 1525 discountrule_id integer DEFAULT 0 NOT NULL, 1526 id integer DEFAULT nextval('ezdiscountsubrule_s'::text) NOT NULL, 1527 limitation character(1), 1528 name character varying(255) DEFAULT ''::character varying NOT NULL 1529 ); 1530 1531 1532 1533 1534 1535 1536 1537 CREATE TABLE ezdiscountsubrule_value ( 1538 discountsubrule_id integer DEFAULT 0 NOT NULL, 1539 issection integer DEFAULT 0 NOT NULL, 1540 value integer DEFAULT 0 NOT NULL 1541 ); 1542 1543 1544 1545 1546 1547 1548 1549 CREATE TABLE ezenumobjectvalue ( 1550 contentobject_attribute_id integer DEFAULT 0 NOT NULL, 1551 contentobject_attribute_version integer DEFAULT 0 NOT NULL, 1552 enumelement character varying(255) DEFAULT ''::character varying NOT NULL, 1553 enumid integer DEFAULT 0 NOT NULL, 1554 enumvalue character varying(255) DEFAULT ''::character varying NOT NULL 1555 ); 1556 1557 1558 1559 1560 1561 1562 1563 CREATE TABLE ezenumvalue ( 1564 contentclass_attribute_id integer DEFAULT 0 NOT NULL, 1565 contentclass_attribute_version integer DEFAULT 0 NOT NULL, 1566 enumelement character varying(255) DEFAULT ''::character varying NOT NULL, 1567 enumvalue character varying(255) DEFAULT ''::character varying NOT NULL, 1568 id integer DEFAULT nextval('ezenumvalue_s'::text) NOT NULL, 1569 placement integer DEFAULT 0 NOT NULL 1570 ); 1571 1572 1573 1574 1575 1576 1577 1578 CREATE TABLE ezforgot_password ( 1579 hash_key character varying(32) DEFAULT ''::character varying NOT NULL, 1580 id integer DEFAULT nextval('ezforgot_password_s'::text) NOT NULL, 1581 "time" integer DEFAULT 0 NOT NULL, 1582 user_id integer DEFAULT 0 NOT NULL 1583 ); 1584 1585 1586 1587 1588 1589 1590 1591 CREATE TABLE ezgeneral_digest_user_settings ( 1592 address character varying(255) DEFAULT ''::character varying NOT NULL, 1593 "day" character varying(255) DEFAULT ''::character varying NOT NULL, 1594 digest_type integer DEFAULT 0 NOT NULL, 1595 id integer DEFAULT nextval('ezgeneral_digest_user_settings_s'::text) NOT NULL, 1596 receive_digest integer DEFAULT 0 NOT NULL, 1597 "time" character varying(255) DEFAULT ''::character varying NOT NULL 1598 ); 1599 1600 1601 1602 1603 1604 1605 1606 CREATE TABLE ezimage ( 1607 alternative_text character varying(255) DEFAULT ''::character varying NOT NULL, 1608 contentobject_attribute_id integer DEFAULT 0 NOT NULL, 1609 filename character varying(255) DEFAULT ''::character varying NOT NULL, 1610 mime_type character varying(50) DEFAULT ''::character varying NOT NULL, 1611 original_filename character varying(255) DEFAULT ''::character varying NOT NULL, 1612 "version" integer DEFAULT 0 NOT NULL 1613 ); 1614 1615 1616 1617 1618 1619 1620 1621 CREATE TABLE ezimagefile ( 1622 contentobject_attribute_id integer DEFAULT 0 NOT NULL, 1623 filepath text NOT NULL, 1624 id integer DEFAULT nextval('ezimagefile_s'::text) NOT NULL 1625 ); 1626 1627 1628 1629 1630 1631 1632 1633 CREATE TABLE ezimagevariation ( 1634 additional_path character varying(255), 1635 contentobject_attribute_id integer DEFAULT 0 NOT NULL, 1636 filename character varying(255) DEFAULT ''::character varying NOT NULL, 1637 height integer DEFAULT 0 NOT NULL, 1638 requested_height integer DEFAULT 0 NOT NULL, 1639 requested_width integer DEFAULT 0 NOT NULL, 1640 "version" integer DEFAULT 0 NOT NULL, 1641 width integer DEFAULT 0 NOT NULL 1642 ); 1643 1644 1645 1646 1647 1648 1649 1650 CREATE TABLE ezinfocollection ( 1651 contentobject_id integer DEFAULT 0 NOT NULL, 1652 created integer DEFAULT 0 NOT NULL, 1653 creator_id integer DEFAULT 0 NOT NULL, 1654 id integer DEFAULT nextval('ezinfocollection_s'::text) NOT NULL, 1655 modified integer DEFAULT 0, 1656 user_identifier character varying(34) 1657 ); 1658 1659 1660 1661 1662 1663 1664 1665 CREATE TABLE ezinfocollection_attribute ( 1666 contentclass_attribute_id integer DEFAULT 0 NOT NULL, 1667 contentobject_attribute_id integer, 1668 contentobject_id integer, 1669 data_float double precision, 1670 data_int integer, 1671 data_text text, 1672 id integer DEFAULT nextval('ezinfocollection_attribute_s'::text) NOT NULL, 1673 informationcollection_id integer DEFAULT 0 NOT NULL 1674 ); 1675 1676 1677 1678 1679 1680 1681 1682 CREATE TABLE ezkeyword ( 1683 class_id integer DEFAULT 0 NOT NULL, 1684 id integer DEFAULT nextval('ezkeyword_s'::text) NOT NULL, 1685 keyword character varying(255) 1686 ); 1687 1688 1689 1690 1691 1692 1693 1694 CREATE TABLE ezkeyword_attribute_link ( 1695 id integer DEFAULT nextval('ezkeyword_attribute_link_s'::text) NOT NULL, 1696 keyword_id integer DEFAULT 0 NOT NULL, 1697 objectattribute_id integer DEFAULT 0 NOT NULL 1698 ); 1699 1700 1701 1702 1703 1704 1705 1706 CREATE TABLE ezmedia ( 1707 contentobject_attribute_id integer DEFAULT 0 NOT NULL, 1708 controls character varying(50), 1709 filename character varying(255) DEFAULT ''::character varying NOT NULL, 1710 has_controller integer DEFAULT 0, 1711 height integer, 1712 is_autoplay integer DEFAULT 0, 1713 is_loop integer DEFAULT 0, 1714 mime_type character varying(50) DEFAULT ''::character varying NOT NULL, 1715 original_filename character varying(255) DEFAULT ''::character varying NOT NULL, 1716 pluginspage character varying(255), 1717 quality character varying(50), 1718 "version" integer DEFAULT 0 NOT NULL, 1719 width integer 1720 ); 1721 1722 1723 1724 1725 1726 1727 1728 CREATE TABLE ezmessage ( 1729 body text, 1730 destination_address character varying(50) DEFAULT ''::character varying NOT NULL, 1731 id integer DEFAULT nextval('ezmessage_s'::text) NOT NULL, 1732 is_sent integer DEFAULT 0 NOT NULL, 1733 send_method character varying(50) DEFAULT ''::character varying NOT NULL, 1734 send_time character varying(50) DEFAULT ''::character varying NOT NULL, 1735 send_weekday character varying(50) DEFAULT ''::character varying NOT NULL, 1736 title character varying(255) DEFAULT ''::character varying NOT NULL 1737 ); 1738 1739 1740 1741 1742 1743 1744 1745 CREATE TABLE ezmodule_run ( 1746 function_name character varying(255), 1747 id integer DEFAULT nextval('ezmodule_run_s'::text) NOT NULL, 1748 module_data text, 1749 module_name character varying(255), 1750 workflow_process_id integer 1751 ); 1752 1753 1754 1755 1756 1757 1758 1759 CREATE TABLE ezmultipricedata ( 1760 contentobject_attr_id integer DEFAULT 0 NOT NULL, 1761 contentobject_attr_version integer DEFAULT 0 NOT NULL, 1762 currency_code character varying(4) DEFAULT ''::character varying NOT NULL, 1763 id integer DEFAULT nextval('ezmultipricedata_s'::text) NOT NULL, 1764 "type" integer DEFAULT 0 NOT NULL, 1765 value numeric(15,2) DEFAULT '0.00' NOT NULL 1766 ); 1767 1768 1769 1770 1771 1772 1773 1774 CREATE TABLE eznode_assignment ( 1775 contentobject_id integer, 1776 contentobject_version integer, 1777 from_node_id integer DEFAULT 0, 1778 id integer DEFAULT nextval('eznode_assignment_s'::text) NOT NULL, 1779 is_main integer DEFAULT 0 NOT NULL, 1780 op_code integer DEFAULT 0 NOT NULL, 1781 parent_node integer, 1782 parent_remote_id character varying(100) DEFAULT ''::character varying NOT NULL, 1783 remote_id integer DEFAULT 0 NOT NULL, 1784 sort_field integer DEFAULT 1, 1785 sort_order integer DEFAULT 1 1786 ); 1787 1788 1789 1790 1791 1792 1793 1794 CREATE TABLE eznotificationcollection ( 1795 data_subject text NOT NULL, 1796 data_text text NOT NULL, 1797 event_id integer DEFAULT 0 NOT NULL, 1798 "handler" character varying(255) DEFAULT ''::character varying NOT NULL, 1799 id integer DEFAULT nextval('eznotificationcollection_s'::text) NOT NULL, 1800 transport character varying(255) DEFAULT ''::character varying NOT NULL 1801 ); 1802 1803 1804 1805 1806 1807 1808 1809 CREATE TABLE eznotificationcollection_item ( 1810 address character varying(255) DEFAULT ''::character varying NOT NULL, 1811 collection_id integer DEFAULT 0 NOT NULL, 1812 event_id integer DEFAULT 0 NOT NULL, 1813 id integer DEFAULT nextval('eznotificationcollection_item_s'::text) NOT NULL, 1814 send_date integer DEFAULT 0 NOT NULL 1815 ); 1816 1817 1818 1819 1820 1821 1822 1823 CREATE TABLE eznotificationevent ( 1824 data_int1 integer DEFAULT 0 NOT NULL, 1825 data_int2 integer DEFAULT 0 NOT NULL, 1826 data_int3 integer DEFAULT 0 NOT NULL, 1827 data_int4 integer DEFAULT 0 NOT NULL, 1828 data_text1 text NOT NULL, 1829 data_text2 text NOT NULL, 1830 data_text3 text NOT NULL, 1831 data_text4 text NOT NULL, 1832 event_type_string character varying(255) DEFAULT ''::character varying NOT NULL, 1833 id integer DEFAULT nextval('eznotificationevent_s'::text) NOT NULL, 1834 status integer DEFAULT 0 NOT NULL 1835 ); 1836 1837 1838 1839 1840 1841 1842 1843 CREATE TABLE ezoperation_memento ( 1844 id integer DEFAULT nextval('ezoperation_memento_s'::text) NOT NULL, 1845 main integer DEFAULT 0 NOT NULL, 1846 main_key character varying(32) DEFAULT ''::character varying NOT NULL, 1847 memento_data text NOT NULL, 1848 memento_key character varying(32) DEFAULT ''::character varying NOT NULL 1849 ); 1850 1851 1852 1853 1854 1855 1856 1857 CREATE TABLE ezorder ( 1858 account_identifier character varying(100) DEFAULT 'default'::character varying NOT NULL, 1859 created integer DEFAULT 0 NOT NULL, 1860 data_text_1 text, 1861 data_text_2 text, 1862 email character varying(150) DEFAULT ''::character varying, 1863 id integer DEFAULT nextval('ezorder_s'::text) NOT NULL, 1864 ignore_vat integer DEFAULT 0 NOT NULL, 1865 is_archived integer DEFAULT 0 NOT NULL, 1866 is_temporary integer DEFAULT 1 NOT NULL, 1867 order_nr integer DEFAULT 0 NOT NULL, 1868 productcollection_id integer DEFAULT 0 NOT NULL, 1869 status_id integer DEFAULT 0, 1870 status_modified integer DEFAULT 0, 1871 status_modifier_id integer DEFAULT 0, 1872 user_id integer DEFAULT 0 NOT NULL 1873 ); 1874 1875 1876 1877 1878 1879 1880 1881 CREATE TABLE ezorder_item ( 1882 description character varying(255), 1883 id integer DEFAULT nextval('ezorder_item_s'::text) NOT NULL, 1884 is_vat_inc integer DEFAULT 0 NOT NULL, 1885 order_id integer DEFAULT 0 NOT NULL, 1886 price double precision, 1887 "type" character varying(30), 1888 vat_value integer DEFAULT 0 NOT NULL 1889 ); 1890 1891 1892 1893 1894 1895 1896 1897 CREATE TABLE ezorder_status ( 1898 id integer DEFAULT nextval('ezorder_status_s'::text) NOT NULL, 1899 is_active integer DEFAULT 1 NOT NULL, 1900 name character varying(255) DEFAULT ''::character varying NOT NULL, 1901 status_id integer DEFAULT 0 NOT NULL 1902 ); 1903 1904 1905 1906 1907 1908 1909 1910 CREATE TABLE ezorder_status_history ( 1911 id integer DEFAULT nextval('ezorder_status_history_s'::text) NOT NULL, 1912 modified integer DEFAULT 0 NOT NULL, 1913 modifier_id integer DEFAULT 0 NOT NULL, 1914 order_id integer DEFAULT 0 NOT NULL, 1915 status_id integer DEFAULT 0 NOT NULL 1916 ); 1917 1918 1919 1920 1921 1922 1923 1924 CREATE TABLE ezpackage ( 1925 id integer DEFAULT nextval('ezpackage_s'::text) NOT NULL, 1926 install_date integer DEFAULT 0 NOT NULL, 1927 name character varying(100) DEFAULT ''::character varying NOT NULL, 1928 "version" character varying(30) DEFAULT '0'::character varying NOT NULL 1929 ); 1930 1931 1932 1933 1934 1935 1936 1937 CREATE TABLE ezpaymentobject ( 1938 id integer DEFAULT nextval('ezpaymentobject_s'::text) NOT NULL, 1939 order_id integer DEFAULT 0 NOT NULL, 1940 payment_string character varying(255) DEFAULT ''::character varying NOT NULL, 1941 status integer DEFAULT 0 NOT NULL, 1942 workflowprocess_id integer DEFAULT 0 NOT NULL 1943 ); 1944 1945 1946 1947 1948 1949 1950 1951 CREATE TABLE ezpdf_export ( 1952 created integer, 1953 creator_id integer, 1954 export_classes character varying(255), 1955 export_structure character varying(255), 1956 id integer DEFAULT nextval('ezpdf_export_s'::text) NOT NULL, 1957 intro_text text, 1958 modified integer, 1959 modifier_id integer, 1960 pdf_filename character varying(255), 1961 show_frontpage integer, 1962 site_access character varying(255), 1963 source_node_id integer, 1964 status integer, 1965 sub_text text, 1966 title character varying(255), 1967 "version" integer DEFAULT 0 NOT NULL 1968 ); 1969 1970 1971 1972 1973 1974 1975 1976 CREATE TABLE ezpending_actions ( 1977 "action" character varying(64) DEFAULT ''::character varying NOT NULL, 1978 param text 1979 ); 1980 1981 1982 1983 1984 1985 1986 1987 CREATE TABLE ezpolicy ( 1988 function_name character varying(255), 1989 id integer DEFAULT nextval('ezpolicy_s'::text) NOT NULL, 1990 module_name character varying(255), 1991 role_id integer 1992 ); 1993 1994 1995 1996 1997 1998 1999 2000 CREATE TABLE ezpolicy_limitation ( 2001 id integer DEFAULT nextval('ezpolicy_limitation_s'::text) NOT NULL, 2002 identifier character varying(255) DEFAULT ''::character varying NOT NULL, 2003 policy_id integer 2004 ); 2005 2006 2007 2008 2009 2010 2011 2012 CREATE TABLE ezpolicy_limitation_value ( 2013 id integer DEFAULT nextval('ezpolicy_limitation_value_s'::text) NOT NULL, 2014 limitation_id integer, 2015 value character varying(255) 2016 ); 2017 2018 2019 2020 2021 2022 2023 2024 CREATE TABLE ezpreferences ( 2025 id integer DEFAULT nextval('ezpreferences_s'::text) NOT NULL, 2026 name character varying(100), 2027 user_id integer DEFAULT 0 NOT NULL, 2028 value character varying(100) 2029 ); 2030 2031 2032 2033 2034 2035 2036 2037 CREATE TABLE ezproductcategory ( 2038 id integer DEFAULT nextval('ezproductcategory_s'::text) NOT NULL, 2039 name character varying(255) DEFAULT ''::character varying NOT NULL 2040 ); 2041 2042 2043 2044 2045 2046 2047 2048 CREATE TABLE ezproductcollection ( 2049 created integer, 2050 currency_code character varying(4) DEFAULT ''::character varying NOT NULL, 2051 id integer DEFAULT nextval('ezproductcollection_s'::text) NOT NULL 2052 ); 2053 2054 2055 2056 2057 2058 2059 2060 CREATE TABLE ezproductcollection_item ( 2061 contentobject_id integer DEFAULT 0 NOT NULL, 2062 discount double precision, 2063 id integer DEFAULT nextval('ezproductcollection_item_s'::text) NOT NULL, 2064 is_vat_inc integer, 2065 item_count integer DEFAULT 0 NOT NULL, 2066 name character varying(255) DEFAULT ''::character varying NOT NULL, 2067 price double precision DEFAULT 0::double precision, 2068 productcollection_id integer DEFAULT 0 NOT NULL, 2069 vat_value double precision 2070 ); 2071 2072 2073 2074 2075 2076 2077 2078 CREATE TABLE ezproductcollection_item_opt ( 2079 id integer DEFAULT nextval('ezproductcollection_item_opt_s'::text) NOT NULL, 2080 item_id integer DEFAULT 0 NOT NULL, 2081 name character varying(255) DEFAULT ''::character varying NOT NULL, 2082 object_attribute_id integer, 2083 option_item_id integer DEFAULT 0 NOT NULL, 2084 price double precision DEFAULT 0::double precision NOT NULL, 2085 value character varying(255) DEFAULT ''::character varying NOT NULL 2086 ); 2087 2088 2089 2090 2091 2092 2093 2094 CREATE TABLE ezrole ( 2095 id integer DEFAULT nextval('ezrole_s'::text) NOT NULL, 2096 is_new integer DEFAULT 0 NOT NULL, 2097 name character varying(255) DEFAULT ''::character varying NOT NULL, 2098 value character(1), 2099 "version" integer DEFAULT 0 2100 ); 2101 2102 2103 2104 2105 2106 2107 2108 CREATE TABLE ezrss_export ( 2109 access_url character varying(255), 2110 active integer, 2111 created integer, 2112 creator_id integer, 2113 description text, 2114 id integer DEFAULT nextval('ezrss_export_s'::text) NOT NULL, 2115 image_id integer, 2116 main_node_only integer DEFAULT 1 NOT NULL, 2117 modified integer, 2118 modifier_id integer, 2119 number_of_objects integer DEFAULT 0 NOT NULL, 2120 rss_version character varying(255), 2121 site_access character varying(255), 2122 status integer DEFAULT 0 NOT NULL, 2123 title character varying(255), 2124 url character varying(255) 2125 ); 2126 2127 2128 2129 2130 2131 2132 2133 CREATE TABLE ezrss_export_item ( 2134 class_id integer, 2135 description character varying(255), 2136 id integer DEFAULT nextval('ezrss_export_item_s'::text) NOT NULL, 2137 rssexport_id integer, 2138 source_node_id integer, 2139 status integer DEFAULT 0 NOT NULL, 2140 subnodes integer DEFAULT 0 NOT NULL, 2141 title character varying(255) 2142 ); 2143 2144 2145 2146 2147 2148 2149 2150 CREATE TABLE ezrss_import ( 2151 active integer, 2152 class_description character varying(255), 2153 class_id integer, 2154 class_title character varying(255), 2155 class_url character varying(255), 2156 created integer, 2157 creator_id integer, 2158 destination_node_id integer, 2159 id integer DEFAULT nextval('ezrss_import_s'::text) NOT NULL, 2160 import_description text NOT NULL, 2161 modified integer, 2162 modifier_id integer, 2163 name character varying(255), 2164 object_owner_id integer, 2165 status integer DEFAULT 0 NOT NULL, 2166 url text 2167 ); 2168 2169 2170 2171 2172 2173 2174 2175 CREATE TABLE ezsearch_object_word_link ( 2176 contentclass_attribute_id integer DEFAULT 0 NOT NULL, 2177 contentclass_id integer DEFAULT 0 NOT NULL, 2178 contentobject_id integer DEFAULT 0 NOT NULL, 2179 frequency double precision DEFAULT 0::double precision NOT NULL, 2180 id integer DEFAULT nextval('ezsearch_object_word_link_s'::text) NOT NULL, 2181 identifier character varying(255) DEFAULT ''::character varying NOT NULL, 2182 integer_value integer DEFAULT 0 NOT NULL, 2183 next_word_id integer DEFAULT 0 NOT NULL, 2184 placement integer DEFAULT 0 NOT NULL, 2185 prev_word_id integer DEFAULT 0 NOT NULL, 2186 published integer DEFAULT 0 NOT NULL, 2187 section_id integer DEFAULT 0 NOT NULL, 2188 word_id integer DEFAULT 0 NOT NULL 2189 ); 2190 2191 2192 2193 2194 2195 2196 2197 CREATE TABLE ezsearch_return_count ( 2198 count integer DEFAULT 0 NOT NULL, 2199 id integer DEFAULT nextval('ezsearch_return_count_s'::text) NOT NULL, 2200 phrase_id integer DEFAULT 0 NOT NULL, 2201 "time" integer DEFAULT 0 NOT NULL 2202 ); 2203 2204 2205 2206 2207 2208 2209 2210 CREATE TABLE ezsearch_search_phrase ( 2211 id integer DEFAULT nextval('ezsearch_search_phrase_s'::text) NOT NULL, 2212 phrase character varying(250), 2213 phrase_count integer DEFAULT 0, 2214 result_count integer DEFAULT 0 2215 ); 2216 2217 2218 2219 2220 2221 2222 2223 CREATE TABLE ezsearch_word ( 2224 id integer DEFAULT nextval('ezsearch_word_s'::text) NOT NULL, 2225 object_count integer DEFAULT 0 NOT NULL, 2226 word character varying(150) 2227 ); 2228 2229 2230 2231 2232 2233 2234 2235 CREATE TABLE ezsection ( 2236 id integer DEFAULT nextval('ezsection_s'::text) NOT NULL, 2237 locale character varying(255), 2238 name character varying(255), 2239 navigation_part_identifier character varying(100) DEFAULT 'ezcontentnavigationpart'::character varying 2240 ); 2241 2242 2243 2244 2245 2246 2247 2248 CREATE TABLE ezsession ( 2249 data text NOT NULL, 2250 expiration_time integer DEFAULT 0 NOT NULL, 2251 session_key character varying(32) DEFAULT ''::character varying NOT NULL, 2252 user_id integer DEFAULT 0 NOT NULL 2253 ); 2254 2255 2256 2257 2258 2259 2260 2261 CREATE TABLE ezsite_data ( 2262 name character varying(60) DEFAULT ''::character varying NOT NULL, 2263 value text NOT NULL 2264 ); 2265 2266 2267 2268 2269 2270 2271 2272 CREATE TABLE ezsubtree_notification_rule ( 2273 id integer DEFAULT nextval('ezsubtree_notification_rule_s'::text) NOT NULL, 2274 node_id integer DEFAULT 0 NOT NULL, 2275 use_digest integer DEFAULT 0, 2276 user_id integer DEFAULT 0 NOT NULL 2277 ); 2278 2279 2280 2281 2282 2283 2284 2285 CREATE TABLE eztipafriend_counter ( 2286 count integer DEFAULT 0 NOT NULL, 2287 node_id integer DEFAULT 0 NOT NULL, 2288 requested integer DEFAULT 0 NOT NULL 2289 ); 2290 2291 2292 2293 2294 2295 2296 2297 CREATE TABLE eztipafriend_request ( 2298 created integer DEFAULT 0 NOT NULL, 2299 email_receiver character varying(100) DEFAULT ''::character varying NOT NULL 2300 ); 2301 2302 2303 2304 2305 2306 2307 2308 CREATE TABLE eztrigger ( 2309 connect_type character(1) DEFAULT ''::bpchar NOT NULL, 2310 function_name character varying(200) DEFAULT ''::character varying NOT NULL, 2311 id integer DEFAULT nextval('eztrigger_s'::text) NOT NULL, 2312 module_name character varying(200) DEFAULT ''::character varying NOT NULL, 2313 name character varying(255), 2314 workflow_id integer 2315 ); 2316 2317 2318 2319 2320 2321 2322 2323 CREATE TABLE ezurl ( 2324 created integer DEFAULT 0 NOT NULL, 2325 id integer DEFAULT nextval('ezurl_s'::text) NOT NULL, 2326 is_valid integer DEFAULT 1 NOT NULL, 2327 last_checked integer DEFAULT 0 NOT NULL, 2328 modified integer DEFAULT 0 NOT NULL, 2329 original_url_md5 character varying(32) DEFAULT ''::character varying NOT NULL, 2330 url character varying(255) 2331 ); 2332 2333 2334 2335 2336 2337 2338 2339 CREATE TABLE ezurl_object_link ( 2340 contentobject_attribute_id integer DEFAULT 0 NOT NULL, 2341 contentobject_attribute_version integer DEFAULT 0 NOT NULL, 2342 url_id integer DEFAULT 0 NOT NULL 2343 ); 2344 2345 2346 2347 2348 2349 2350 2351 CREATE TABLE ezurlalias ( 2352 destination_url text NOT NULL, 2353 forward_to_id integer DEFAULT 0 NOT NULL, 2354 id integer DEFAULT nextval('ezurlalias_s'::text) NOT NULL, 2355 is_internal integer DEFAULT 1 NOT NULL, 2356 is_wildcard integer DEFAULT 0 NOT NULL, 2357 source_md5 character varying(32), 2358 source_url text NOT NULL 2359 ); 2360 2361 2362 2363 2364 2365 2366 2367 CREATE TABLE ezuser ( 2368 contentobject_id integer DEFAULT 0 NOT NULL, 2369 email character varying(150) DEFAULT ''::character varying NOT NULL, 2370 login character varying(150) DEFAULT ''::character varying NOT NULL, 2371 password_hash character varying(50), 2372 password_hash_type integer DEFAULT 1 NOT NULL 2373 ); 2374 2375 2376 2377 2378 2379 2380 2381 CREATE TABLE ezuser_accountkey ( 2382 hash_key character varying(32) DEFAULT ''::character varying NOT NULL, 2383 id integer DEFAULT nextval('ezuser_accountkey_s'::text) NOT NULL, 2384 "time" integer DEFAULT 0 NOT NULL, 2385 user_id integer DEFAULT 0 NOT NULL 2386 ); 2387 2388 2389 2390 2391 2392 2393 2394 CREATE TABLE ezuser_discountrule ( 2395 contentobject_id integer, 2396 discountrule_id integer, 2397 id integer DEFAULT nextval('ezuser_discountrule_s'::text) NOT NULL, 2398 name character varying(255) DEFAULT ''::character varying NOT NULL 2399 ); 2400 2401 2402 2403 2404 2405 2406 2407 CREATE TABLE ezuser_role ( 2408 contentobject_id integer, 2409 id integer DEFAULT nextval('ezuser_role_s'::text) NOT NULL, 2410 limit_identifier character varying(255) DEFAULT ''::character varying, 2411 limit_value character varying(255) DEFAULT ''::character varying, 2412 role_id integer 2413 ); 2414 2415 2416 2417 2418 2419 2420 2421 CREATE TABLE ezuser_setting ( 2422 is_enabled integer DEFAULT 0 NOT NULL, 2423 max_login integer, 2424 user_id integer DEFAULT 0 NOT NULL 2425 ); 2426 2427 2428 2429 2430 2431 2432 2433 CREATE TABLE ezuservisit ( 2434 current_visit_timestamp integer DEFAULT 0 NOT NULL, 2435 failed_login_attempts integer DEFAULT 0 NOT NULL, 2436 last_visit_timestamp integer DEFAULT 0 NOT NULL, 2437 user_id integer DEFAULT 0 NOT NULL 2438 ); 2439 2440 2441 2442 2443 2444 2445 2446 CREATE TABLE ezvatrule ( 2447 country character varying(255) DEFAULT ''::character varying NOT NULL, 2448 id integer DEFAULT nextval('ezvatrule_s'::text) NOT NULL, 2449 vat_type integer DEFAULT 0 NOT NULL 2450 ); 2451 2452 2453 2454 2455 2456 2457 2458 CREATE TABLE ezvatrule_product_category ( 2459 product_category_id integer DEFAULT 0 NOT NULL, 2460 vatrule_id integer DEFAULT 0 NOT NULL 2461 ); 2462 2463 2464 2465 2466 2467 2468 2469 CREATE TABLE ezvattype ( 2470 id integer DEFAULT nextval('ezvattype_s'::text) NOT NULL, 2471 name character varying(255) DEFAULT ''::character varying NOT NULL, 2472 percentage double precision 2473 ); 2474 2475 2476 2477 2478 2479 2480 2481 CREATE TABLE ezview_counter ( 2482 count integer DEFAULT 0 NOT NULL, 2483 node_id integer DEFAULT 0 NOT NULL 2484 ); 2485 2486 2487 2488 2489 2490 2491 2492 CREATE TABLE ezwaituntildatevalue ( 2493 contentclass_attribute_id integer DEFAULT 0 NOT NULL, 2494 contentclass_id integer DEFAULT 0 NOT NULL, 2495 id integer DEFAULT nextval('ezwaituntildatevalue_s'::text) NOT NULL, 2496 workflow_event_id integer DEFAULT 0 NOT NULL, 2497 workflow_event_version integer DEFAULT 0 NOT NULL 2498 ); 2499 2500 2501 2502 2503 2504 2505 2506 CREATE TABLE ezwishlist ( 2507 id integer DEFAULT nextval('ezwishlist_s'::text) NOT NULL, 2508 productcollection_id integer DEFAULT 0 NOT NULL, 2509 user_id integer DEFAULT 0 NOT NULL 2510 ); 2511 2512 2513 2514 2515 2516 2517 2518 CREATE TABLE ezworkflow ( 2519 created integer DEFAULT 0 NOT NULL, 2520 creator_id integer DEFAULT 0 NOT NULL, 2521 id integer DEFAULT nextval('ezworkflow_s'::text) NOT NULL, 2522 is_enabled integer DEFAULT 0 NOT NULL, 2523 modified integer DEFAULT 0 NOT NULL, 2524 modifier_id integer DEFAULT 0 NOT NULL, 2525 name character varying(255) DEFAULT ''::character varying NOT NULL, 2526 "version" integer DEFAULT 0 NOT NULL, 2527 workflow_type_string character varying(50) DEFAULT ''::character varying NOT NULL 2528 ); 2529 2530 2531 2532 2533 2534 2535 2536 CREATE TABLE ezworkflow_assign ( 2537 access_type integer DEFAULT 0 NOT NULL, 2538 as_tree integer DEFAULT 0 NOT NULL, 2539 id integer DEFAULT nextval('ezworkflow_assign_s'::text) NOT NULL, 2540 node_id integer DEFAULT 0 NOT NULL, 2541 workflow_id integer DEFAULT 0 NOT NULL 2542 ); 2543 2544 2545 2546 2547 2548 2549 2550 CREATE TABLE ezworkflow_event ( 2551 data_int1 integer, 2552 data_int2 integer, 2553 data_int3 integer, 2554 data_int4 integer, 2555 data_text1 character varying(50), 2556 data_text2 character varying(50), 2557 data_text3 character varying(50), 2558 data_text4 character varying(50), 2559 description character varying(50) DEFAULT ''::character varying NOT NULL, 2560 id integer DEFAULT nextval('ezworkflow_event_s'::text) NOT NULL, 2561 placement integer DEFAULT 0 NOT NULL, 2562 "version" integer DEFAULT 0 NOT NULL, 2563 workflow_id integer DEFAULT 0 NOT NULL, 2564 workflow_type_string character varying(50) DEFAULT ''::character varying NOT NULL 2565 ); 2566 2567 2568 2569 2570 2571 2572 2573 CREATE TABLE ezworkflow_group ( 2574 created integer DEFAULT 0 NOT NULL, 2575 creator_id integer DEFAULT 0 NOT NULL, 2576 id integer DEFAULT nextval('ezworkflow_group_s'::text) NOT NULL, 2577 modified integer DEFAULT 0 NOT NULL, 2578 modifier_id integer DEFAULT 0 NOT NULL, 2579 name character varying(255) DEFAULT ''::character varying NOT NULL 2580 ); 2581 2582 2583 2584 2585 2586 2587 2588 CREATE TABLE ezworkflow_group_link ( 2589 group_id integer DEFAULT 0 NOT NULL, 2590 group_name character varying(255), 2591 workflow_id integer DEFAULT 0 NOT NULL, 2592 workflow_version integer DEFAULT 0 NOT NULL 2593 ); 2594 2595 2596 2597 2598 2599 2600 2601 CREATE TABLE ezworkflow_process ( 2602 activation_date integer, 2603 content_id integer DEFAULT 0 NOT NULL, 2604 content_version integer DEFAULT 0 NOT NULL, 2605 created integer DEFAULT 0 NOT NULL, 2606 event_id integer DEFAULT 0 NOT NULL, 2607 event_position integer DEFAULT 0 NOT NULL, 2608 event_state integer, 2609 event_status integer DEFAULT 0 NOT NULL, 2610 id integer DEFAULT nextval('ezworkflow_process_s'::text) NOT NULL, 2611 last_event_id integer DEFAULT 0 NOT NULL, 2612 last_event_position integer DEFAULT 0 NOT NULL, 2613 last_event_status integer DEFAULT 0 NOT NULL, 2614 memento_key character varying(32), 2615 modified integer DEFAULT 0 NOT NULL, 2616 node_id integer DEFAULT 0 NOT NULL, 2617 parameters text, 2618 process_key character varying(32) DEFAULT ''::character varying NOT NULL, 2619 session_key character varying(32) DEFAULT '0'::character varying NOT NULL, 2620 status integer, 2621 user_id integer DEFAULT 0 NOT NULL, 2622 workflow_id integer DEFAULT 0 NOT NULL 2623 ); 2624 2625 2626 2627 2628 2629 2630 2631 CREATE INDEX ezbasket_session_id ON ezbasket USING btree (session_id); 2632 2633 2634 2635 2636 2637 2638 2639 CREATE INDEX ezcollab_group_depth ON ezcollab_group USING btree (depth); 2640 2641 2642 2643 2644 2645 2646 2647 CREATE INDEX ezcollab_group_path ON ezcollab_group USING btree (path_string); 2648 2649 2650 2651 2652 2653 2654 2655 CREATE INDEX ezcontentbrowsebookmark_user ON ezcontentbrowsebookmark USING btree (user_id); 2656 2657 2658 2659 2660 2661 2662 2663 CREATE INDEX ezcontentbrowserecent_user ON ezcontentbrowserecent USING btree (user_id); 2664 2665 2666 2667 2668 2669 2670 2671 CREATE INDEX ezcontentclass_version ON ezcontentclass USING btree ("version"); 2672 2673 2674 2675 2676 2677 2678 2679 CREATE INDEX ezcontentclass_attr_ccid ON ezcontentclass_attribute USING btree (contentclass_id); 2680 2681 2682 2683 2684 2685 2686 2687 CREATE INDEX ezcontentobject_classid ON ezcontentobject USING btree (contentclass_id); 2688 2689 2690 2691 2692 2693 2694 2695 CREATE INDEX ezcontentobject_currentversion ON ezcontentobject USING btree (current_version); 2696 2697 2698 2699 2700 2701 2702 2703 CREATE INDEX ezcontentobject_lmask ON ezcontentobject USING btree (language_mask); 2704 2705 2706 2707 2708 2709 2710 2711 CREATE INDEX ezcontentobject_pub ON ezcontentobject USING btree (published); 2712 2713 2714 2715 2716 2717 2718 2719 CREATE INDEX ezcontentobject_status ON ezcontentobject USING btree (status); 2720 2721 2722 2723 2724 2725 2726 2727 CREATE INDEX ezcontentobject_attr_id ON ezcontentobject_attribute USING btree (id); 2728 2729 2730 2731 2732 2733 2734 2735 CREATE INDEX ezcontentobject_attribute_co_id_ver_lang_code ON ezcontentobject_attribute USING btree (contentobject_id, "version", language_code); 2736 2737 2738 2739 2740 2741 2742 2743 CREATE INDEX ezcontentobject_attribute_contentobject_id ON ezcontentobject_attribute USING btree (contentobject_id); 2744 2745 2746 2747 2748 2749 2750 2751 CREATE INDEX ezcontentobject_attribute_language_code ON ezcontentobject_attribute USING btree (language_code); 2752 2753 2754 2755 2756 2757 2758 2759 CREATE INDEX sort_key_int ON ezcontentobject_attribute USING btree (sort_key_int); 2760 2761 2762 2763 2764 2765 2766 2767 CREATE INDEX sort_key_string ON ezcontentobject_attribute USING btree (sort_key_string); 2768 2769 2770 2771 2772 2773 2774 2775 CREATE INDEX ezco_link_from ON ezcontentobject_link USING btree (from_contentobject_id, from_contentobject_version, contentclassattribute_id); 2776 2777 2778 2779 2780 2781 2782 2783 CREATE INDEX ezco_link_to_co_id ON ezcontentobject_link USING btree (to_contentobject_id); 2784 2785 2786 2787 2788 2789 2790 2791 CREATE INDEX ezcontentobject_name_co_id ON ezcontentobject_name USING btree (contentobject_id); 2792 2793 2794 2795 2796 2797 2798 2799 CREATE INDEX ezcontentobject_name_cov_id ON ezcontentobject_name USING btree (content_version); 2800 2801 2802 2803 2804 2805 2806 2807 CREATE INDEX ezcontentobject_name_lang_id ON ezcontentobject_name USING btree (language_id); 2808 2809 2810 2811 2812 2813 2814 2815 CREATE INDEX ezcontentobject_name_name ON ezcontentobject_name USING btree (name); 2816 2817 2818 2819 2820 2821 2822 2823 CREATE INDEX ezcobj_trash_co_id ON ezcontentobject_trash USING btree (contentobject_id); 2824 2825 2826 2827 2828 2829 2830 2831 CREATE INDEX ezcobj_trash_depth ON ezcontentobject_trash USING btree (depth); 2832 2833 2834 2835 2836 2837 2838 2839 CREATE INDEX ezcobj_trash_modified_subnode ON ezcontentobject_trash USING btree (modified_subnode); 2840 2841 2842 2843 2844 2845 2846 2847 CREATE INDEX ezcobj_trash_p_node_id ON ezcontentobject_trash USING btree (parent_node_id); 2848 2849 2850 2851 2852 2853 2854 2855 CREATE INDEX ezcobj_trash_path ON ezcontentobject_trash USING btree (path_string); 2856 2857 2858 2859 2860 2861 2862 2863 CREATE INDEX ezcobj_trash_path_ident ON ezcontentobject_trash USING btree (path_identification_string); 2864 2865 2866 2867 2868 2869 2870 2871 CREATE INDEX ezcontentobject_tree_co_id ON ezcontentobject_tree USING btree (contentobject_id); 2872 2873 2874 2875 2876 2877 2878 2879 CREATE INDEX ezcontentobject_tree_depth ON ezcontentobject_tree USING btree (depth); 2880 2881 2882 2883 2884 2885 2886 2887 CREATE INDEX ezcontentobject_tree_p_node_id ON ezcontentobject_tree USING btree (parent_node_id); 2888 2889 2890 2891 2892 2893 2894 2895 CREATE INDEX ezcontentobject_tree_path ON ezcontentobject_tree USING btree (path_string); 2896 2897 2898 2899 2900 2901 2902 2903 CREATE INDEX ezcontentobject_tree_path_ident ON ezcontentobject_tree USING btree (path_identification_string); 2904 2905 2906 2907 2908 2909 2910 2911 CREATE INDEX modified_subnode ON ezcontentobject_tree USING btree (modified_subnode); 2912 2913 2914 2915 2916 2917 2918 2919 CREATE INDEX ezcobj_version_creator_id ON ezcontentobject_version USING btree (creator_id); 2920 2921 2922 2923 2924 2925 2926 2927 CREATE INDEX ezcobj_version_status ON ezcontentobject_version USING btree (status); 2928 2929 2930 2931 2932 2933 2934 2935 CREATE INDEX idx_object_version_objver ON ezcontentobject_version USING btree (contentobject_id, "version"); 2936 2937 2938 2939 2940 2941 2942 2943 CREATE INDEX ezcurrencydata_code ON ezcurrencydata USING btree (code); 2944 2945 2946 2947 2948 2949 2950 2951 CREATE INDEX ezenumobjectvalue_co_attr_id_co_attr_ver ON ezenumobjectvalue USING btree (contentobject_attribute_id, contentobject_attribute_version); 2952 2953 2954 2955 2956 2957 2958 2959 CREATE INDEX ezenumvalue_co_cl_attr_id_co_class_att_ver ON ezenumvalue USING btree (contentclass_attribute_id, contentclass_attribute_version); 2960 2961 2962 2963 2964 2965 2966 2967 CREATE INDEX ezimagefile_coid ON ezimagefile USING btree (contentobject_attribute_id); 2968 2969 2970 2971 2972 2973 2974 2975 CREATE INDEX ezimagefile_file ON ezimagefile USING btree (filepath); 2976 2977 2978 2979 2980 2981 2982 2983 CREATE INDEX ezinfocollection_attr_co_id ON ezinfocollection_attribute USING btree (contentobject_id); 2984 2985 2986 2987 2988 2989 2990 2991 CREATE INDEX ezkeyword_keyword ON ezkeyword USING btree (keyword); 2992 2993 2994 2995 2996 2997 2998 2999 CREATE INDEX ezkeyword_keyword_id ON ezkeyword USING btree (keyword, id); 3000 3001 3002 3003 3004 3005 3006 3007 CREATE INDEX ezkeyword_attr_link_keyword_id ON ezkeyword_attribute_link USING btree (keyword_id); 3008 3009 3010 3011 3012 3013 3014 3015 CREATE INDEX ezkeyword_attr_link_kid_oaid ON ezkeyword_attribute_link USING btree (keyword_id, objectattribute_id); 3016 3017 3018 3019 3020 3021 3022 3023 CREATE UNIQUE INDEX ezmodule_run_workflow_process_id_s ON ezmodule_run USING btree (workflow_process_id); 3024 3025 3026 3027 3028 3029 3030 3031 CREATE INDEX ezmultipricedata_coa_id ON ezmultipricedata USING btree (contentobject_attr_id); 3032 3033 3034 3035 3036 3037 3038 3039 CREATE INDEX ezmultipricedata_coa_version ON ezmultipricedata USING btree (contentobject_attr_version); 3040 3041 3042 3043 3044 3045 3046 3047 CREATE INDEX ezmultipricedata_currency_code ON ezmultipricedata USING btree (currency_code); 3048 3049 3050 3051 3052 3053 3054 3055 CREATE INDEX eznode_assignment_co_id ON eznode_assignment USING btree (contentobject_id); 3056 3057 3058 3059 3060 3061 3062 3063 CREATE INDEX eznode_assignment_co_version ON eznode_assignment USING btree (contentobject_version); 3064 3065 3066 3067 3068 3069 3070 3071 CREATE INDEX eznode_assignment_coid_cov ON eznode_assignment USING btree (contentobject_id, contentobject_version); 3072 3073 3074 3075 3076 3077 3078 3079 CREATE INDEX eznode_assignment_is_main ON eznode_assignment USING btree (is_main); 3080 3081 3082 3083 3084 3085 3086 3087 CREATE INDEX eznode_assignment_parent_node ON eznode_assignment USING btree (parent_node); 3088 3089 3090 3091 3092 3093 3094 3095 CREATE INDEX ezoperation_memento_memento_key_main ON ezoperation_memento USING btree (memento_key, main); 3096 3097 3098 3099 3100 3101 3102 3103 CREATE INDEX ezorder_is_archived ON ezorder USING btree (is_archived); 3104 3105 3106 3107 3108 3109 3110 3111 CREATE INDEX ezorder_is_tmp ON ezorder USING btree (is_temporary); 3112 3113 3114 3115 3116 3117 3118 3119 CREATE INDEX ezorder_item_order_id ON ezorder_item USING btree (order_id); 3120 3121 3122 3123 3124 3125 3126 3127 CREATE INDEX ezorder_item_type ON ezorder_item USING btree ("type"); 3128 3129 3130 3131 3132 3133 3134 3135 CREATE INDEX ezorder_status_active ON ezorder_status USING btree (is_active); 3136 3137 3138 3139 3140 3141 3142 3143 CREATE INDEX ezorder_status_name ON ezorder_status USING btree (name); 3144 3145 3146 3147 3148 3149 3150 3151 CREATE INDEX ezorder_status_sid ON ezorder_status USING btree (status_id); 3152 3153 3154 3155 3156 3157 3158 3159 CREATE INDEX ezorder_status_history_mod ON ezorder_status_history USING btree (modified); 3160 3161 3162 3163 3164 3165 3166 3167 CREATE INDEX ezorder_status_history_oid ON ezorder_status_history USING btree (order_id); 3168 3169 3170 3171 3172 3173 3174 3175 CREATE INDEX ezorder_status_history_sid ON ezorder_status_history USING btree (status_id); 3176 3177 3178 3179 3180 3181 3182 3183 CREATE INDEX ezpending_actions_action ON ezpending_actions USING btree ("action"); 3184 3185 3186 3187 3188 3189 3190 3191 CREATE INDEX ezpolicy_limitation_value_val ON ezpolicy_limitation_value USING btree (value); 3192 3193 3194 3195 3196 3197 3198 3199 CREATE INDEX ezpreferences_name ON ezpreferences USING btree (name); 3200 3201 3202 3203 3204 3205 3206 3207 CREATE INDEX ezpreferences_user_id_idx ON ezpreferences USING btree (user_id, name); 3208 3209 3210 3211 3212 3213 3214 3215 CREATE INDEX ezproductcollection_item_contentobject_id ON ezproductcollection_item USING btree (contentobject_id); 3216 3217 3218 3219 3220 3221 3222 3223 CREATE INDEX ezproductcollection_item_productcollection_id ON ezproductcollection_item USING btree (productcollection_id); 3224 3225 3226 3227 3228 3229 3230 3231 CREATE INDEX ezproductcollection_item_opt_item_id ON ezproductcollection_item_opt USING btree (item_id); 3232 3233 3234 3235 3236 3237 3238 3239 CREATE INDEX ezrss_export_rsseid ON ezrss_export_item USING btree (rssexport_id); 3240 3241 3242 3243 3244 3245 3246 3247 CREATE INDEX ezsearch_object_word_link_frequency ON ezsearch_object_word_link USING btree (frequency); 3248 3249 3250 3251 3252 3253 3254 3255 CREATE INDEX ezsearch_object_word_link_identifier ON ezsearch_object_word_link USING btree (identifier); 3256 3257 3258 3259 3260 3261 3262 3263 CREATE INDEX ezsearch_object_word_link_integer_value ON ezsearch_object_word_link USING btree (integer_value); 3264 3265 3266 3267 3268 3269 3270 3271 CREATE INDEX ezsearch_object_word_link_object ON ezsearch_object_word_link USING btree (contentobject_id); 3272 3273 3274 3275 3276 3277 3278 3279 CREATE INDEX ezsearch_object_word_link_word ON ezsearch_object_word_link USING btree (word_id); 3280 3281 3282 3283 3284 3285 3286 3287 CREATE INDEX ezsearch_return_cnt_ph_id_cnt ON ezsearch_return_count USING btree (phrase_id, count); 3288 3289 3290 3291 3292 3293 3294 3295 CREATE INDEX ezsearch_search_phrase_count ON ezsearch_search_phrase USING btree (phrase_count); 3296 3297 3298 3299 3300 3301 3302 3303 CREATE UNIQUE INDEX ezsearch_search_phrase_phrase ON ezsearch_search_phrase USING btree (phrase); 3304 3305 3306 3307 3308 3309 3310 3311 CREATE INDEX ezsearch_word_word_i ON ezsearch_word USING btree (word); 3312 3313 3314 3315 3316 3317 3318 3319 CREATE INDEX expiration_time ON ezsession USING btree (expiration_time); 3320 3321 3322 3323 3324 3325 3326 3327 CREATE INDEX ezsession_user_id ON ezsession USING btree (user_id); 3328 3329 3330 3331 3332 3333 3334 3335 CREATE INDEX ezsubtree_notification_rule_user_id ON ezsubtree_notification_rule USING btree (user_id); 3336 3337 3338 3339 3340 3341 3342 3343 CREATE INDEX eztipafriend_request_created ON eztipafriend_request USING btree (created); 3344 3345 3346 3347 3348 3349 3350 3351 CREATE INDEX eztipafriend_request_email_rec ON eztipafriend_request USING btree (email_receiver); 3352 3353 3354 3355 3356 3357 3358 3359 CREATE UNIQUE INDEX eztrigger_def_id ON eztrigger USING btree (module_name, function_name, connect_type); 3360 3361 3362 3363 3364 3365 3366 3367 CREATE INDEX eztrigger_fetch ON eztrigger USING btree (name, module_name, function_name); 3368 3369 3370 3371 3372 3373 3374 3375 CREATE INDEX ezurl_url ON ezurl USING btree (url); 3376 3377 3378 3379 3380 3381 3382 3383 CREATE INDEX ezurl_ol_coa_id ON ezurl_object_link USING btree (contentobject_attribute_id); 3384 3385 3386 3387 3388 3389 3390 3391 CREATE INDEX ezurl_ol_coa_version ON ezurl_object_link USING btree (contentobject_attribute_version); 3392 3393 3394 3395 3396 3397 3398 3399 CREATE INDEX ezurl_ol_url_id ON ezurl_object_link USING btree (url_id); 3400 3401 3402 3403 3404 3405 3406 3407 CREATE INDEX ezurlalias_desturl ON ezurlalias USING btree (destination_url); 3408 3409 3410 3411 3412 3413 3414 3415 CREATE INDEX ezurlalias_forward_to_id ON ezurlalias USING btree (forward_to_id); 3416 3417 3418 3419 3420 3421 3422 3423 CREATE INDEX ezurlalias_is_wildcard ON ezurlalias USING btree (is_wildcard); 3424 3425 3426 3427 3428 3429 3430 3431 CREATE INDEX ezurlalias_source_md5 ON ezurlalias USING btree (source_md5); 3432 3433 3434 3435 3436 3437 3438 3439 CREATE INDEX ezurlalias_source_url ON ezurlalias USING btree (source_url); 3440 3441 3442 3443 3444 3445 3446 3447 CREATE INDEX ezuser_role_contentobject_id ON ezuser_role USING btree (contentobject_id); 3448 3449 3450 3451 3452 3453 3454 3455 CREATE INDEX ezuser_role_role_id ON ezuser_role USING btree (role_id); 3456 3457 3458 3459 3460 3461 3462 3463 CREATE INDEX ezwaituntildateevalue_wf_ev_id_wf_ver ON ezwaituntildatevalue USING btree (workflow_event_id, workflow_event_version); 3464 3465 3466 3467 3468 3469 3470 3471 CREATE INDEX ezworkflow_process_process_key ON ezworkflow_process USING btree (process_key); 3472 3473 3474 3475 3476 3477 3478 3479 3480 ALTER TABLE ONLY ezapprove_items 3481 ADD CONSTRAINT ezapprove_items_pkey PRIMARY KEY (id); 3482 3483 3484 3485 3486 3487 3488 3489 ALTER TABLE ONLY ezbasket 3490 ADD CONSTRAINT ezbasket_pkey PRIMARY KEY (id); 3491 3492 3493 3494 3495 3496 3497 3498 ALTER TABLE ONLY ezbinaryfile 3499 ADD CONSTRAINT ezbinaryfile_pkey PRIMARY KEY (contentobject_attribute_id, "version"); 3500 3501 3502 3503 3504 3505 3506 3507 ALTER TABLE ONLY ezcollab_group 3508 ADD CONSTRAINT ezcollab_group_pkey PRIMARY KEY (id); 3509 3510 3511 3512 3513 3514 3515 3516 ALTER TABLE ONLY ezcollab_item 3517 ADD CONSTRAINT ezcollab_item_pkey PRIMARY KEY (id); 3518 3519 3520 3521 3522 3523 3524 3525 ALTER TABLE ONLY ezcollab_item_group_link 3526 ADD CONSTRAINT ezcollab_item_group_link_pkey PRIMARY KEY (collaboration_id, group_id, user_id); 3527 3528 3529 3530 3531 3532 3533 3534 ALTER TABLE ONLY ezcollab_item_message_link 3535 ADD CONSTRAINT ezcollab_item_message_link_pkey PRIMARY KEY (id); 3536 3537 3538 3539 3540 3541 3542 3543 ALTER TABLE ONLY ezcollab_item_participant_link 3544 ADD CONSTRAINT ezcollab_item_participant_link_pkey PRIMARY KEY (collaboration_id, participant_id); 3545 3546 3547 3548 3549 3550 3551 3552 ALTER TABLE ONLY ezcollab_item_status 3553 ADD CONSTRAINT ezcollab_item_status_pkey PRIMARY KEY (collaboration_id, user_id); 3554 3555 3556 3557 3558 3559 3560 3561 ALTER TABLE ONLY ezcollab_notification_rule 3562 ADD CONSTRAINT ezcollab_notification_rule_pkey PRIMARY KEY (id); 3563 3564 3565 3566 3567 3568 3569 3570 ALTER TABLE ONLY ezcollab_profile 3571 ADD CONSTRAINT ezcollab_profile_pkey PRIMARY KEY (id); 3572 3573 3574 3575 3576 3577 3578 3579 ALTER TABLE ONLY ezcollab_simple_message 3580 ADD CONSTRAINT ezcollab_simple_message_pkey PRIMARY KEY (id); 3581 3582 3583 3584 3585 3586 3587 3588 ALTER TABLE ONLY ezcontent_language 3589 ADD CONSTRAINT ezcontent_language_pkey PRIMARY KEY (id); 3590 3591 3592 3593 3594 3595 3596 3597 ALTER TABLE ONLY ezcontentbrowsebookmark 3598 ADD CONSTRAINT ezcontentbrowsebookmark_pkey PRIMARY KEY (id); 3599 3600 3601 3602 3603 3604 3605 3606 ALTER TABLE ONLY ezcontentbrowserecent 3607 ADD CONSTRAINT ezcontentbrowserecent_pkey PRIMARY KEY (id); 3608 3609 3610 3611 3612 3613 3614 3615 ALTER TABLE ONLY ezcontentclass 3616 ADD CONSTRAINT ezcontentclass_pkey PRIMARY KEY (id, "version"); 3617 3618 3619 3620 3621 3622 3623 3624 ALTER TABLE ONLY ezcontentclass_attribute 3625 ADD CONSTRAINT ezcontentclass_attribute_pkey PRIMARY KEY (id, "version"); 3626 3627 3628 3629 3630 3631 3632 3633 ALTER TABLE ONLY ezcontentclass_classgroup 3634 ADD CONSTRAINT ezcontentclass_classgroup_pkey PRIMARY KEY (contentclass_id, contentclass_version, group_id); 3635 3636 3637 3638 3639 3640 3641 3642 ALTER TABLE ONLY ezcontentclass_name 3643 ADD CONSTRAINT ezcontentclass_name_pkey PRIMARY KEY (contentclass_id, contentclass_version, language_id); 3644 3645 3646 3647 3648 3649 3650 3651 ALTER TABLE ONLY ezcontentclassgroup 3652 ADD CONSTRAINT ezcontentclassgroup_pkey PRIMARY KEY (id); 3653 3654 3655 3656 3657 3658 3659 3660 ALTER TABLE ONLY ezcontentobject 3661 ADD CONSTRAINT ezcontentobject_pkey PRIMARY KEY (id); 3662 3663 3664 3665 3666 3667 3668 3669 ALTER TABLE ONLY ezcontentobject_attribute 3670 ADD CONSTRAINT ezcontentobject_attribute_pkey PRIMARY KEY (id, "version"); 3671 3672 3673 3674 3675 3676 3677 3678 ALTER TABLE ONLY ezcontentobject_link 3679 ADD CONSTRAINT ezcontentobject_link_pkey PRIMARY KEY (id); 3680 3681 3682 3683 3684 3685 3686 3687 ALTER TABLE ONLY ezcontentobject_name 3688 ADD CONSTRAINT ezcontentobject_name_pkey PRIMARY KEY (contentobject_id, content_version, content_translation); 3689 3690 3691 3692 3693 3694 3695 3696 ALTER TABLE ONLY ezcontentobject_trash 3697 ADD CONSTRAINT ezcontentobject_trash_pkey PRIMARY KEY (node_id); 3698 3699 3700 3701 3702 3703 3704 3705 ALTER TABLE ONLY ezcontentobject_tree 3706 ADD CONSTRAINT ezcontentobject_tree_pkey PRIMARY KEY (node_id); 3707 3708 3709 3710 3711 3712 3713 3714 ALTER TABLE ONLY ezcontentobject_version 3715 ADD CONSTRAINT ezcontentobject_version_pkey PRIMARY KEY (id); 3716 3717 3718 3719 3720 3721 3722 3723 ALTER TABLE ONLY ezcurrencydata 3724 ADD CONSTRAINT ezcurrencydata_pkey PRIMARY KEY (id); 3725 3726 3727 3728 3729 3730 3731 3732 ALTER TABLE ONLY ezdiscountrule 3733 ADD CONSTRAINT ezdiscountrule_pkey PRIMARY KEY (id); 3734 3735 3736 3737 3738 3739 3740 3741 ALTER TABLE ONLY ezdiscountsubrule 3742 ADD CONSTRAINT ezdiscountsubrule_pkey PRIMARY KEY (id); 3743 3744 3745 3746 3747 3748 3749 3750 ALTER TABLE ONLY ezdiscountsubrule_value 3751 ADD CONSTRAINT ezdiscountsubrule_value_pkey PRIMARY KEY (discountsubrule_id, value, issection); 3752 3753 3754 3755 3756 3757 3758 3759 ALTER TABLE ONLY ezenumobjectvalue 3760 ADD CONSTRAINT ezenumobjectvalue_pkey PRIMARY KEY (contentobject_attribute_id, contentobject_attribute_version, enumid); 3761 3762 3763 3764 3765 3766 3767 3768 ALTER TABLE ONLY ezenumvalue 3769 ADD CONSTRAINT ezenumvalue_pkey PRIMARY KEY (id, contentclass_attribute_id, contentclass_attribute_version); 3770 3771 3772 3773 3774 3775 3776 3777 ALTER TABLE ONLY ezforgot_password 3778 ADD CONSTRAINT ezforgot_password_pkey PRIMARY KEY (id); 3779 3780 3781 3782 3783 3784 3785 3786 ALTER TABLE ONLY ezgeneral_digest_user_settings 3787 ADD CONSTRAINT ezgeneral_digest_user_settings_pkey PRIMARY KEY (id); 3788 3789 3790 3791 3792 3793 3794 3795 ALTER TABLE ONLY ezimage 3796 ADD CONSTRAINT ezimage_pkey PRIMARY KEY (contentobject_attribute_id, "version"); 3797 3798 3799 3800 3801 3802 3803 3804 ALTER TABLE ONLY ezimagefile 3805 ADD CONSTRAINT ezimagefile_pkey PRIMARY KEY (id); 3806 3807 3808 3809 3810 3811 3812 3813 ALTER TABLE ONLY ezimagevariation 3814 ADD CONSTRAINT ezimagevariation_pkey PRIMARY KEY (contentobject_attribute_id, "version", requested_width, requested_height); 3815 3816 3817 3818 3819 3820 3821 3822 ALTER TABLE ONLY ezinfocollection 3823 ADD CONSTRAINT ezinfocollection_pkey PRIMARY KEY (id); 3824 3825 3826 3827 3828 3829 3830 3831 ALTER TABLE ONLY ezinfocollection_attribute 3832 ADD CONSTRAINT ezinfocollection_attribute_pkey PRIMARY KEY (id); 3833 3834 3835 3836 3837 3838 3839 3840 ALTER TABLE ONLY ezkeyword 3841 ADD CONSTRAINT ezkeyword_pkey PRIMARY KEY (id); 3842 3843 3844 3845 3846 3847 3848 3849 ALTER TABLE ONLY ezkeyword_attribute_link 3850 ADD CONSTRAINT ezkeyword_attribute_link_pkey PRIMARY KEY (id); 3851 3852 3853 3854 3855 3856 3857 3858 ALTER TABLE ONLY ezmedia 3859 ADD CONSTRAINT ezmedia_pkey PRIMARY KEY (contentobject_attribute_id, "version"); 3860 3861 3862 3863 3864 3865 3866 3867 ALTER TABLE ONLY ezmessage 3868 ADD CONSTRAINT ezmessage_pkey PRIMARY KEY (id); 3869 3870 3871 3872 3873 3874 3875 3876 ALTER TABLE ONLY ezmodule_run 3877 ADD CONSTRAINT ezmodule_run_pkey PRIMARY KEY (id); 3878 3879 3880 3881 3882 3883 3884 3885 ALTER TABLE ONLY ezmultipricedata 3886 ADD CONSTRAINT ezmultipricedata_pkey PRIMARY KEY (id); 3887 3888 3889 3890 3891 3892 3893 3894 ALTER TABLE ONLY eznode_assignment 3895 ADD CONSTRAINT eznode_assignment_pkey PRIMARY KEY (id); 3896 3897 3898 3899 3900 3901 3902 3903 ALTER TABLE ONLY eznotificationcollection 3904 ADD CONSTRAINT eznotificationcollection_pkey PRIMARY KEY (id); 3905 3906 3907 3908 3909 3910 3911 3912 ALTER TABLE ONLY eznotificationcollection_item 3913 ADD CONSTRAINT eznotificationcollection_item_pkey PRIMARY KEY (id); 3914 3915 3916 3917 3918 3919 3920 3921 ALTER TABLE ONLY eznotificationevent 3922 ADD CONSTRAINT eznotificationevent_pkey PRIMARY KEY (id); 3923 3924 3925 3926 3927 3928 3929 3930 ALTER TABLE ONLY ezoperation_memento 3931 ADD CONSTRAINT ezoperation_memento_pkey PRIMARY KEY (id, memento_key); 3932 3933 3934 3935 3936 3937 3938 3939 ALTER TABLE ONLY ezorder 3940 ADD CONSTRAINT ezorder_pkey PRIMARY KEY (id); 3941 3942 3943 3944 3945 3946 3947 3948 ALTER TABLE ONLY ezorder_item 3949 ADD CONSTRAINT ezorder_item_pkey PRIMARY KEY (id); 3950 3951 3952 3953 3954 3955 3956 3957 ALTER TABLE ONLY ezorder_status 3958 ADD CONSTRAINT ezorder_status_pkey PRIMARY KEY (id); 3959 3960 3961 3962 3963 3964 3965 3966 ALTER TABLE ONLY ezorder_status_history 3967 ADD CONSTRAINT ezorder_status_history_pkey PRIMARY KEY (id); 3968 3969 3970 3971 3972 3973 3974 3975 ALTER TABLE ONLY ezpackage 3976 ADD CONSTRAINT ezpackage_pkey PRIMARY KEY (id); 3977 3978 3979 3980 3981 3982 3983 3984 ALTER TABLE ONLY ezpaymentobject 3985 ADD CONSTRAINT ezpaymentobject_pkey PRIMARY KEY (id); 3986 3987 3988 3989 3990 3991 3992 3993 ALTER TABLE ONLY ezpdf_export 3994 ADD CONSTRAINT ezpdf_export_pkey PRIMARY KEY (id, "version"); 3995 3996 3997 3998 3999 4000 4001 4002 ALTER TABLE ONLY ezpolicy 4003 ADD CONSTRAINT ezpolicy_pkey PRIMARY KEY (id); 4004 4005 4006 4007 4008 4009 4010 4011 ALTER TABLE ONLY ezpolicy_limitation 4012 ADD CONSTRAINT ezpolicy_limitation_pkey PRIMARY KEY (id); 4013 4014 4015 4016 4017 4018 4019 4020 ALTER TABLE ONLY ezpolicy_limitation_value 4021 ADD CONSTRAINT ezpolicy_limitation_value_pkey PRIMARY KEY (id); 4022 4023 4024 4025 4026 4027 4028 4029 ALTER TABLE ONLY ezpreferences 4030 ADD CONSTRAINT ezpreferences_pkey PRIMARY KEY (id); 4031 4032 4033 4034 4035 4036 4037 4038 ALTER TABLE ONLY ezproductcategory 4039 ADD CONSTRAINT ezproductcategory_pkey PRIMARY KEY (id); 4040 4041 4042 4043 4044 4045 4046 4047 ALTER TABLE ONLY ezproductcollection 4048 ADD CONSTRAINT ezproductcollection_pkey PRIMARY KEY (id); 4049 4050 4051 4052 4053 4054 4055 4056 ALTER TABLE ONLY ezproductcollection_item 4057 ADD CONSTRAINT ezproductcollection_item_pkey PRIMARY KEY (id); 4058 4059 4060 4061 4062 4063 4064 4065 ALTER TABLE ONLY ezproductcollection_item_opt 4066 ADD CONSTRAINT ezproductcollection_item_opt_pkey PRIMARY KEY (id); 4067 4068 4069 4070 4071 4072 4073 4074 ALTER TABLE ONLY ezrole 4075 ADD CONSTRAINT ezrole_pkey PRIMARY KEY (id); 4076 4077 4078 4079 4080 4081 4082 4083 ALTER TABLE ONLY ezrss_export 4084 ADD CONSTRAINT ezrss_export_pkey PRIMARY KEY (id, status); 4085 4086 4087 4088 4089 4090 4091 4092 ALTER TABLE ONLY ezrss_export_item 4093 ADD CONSTRAINT ezrss_export_item_pkey PRIMARY KEY (id, status); 4094 4095 4096 4097 4098 4099 4100 4101 ALTER TABLE ONLY ezrss_import 4102 ADD CONSTRAINT ezrss_import_pkey PRIMARY KEY (id, status); 4103 4104 4105 4106 4107 4108 4109 4110 ALTER TABLE ONLY ezsearch_object_word_link 4111 ADD CONSTRAINT ezsearch_object_word_link_pkey PRIMARY KEY (id); 4112 4113 4114 4115 4116 4117 4118 4119 ALTER TABLE ONLY ezsearch_return_count 4120 ADD CONSTRAINT ezsearch_return_count_pkey PRIMARY KEY (id); 4121 4122 4123 4124 4125 4126 4127 4128 ALTER TABLE ONLY ezsearch_search_phrase 4129 ADD CONSTRAINT ezsearch_search_phrase_pkey PRIMARY KEY (id); 4130 4131 4132 4133 4134 4135 4136 4137 ALTER TABLE ONLY ezsearch_word 4138 ADD CONSTRAINT ezsearch_word_pkey PRIMARY KEY (id); 4139 4140 4141 4142 4143 4144 4145 4146 ALTER TABLE ONLY ezsection 4147 ADD CONSTRAINT ezsection_pkey PRIMARY KEY (id); 4148 4149 4150 4151 4152 4153 4154 4155 ALTER TABLE ONLY ezsession 4156 ADD CONSTRAINT ezsession_pkey PRIMARY KEY (session_key); 4157 4158 4159 4160 4161 4162 4163 4164 ALTER TABLE ONLY ezsite_data 4165 ADD CONSTRAINT ezsite_data_pkey PRIMARY KEY (name); 4166 4167 4168 4169 4170 4171 4172 4173 ALTER TABLE ONLY ezsubtree_notification_rule 4174 ADD CONSTRAINT ezsubtree_notification_rule_pkey PRIMARY KEY (id); 4175 4176 4177 4178 4179 4180 4181 4182 ALTER TABLE ONLY eztipafriend_counter 4183 ADD CONSTRAINT eztipafriend_counter_pkey PRIMARY KEY (node_id, requested); 4184 4185 4186 4187 4188 4189 4190 4191 ALTER TABLE ONLY eztrigger 4192 ADD CONSTRAINT eztrigger_pkey PRIMARY KEY (id); 4193 4194 4195 4196 4197 4198 4199 4200 ALTER TABLE ONLY ezurl 4201 ADD CONSTRAINT ezurl_pkey PRIMARY KEY (id); 4202 4203 4204 4205 4206 4207 4208 4209 ALTER TABLE ONLY ezurlalias 4210 ADD CONSTRAINT ezurlalias_pkey PRIMARY KEY (id); 4211 4212 4213 4214 4215 4216 4217 4218 ALTER TABLE ONLY ezuser 4219 ADD CONSTRAINT ezuser_pkey PRIMARY KEY (contentobject_id); 4220 4221 4222 4223 4224 4225 4226 4227 ALTER TABLE ONLY ezuser_accountkey 4228 ADD CONSTRAINT ezuser_accountkey_pkey PRIMARY KEY (id); 4229 4230 4231 4232 4233 4234 4235 4236 ALTER TABLE ONLY ezuser_discountrule 4237 ADD CONSTRAINT ezuser_discountrule_pkey PRIMARY KEY (id); 4238 4239 4240 4241 4242 4243 4244 4245 ALTER TABLE ONLY ezuser_role 4246 ADD CONSTRAINT ezuser_role_pkey PRIMARY KEY (id); 4247 4248 4249 4250 4251 4252 4253 4254 ALTER TABLE ONLY ezuser_setting 4255 ADD CONSTRAINT ezuser_setting_pkey PRIMARY KEY (user_id); 4256 4257 4258 4259 4260 4261 4262 4263 ALTER TABLE ONLY ezuservisit 4264 ADD CONSTRAINT ezuservisit_pkey PRIMARY KEY (user_id); 4265 4266 4267 4268 4269 4270 4271 4272 ALTER TABLE ONLY ezvatrule 4273 ADD CONSTRAINT ezvatrule_pkey PRIMARY KEY (id); 4274 4275 4276 4277 4278 4279 4280 4281 ALTER TABLE ONLY ezvatrule_product_category 4282 ADD CONSTRAINT ezvatrule_product_category_pkey PRIMARY KEY (vatrule_id, product_category_id); 4283 4284 4285 4286 4287 4288 4289 4290 ALTER TABLE ONLY ezvattype 4291 ADD CONSTRAINT ezvattype_pkey PRIMARY KEY (id); 4292 4293 4294 4295 4296 4297 4298 4299 ALTER TABLE ONLY ezview_counter 4300 ADD CONSTRAINT ezview_counter_pkey PRIMARY KEY (node_id); 4301 4302 4303 4304 4305 4306 4307 4308 ALTER TABLE ONLY ezwaituntildatevalue 4309 ADD CONSTRAINT ezwaituntildatevalue_pkey PRIMARY KEY (id, workflow_event_id, workflow_event_version); 4310 4311 4312 4313 4314 4315 4316 4317 ALTER TABLE ONLY ezwishlist 4318 ADD CONSTRAINT ezwishlist_pkey PRIMARY KEY (id); 4319 4320 4321 4322 4323 4324 4325 4326 ALTER TABLE ONLY ezworkflow 4327 ADD CONSTRAINT ezworkflow_pkey PRIMARY KEY (id, "version"); 4328 4329 4330 4331 4332 4333 4334 4335 ALTER TABLE ONLY ezworkflow_assign 4336 ADD CONSTRAINT ezworkflow_assign_pkey PRIMARY KEY (id); 4337 4338 4339 4340 4341 4342 4343 4344 ALTER TABLE ONLY ezworkflow_event 4345 ADD CONSTRAINT ezworkflow_event_pkey PRIMARY KEY (id, "version"); 4346 4347 4348 4349 4350 4351 4352 4353 ALTER TABLE ONLY ezworkflow_group 4354 ADD CONSTRAINT ezworkflow_group_pkey PRIMARY KEY (id); 4355 4356 4357 4358 4359 4360 4361 4362 ALTER TABLE ONLY ezworkflow_group_link 4363 ADD CONSTRAINT ezworkflow_group_link_pkey PRIMARY KEY (workflow_id, group_id, workflow_version); 4364 4365 4366 4367 4368 4369 4370 4371 ALTER TABLE ONLY ezworkflow_process 4372 ADD CONSTRAINT ezworkflow_process_pkey PRIMARY KEY (id); 4373 4374 4375 4376 4377 4378 4379 4380
titre
Description
Corps
titre
Description
Corps
titre
Description
Corps
titre
Corps
| Généré le : Sat Feb 24 10:30:04 2007 | par Balluche grâce à PHPXref 0.7 |