Changeset 14614 for branches/dev/html

Timestamp:

2007/06/14 10:06:17 (19 years ago)

Author:

adati

Message:

dtb_mailtemplateにbodyカラムを追加

Location:

branches/dev/html/install/sql

Files:

• column_comment.sql (modified) (1 diff)
• create_table_mysql.sql (modified) (1 diff)
• create_table_pgsql.sql (modified) (1 diff)

branches/dev/html/install/sql/column_comment.sql

@@ -90 +90 @@
 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','header','¥Ø¥Ã¥À¡¼Ê¸½ñ');
 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','footer','¥Õ¥Ã¥¿¡¼Ê¸½ñ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','body','ËÜʸʸ½ñ');
 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','creator_id','ºîÀ®¤·¤¿´ÉÍý¼ÔID');
 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','del_flg','0:´ûÄê¡¢1:ºï½ü');

branches/dev/html/install/sql/create_table_mysql.sql

@@ -181 +181 @@
     header text,
     footer text,
+    body   text,
     creator_id int NOT NULL,
     del_flg smallint NOT NULL DEFAULT 0,

branches/dev/html/install/sql/create_table_pgsql.sql

@@ -181 +181 @@
     header text,
     footer text,
+    body   text,
     creator_id int4 NOT NULL,
     del_flg int2 NOT NULL DEFAULT 0,