Changeset 19808
- Timestamp:
- 2011/01/02 00:17:14 (13 years ago)
- Location:
- branches/version-2_5-dev
- Files:
-
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_Product.php
r19805 r19808 833 833 834 834 $records["product_class_id"] = $objQuery->nextVal('dtb_products_class_product_class_id'); 835 unset($records["update_date"]); 836 835 $records["update_date"] = 'now()'; 837 836 $records["create_date"] = "Now()"; 838 837 $objQuery->insert($table, $records); -
branches/version-2_5-dev/html/install/index.php
r19805 r19808 261 261 $sqlval['detail_tpl'] = "default1"; 262 262 $sqlval['mypage_tpl'] = "default1"; 263 $sqlval['update_date'] = 'now()'; 263 264 $objQuery = new SC_Query($dsn); 264 265 $cnt = $objQuery->count("dtb_baseinfo"); -
branches/version-2_5-dev/html/install/sql/create_table_mysql.sql
r19781 r19808 6 6 error text, 7 7 ok text, 8 create_date datetime NOT NULL,9 update_date datetimeNOT NULL,8 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 9 update_date timestamp NOT NULL, 10 10 PRIMARY KEY (log_id) 11 11 ) TYPE=InnoDB; … … 21 21 rank int NOT NULL DEFAULT 0, 22 22 creator_id int NOT NULL, 23 create_date datetime NOT NULL,24 update_date datetimeNOT NULL,23 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 24 update_date timestamp NOT NULL, 25 25 del_flg smallint NOT NULL DEFAULT 0, 26 26 PRIMARY KEY (kiyaku_id) … … 34 34 rank int NOT NULL DEFAULT 0, 35 35 creator_id int NOT NULL, 36 create_date datetime NOT NULL,37 update_date datetimeNOT NULL,36 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 37 update_date timestamp NOT NULL, 38 38 del_flg smallint NOT NULL DEFAULT 0, 39 39 PRIMARY KEY (holiday_id) … … 66 66 member smallint, 67 67 order_date datetime, 68 create_date datetime NOT NULL68 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 69 69 ) TYPE=InnoDB; 70 70 … … 81 81 other_files text, 82 82 del_flg smallint NOT NULL DEFAULT 0, 83 create_date datetime NOT NULL,84 update_date datetime,83 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 84 update_date timestamp NOT NULL, 85 85 release_date datetime NOT NULL, 86 86 PRIMARY KEY (module_id) … … 140 140 point_rate numeric NOT NULL DEFAULT 0, 141 141 welcome_point numeric NOT NULL DEFAULT 0, 142 update_date datetime,142 update_date timestamp NOT NULL, 143 143 top_tpl text, 144 144 product_tpl text, … … 164 164 del_flg smallint NOT NULL DEFAULT 0, 165 165 creator_id int NOT NULL, 166 create_date datetime NOT NULL,167 update_date datetime,166 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 167 update_date timestamp NOT NULL, 168 168 PRIMARY KEY (deliv_id) 169 169 ) TYPE=InnoDB; … … 195 195 del_flg smallint NOT NULL DEFAULT 0, 196 196 creator_id int NOT NULL, 197 create_date datetime NOT NULL,198 update_date datetime,197 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 198 update_date timestamp NOT NULL, 199 199 payment_image text, 200 200 upper_rule numeric, … … 231 231 creator_id int NOT NULL, 232 232 del_flg smallint NOT NULL DEFAULT 0, 233 create_date datetime NOT NULL,234 update_date datetimeNOT NULL233 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 234 update_date timestamp NOT NULL 235 235 ) TYPE=InnoDB; 236 236 … … 247 247 del_flg smallint NOT NULL DEFAULT 0, 248 248 creator_id int NOT NULL, 249 create_date datetime NOT NULL,250 update_date datetimeNOT NULL,249 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 250 update_date timestamp NOT NULL, 251 251 PRIMARY KEY (send_id) 252 252 ) TYPE=InnoDB; … … 304 304 del_flg smallint NOT NULL DEFAULT 0, 305 305 creator_id int NOT NULL, 306 create_date datetime NOT NULL,307 update_date datetime,306 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 307 update_date timestamp NOT NULL, 308 308 deliv_date_id int, 309 309 PRIMARY KEY (product_id) … … 324 324 point_rate numeric, 325 325 creator_id int NOT NULL, 326 create_date datetime NOT NULL,327 update_date datetime,326 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 327 update_date timestamp NOT NULL, 328 328 down_filename text, 329 329 down_realfilename text, … … 337 337 rank int, 338 338 creator_id int NOT NULL, 339 create_date datetime NOT NULL,340 update_date datetime,339 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 340 update_date timestamp NOT NULL, 341 341 del_flg smallint NOT NULL DEFAULT 0, 342 342 PRIMARY KEY (class_id) … … 349 349 rank int, 350 350 creator_id int NOT NULL, 351 create_date datetime NOT NULL,352 update_date datetime,351 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 352 update_date timestamp NOT NULL, 353 353 del_flg smallint NOT NULL DEFAULT 0, 354 354 PRIMARY KEY (classcategory_id) … … 370 370 rank int, 371 371 creator_id int NOT NULL, 372 create_date datetime NOT NULL,373 update_date datetime,372 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 373 update_date timestamp NOT NULL, 374 374 del_flg smallint NOT NULL DEFAULT 0, 375 375 PRIMARY KEY (category_id) … … 387 387 product_id int NOT NULL, 388 388 creator_id int NOT NULL, 389 create_date datetime NOT NULL,390 update_date datetime,389 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 390 update_date timestamp NOT NULL, 391 391 del_flg smallint NOT NULL DEFAULT 0, 392 392 PRIMARY KEY(product_status_id, product_id) … … 406 406 total_average numeric NOT NULL DEFAULT 0, 407 407 order_date datetime NOT NULL, 408 create_date datetime NOT NULL,408 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 409 409 year smallint NOT NULL, 410 410 month smallint NOT NULL, … … 431 431 hour smallint NOT NULL DEFAULT 0, 432 432 order_date datetime, 433 create_date datetime NOT NULL433 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 434 434 ) TYPE=InnoDB; 435 435 … … 441 441 status smallint NOT NULL DEFAULT 0, 442 442 creator_id int NOT NULL, 443 create_date datetime NOT NULL,444 update_date datetimeNOT NULL443 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 444 update_date timestamp NOT NULL 445 445 ) TYPE=InnoDB; 446 446 … … 457 457 status smallint DEFAULT 2, 458 458 creator_id int NOT NULL, 459 create_date datetime,460 update_date datetime,459 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 460 update_date timestamp NOT NULL, 461 461 del_flg smallint NOT NULL DEFAULT 0, 462 462 PRIMARY KEY (review_id) … … 466 466 customer_id int NOT NULL, 467 467 product_id int NOT NULL, 468 create_date datetime NOT NULL,469 update_date datetimeNOT NULL468 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 469 update_date timestamp NOT NULL 470 470 ) TYPE=InnoDB; 471 471 … … 473 473 category_id int NOT NULL, 474 474 product_count int NOT NULL, 475 create_date datetime NOT NULL475 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 476 476 ) TYPE=InnoDB; 477 477 … … 479 479 category_id int NOT NULL, 480 480 product_count int, 481 create_date datetime NOT NULL481 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 482 482 ) TYPE=InnoDB; 483 483 … … 492 492 link_method text, 493 493 creator_id int NOT NULL, 494 create_date datetime NOT NULL,495 update_date datetime,494 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 495 update_date timestamp NOT NULL, 496 496 del_flg smallint NOT NULL DEFAULT 0, 497 497 PRIMARY KEY (news_id) … … 506 506 comment text, 507 507 creator_id int NOT NULL, 508 create_date datetime NOT NULL,509 update_date datetime,508 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 509 update_date timestamp NOT NULL, 510 510 del_flg smallint NOT NULL DEFAULT 0, 511 511 PRIMARY KEY (best_id) … … 556 556 note text, 557 557 status smallint NOT NULL DEFAULT 1, 558 create_date datetime NOT NULL,559 update_date datetime,558 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 559 update_date timestamp NOT NULL, 560 560 del_flg smallint NOT NULL DEFAULT 0, 561 561 mobile_phone_id text, … … 621 621 note text, 622 622 status smallint, 623 create_date datetime NOT NULL,624 update_date datetime,623 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 624 update_date timestamp NOT NULL, 625 625 commit_date datetime, 626 626 payment_date datetime, … … 700 700 deliv_check smallint, 701 701 point_check smallint, 702 create_date datetime NOT NULL,703 update_date datetime,702 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 703 update_date timestamp NOT NULL, 704 704 device_type_id int, 705 705 del_flg smallint NOT NULL DEFAULT 0, … … 761 761 del_flg smallint NOT NULL DEFAULT 0, 762 762 creator_id int NOT NULL, 763 update_date datetime,764 create_date datetimeNOT NULL,763 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 764 update_date timestamp NOT NULL, 765 765 login_date datetime, 766 766 PRIMARY KEY (member_id) … … 771 771 relate_product_id int, 772 772 customer_id int, 773 create_date datetime773 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 774 774 ) TYPE=InnoDB; 775 775 … … 789 789 keyword text, 790 790 update_url text, 791 create_date datetime NOT NULL,792 update_date datetimeNOT NULL,791 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 792 update_date timestamp NOT NULL, 793 793 PRIMARY KEY (device_type_id, page_id) 794 794 ) TYPE=InnoDB; … … 800 800 tpl_path text, 801 801 filename varchar(50) NOT NULL, 802 create_date datetime NOT NULL,803 update_date datetimeNOT NULL,802 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 803 update_date timestamp NOT NULL, 804 804 php_path text, 805 805 deletable_flg smallint NOT NULL DEFAULT 1, … … 826 826 rw_flg smallint DEFAULT 1, 827 827 status smallint NOT NULL DEFAULT 1, 828 create_date datetime NOT NULL,829 update_date datetimeNOT NULL,828 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 829 update_date timestamp NOT NULL, 830 830 mb_convert_kana_option text, 831 831 size_const_type text, … … 838 838 sql_name text NOT NULL, 839 839 csv_sql text, 840 update_date datetime NOT NULL,841 create_date datetimeNOT NULL,840 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 841 update_date timestamp NOT NULL, 842 842 PRIMARY KEY (sql_id) 843 843 ) TYPE=InnoDB; … … 846 846 template_code varchar(50) NOT NULL, 847 847 template_name text, 848 create_date datetime NOT NULL,849 update_date datetimeNOT NULL,848 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 849 update_date timestamp NOT NULL, 850 850 PRIMARY KEY (template_code) 851 851 ) TYPE=InnoDB; … … 864 864 rank int NOT NULL DEFAULT 0, 865 865 creator_id int NOT NULL, 866 create_date datetime NOT NULL,867 update_date datetimeNOT NULL,866 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 867 update_date timestamp NOT NULL, 868 868 del_flg smallint NOT NULL DEFAULT 0, 869 869 PRIMARY KEY (maker_id) … … 873 873 maker_id int NOT NULL, 874 874 product_count int NOT NULL, 875 create_date datetime NOT NULL875 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 876 876 ) TYPE=InnoDB; 877 877 … … 1196 1196 auto_update_flg smallint NOT NULL DEFAULT 0, 1197 1197 del_flg smallint NOT NULL DEFAULT 0, 1198 create_date datetime NOT NULL,1199 update_date datetimeNOT NULL1198 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1199 update_date timestamp NOT NULL 1200 1200 ) TYPE=InnoDB; 1201 1201 … … 1203 1203 sess_id varchar(50) NOT NULL, 1204 1204 sess_data text, 1205 create_date datetime NOT NULL,1206 update_date datetimeNOT NULL,1205 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1206 update_date timestamp NOT NULL, 1207 1207 PRIMARY KEY (sess_id) 1208 1208 ) TYPE=InnoDB; … … 1215 1215 del_flg smallint NOT NULL DEFAULT 0, 1216 1216 memo text, 1217 create_date datetime NOT NULL,1218 update_date datetimeNOT NULL,1217 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1218 update_date timestamp NOT NULL, 1219 1219 PRIMARY KEY (control_id) 1220 1220 ) TYPE=InnoDB; … … 1229 1229 status smallint NOT NULL DEFAULT 2, 1230 1230 del_flg smallint NOT NULL DEFAULT 0, 1231 create_date datetime NOT NULL,1232 update_date datetimeNOT NULL,1231 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1232 update_date timestamp NOT NULL, 1233 1233 PRIMARY KEY (trackback_id) 1234 1234 ) TYPE=InnoDB; … … 1237 1237 bkup_name varchar(50), 1238 1238 bkup_memo text, 1239 create_date datetime,1239 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1240 1240 PRIMARY KEY (bkup_name) 1241 1241 ) TYPE=InnoDB; … … 1247 1247 del_flg smallint NOT NULL DEFAULT 0, 1248 1248 class_name varchar(255) NOT NULL, 1249 create_date datetime NOT NULL,1250 update_date datetimeNOT NULL,1249 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1250 update_date timestamp NOT NULL, 1251 1251 PRIMARY KEY (plugin_id) 1252 1252 ) TYPE=InnoDB; -
branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql
r19773 r19808 7 7 ok text, 8 8 create_date timestamp NOT NULL DEFAULT now(), 9 update_date timestamp NOT NULL DEFAULT now(),9 update_date timestamp NOT NULL, 10 10 PRIMARY KEY (log_id) 11 11 ); … … 82 82 del_flg smallint NOT NULL DEFAULT 0, 83 83 create_date timestamp NOT NULL DEFAULT now(), 84 update_date timestamp ,84 update_date timestamp NOT NULL, 85 85 release_date timestamp NOT NULL, 86 86 PRIMARY KEY (module_id) … … 140 140 point_rate numeric NOT NULL DEFAULT 0, 141 141 welcome_point numeric NOT NULL DEFAULT 0, 142 update_date timestamp ,142 update_date timestamp NOT NULL, 143 143 top_tpl text, 144 144 product_tpl text, … … 165 165 creator_id int NOT NULL, 166 166 create_date timestamp NOT NULL DEFAULT now(), 167 update_date timestamp ,167 update_date timestamp NOT NULL, 168 168 PRIMARY KEY (deliv_id) 169 169 ); … … 196 196 creator_id int NOT NULL, 197 197 create_date timestamp NOT NULL DEFAULT now(), 198 update_date timestamp ,198 update_date timestamp NOT NULL, 199 199 payment_image text, 200 200 upper_rule numeric, … … 248 248 creator_id int NOT NULL, 249 249 create_date timestamp NOT NULL DEFAULT now(), 250 update_date timestamp NOT NULL DEFAULT now(),250 update_date timestamp NOT NULL, 251 251 PRIMARY KEY (send_id) 252 252 ); … … 305 305 creator_id int NOT NULL, 306 306 create_date timestamp NOT NULL DEFAULT now(), 307 update_date timestamp ,307 update_date timestamp NOT NULL, 308 308 deliv_date_id int, 309 309 PRIMARY KEY (product_id) … … 325 325 creator_id int NOT NULL, 326 326 create_date timestamp NOT NULL DEFAULT now(), 327 update_date timestamp ,327 update_date timestamp NOT NULL, 328 328 down_filename text, 329 329 down_realfilename text, … … 338 338 creator_id int NOT NULL, 339 339 create_date timestamp NOT NULL DEFAULT now(), 340 update_date timestamp ,340 update_date timestamp NOT NULL, 341 341 del_flg smallint NOT NULL DEFAULT 0, 342 342 PRIMARY KEY (class_id) … … 350 350 creator_id int NOT NULL, 351 351 create_date timestamp NOT NULL DEFAULT now(), 352 update_date timestamp ,352 update_date timestamp NOT NULL, 353 353 del_flg smallint NOT NULL DEFAULT 0, 354 354 PRIMARY KEY (classcategory_id) … … 371 371 creator_id int NOT NULL, 372 372 create_date timestamp NOT NULL DEFAULT now(), 373 update_date timestamp ,373 update_date timestamp NOT NULL, 374 374 del_flg smallint NOT NULL DEFAULT 0, 375 375 PRIMARY KEY (category_id) … … 388 388 creator_id int NOT NULL, 389 389 create_date timestamp NOT NULL DEFAULT now(), 390 update_date timestamp ,390 update_date timestamp NOT NULL, 391 391 del_flg smallint NOT NULL DEFAULT 0, 392 392 PRIMARY KEY (product_status_id, product_id) … … 443 443 creator_id int NOT NULL, 444 444 create_date timestamp NOT NULL DEFAULT now(), 445 update_date timestamp NOT NULL DEFAULT now()445 update_date timestamp NOT NULL 446 446 ); 447 447 … … 459 459 creator_id int NOT NULL, 460 460 create_date timestamp NOT NULL DEFAULT now(), 461 update_date timestamp ,461 update_date timestamp NOT NULL, 462 462 del_flg smallint NOT NULL DEFAULT 0, 463 463 PRIMARY KEY (review_id) … … 468 468 product_id int NOT NULL, 469 469 create_date timestamp NOT NULL DEFAULT now(), 470 update_date timestamp NOT NULL DEFAULT now(),470 update_date timestamp NOT NULL, 471 471 PRIMARY KEY (customer_id, product_id) 472 472 ); … … 475 475 category_id int NOT NULL, 476 476 product_count int NOT NULL, 477 create_date timestamp NOT NULL DEFAULT Now()477 create_date timestamp NOT NULL DEFAULT now() 478 478 ); 479 479 … … 481 481 category_id int NOT NULL, 482 482 product_count int, 483 create_date timestamp NOT NULL DEFAULT Now()483 create_date timestamp NOT NULL DEFAULT now() 484 484 ); 485 485 … … 495 495 creator_id int NOT NULL, 496 496 create_date timestamp NOT NULL DEFAULT now(), 497 update_date timestamp ,497 update_date timestamp NOT NULL, 498 498 del_flg smallint NOT NULL DEFAULT 0, 499 499 PRIMARY KEY (news_id) … … 509 509 creator_id int NOT NULL, 510 510 create_date timestamp NOT NULL DEFAULT now(), 511 update_date timestamp ,511 update_date timestamp NOT NULL, 512 512 del_flg smallint NOT NULL DEFAULT 0, 513 513 PRIMARY KEY (best_id) … … 559 559 status smallint NOT NULL DEFAULT 1, 560 560 create_date timestamp NOT NULL DEFAULT now(), 561 update_date timestamp DEFAULT now(),561 update_date timestamp NOT NULL, 562 562 del_flg smallint NOT NULL DEFAULT 0, 563 563 mobile_phone_id text, … … 624 624 status smallint, 625 625 create_date timestamp NOT NULL DEFAULT now(), 626 update_date timestamp ,626 update_date timestamp NOT NULL, 627 627 commit_date timestamp, 628 628 payment_date timestamp, … … 703 703 point_check smallint, 704 704 create_date timestamp NOT NULL DEFAULT now(), 705 update_date timestamp ,705 update_date timestamp NOT NULL, 706 706 device_type_id int, 707 707 del_flg smallint NOT NULL DEFAULT 0, … … 763 763 del_flg smallint NOT NULL DEFAULT 0, 764 764 creator_id int NOT NULL, 765 update_date timestamp,766 create_date timestamp NOT NULL DEFAULT now(),765 create_date timestamp NOT NULL DEFAULT now(), 766 update_date timestamp NOT NULL, 767 767 login_date timestamp, 768 768 PRIMARY KEY (member_id) … … 773 773 relate_product_id int, 774 774 customer_id int, 775 create_date timestamp DEFAULT now()775 create_date timestamp NOT NULL DEFAULT now() 776 776 ); 777 777 … … 792 792 update_url text, 793 793 create_date timestamp NOT NULL DEFAULT now(), 794 update_date timestamp NOT NULL DEFAULT now(),794 update_date timestamp NOT NULL, 795 795 PRIMARY KEY (device_type_id, page_id) 796 796 ); … … 803 803 filename text NOT NULL, 804 804 create_date timestamp NOT NULL DEFAULT now(), 805 update_date timestamp NOT NULL DEFAULT now(),805 update_date timestamp NOT NULL, 806 806 php_path text, 807 807 deletable_flg smallint NOT NULL DEFAULT 1, … … 829 829 status smallint NOT NULL DEFAULT 1, 830 830 create_date timestamp NOT NULL DEFAULT now(), 831 update_date timestamp NOT NULL DEFAULT now(),831 update_date timestamp NOT NULL, 832 832 mb_convert_kana_option text, 833 833 size_const_type text, … … 840 840 sql_name text NOT NULL, 841 841 csv_sql text, 842 update_date timestamp NOT NULL DEFAULT now(),843 create_date timestamp NOT NULL DEFAULT now(),842 create_date timestamp NOT NULL DEFAULT now(), 843 update_date timestamp NOT NULL, 844 844 PRIMARY KEY (sql_id) 845 845 ); … … 849 849 template_name text, 850 850 create_date timestamp NOT NULL DEFAULT now(), 851 update_date timestamp NOT NULL DEFAULT now(),851 update_date timestamp NOT NULL, 852 852 PRIMARY KEY (template_code) 853 853 ); … … 875 875 maker_id int NOT NULL, 876 876 product_count int NOT NULL, 877 create_date timestamp NOT NULL DEFAULT Now()877 create_date timestamp NOT NULL DEFAULT now() 878 878 ); 879 879 … … 1198 1198 auto_update_flg smallint NOT NULL DEFAULT 0, 1199 1199 del_flg smallint NOT NULL DEFAULT 0, 1200 create_date timestamp NOT NULL DEFAULT NOW(),1200 create_date timestamp NOT NULL DEFAULT now(), 1201 1201 update_date timestamp NOT NULL 1202 1202 ); … … 1205 1205 sess_id text NOT NULL, 1206 1206 sess_data text, 1207 create_date timestamp NOT NULL ,1207 create_date timestamp NOT NULL DEFAULT now(), 1208 1208 update_date timestamp NOT NULL, 1209 1209 PRIMARY KEY (sess_id) … … 1218 1218 memo text, 1219 1219 create_date timestamp NOT NULL DEFAULT now(), 1220 update_date timestamp NOT NULL DEFAULT now(),1220 update_date timestamp NOT NULL, 1221 1221 PRIMARY KEY (control_id) 1222 1222 ); … … 1231 1231 status smallint NOT NULL DEFAULT 2, 1232 1232 del_flg smallint NOT NULL DEFAULT 0, 1233 create_date timestamp NOT NULL ,1233 create_date timestamp NOT NULL DEFAULT now(), 1234 1234 update_date timestamp NOT NULL, 1235 1235 PRIMARY KEY (trackback_id) … … 1239 1239 bkup_name text, 1240 1240 bkup_memo text, 1241 create_date timestamp ,1241 create_date timestamp NOT NULL DEFAULT now(), 1242 1242 PRIMARY KEY (bkup_name) 1243 1243 ); … … 1250 1250 class_name text NOT NULL, 1251 1251 create_date timestamp NOT NULL DEFAULT now(), 1252 update_date timestamp NOT NULL DEFAULT now(),1252 update_date timestamp NOT NULL, 1253 1253 PRIMARY KEY (plugin_id) 1254 1254 );
Note: See TracChangeset
for help on using the changeset viewer.