- Timestamp:
- 2010/08/18 15:12:25 (14 years ago)
- bzr:base-revision:
- ohkouchi@loop-az.jp-20100818034225-loyoujma8pjbxn2u
- bzr:committer:
- Kentaro Ohkouchi <ohkouchi@loop-az.jp>
- bzr:file-ids:
html/install/index.php 16809@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Findex.php
html/install/sql/column_comment.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcolumn_comment.sql
html/install/sql/create_table_mysql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_mysql.sql
html/install/sql/create_table_pgsql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_pgsql.sql
html/install/sql/drop_table.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fdrop_table.sql
html/install/sql/drop_view.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fdrop_view.sql
html/install/sql/insert_data.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Finsert_data.sql- bzr:mapping-version:
- v4
- bzr:merge:
ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9- bzr:repository-uuid:
- 1e3b908f-19a9-db11-a64c-001125224ba8
- bzr:revision-id:
- ohkouchi@loop-az.jp-20100818061207-vgzu2onofgbq0k0i
- bzr:revno:
- 2270
- bzr:revprop:branch-nick:
- branches/version-2_5-dev
- bzr:root:
- branches/version-2_5-dev
- bzr:text-parents:
html/install/index.php ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/column_comment.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/create_table_mysql.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/create_table_pgsql.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/drop_table.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/drop_view.sql svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18777
html/install/sql/insert_data.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981- bzr:text-revisions:
html/install/index.php ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/column_comment.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/create_table_mysql.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/create_table_pgsql.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/drop_table.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/drop_view.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/insert_data.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9- bzr:timestamp:
- 2010-08-18 15:12:07.440000057 +0900
- bzr:user-agent:
- bzr2.1.2+bzr-svn1.0.2
- svn:original-date:
- 2010-08-18T06:12:07.440000Z
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql
r18786 r18787 563 563 PRIMARY KEY (customer_id) 564 564 ); 565 566 CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id);567 565 568 566 CREATE TABLE dtb_order ( … … 1171 1169 ); 1172 1170 1171 CREATE TABLE dtb_mobile_ext_session_id ( 1172 session_id text NOT NULL, 1173 param_key text, 1174 param_value text, 1175 url text, 1176 create_date timestamp NOT NULL DEFAULT now() 1177 ); 1178 1179 CREATE TABLE dtb_mobile_kara_mail ( 1180 kara_mail_id serial PRIMARY KEY, 1181 session_id text NOT NULL, 1182 token text NOT NULL, 1183 next_url text NOT NULL, 1184 create_date timestamp NOT NULL DEFAULT now(), 1185 email text, 1186 receive_date timestamp 1187 ); 1188 1189 CREATE TABLE dtb_session ( 1190 sess_id text NOT NULL, 1191 sess_data text, 1192 create_date timestamp NOT NULL, 1193 update_date timestamp NOT NULL, 1194 PRIMARY KEY (sess_id) 1195 ); 1196 1197 CREATE TABLE dtb_module ( 1198 module_id int NOT NULL UNIQUE, 1199 module_code text NOT NULL, 1200 module_name text NOT NULL, 1201 sub_data text, 1202 auto_update_flg int2 NOT NULL DEFAULT 0, 1203 del_flg int2 NOT NULL DEFAULT 0, 1204 create_date timestamp NOT NULL DEFAULT NOW(), 1205 update_date timestamp NOT NULL 1206 ); 1207 1208 CREATE TABLE dtb_site_control ( 1209 control_id serial primary key NOT NULL, 1210 control_title text , 1211 control_text text , 1212 control_flg int2 NOT NULL DEFAULT 2, 1213 del_flg int2 NOT NULL DEFAULT 0, 1214 memo text , 1215 create_date timestamp NOT NULL DEFAULT now(), 1216 update_date timestamp NOT NULL DEFAULT now() 1217 ); 1218 1219 CREATE TABLE dtb_trackback ( 1220 trackback_id serial primary key NOT NULL, 1221 product_id int NOT NULL, 1222 blog_name varchar(255) NOT NULL DEFAULT '', 1223 title varchar(255) NOT NULL DEFAULT '', 1224 excerpt text NOT NULL DEFAULT '', 1225 url text NOT NULL DEFAULT '', 1226 status int2 NOT NULL DEFAULT 2, 1227 del_flg int2 NOT NULL DEFAULT 0, 1228 create_date timestamp NOT NULL, 1229 update_date timestamp NOT NULL 1230 ); 1231 1232 CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id); 1233 CREATE INDEX dtb_products_class_product_id_key ON dtb_products_class(product_id); 1234 CREATE INDEX dtb_order_detail_product_id_key ON dtb_order_detail(product_id); 1235 CREATE INDEX dtb_send_customer_customer_id_key ON dtb_send_customer(customer_id); 1236 1237 CREATE INDEX dtb_mobile_ext_session_id_param_key_key ON dtb_mobile_ext_session_id (param_key); 1238 CREATE INDEX dtb_mobile_ext_session_id_param_value_key ON dtb_mobile_ext_session_id (param_value); 1239 CREATE INDEX dtb_mobile_ext_session_id_url_key ON dtb_mobile_ext_session_id (url); 1240 CREATE INDEX dtb_mobile_ext_session_id_create_date_key ON dtb_mobile_ext_session_id (create_date); 1241 1242 CREATE INDEX dtb_mobile_kara_mail_token_key ON dtb_mobile_kara_mail (token); 1243 CREATE INDEX dtb_mobile_kara_mail_create_date_key ON dtb_mobile_kara_mail (create_date); 1244 CREATE INDEX dtb_mobile_kara_mail_receive_date_key ON dtb_mobile_kara_mail (receive_date);
Note: See TracChangeset
for help on using the changeset viewer.