Changeset 16802
- Timestamp:
- 2007/11/22 14:44:40 (16 years ago)
- Location:
- branches/beta/html/install/sql
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/beta/html/install/sql/create_table_pgsql.sql
r15120 r16802 177 177 178 178 CREATE TABLE dtb_mailtemplate ( 179 template_id SERIAL NOT NULL ,179 template_id SERIAL NOT NULL UNIQUE, 180 180 subject text, 181 181 header text, -
branches/beta/html/install/sql/insert_data.sql
r16350 r16802 224 224 INSERT INTO dtb_templates (template_code, template_name, create_date, update_date) VALUES('default1','¤Õ¤È¤ó¤ä¤µ¤ó', now(), now()); 225 225 226 insert into dtb_mailtemplate (template_id, subject, body, creator_id, update_date, create_date, send_type, template_name) values ( 227 '1', 226 insert into dtb_mailtemplate (subject, body, creator_id, update_date, create_date, send_type, template_name) values ( 228 227 '¤´Ãíʸ¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£', 229 228 '{name}ÍÍ … … 245 244 '¼õÃí´°Î»¥Æ¥ó¥×¥ì¡¼¥È(PCÍÑ)'); 246 245 247 insert into dtb_mailtemplate (template_id, subject, body, creator_id, update_date, create_date, send_type, template_name) values ( 248 '2', 246 insert into dtb_mailtemplate (subject, body, creator_id, update_date, create_date, send_type, template_name) values ( 249 247 '¤´Ãíʸ¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£', 250 248 '{name}ÍÍ
Note: See TracChangeset
for help on using the changeset viewer.