• R/O
  • SSH
  • HTTPS

pal: Commit


Commit MetaInfo

Revision407 (tree)
Zeit2007-07-28 04:10:28
Autortakeharu

Log Message

added insert sql for ORDERS_STATUS

Ändern Zusammenfassung

Diff

--- pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_sample_data.sql (revision 406)
+++ pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/insert_sample_data.sql (revision 407)
@@ -1,19 +1,12 @@
11
2---CATEGORIES
3-INSERT INTO CATEGORIES(categories_image,parent_id,sort_order,date_added,last_modified) VALUES(null,0,1,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
4-INSERT INTO CATEGORIES(categories_image,parent_id,sort_order,date_added,last_modified) VALUES(null,0,2,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
5-INSERT INTO CATEGORIES(categories_image,parent_id,sort_order,date_added,last_modified) VALUES(null,0,3,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
6-INSERT INTO CATEGORIES(categories_image,parent_id,sort_order,date_added,last_modified) VALUES(null,0,4,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
7-INSERT INTO CATEGORIES(categories_image,parent_id,sort_order,date_added,last_modified) VALUES(null,1,1,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
8-INSERT INTO CATEGORIES(categories_image,parent_id,sort_order,date_added,last_modified) VALUES(null,1,2,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
9---CATEGORIES_DESCRIPTION
10-INSERT INTO CATEGORIES_DESCRIPTION VALUES(1,1,'革靴');
11-INSERT INTO CATEGORIES_DESCRIPTION VALUES(2,1,'スニーカー');
12-INSERT INTO CATEGORIES_DESCRIPTION VALUES(3,1,'サンダル');
13-INSERT INTO CATEGORIES_DESCRIPTION VALUES(4,1,'ブーツ');
14-INSERT INTO CATEGORIES_DESCRIPTION VALUES(5,1,'スクウェアトゥ');
15-INSERT INTO CATEGORIES_DESCRIPTION VALUES(6,1,'ラウンドトゥ');
2+--ORDERS_STATUS
3+INSERT INTO orders_status (orders_status_id,language_id,orders_status_name) VALUES(1,1,'未処理');
4+INSERT INTO orders_status (orders_status_id,language_id,orders_status_name) VALUES(2,1,'処理中');
5+INSERT INTO orders_status (orders_status_id,language_id,orders_status_name) VALUES(3,1,'発送済');
6+INSERT INTO orders_status (orders_status_id,language_id,orders_status_name) VALUES(4,1,'処理済');
7+INSERT INTO orders_status (orders_status_id,language_id,orders_status_name) VALUES(5,1,'キャンセル');
168
9+
1710 --ADDRESS_BOOK
1811 --INSERT INTO address_book VALUES ( 1, 1, 'm', 'ACME Inc.', 'John', 'Doe', '1 Way Street', '', '12345', 'NeverNever', '', 223, 12);
1912
Show on old repository browser