svnno****@sourc*****
svnno****@sourc*****
2007年 7月 19日 (木) 06:13:14 JST
Revision: 305
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=305
Author: takeharu
Date: 2007-07-19 06:13:14 +0900 (Thu, 19 Jul 2007)
Log Message:
-----------
updated sql for manufacutures table to support auto increment id
Modified Paths:
--------------
pompei/trunk/src/main/webapp/WEB-INF/db/create_table.sql
-------------- next part --------------
Modified: pompei/trunk/src/main/webapp/WEB-INF/db/create_table.sql
===================================================================
--- pompei/trunk/src/main/webapp/WEB-INF/db/create_table.sql 2007-07-18 21:11:47 UTC (rev 304)
+++ pompei/trunk/src/main/webapp/WEB-INF/db/create_table.sql 2007-07-18 21:13:14 UTC (rev 305)
@@ -199,7 +199,8 @@
DROP TABLE manufacturers;
CREATE TABLE manufacturers (
- manufacturers_id int NOT NULL,
+ manufacturers_id int NOT NULL GENERATED ALWAYS AS IDENTITY
+ (START WITH 1, INCREMENT BY 1),
manufacturers_name varchar(32) NOT NULL,
manufacturers_image varchar(64),
date_added TIMESTAMP,
@@ -212,10 +213,15 @@
manufacturers_id int NOT NULL,
languages_id int NOT NULL,
manufacturers_url varchar(255) NOT NULL,
+ manufacturers_short_desc varchar(100),
+ manufacturers_long_desc varchar(1000),
url_clicked int NOT NULL default 0,
date_last_click TIMESTAMP,
PRIMARY KEY (manufacturers_id, languages_id)
);
+ALTER TABLE manufacturers_info
+ ADD FOREIGN KEY (manufacturers_id)
+ REFERENCES manufacturers (manufacturers_id);
DROP TABLE newsletters;
CREATE TABLE newsletters (