Changeset 1203 for pykota/trunk/initscripts/postgresql/upgrade-to-1.16.sql

Timestamp:

11/23/03 20:01:37 (20 years ago)

Author:

jalet

Message:

Job price added to history

Files:

• pykota/trunk/initscripts/postgresql/upgrade-to-1.16.sql (modified) (2 diffs)

pykota/trunk/initscripts/postgresql/upgrade-to-1.16.sql

@@ -20 +20 @@
 --
 -- $Log$
+-- Revision 1.2  2003/11/23 19:01:36  jalet
+-- Job price added to history
+--
 -- Revision 1.1  2003/11/21 14:29:14  jalet
 -- Forgot to add this file...
@@ -39 +42 @@
 -- Modify the old database schema
 --
+ALTER TABLE jobhistory ADD COLUMN jobprice FLOAT;
 ALTER TABLE jobhistory ADD COLUMN filename TEXT;
 ALTER TABLE jobhistory ADD COLUMN title TEXT;