svnno****@sourc*****
svnno****@sourc*****
2007年 7月 19日 (木) 03:05:05 JST
Revision: 295
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=295
Author: takeharu
Date: 2007-07-19 03:05:05 +0900 (Thu, 19 Jul 2007)
Log Message:
-----------
updated sql for categories table to support auto increment id
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-18 18:01:21 UTC (rev 294)
+++ pompei/trunk/src/main/webapp/WEB-INF/db/insert_sample_data.sql 2007-07-18 18:05:05 UTC (rev 295)
@@ -1,11 +1,11 @@
--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);
+INSERT INTO CATEGORIES(categories_image,parent_id,sort_order,date_added,last_modified) VALUES(null,0,1,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
+INSERT INTO CATEGORIES(categories_image,parent_id,sort_order,date_added,last_modified) VALUES(null,0,2,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
+INSERT INTO CATEGORIES(categories_image,parent_id,sort_order,date_added,last_modified) VALUES(null,0,3,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
+INSERT INTO CATEGORIES(categories_image,parent_id,sort_order,date_added,last_modified) VALUES(null,0,4,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
+INSERT INTO CATEGORIES(categories_image,parent_id,sort_order,date_added,last_modified) VALUES(null,1,1,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
+INSERT INTO CATEGORIES(categories_image,parent_id,sort_order,date_added,last_modified) VALUES(null,1,2,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
--CATEGORIES_DESCRIPTION
INSERT INTO CATEGORIES_DESCRIPTION VALUES(1,1,'革靴');
INSERT INTO CATEGORIES_DESCRIPTION VALUES(2,1,'スニーカー');