svnno****@sourc*****
svnno****@sourc*****
2007年 7月 16日 (月) 03:11:53 JST
Revision: 263
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=263
Author: takeharu
Date: 2007-07-16 03:11:53 +0900 (Mon, 16 Jul 2007)
Log Message:
-----------
added the text to insert queary
Modified Paths:
--------------
pompei/trunk/src/main/webapp/WEB-INF/db/insert_sample_data.sql
-------------- next part --------------
Modified: pompei/trunk/src/main/webapp/WEB-INF/db/insert_sample_data.sql
===================================================================
--- pompei/trunk/src/main/webapp/WEB-INF/db/insert_sample_data.sql 2007-07-15 18:10:16 UTC (rev 262)
+++ pompei/trunk/src/main/webapp/WEB-INF/db/insert_sample_data.sql 2007-07-15 18:11:53 UTC (rev 263)
@@ -1,4 +1,18 @@
+--CATEGORIES
+INSERT INTO CATEGORIES VALUES(1,null,0,1,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
+INSERT INTO CATEGORIES VALUES(2,null,0,2,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
+INSERT INTO CATEGORIES VALUES(3,null,0,3,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
+INSERT INTO CATEGORIES VALUES(4,null,0,4,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
+INSERT INTO CATEGORIES VALUES(5,null,1,1,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
+INSERT INTO CATEGORIES VALUES(6,null,1,2,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
+--CATEGORIES_DESCRIPTION
+INSERT INTO CATEGORIES_DESCRIPTION VALUES(1,1,'革靴');
+INSERT INTO CATEGORIES_DESCRIPTION VALUES(2,1,'スニーカー');
+INSERT INTO CATEGORIES_DESCRIPTION VALUES(3,1,'サンダル');
+INSERT INTO CATEGORIES_DESCRIPTION VALUES(4,1,'ブーツ');
+INSERT INTO CATEGORIES_DESCRIPTION VALUES(5,1,'スクウェアトゥ');
+INSERT INTO CATEGORIES_DESCRIPTION VALUES(6,1,'ラウンドトゥ');
--ADDRESS_BOOK
--INSERT INTO address_book VALUES ( 1, 1, 'm', 'ACME Inc.', 'John', 'Doe', '1 Way Street', '', '12345', 'NeverNever', '', 223, 12);