Changeset 14653

Timestamp:

2007/06/14 14:57:20 (17 years ago)

Author:

adati

Message:

 

File:

• branches/dev/html/install/sql/insert_data.sql (modified) (2 diffs)

branches/dev/html/install/sql/insert_data.sql

@@ -220 +220 @@
 INSERT INTO dtb_templates (template_code, template_name, create_date, update_date) VALUES('default1','¥Ç¥Õ¥©¥ë¥È1', now(), now());
 
-insert into dtb_mailtemplate (template_id, subject, header, footer, creator_id, update_date, create_date) values (
-1,
+insert into dtb_mailtemplate (template_id, subject, body, creator_id, update_date, create_date, send_type, template_name) values (
+0,
 '¤´Ãíʸ¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£',
-'¤³¤ÎÅ٤Ϥ´Ãíʸ¤¤¤¿¤À¤­À¿¤ËÍ­Æñ¤¦¤´¤¶¤¤¤Þ¤¹¡£
+'{name}ÍÍ
+
+¤³¤ÎÅ٤Ϥ´Ãíʸ¤¤¤¿¤À¤­À¿¤ËÍ­Æñ¤¦¤´¤¶¤¤¤Þ¤¹¡£
 ²¼µ­¤´ÃíʸÆâÍƤˤª´Ö°ã¤¨¤¬¤Ê¤¤¤«¤´³Îǧ²¼¤µ¤¤¡£
 
-',
-'
-
-==============================================================¡ù
-
+{order}
 
 ¤³¤Î¥á¥Ã¥»¡¼¥¸¤Ï¤ªµÒÍͤؤΤªÃΤ餻ÀìÍѤǤ¹¤Î¤Ç¡¢
@@ -236 +234 @@
 ¤´Î»¾µ¤¯¤À¤µ¤¤¡£
 
-¤´¼ÁÌä¤ä¤´ÉÔÌÀ¤ÊÅÀ¤¬¤´¤¶¤¤¤Þ¤·¤¿¤é¡¢¤³¤Á¤é¤«¤é¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£
-http://------.co.jp
-
-',0,Now(), now());
+¤´¼ÁÌä¤ä¤´ÉÔÌÀ¤ÊÅÀ¤¬¤´¤¶¤¤¤Þ¤·¤¿¤é¡¢¤³¤Á¤é¤«¤é¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£',
+0,
+Now(),
+Now(),
+0,
+'¼õÃí´°Î»¥Æ¥ó¥×¥ì¡¼¥È(PCÍÑ)');
+
+1,
+'¤´Ãíʸ¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£',
+'{name}ÍÍ
+
+¤³¤ÎÅ٤Ϥ´Ãíʸ¤¤¤¿¤À¤­À¿¤ËÍ­Æñ¤¦¤´¤¶¤¤¤Þ¤¹¡£
+²¼µ­¤´ÃíʸÆâÍƤˤª´Ö°ã¤¨¤¬¤Ê¤¤¤«¤´³Îǧ²¼¤µ¤¤¡£
+
+{order}
+
+¤³¤Î¥á¥Ã¥»¡¼¥¸¤Ï¤ªµÒÍͤؤΤªÃΤ餻ÀìÍѤǤ¹¤Î¤Ç¡¢
+¤³¤Î¥á¥Ã¥»¡¼¥¸¤Ø¤ÎÊÖ¿®¤È¤·¤Æ¤´¼ÁÌä¤ò¤ªÁ÷¤ê¤¤¤¿¤À¤¤¤Æ¤â²óÅú¤Ç¤­¤Þ¤»¤ó¡£
+¤´Î»¾µ¤¯¤À¤µ¤¤¡£
+
+¤´¼ÁÌä¤ä¤´ÉÔÌÀ¤ÊÅÀ¤¬¤´¤¶¤¤¤Þ¤·¤¿¤é¡¢¤³¤Á¤é¤«¤é¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£',
+0,
+Now(),
+Now(),
+1,
+'¼õÃí´°Î»¥Æ¥ó¥×¥ì¡¼¥È(·ÈÂÓÍÑ)');
 
 insert into dtb_news (news_date,rank, news_title, news_comment, creator_id, create_date, update_date)