Changeset 17087


Ignore:
Timestamp:
2008/02/27 19:26:23 (14 years ago)
Author:
Yammy
Message:

定休日テーブル用のMySQLのSQL修正

Location:
branches/comu-ver2/html/install/sql
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • branches/comu-ver2/html/install/sql/create_table_mysql.sql

    r17073 r17087  
    2626 
    2727CREATE TABLE dtb_holiday ( 
    28     holiday_id auto_increment primary key NOT NULL, 
     28    holiday_id int auto_increment primary key NOT NULL, 
    2929    title text NOT NULL, 
    3030    month smallint NOT NULL, 
     
    3333    creator_id int NOT NULL, 
    3434    create_date datetime NOT NULL, 
    35     update_date datetimep NOT NULL, 
     35    update_date datetime NOT NULL, 
    3636    del_flg  smallint NOT NULL DEFAULT 0 
    3737) TYPE=InnoDB ; 
  • branches/comu-ver2/html/install/sql/drop_table.sql

    r16862 r17087  
    9292DROP TABLE mtb_ownersstore_err; 
    9393DROP TABLE mtb_ownersstore_ips; 
     94DROP TABLE dtb_holiday; 
Note: See TracChangeset for help on using the changeset viewer.