Index: branches/comu/html/install/sql/add/dtb_site_control_mysql.sql =================================================================== --- branches/comu/html/install/sql/add/dtb_site_control_mysql.sql (revision 11983) +++ branches/comu/html/install/sql/add/dtb_site_control_mysql.sql (revision 11983) @@ -0,0 +1,14 @@ +CREATE TABLE dtb_site_control ( + control_id int auto_increment NOT NULL, + control_title varchar(255) NOT NULL DEFAULT '', + control_text text NOT NULL DEFAULT '', + control_flg int NOT NULL DEFAULT 2, + del_flg int NOT NULL DEFAULT 0, + memo text NOT NULL DEFAULT '', + create_date datetime NOT NULL, + update_date datetime NOT NULL, + PRIMARY KEY (control_id) +) TYPE=InnoDB; + +INSERT INTO dtb_site_control (control_title, control_text, create_date, update_date) VALUES('¥È¥é¥Ã¥¯¥Ð¥Ã¥¯µ¡Ç½', '¥È¥é¥Ã¥¯¥Ð¥Ã¥¯µ¡Ç½¤ò»ÈÍѤ¹¤ë¤«¤É¤¦¤«¤ò·èÄꤷ¤Þ¤¹¡£', NOW(), NOW()); +INSERT INTO dtb_site_control (control_title, control_text, create_date, update_date) VALUES('¥¢¥Õ¥£¥ê¥¨¥¤¥Èµ¡Ç½', '¥¢¥Õ¥£¥ê¥¨¥¤¥Èµ¡Ç½¤ò»ÈÍѤ¹¤ë¤«¤É¤¦¤«¤ò·èÄꤷ¤Þ¤¹¡£', NOW(), NOW()); Index: branches/comu/html/install/sql/add/dtb_site_control_pgsql.sql =================================================================== --- branches/comu/html/install/sql/add/dtb_site_control_pgsql.sql (revision 11983) +++ branches/comu/html/install/sql/add/dtb_site_control_pgsql.sql (revision 11983) @@ -0,0 +1,13 @@ +CREATE TABLE dtb_site_control ( + control_id serial primary key NOT NULL, + control_title text NOT NULL DEFAULT '', + control_text text NOT NULL DEFAULT '', + control_flg int2 NOT NULL DEFAULT 2, + del_flg int2 NOT NULL DEFAULT 0, + memo text NOT NULL DEFAULT '', + create_date timestamp NOT NULL DEFAULT now(), + update_date timestamp NOT NULL DEFAULT now() +); + +INSERT INTO dtb_site_control (control_title, control_text) VALUES('¥È¥é¥Ã¥¯¥Ð¥Ã¥¯µ¡Ç½', '¥È¥é¥Ã¥¯¥Ð¥Ã¥¯µ¡Ç½¤ò»ÈÍѤ¹¤ë¤«¤É¤¦¤«¤ò·èÄꤷ¤Þ¤¹¡£'); +INSERT INTO dtb_site_control (control_title, control_text) VALUES('¥¢¥Õ¥£¥ê¥¨¥¤¥Èµ¡Ç½', '¥¢¥Õ¥£¥ê¥¨¥¤¥Èµ¡Ç½¤ò»ÈÍѤ¹¤ë¤«¤É¤¦¤«¤ò·èÄꤷ¤Þ¤¹¡£'); Index: branches/comu/html/install/sql/add/dtb_trackback_mysql.sql =================================================================== --- branches/comu/html/install/sql/add/dtb_trackback_mysql.sql (revision 11983) +++ branches/comu/html/install/sql/add/dtb_trackback_mysql.sql (revision 11983) @@ -0,0 +1,13 @@ +CREATE TABLE dtb_trackback ( + trackback_id int auto_increment NOT NULL, + product_id int NOT NULL, + blog_name varchar(255) NOT NULL DEFAULT '', + title varchar(255) NOT NULL DEFAULT '', + excerpt text NOT NULL DEFAULT '', + url text NOT NULL DEFAULT '', + status int NOT NULL DEFAULT 2, + del_flg int NOT NULL DEFAULT 0, + create_date datetime NOT NULL, + update_date datetime NOT NULL, + PRIMARY KEY (trackback_id) +) TYPE=InnoDB; Index: branches/comu/html/install/sql/add/dtb_mobile_ext_session_id_mysql.sql =================================================================== --- branches/comu/html/install/sql/add/dtb_mobile_ext_session_id_mysql.sql (revision 11983) +++ branches/comu/html/install/sql/add/dtb_mobile_ext_session_id_mysql.sql (revision 11983) @@ -0,0 +1,19 @@ +CREATE TABLE dtb_mobile_ext_session_id ( + session_id text NOT NULL, + param_key text, + param_value text, + url text, + create_date timestamp NOT NULL DEFAULT now() +); + +CREATE INDEX dtb_mobile_ext_session_id_param_key_key ON dtb_mobile_ext_session_id (param_key(64)); +CREATE INDEX dtb_mobile_ext_session_id_param_value_key ON dtb_mobile_ext_session_id (param_value(64)); +CREATE INDEX dtb_mobile_ext_session_id_url_key ON dtb_mobile_ext_session_id (url(64)); +CREATE INDEX dtb_mobile_ext_session_id_create_date_key ON dtb_mobile_ext_session_id (create_date); + +INSERT INTO dtb_table_comment (table_name, description) VALUES ('dtb_mobile_ext_session_id', '¥»¥Ã¥·¥ç¥óID´ÉÍý'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'session_id', '¥»¥Ã¥·¥ç¥óID'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'param_key', '¥Ñ¥é¥á¡¼¥¿Ì¾'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'param_value', '¥Ñ¥é¥á¡¼¥¿ÃÍ'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'url', 'URL'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'create_date', 'ºîÀ®Æü»þ'); Index: branches/comu/html/install/sql/add/dtb_trackback_pgsql.sql =================================================================== --- branches/comu/html/install/sql/add/dtb_trackback_pgsql.sql (revision 11983) +++ branches/comu/html/install/sql/add/dtb_trackback_pgsql.sql (revision 11983) @@ -0,0 +1,12 @@ +CREATE TABLE dtb_trackback ( + trackback_id serial primary key NOT NULL, + product_id int NOT NULL, + blog_name varchar(255) NOT NULL DEFAULT '', + title varchar(255) NOT NULL DEFAULT '', + excerpt text NOT NULL DEFAULT '', + url text NOT NULL DEFAULT '', + status int2 NOT NULL DEFAULT 2, + del_flg int2 NOT NULL DEFAULT 0, + create_date timestamp NOT NULL, + update_date timestamp NOT NULL +); Index: branches/comu/html/install/sql/add/dtb_mobile_ext_session_id_pgsql.sql =================================================================== --- branches/comu/html/install/sql/add/dtb_mobile_ext_session_id_pgsql.sql (revision 11983) +++ branches/comu/html/install/sql/add/dtb_mobile_ext_session_id_pgsql.sql (revision 11983) @@ -0,0 +1,19 @@ +CREATE TABLE dtb_mobile_ext_session_id ( + session_id text NOT NULL, + param_key text, + param_value text, + url text, + create_date timestamp NOT NULL DEFAULT now() +); + +CREATE INDEX dtb_mobile_ext_session_id_param_key_key ON dtb_mobile_ext_session_id (param_key); +CREATE INDEX dtb_mobile_ext_session_id_param_value_key ON dtb_mobile_ext_session_id (param_value); +CREATE INDEX dtb_mobile_ext_session_id_url_key ON dtb_mobile_ext_session_id (url); +CREATE INDEX dtb_mobile_ext_session_id_create_date_key ON dtb_mobile_ext_session_id (create_date); + +INSERT INTO dtb_table_comment (table_name, description) VALUES ('dtb_mobile_ext_session_id', '¥»¥Ã¥·¥ç¥óID´ÉÍý'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'session_id', '¥»¥Ã¥·¥ç¥óID'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'param_key', '¥Ñ¥é¥á¡¼¥¿Ì¾'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'param_value', '¥Ñ¥é¥á¡¼¥¿ÃÍ'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'url', 'URL'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'create_date', 'ºîÀ®Æü»þ'); Index: branches/comu/html/install/sql/add/dtb_mobile_kara_mail_mysql.sql =================================================================== --- branches/comu/html/install/sql/add/dtb_mobile_kara_mail_mysql.sql (revision 11983) +++ branches/comu/html/install/sql/add/dtb_mobile_kara_mail_mysql.sql (revision 11983) @@ -0,0 +1,22 @@ +CREATE TABLE dtb_mobile_kara_mail ( + kara_mail_id serial PRIMARY KEY, + session_id text NOT NULL, + token text NOT NULL, + next_url text NOT NULL, + create_date timestamp NOT NULL DEFAULT now(), + email text, + receive_date timestamp +); + +CREATE INDEX dtb_mobile_kara_mail_token_key ON dtb_mobile_kara_mail (token(64)); +CREATE INDEX dtb_mobile_kara_mail_create_date_key ON dtb_mobile_kara_mail (create_date); +CREATE INDEX dtb_mobile_kara_mail_receive_date_key ON dtb_mobile_kara_mail (receive_date); + +INSERT INTO dtb_table_comment (table_name, description) VALUES ('dtb_mobile_kara_mail', '¶õ¥á¡¼¥ë´ÉÍý'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'kara_mail_id', '¶õ¥á¡¼¥ë´ÉÍýID'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'session_id', '¥»¥Ã¥·¥ç¥óID'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'token', '¥È¡¼¥¯¥ó'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'next_url', '¼¡¥Ú¡¼¥¸URL'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'create_date', 'ºîÀ®Æü»þ'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'email', '¥á¡¼¥ë¥¢¥É¥ì¥¹'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'receive_date', '¼õ¿®Æü»þ'); Index: branches/comu/html/install/sql/add/dtb_mobile_kara_mail_pgsql.sql =================================================================== --- branches/comu/html/install/sql/add/dtb_mobile_kara_mail_pgsql.sql (revision 11983) +++ branches/comu/html/install/sql/add/dtb_mobile_kara_mail_pgsql.sql (revision 11983) @@ -0,0 +1,22 @@ +CREATE TABLE dtb_mobile_kara_mail ( + kara_mail_id serial PRIMARY KEY, + session_id text NOT NULL, + token text NOT NULL, + next_url text NOT NULL, + create_date timestamp NOT NULL DEFAULT now(), + email text, + receive_date timestamp +); + +CREATE INDEX dtb_mobile_kara_mail_token_key ON dtb_mobile_kara_mail (token); +CREATE INDEX dtb_mobile_kara_mail_create_date_key ON dtb_mobile_kara_mail (create_date); +CREATE INDEX dtb_mobile_kara_mail_receive_date_key ON dtb_mobile_kara_mail (receive_date); + +INSERT INTO dtb_table_comment (table_name, description) VALUES ('dtb_mobile_kara_mail', '¶õ¥á¡¼¥ë´ÉÍý'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'kara_mail_id', '¶õ¥á¡¼¥ë´ÉÍýID'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'session_id', '¥»¥Ã¥·¥ç¥óID'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'token', '¥È¡¼¥¯¥ó'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'next_url', '¼¡¥Ú¡¼¥¸URL'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'create_date', 'ºîÀ®Æü»þ'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'email', '¥á¡¼¥ë¥¢¥É¥ì¥¹'); +INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'receive_date', '¼õ¿®Æü»þ'); Index: branches/comu/html/install/sql/insert_data.sql =================================================================== --- branches/comu/html/install/sql/insert_data.sql (revision 11730) +++ branches/comu/html/install/sql/insert_data.sql (revision 11983) @@ -23,25 +23,25 @@ update dtb_pagelayout set page_id = 0 where page_id = 5; -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'category'),2,'category'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'guide'),3,'guide'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'cart'),1,'cart'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,3,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'search_products'),2,'search_products'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,4,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'news'),1,'news'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,3,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'login'),1,'login'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,4,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'best5'),2,'best5'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'category'),2,'category'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'guide'),3,'guide'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'cart'),1,'cart'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'search_products'),0,'search_products'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'news'),0,'news'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'login'),0,'login'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'best5'),0,'best5'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'category'),2,'category'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'guide'),3,'guide'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'cart'),1,'cart'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'search_products'),0,'search_products'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'news'),0,'news'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'login'),0,'login'); -INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'best5'),0,'best5'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,1,2,'category'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,2,3,'guide'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,3,1,'cart'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,3,4,2,'search_products'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,4,5,1,'news'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,3,6,1,'login'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,4,7,2,'best5'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,1,2,'category'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,2,3,'guide'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,3,1,'cart'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,4,0,'search_products'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,5,0,'news'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,6,0,'login'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,7,0,'best5'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,1,2,'category'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,2,3,'guide'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,3,1,'cart'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,4,0,'search_products'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,5,0,'news'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,6,0,'login'); +INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,7,0,'best5'); insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'product_id','¾¦ÉÊID',1,now(),now()); @@ -53,6 +53,6 @@ insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'product_flag','¾¦ÉÊ¥¹¥Æ¡¼¥¿¥¹',7,now(),now()); insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'product_code','¾¦ÉÊ¥³¡¼¥É',8,now(),now()); -insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'price01','»²¹Í»Ô¾ì²Á³Ê',9,now(),now()); -insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'price02','²Á³Ê',10,now(),now()); +insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'price01','Ä̾ï²Á³Ê',9,now(),now()); +insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'price02','ÈÎÇä²Á³Ê',10,now(),now()); insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'stock','ºß¸Ë¿ô',11,now(),now()); insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'deliv_fee','Á÷ÎÁ',12,now(),now()); @@ -364,5 +364,5 @@ INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) -VALUES ('Â裱¾ò¡Ê²ñ°÷¡Ë','1. ¡Ö²ñ°÷¡×¤È¤Ï¡¢Åö¼Ò¤¬Äê¤á¤ë¼ê³¤Ë½¾¤¤Ëܵ¬Ìó¤ËƱ°Õ¤Î¾å¡¢Æþ²ñ¤Î¿½¤·¹þ¤ß¤ò¹Ô¤¦¸Ä¿Í¤ò¤¤¤¤¤Þ¤¹¡£ +VALUES ('Âè1¾ò¡Ê²ñ°÷¡Ë','1. ¡Ö²ñ°÷¡×¤È¤Ï¡¢Åö¼Ò¤¬Äê¤á¤ë¼ê³¤Ë½¾¤¤Ëܵ¬Ìó¤ËƱ°Õ¤Î¾å¡¢Æþ²ñ¤Î¿½¤·¹þ¤ß¤ò¹Ô¤¦¸Ä¿Í¤ò¤¤¤¤¤Þ¤¹¡£ 2. ¡Ö²ñ°÷¾ðÊó¡×¤È¤Ï¡¢²ñ°÷¤¬Åö¼Ò¤Ë³«¼¨¤·¤¿²ñ°÷¤Î°À­¤Ë´Ø¤¹¤ë¾ðÊ󤪤è¤Ó²ñ°÷¤Î¼è°ú¤Ë´Ø¤¹¤ëÍúÎòÅù¤Î¾ðÊó¤ò¤¤¤¤¤Þ¤¹¡£ 3. Ëܵ¬Ìó¤Ï¡¢¤¹¤Ù¤Æ¤Î²ñ°÷¤ËŬÍѤµ¤ì¡¢ÅÐÏ¿¼ê³»þ¤ª¤è¤ÓÅÐÏ¿¸å¤Ë¤ª¼é¤ê¤¤¤¿¤À¤¯µ¬Ìó¤Ç¤¹¡£', @@ -370,5 +370,5 @@ INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) -VALUES ('Â裲¾ò¡ÊÅÐÏ¿¡Ë','1. ²ñ°÷»ñ³Ê +VALUES ('Âè2¾ò¡ÊÅÐÏ¿¡Ë','1. ²ñ°÷»ñ³Ê Ëܵ¬Ìó¤ËƱ°Õ¤Î¾å¡¢½êÄê¤ÎÆþ²ñ¿½¹þ¤ß¤ò¤µ¤ì¤¿¤ªµÒÍͤϡ¢½êÄê¤ÎÅÐÏ¿¼ê³´°Î»¸å¤Ë²ñ°÷¤È¤·¤Æ¤Î»ñ³Ê¤òÍ­¤·¤Þ¤¹¡£²ñ°÷ÅÐÏ¿¼ê³¤Ï¡¢²ñ°÷¤È¤Ê¤ë¤´Ëܿͤ¬¹Ô¤Ã¤Æ¤¯¤À¤µ¤¤¡£ÂåÍý¤Ë¤è¤ëÅÐÏ¿¤Ï°ìÀÚǧ¤á¤é¤ì¤Þ¤»¤ó¡£¤Ê¤ª¡¢²áµî¤Ë²ñ°÷»ñ³Ê¤¬¼è¤ê¾Ã¤µ¤ì¤¿Êý¤ä¤½¤Î¾Åö¼Ò¤¬Áê±þ¤·¤¯¤Ê¤¤¤ÈȽÃǤ·¤¿Êý¤«¤é¤Î²ñ°÷¿½¹þ¤Ï¤ªÃǤꤹ¤ë¾ì¹ç¤¬¤¢¤ê¤Þ¤¹¡£ @@ -383,14 +383,14 @@ INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) -VALUES ('Â裳¾ò¡ÊÊѹ¹¡Ë','1. ²ñ°÷¤Ï¡¢»á̾¡¢½»½ê¤Ê¤ÉÅö¼Ò¤ËÆϤ±½Ð¤¿»ö¹à¤ËÊѹ¹¤¬¤¢¤Ã¤¿¾ì¹ç¤Ë¤Ï¡¢Â®¤ä¤«¤ËÅö¼Ò¤ËÏ¢Íí¤¹¤ë¤â¤Î¤È¤·¤Þ¤¹¡£ +VALUES ('Âè3¾ò¡ÊÊѹ¹¡Ë','1. ²ñ°÷¤Ï¡¢»á̾¡¢½»½ê¤Ê¤ÉÅö¼Ò¤ËÆϤ±½Ð¤¿»ö¹à¤ËÊѹ¹¤¬¤¢¤Ã¤¿¾ì¹ç¤Ë¤Ï¡¢Â®¤ä¤«¤ËÅö¼Ò¤ËÏ¢Íí¤¹¤ë¤â¤Î¤È¤·¤Þ¤¹¡£ 2. Êѹ¹ÅÐÏ¿¤¬¤Ê¤µ¤ì¤Ê¤«¤Ã¤¿¤³¤È¤Ë¤è¤êÀ¸¤¸¤¿Â»³²¤Ë¤Ä¤¤¤Æ¡¢Åö¼Ò¤Ï°ìÀÚÀÕǤ¤òÉ餤¤Þ¤»¤ó¡£¤Þ¤¿¡¢Êѹ¹ÅÐÏ¿¤¬¤Ê¤µ¤ì¤¿¾ì¹ç¤Ç¤â¡¢Êѹ¹ÅÐÏ¿Á°¤Ë¤¹¤Ç¤Ë¼ê³¤¬¤Ê¤µ¤ì¤¿¼è°ú¤Ï¡¢Êѹ¹ÅÐÏ¿Á°¤Î¾ðÊó¤Ë´ð¤Å¤¤¤Æ¹Ô¤ï¤ì¤Þ¤¹¤Î¤Ç¤´Ãí°Õ¤¯¤À¤µ¤¤¡£', 10,0,Now(),0, now()); INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) -VALUES ('Â裴¾ò¡ÊÂà²ñ¡Ë','²ñ°÷¤¬Âà²ñ¤ò´õ˾¤¹¤ë¾ì¹ç¤Ë¤Ï¡¢²ñ°÷Ëܿͤ¬Âà²ñ¼ê³¤­¤ò¹Ô¤Ã¤Æ¤¯¤À¤µ¤¤¡£½êÄê¤ÎÂà²ñ¼ê³¤Î½ªÎ»¸å¤Ë¡¢Âà²ñ¤È¤Ê¤ê¤Þ¤¹¡£', +VALUES ('Âè4¾ò¡ÊÂà²ñ¡Ë','²ñ°÷¤¬Âà²ñ¤ò´õ˾¤¹¤ë¾ì¹ç¤Ë¤Ï¡¢²ñ°÷Ëܿͤ¬Âà²ñ¼ê³¤­¤ò¹Ô¤Ã¤Æ¤¯¤À¤µ¤¤¡£½êÄê¤ÎÂà²ñ¼ê³¤Î½ªÎ»¸å¤Ë¡¢Âà²ñ¤È¤Ê¤ê¤Þ¤¹¡£', 9,0,Now(),0, now()); INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) -VALUES ('Â裵¾ò¡Ê²ñ°÷»ñ³Ê¤ÎÁÓ¼ºµÚ¤ÓÇå½þµÁ̳¡Ë','1. ²ñ°÷¤¬¡¢²ñ°÷»ñ³Ê¼èÆÀ¿½¹þ¤ÎºÝ¤Ëµõµ¶¤Î¿½¹ð¤ò¤·¤¿¤È¤­¡¢ÄÌ¿®ÈÎÇä¤Ë¤è¤ëÂå¶â»ÙʧºÄ̳¤òÂդ俤Ȥ­¡¢¤½¤Î¾Åö¼Ò¤¬²ñ°÷¤È¤·¤ÆÉÔŬÅö¤Èǧ¤á¤ë»öͳ¤¬¤¢¤ë¤È¤­¤Ï¡¢Åö¼Ò¤Ï¡¢²ñ°÷»ñ³Ê¤ò¼è¤ê¾Ã¤¹¤³¤È¤¬¤Ç¤­¤ë¤³¤È¤È¤·¤Þ¤¹¡£ +VALUES ('Âè5¾ò¡Ê²ñ°÷»ñ³Ê¤ÎÁÓ¼ºµÚ¤ÓÇå½þµÁ̳¡Ë','1. ²ñ°÷¤¬¡¢²ñ°÷»ñ³Ê¼èÆÀ¿½¹þ¤ÎºÝ¤Ëµõµ¶¤Î¿½¹ð¤ò¤·¤¿¤È¤­¡¢ÄÌ¿®ÈÎÇä¤Ë¤è¤ëÂå¶â»ÙʧºÄ̳¤òÂդ俤Ȥ­¡¢¤½¤Î¾Åö¼Ò¤¬²ñ°÷¤È¤·¤ÆÉÔŬÅö¤Èǧ¤á¤ë»öͳ¤¬¤¢¤ë¤È¤­¤Ï¡¢Åö¼Ò¤Ï¡¢²ñ°÷»ñ³Ê¤ò¼è¤ê¾Ã¤¹¤³¤È¤¬¤Ç¤­¤ë¤³¤È¤È¤·¤Þ¤¹¡£ 2. ²ñ°÷¤¬¡¢°Ê²¼¤Î³Æ¹æ¤ËÄê¤á¤ë¹Ô°Ù¤ò¤·¤¿¤È¤­¤Ï¡¢¤³¤ì¤Ë¤è¤êÅö¼Ò¤¬Èï¤Ã¤¿Â»³²¤òÇå½þ¤¹¤ëÀÕǤ¤òÉ餤¤Þ¤¹¡£ (1)²ñ°÷Èֹ桢¥Ñ¥¹¥ï¡¼¥É¤òÉÔÀµ¤ËÍøÍѤ¹¤ë¤³¤È @@ -401,5 +401,5 @@ INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) -VALUES ('Â裶¾ò¡Ê²ñ°÷¾ðÊó¤Î¼è°·¤¤¡Ë','1. Åö¼Ò¤Ï¡¢¸¶Â§¤È¤·¤Æ²ñ°÷¾ðÊó¤ò²ñ°÷¤Î»öÁ°¤ÎƱ°Õ¤Ê¤¯Âè»°¼Ô¤ËÂФ·¤Æ³«¼¨¤¹¤ë¤³¤È¤Ï¤¢¤ê¤Þ¤»¤ó¡£¤¿¤À¤·¡¢¼¡¤Î³Æ¹æ¤Î¾ì¹ç¤Ë¤Ï¡¢²ñ°÷¤Î»öÁ°¤ÎƱ°Õ¤Ê¤¯¡¢Åö¼Ò¤Ï²ñ°÷¾ðÊ󤽤ξ¤Î¤ªµÒÍ;ðÊó¤ò³«¼¨¤Ç¤­¤ë¤â¤Î¤È¤·¤Þ¤¹¡£ +VALUES ('Âè6¾ò¡Ê²ñ°÷¾ðÊó¤Î¼è°·¤¤¡Ë','1. Åö¼Ò¤Ï¡¢¸¶Â§¤È¤·¤Æ²ñ°÷¾ðÊó¤ò²ñ°÷¤Î»öÁ°¤ÎƱ°Õ¤Ê¤¯Âè»°¼Ô¤ËÂФ·¤Æ³«¼¨¤¹¤ë¤³¤È¤Ï¤¢¤ê¤Þ¤»¤ó¡£¤¿¤À¤·¡¢¼¡¤Î³Æ¹æ¤Î¾ì¹ç¤Ë¤Ï¡¢²ñ°÷¤Î»öÁ°¤ÎƱ°Õ¤Ê¤¯¡¢Åö¼Ò¤Ï²ñ°÷¾ðÊ󤽤ξ¤Î¤ªµÒÍ;ðÊó¤ò³«¼¨¤Ç¤­¤ë¤â¤Î¤È¤·¤Þ¤¹¡£ (1)Ë¡Îá¤Ë´ð¤Å¤­³«¼¨¤òµá¤á¤é¤ì¤¿¾ì¹ç (2)Åö¼Ò¤Î¸¢Íø¡¢Íø±×¡¢Ì¾ÍÀÅù¤òÊݸ¤ë¤¿¤á¤ËɬÍפǤ¢¤ë¤ÈÅö¼Ò¤¬È½ÃǤ·¤¿¾ì¹ç @@ -409,5 +409,5 @@ INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) -VALUES ('Â裷¾ò¡Ê¶Ø»ß»ö¹à¡Ë','ËÜ¥µ¡¼¥Ó¥¹¤ÎÍøÍѤ˺ݤ·¤Æ¡¢²ñ°÷¤ËÂФ·¼¡¤Î³Æ¹æ¤Î¹Ô°Ù¤ò¹Ô¤¦¤³¤È¤ò¶Ø»ß¤·¤Þ¤¹¡£ +VALUES ('Âè7¾ò¡Ê¶Ø»ß»ö¹à¡Ë','ËÜ¥µ¡¼¥Ó¥¹¤ÎÍøÍѤ˺ݤ·¤Æ¡¢²ñ°÷¤ËÂФ·¼¡¤Î³Æ¹æ¤Î¹Ô°Ù¤ò¹Ô¤¦¤³¤È¤ò¶Ø»ß¤·¤Þ¤¹¡£ 1. Ë¡Îá¤Þ¤¿¤ÏËܵ¬Ìó¡¢ËÜ¥µ¡¼¥Ó¥¹¤´ÍøÍѾå¤Î¤´Ãí°Õ¡¢ËÜ¥µ¡¼¥Ó¥¹¤Ç¤Î¤ªÇ㤤ʪ¾å¤Î¤´Ãí°Õ¤½¤Î¾¤ÎËܵ¬ÌóÅù¤Ë°ãÈ¿¤¹¤ë¤³¤È @@ -423,5 +423,5 @@ INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) -VALUES ('Â裸¾ò¡Ê¥µ¡¼¥Ó¥¹¤ÎÃæÃÇ¡¦Ää»ßÅù¡Ë','1. Åö¼Ò¤Ï¡¢ËÜ¥µ¡¼¥Ó¥¹¤Î²ÔÆ°¾õÂÖ¤òÎɹ¥¤ËÊݤĤ¿¤á¤Ë¡¢¼¡¤Î³Æ¹æ¤Î°ì¤Ë³ºÅö¤¹¤ë¾ì¹ç¡¢Í½¹ð¤Ê¤·¤Ë¡¢ËÜ¥µ¡¼¥Ó¥¹¤ÎÄó¶¡Á´¤Æ¤¢¤ë¤¤¤Ï°ìÉô¤òÄä»ß¤¹¤ë¤³¤È¤¬¤¢¤ê¤Þ¤¹¡£ +VALUES ('Âè8¾ò¡Ê¥µ¡¼¥Ó¥¹¤ÎÃæÃÇ¡¦Ää»ßÅù¡Ë','1. Åö¼Ò¤Ï¡¢ËÜ¥µ¡¼¥Ó¥¹¤Î²ÔÆ°¾õÂÖ¤òÎɹ¥¤ËÊݤĤ¿¤á¤Ë¡¢¼¡¤Î³Æ¹æ¤Î°ì¤Ë³ºÅö¤¹¤ë¾ì¹ç¡¢Í½¹ð¤Ê¤·¤Ë¡¢ËÜ¥µ¡¼¥Ó¥¹¤ÎÄó¶¡Á´¤Æ¤¢¤ë¤¤¤Ï°ìÉô¤òÄä»ß¤¹¤ë¤³¤È¤¬¤¢¤ê¤Þ¤¹¡£ (1)¥·¥¹¥Æ¥à¤ÎÄê´üÊݼ餪¤è¤Ó¶ÛµÞÊݼé¤Î¤¿¤á¤ËɬÍפʾì¹ç (2)¥·¥¹¥Æ¥à¤ËÉé²Ù¤¬½¸Ã椷¤¿¾ì¹ç @@ -431,5 +431,5 @@ INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) -VALUES ('Â裹¾ò¡Ê¥µ¡¼¥Ó¥¹¤ÎÊѹ¹¡¦ÇѻߡË','Åö¼Ò¤Ï¡¢¤½¤ÎȽÃǤˤè¤ê¥µ¡¼¥Ó¥¹¤ÎÁ´Éô¤Þ¤¿¤Ï°ìÉô¤ò»öÁ°¤ÎÄÌÃΤʤ¯¡¢Å¬µ¹Êѹ¹¡¦ÇѻߤǤ­¤ë¤â¤Î¤È¤·¤Þ¤¹¡£', +VALUES ('Âè9¾ò¡Ê¥µ¡¼¥Ó¥¹¤ÎÊѹ¹¡¦ÇѻߡË','Åö¼Ò¤Ï¡¢¤½¤ÎȽÃǤˤè¤ê¥µ¡¼¥Ó¥¹¤ÎÁ´Éô¤Þ¤¿¤Ï°ìÉô¤ò»öÁ°¤ÎÄÌÃΤʤ¯¡¢Å¬µ¹Êѹ¹¡¦ÇѻߤǤ­¤ë¤â¤Î¤È¤·¤Þ¤¹¡£', 4,0,Now(),0, now()); Index: branches/comu/html/install/sql/column_comment.sql =================================================================== --- branches/comu/html/install/sql/column_comment.sql (revision 11730) +++ branches/comu/html/install/sql/column_comment.sql (revision 11983) @@ -368,6 +368,8 @@ INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','cell02','·ÈÂÓÅÅÏÃÈÖ¹æ2'); INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','cell03','·ÈÂÓÅÅÏÃÈÖ¹æ3'); +INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','mobile_phone_id','·ÈÂÓüËöID'); INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail','email','¥á¡¼¥ë¥¢¥É¥ì¥¹'); INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail','mail_flag','1:HTML 2:TEXT 3:´õ˾¤·¤Ê¤¤ 4:²¾ÅÐÏ¿¡ÊHTML¡Ë 5:²¾ÅÐÏ¿(TEXT) 6:²¾ÅÐÏ¿(´õ˾¤·¤Ê¤¤)'); +INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail','secret_key','°Å¹æ²½¸ÜµÒID'); INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','email','¥á¡¼¥ë¥¢¥É¥ì¥¹'); INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','mail_flag','1:HTML 2:TEXT 3:´õ˾¤·¤Ê¤¤(Ää»ß)'); Index: branches/comu/html/install/sql/create_table_mysql.sql =================================================================== --- branches/comu/html/install/sql/create_table_mysql.sql (revision 5) +++ branches/comu/html/install/sql/create_table_mysql.sql (revision 11983) @@ -159,7 +159,7 @@ payment_image text, upper_rule numeric, - charge_flg int2 DEFAULT 1, - rule_min numeric, - upper_rule_max numeric, + charge_flg int2 DEFAULT 1, + rule_min numeric, + upper_rule_max numeric, module_id int4, module_path text, @@ -517,13 +517,10 @@ cell01 text, cell02 text, - cell03 text -) TYPE=InnoDB ; - -CREATE TABLE dtb_customer_mail ( - email varchar(50) NOT NULL UNIQUE, - mail_flag smallint, - create_date datetime NOT NULL , - update_date datetime -) TYPE=InnoDB ; + cell03 text, + mobile_phone_id text, + mailmaga_flg smallint +) TYPE=InnoDB ; + +CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64)); CREATE TABLE dtb_customer_mail_temp ( @@ -688,5 +685,5 @@ cell02 text, cell03 text, - order_id int4, + order_id int4, memo01 text, memo02 text, @@ -898,15 +895,16 @@ CREATE TABLE dtb_templates ( - template_code varchar(50) NOT NULL UNIQUE , - template_name text , - create_date datetime NOT NULL , - update_date datetime NOT NULL + template_code varchar(50) NOT NULL UNIQUE , + template_name text , + create_date datetime NOT NULL , + update_date datetime NOT NULL ) TYPE=InnoDB ; CREATE TABLE dtb_table_comment ( - id int auto_increment primary key, - table_name text, - column_name text, - description text -) TYPE=InnoDB ; + id int auto_increment primary key, + table_name text, + column_name text, + description text +) TYPE=InnoDB ; + Index: branches/comu/html/install/sql/create_table_pgsql.sql =================================================================== --- branches/comu/html/install/sql/create_table_pgsql.sql (revision 5) +++ branches/comu/html/install/sql/create_table_pgsql.sql (revision 11983) @@ -159,7 +159,7 @@ payment_image text, upper_rule numeric, - charge_flg int2 DEFAULT 1, - rule_min numeric, - upper_rule_max numeric, + charge_flg int2 DEFAULT 1, + rule_min numeric, + upper_rule_max numeric, module_id int4, module_path text, @@ -517,13 +517,10 @@ cell01 text, cell02 text, - cell03 text -); - -CREATE TABLE dtb_customer_mail ( - email text NOT NULL UNIQUE, - mail_flag int2, - create_date timestamp NOT NULL DEFAULT now(), - update_date timestamp DEFAULT now() -); + cell03 text, + mobile_phone_id text, + mailmaga_flg int2 +); + +CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id); CREATE TABLE dtb_customer_mail_temp ( @@ -898,15 +895,16 @@ create table dtb_templates ( -template_code text NOT NULL UNIQUE , -template_name text , -create_date timestamp NOT NULL default now(), -update_date timestamp NOT NULL default now() +template_code text NOT NULL UNIQUE , +template_name text , +create_date timestamp NOT NULL default now(), +update_date timestamp NOT NULL default now() ); create table dtb_table_comment ( -id serial, -table_name text, -column_name text, -description text -); +id serial, +table_name text, +column_name text, +description text +); +