Changeset 22280
- Timestamp:
- 2013/01/18 18:19:12 (11 years ago)
- Location:
- branches/version-2_12-multilang
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-multilang/data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php
r21867 r22280 323 323 $objQuery->exec('SET SESSION storage_engine = InnoDB'); 324 324 $objQuery->exec("SET SESSION sql_mode = 'ANSI'"); 325 $objQuery->exec("SET TIME_ZONE = '+9:00'"); 325 326 } 326 327 } -
branches/version-2_12-multilang/html/install/sql/create_table_pgsql.sql
r22205 r22280 6 6 error text, 7 7 ok text, 8 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,9 update_date timestamp NOT NULL,8 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 9 update_date timestamp WITH TIME ZONE NOT NULL, 10 10 PRIMARY KEY (log_id) 11 11 ); … … 22 22 rank int NOT NULL DEFAULT 0, 23 23 creator_id int NOT NULL, 24 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,25 update_date timestamp NOT NULL,24 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 25 update_date timestamp WITH TIME ZONE NOT NULL, 26 26 del_flg smallint NOT NULL DEFAULT 0, 27 27 PRIMARY KEY (kiyaku_id) … … 35 35 rank int NOT NULL DEFAULT 0, 36 36 creator_id int NOT NULL, 37 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,38 update_date timestamp NOT NULL,37 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 38 update_date timestamp WITH TIME ZONE NOT NULL, 39 39 del_flg smallint NOT NULL DEFAULT 0, 40 40 PRIMARY KEY (holiday_id) … … 62 62 other_files text, 63 63 del_flg smallint NOT NULL DEFAULT 0, 64 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,65 update_date timestamp NOT NULL,66 release_date timestamp NOT NULL,64 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 65 update_date timestamp WITH TIME ZONE NOT NULL, 66 release_date timestamp WITH TIME ZONE NOT NULL, 67 67 PRIMARY KEY (module_id) 68 68 ); … … 124 124 point_rate numeric NOT NULL DEFAULT 0, 125 125 welcome_point numeric NOT NULL DEFAULT 0, 126 update_date timestamp NOT NULL,126 update_date timestamp WITH TIME ZONE NOT NULL, 127 127 top_tpl text, 128 128 product_tpl text, … … 150 150 del_flg smallint NOT NULL DEFAULT 0, 151 151 creator_id int NOT NULL, 152 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,153 update_date timestamp NOT NULL,152 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 153 update_date timestamp WITH TIME ZONE NOT NULL, 154 154 PRIMARY KEY (deliv_id) 155 155 ); … … 188 188 del_flg smallint NOT NULL DEFAULT 0, 189 189 creator_id int NOT NULL, 190 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,191 update_date timestamp NOT NULL,190 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 191 update_date timestamp WITH TIME ZONE NOT NULL, 192 192 payment_image text, 193 193 upper_rule numeric, … … 217 217 creator_id int NOT NULL, 218 218 del_flg smallint NOT NULL DEFAULT 0, 219 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,220 update_date timestamp NOT NULL,219 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 220 update_date timestamp WITH TIME ZONE NOT NULL, 221 221 PRIMARY KEY (template_id) 222 222 ); … … 229 229 del_flg smallint NOT NULL DEFAULT 0, 230 230 creator_id int NOT NULL, 231 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,232 update_date timestamp NOT NULL,231 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 232 update_date timestamp WITH TIME ZONE NOT NULL, 233 233 PRIMARY KEY (template_id) 234 234 ); … … 241 241 send_count int, 242 242 complete_count int NOT NULL DEFAULT 0, 243 start_date timestamp ,244 end_date timestamp ,243 start_date timestamp WITH TIME ZONE, 244 end_date timestamp WITH TIME ZONE, 245 245 search_data text, 246 246 del_flg smallint NOT NULL DEFAULT 0, 247 247 creator_id int NOT NULL, 248 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,249 update_date timestamp NOT NULL,248 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 249 update_date timestamp WITH TIME ZONE NOT NULL, 250 250 PRIMARY KEY (send_id) 251 251 ); … … 303 303 del_flg smallint NOT NULL DEFAULT 0, 304 304 creator_id int NOT NULL, 305 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,306 update_date timestamp NOT NULL,305 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 306 update_date timestamp WITH TIME ZONE NOT NULL, 307 307 deliv_date_id int, 308 308 PRIMARY KEY (product_id) … … 324 324 point_rate numeric NOT NULL DEFAULT 0, 325 325 creator_id int NOT NULL, 326 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,327 update_date timestamp NOT NULL,326 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 327 update_date timestamp WITH TIME ZONE NOT NULL, 328 328 down_filename text, 329 329 down_realfilename text, … … 338 338 rank int, 339 339 creator_id int NOT NULL, 340 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,341 update_date timestamp NOT NULL,340 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 341 update_date timestamp WITH TIME ZONE NOT NULL, 342 342 del_flg smallint NOT NULL DEFAULT 0, 343 343 PRIMARY KEY (class_id) … … 350 350 rank int, 351 351 creator_id int NOT NULL, 352 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,353 update_date timestamp NOT NULL,352 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 353 update_date timestamp WITH TIME ZONE NOT NULL, 354 354 del_flg smallint NOT NULL DEFAULT 0, 355 355 PRIMARY KEY (classcategory_id) … … 363 363 rank int, 364 364 creator_id int NOT NULL, 365 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,366 update_date timestamp NOT NULL,365 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 366 update_date timestamp WITH TIME ZONE NOT NULL, 367 367 del_flg smallint NOT NULL DEFAULT 0, 368 368 PRIMARY KEY (category_id) … … 380 380 product_id int NOT NULL, 381 381 creator_id int NOT NULL, 382 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,383 update_date timestamp NOT NULL,382 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 383 update_date timestamp WITH TIME ZONE NOT NULL, 384 384 del_flg smallint NOT NULL DEFAULT 0, 385 385 PRIMARY KEY (product_status_id, product_id) … … 393 393 status smallint NOT NULL DEFAULT 0, 394 394 creator_id int NOT NULL, 395 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,396 update_date timestamp NOT NULL,395 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 396 update_date timestamp WITH TIME ZONE NOT NULL, 397 397 PRIMARY KEY (product_id, recommend_product_id) 398 398 ); … … 410 410 status smallint DEFAULT 2, 411 411 creator_id int NOT NULL, 412 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,413 update_date timestamp NOT NULL,412 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 413 update_date timestamp WITH TIME ZONE NOT NULL, 414 414 del_flg smallint NOT NULL DEFAULT 0, 415 415 PRIMARY KEY (review_id) … … 419 419 customer_id int NOT NULL, 420 420 product_id int NOT NULL, 421 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,422 update_date timestamp NOT NULL,421 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 422 update_date timestamp WITH TIME ZONE NOT NULL, 423 423 PRIMARY KEY (customer_id, product_id) 424 424 ); … … 427 427 category_id int NOT NULL, 428 428 product_count int NOT NULL, 429 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,429 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 430 430 PRIMARY KEY (category_id) 431 431 ); … … 434 434 category_id int NOT NULL, 435 435 product_count int, 436 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,436 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 437 437 PRIMARY KEY (category_id) 438 438 ); … … 440 440 CREATE TABLE dtb_news ( 441 441 news_id int NOT NULL, 442 news_date timestamp ,442 news_date timestamp WITH TIME ZONE, 443 443 rank int, 444 444 news_title text NOT NULL, … … 448 448 link_method text, 449 449 creator_id int NOT NULL, 450 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,451 update_date timestamp NOT NULL,450 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 451 update_date timestamp WITH TIME ZONE NOT NULL, 452 452 del_flg smallint NOT NULL DEFAULT 0, 453 453 PRIMARY KEY (news_id) … … 462 462 comment text, 463 463 creator_id int NOT NULL, 464 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,465 update_date timestamp NOT NULL,464 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 465 update_date timestamp WITH TIME ZONE NOT NULL, 466 466 del_flg smallint NOT NULL DEFAULT 0, 467 467 PRIMARY KEY (best_id) … … 471 471 send_id int NOT NULL, 472 472 order_id int NOT NULL, 473 send_date timestamp ,473 send_date timestamp WITH TIME ZONE, 474 474 template_id int, 475 475 creator_id int NOT NULL, … … 501 501 sex smallint, 502 502 job smallint, 503 birth timestamp ,503 birth timestamp WITH TIME ZONE, 504 504 password text, 505 505 reminder smallint, … … 507 507 salt text, 508 508 secret_key text NOT NULL, 509 first_buy_date timestamp ,510 last_buy_date timestamp ,509 first_buy_date timestamp WITH TIME ZONE, 510 last_buy_date timestamp WITH TIME ZONE, 511 511 buy_times numeric DEFAULT 0, 512 512 buy_total numeric DEFAULT 0, … … 514 514 note text, 515 515 status smallint NOT NULL DEFAULT 1, 516 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,517 update_date timestamp NOT NULL,516 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 517 update_date timestamp WITH TIME ZONE NOT NULL, 518 518 del_flg smallint NOT NULL DEFAULT 0, 519 519 mobile_phone_id text, … … 546 546 order_addr02 text, 547 547 order_sex smallint, 548 order_birth timestamp ,548 order_birth timestamp WITH TIME ZONE, 549 549 order_job int, 550 550 subtotal numeric, … … 563 563 note text, 564 564 status smallint, 565 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,566 update_date timestamp NOT NULL,567 commit_date timestamp ,568 payment_date timestamp ,565 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 566 update_date timestamp WITH TIME ZONE NOT NULL, 567 commit_date timestamp WITH TIME ZONE, 568 payment_date timestamp WITH TIME ZONE, 569 569 device_type_id int, 570 570 del_flg smallint NOT NULL DEFAULT 0, … … 604 604 order_addr02 text, 605 605 order_sex smallint, 606 order_birth timestamp ,606 order_birth timestamp WITH TIME ZONE, 607 607 order_job int, 608 608 subtotal numeric, … … 624 624 deliv_check smallint, 625 625 point_check smallint, 626 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,627 update_date timestamp NOT NULL,626 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 627 update_date timestamp WITH TIME ZONE NOT NULL, 628 628 device_type_id int, 629 629 del_flg smallint NOT NULL DEFAULT 0, … … 665 665 shipping_time text, 666 666 shipping_num text, 667 shipping_date timestamp ,668 shipping_commit_date timestamp ,667 shipping_date timestamp WITH TIME ZONE, 668 shipping_commit_date timestamp WITH TIME ZONE, 669 669 rank int, 670 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,671 update_date timestamp NOT NULL,670 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 671 update_date timestamp WITH TIME ZONE NOT NULL, 672 672 del_flg smallint NOT NULL DEFAULT 0, 673 673 PRIMARY KEY (shipping_id, order_id) … … 736 736 del_flg smallint NOT NULL DEFAULT 0, 737 737 creator_id int NOT NULL, 738 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,739 update_date timestamp NOT NULL,740 login_date timestamp ,738 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 739 update_date timestamp WITH TIME ZONE NOT NULL, 740 login_date timestamp WITH TIME ZONE, 741 741 PRIMARY KEY (member_id) 742 742 ); … … 755 755 keyword text, 756 756 update_url text, 757 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,758 update_date timestamp NOT NULL,757 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 758 update_date timestamp WITH TIME ZONE NOT NULL, 759 759 PRIMARY KEY (device_type_id, page_id) 760 760 ); … … 766 766 tpl_path text, 767 767 filename text NOT NULL, 768 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,769 update_date timestamp NOT NULL,768 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 769 update_date timestamp WITH TIME ZONE NOT NULL, 770 770 php_path text, 771 771 deletable_flg smallint NOT NULL DEFAULT 1, … … 793 793 rw_flg smallint DEFAULT 1, 794 794 status smallint NOT NULL DEFAULT 1, 795 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,796 update_date timestamp NOT NULL,795 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 796 update_date timestamp WITH TIME ZONE NOT NULL, 797 797 mb_convert_kana_option text, 798 798 size_const_type text, … … 805 805 sql_name text NOT NULL, 806 806 csv_sql text, 807 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,808 update_date timestamp NOT NULL,807 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 808 update_date timestamp WITH TIME ZONE NOT NULL, 809 809 PRIMARY KEY (sql_id) 810 810 ); … … 814 814 device_type_id int NOT NULL, 815 815 template_name text, 816 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,817 update_date timestamp NOT NULL,816 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 817 update_date timestamp WITH TIME ZONE NOT NULL, 818 818 PRIMARY KEY (template_code) 819 819 ); … … 824 824 rank int NOT NULL DEFAULT 0, 825 825 creator_id int NOT NULL, 826 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,827 update_date timestamp NOT NULL,826 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 827 update_date timestamp WITH TIME ZONE NOT NULL, 828 828 del_flg smallint NOT NULL DEFAULT 0, 829 829 PRIMARY KEY (maker_id) … … 833 833 maker_id int NOT NULL, 834 834 product_count int NOT NULL, 835 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,835 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 836 836 PRIMARY KEY (maker_id) 837 837 ); … … 1109 1109 param_value text, 1110 1110 url text, 1111 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,1111 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 1112 1112 PRIMARY KEY (session_id) 1113 1113 ); … … 1120 1120 auto_update_flg smallint NOT NULL DEFAULT 0, 1121 1121 del_flg smallint NOT NULL DEFAULT 0, 1122 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,1123 update_date timestamp NOT NULL,1122 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 1123 update_date timestamp WITH TIME ZONE NOT NULL, 1124 1124 PRIMARY KEY (module_id) 1125 1125 ); … … 1128 1128 sess_id text NOT NULL, 1129 1129 sess_data text, 1130 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,1131 update_date timestamp NOT NULL,1130 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 1131 update_date timestamp WITH TIME ZONE NOT NULL, 1132 1132 PRIMARY KEY (sess_id) 1133 1133 ); … … 1136 1136 bkup_name text, 1137 1137 bkup_memo text, 1138 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,1138 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 1139 1139 PRIMARY KEY (bkup_name) 1140 1140 ); … … 1157 1157 free_field3 text, 1158 1158 free_field4 text, 1159 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,1160 update_date timestamp NOT NULL,1159 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 1160 update_date timestamp WITH TIME ZONE NOT NULL, 1161 1161 PRIMARY KEY (plugin_id) 1162 1162 ); … … 1167 1167 hook_point text NOT NULL, 1168 1168 callback text, 1169 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,1170 update_date timestamp NOT NULL,1169 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 1170 update_date timestamp WITH TIME ZONE NOT NULL, 1171 1171 PRIMARY KEY (plugin_hookpoint_id) 1172 1172 ); … … 1189 1189 sub_data text, 1190 1190 del_flg smallint NOT NULL DEFAULT 0, 1191 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,1192 update_date timestamp NOT NULL,1191 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 1192 update_date timestamp WITH TIME ZONE NOT NULL, 1193 1193 PRIMARY KEY (api_config_id) 1194 1194 ); … … 1200 1200 enable smallint NOT NULL DEFAULT 0, 1201 1201 del_flg smallint NOT NULL DEFAULT 0, 1202 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,1203 update_date timestamp NOT NULL,1202 create_date timestamp WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP, 1203 update_date timestamp WITH TIME ZONE NOT NULL, 1204 1204 PRIMARY KEY (api_account_id) 1205 1205 );
Note: See TracChangeset
for help on using the changeset viewer.