Changeset 21185 for branches/version-2_11-dev/html
- Timestamp:
- 2011/08/11 19:37:10 (13 years ago)
- Location:
- branches/version-2_11-dev/html
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_11-dev/html/install/index.php
r20970 r21185 551 551 $sqlval['detail_tpl'] = "default1"; 552 552 $sqlval['mypage_tpl'] = "default1"; 553 $sqlval['update_date'] = ' now()';553 $sqlval['update_date'] = 'CURRENT_TIMESTAMP'; 554 554 $objQuery = new SC_Query($dsn); 555 555 $cnt = $objQuery->count("dtb_baseinfo"); … … 571 571 'work' => 1, 572 572 'del_flg' => 0, 573 'update_date' => ' now()',573 'update_date' => 'CURRENT_TIMESTAMP', 574 574 ); 575 575 -
branches/version-2_11-dev/html/install/sql/create_table_pgsql.sql
r20887 r21185 6 6 error text, 7 7 ok text, 8 create_date timestamp NOT NULL DEFAULT now(),8 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 9 9 update_date timestamp NOT NULL, 10 10 PRIMARY KEY (log_id) … … 21 21 rank int NOT NULL DEFAULT 0, 22 22 creator_id int NOT NULL, 23 create_date timestamp NOT NULL DEFAULT now(),23 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 24 24 update_date timestamp NOT NULL, 25 25 del_flg smallint NOT NULL DEFAULT 0, … … 34 34 rank int NOT NULL DEFAULT 0, 35 35 creator_id int NOT NULL, 36 create_date timestamp NOT NULL DEFAULT now(),36 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 37 37 update_date timestamp NOT NULL, 38 38 del_flg smallint NOT NULL DEFAULT 0, … … 70 70 other_files text, 71 71 del_flg smallint NOT NULL DEFAULT 0, 72 create_date timestamp NOT NULL DEFAULT now(),72 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 73 73 update_date timestamp NOT NULL, 74 74 release_date timestamp NOT NULL, … … 154 154 del_flg smallint NOT NULL DEFAULT 0, 155 155 creator_id int NOT NULL, 156 create_date timestamp NOT NULL DEFAULT now(),156 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 157 157 update_date timestamp NOT NULL, 158 158 PRIMARY KEY (deliv_id) … … 192 192 del_flg smallint NOT NULL DEFAULT 0, 193 193 creator_id int NOT NULL, 194 create_date timestamp NOT NULL DEFAULT now(),194 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 195 195 update_date timestamp NOT NULL, 196 196 payment_image text, … … 221 221 creator_id int NOT NULL, 222 222 del_flg smallint NOT NULL DEFAULT 0, 223 create_date timestamp NOT NULL DEFAULT now(),223 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 224 224 update_date timestamp NOT NULL 225 225 ); … … 232 232 del_flg smallint NOT NULL DEFAULT 0, 233 233 creator_id int NOT NULL, 234 create_date timestamp NOT NULL DEFAULT now(),234 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 235 235 update_date timestamp NOT NULL, 236 236 PRIMARY KEY (template_id) … … 249 249 del_flg smallint NOT NULL DEFAULT 0, 250 250 creator_id int NOT NULL, 251 create_date timestamp NOT NULL DEFAULT now(),251 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 252 252 update_date timestamp NOT NULL, 253 253 PRIMARY KEY (send_id) … … 306 306 del_flg smallint NOT NULL DEFAULT 0, 307 307 creator_id int NOT NULL, 308 create_date timestamp NOT NULL DEFAULT now(),308 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 309 309 update_date timestamp NOT NULL, 310 310 deliv_date_id int, … … 326 326 point_rate numeric, 327 327 creator_id int NOT NULL, 328 create_date timestamp NOT NULL DEFAULT now(),328 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 329 329 update_date timestamp NOT NULL, 330 330 down_filename text, … … 339 339 rank int, 340 340 creator_id int NOT NULL, 341 create_date timestamp NOT NULL DEFAULT now(),341 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 342 342 update_date timestamp NOT NULL, 343 343 del_flg smallint NOT NULL DEFAULT 0, … … 351 351 rank int, 352 352 creator_id int NOT NULL, 353 create_date timestamp NOT NULL DEFAULT now(),353 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 354 354 update_date timestamp NOT NULL, 355 355 del_flg smallint NOT NULL DEFAULT 0, … … 372 372 rank int, 373 373 creator_id int NOT NULL, 374 create_date timestamp NOT NULL DEFAULT now(),374 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 375 375 update_date timestamp NOT NULL, 376 376 del_flg smallint NOT NULL DEFAULT 0, … … 389 389 product_id int NOT NULL, 390 390 creator_id int NOT NULL, 391 create_date timestamp NOT NULL DEFAULT now(),391 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 392 392 update_date timestamp NOT NULL, 393 393 del_flg smallint NOT NULL DEFAULT 0, … … 402 402 status smallint NOT NULL DEFAULT 0, 403 403 creator_id int NOT NULL, 404 create_date timestamp NOT NULL DEFAULT now(),404 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 405 405 update_date timestamp NOT NULL 406 406 ); … … 418 418 status smallint DEFAULT 2, 419 419 creator_id int NOT NULL, 420 create_date timestamp NOT NULL DEFAULT now(),420 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 421 421 update_date timestamp NOT NULL, 422 422 del_flg smallint NOT NULL DEFAULT 0, … … 427 427 customer_id int NOT NULL, 428 428 product_id int NOT NULL, 429 create_date timestamp NOT NULL DEFAULT now(),429 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 430 430 update_date timestamp NOT NULL, 431 431 PRIMARY KEY (customer_id, product_id) … … 435 435 category_id int NOT NULL, 436 436 product_count int NOT NULL, 437 create_date timestamp NOT NULL DEFAULT now()437 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 438 438 ); 439 439 … … 441 441 category_id int NOT NULL, 442 442 product_count int, 443 create_date timestamp NOT NULL DEFAULT now()443 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 444 444 ); 445 445 … … 454 454 link_method text, 455 455 creator_id int NOT NULL, 456 create_date timestamp NOT NULL DEFAULT now(),456 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 457 457 update_date timestamp NOT NULL, 458 458 del_flg smallint NOT NULL DEFAULT 0, … … 468 468 comment text, 469 469 creator_id int NOT NULL, 470 create_date timestamp NOT NULL DEFAULT now(),470 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 471 471 update_date timestamp NOT NULL, 472 472 del_flg smallint NOT NULL DEFAULT 0, … … 519 519 note text, 520 520 status smallint NOT NULL DEFAULT 1, 521 create_date timestamp NOT NULL DEFAULT now(),521 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 522 522 update_date timestamp NOT NULL, 523 523 del_flg smallint NOT NULL DEFAULT 0, … … 566 566 note text, 567 567 status smallint, 568 create_date timestamp NOT NULL DEFAULT now(),568 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 569 569 update_date timestamp NOT NULL, 570 570 commit_date timestamp, … … 626 626 deliv_check smallint, 627 627 point_check smallint, 628 create_date timestamp NOT NULL DEFAULT now(),628 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 629 629 update_date timestamp NOT NULL, 630 630 device_type_id int, … … 669 669 shipping_commit_date timestamp, 670 670 rank int, 671 create_date timestamp NOT NULL DEFAULT now(),671 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 672 672 update_date timestamp NOT NULL, 673 673 del_flg smallint NOT NULL DEFAULT 0, … … 733 733 del_flg smallint NOT NULL DEFAULT 0, 734 734 creator_id int NOT NULL, 735 create_date timestamp NOT NULL DEFAULT now(),735 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 736 736 update_date timestamp NOT NULL, 737 737 login_date timestamp, … … 752 752 keyword text, 753 753 update_url text, 754 create_date timestamp NOT NULL DEFAULT now(),754 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 755 755 update_date timestamp NOT NULL, 756 756 PRIMARY KEY (device_type_id, page_id) … … 763 763 tpl_path text, 764 764 filename text NOT NULL, 765 create_date timestamp NOT NULL DEFAULT now(),765 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 766 766 update_date timestamp NOT NULL, 767 767 php_path text, … … 789 789 rw_flg smallint DEFAULT 1, 790 790 status smallint NOT NULL DEFAULT 1, 791 create_date timestamp NOT NULL DEFAULT now(),791 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 792 792 update_date timestamp NOT NULL, 793 793 mb_convert_kana_option text, … … 801 801 sql_name text NOT NULL, 802 802 csv_sql text, 803 create_date timestamp NOT NULL DEFAULT now(),803 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 804 804 update_date timestamp NOT NULL, 805 805 PRIMARY KEY (sql_id) … … 810 810 device_type_id int NOT NULL, 811 811 template_name text, 812 create_date timestamp NOT NULL DEFAULT now(),812 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 813 813 update_date timestamp NOT NULL, 814 814 PRIMARY KEY (template_code) … … 820 820 rank int NOT NULL DEFAULT 0, 821 821 creator_id int NOT NULL, 822 create_date timestamp NOT NULL DEFAULT now(),822 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 823 823 update_date timestamp NOT NULL, 824 824 del_flg smallint NOT NULL DEFAULT 0, … … 829 829 maker_id int NOT NULL, 830 830 product_count int NOT NULL, 831 create_date timestamp NOT NULL DEFAULT now()831 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 832 832 ); 833 833 … … 1104 1104 param_value text, 1105 1105 url text, 1106 create_date timestamp NOT NULL DEFAULT now()1106 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 1107 1107 ); 1108 1108 … … 1114 1114 auto_update_flg smallint NOT NULL DEFAULT 0, 1115 1115 del_flg smallint NOT NULL DEFAULT 0, 1116 create_date timestamp NOT NULL DEFAULT now(),1116 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1117 1117 update_date timestamp NOT NULL 1118 1118 ); … … 1121 1121 sess_id text NOT NULL, 1122 1122 sess_data text, 1123 create_date timestamp NOT NULL DEFAULT now(),1123 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1124 1124 update_date timestamp NOT NULL, 1125 1125 PRIMARY KEY (sess_id) … … 1129 1129 bkup_name text, 1130 1130 bkup_memo text, 1131 create_date timestamp NOT NULL DEFAULT now(),1131 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1132 1132 PRIMARY KEY (bkup_name) 1133 1133 ); … … 1147 1147 enable smallint NOT NULL DEFAULT 0, 1148 1148 del_flg smallint NOT NULL DEFAULT 0, 1149 create_date timestamp NOT NULL DEFAULT now(),1149 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1150 1150 update_date timestamp NOT NULL, 1151 1151 PRIMARY KEY (plugin_id) -
branches/version-2_11-dev/html/test/upgrade/index.php
r20813 r21185 117 117 'auto_update_flg' => '0', 118 118 'del_flg' => '0', 119 'update_date' => ' NOW()',119 'update_date' => 'CURRENT_TIMESTAMP', 120 120 ); 121 121 $objQuery->update($table, $arrUpdate, $where, array($arrProduct['product_id'])); … … 127 127 'auto_update_flg' => '0', 128 128 'del_flg' => '0', 129 'update_date' => ' NOW()',130 'create_date' => ' NOW()',129 'update_date' => 'CURRENT_TIMESTAMP', 130 'create_date' => 'CURRENT_TIMESTAMP', 131 131 ); 132 132 $objQuery->insert($table, $arrInsert);
Note: See TracChangeset
for help on using the changeset viewer.