SF.net SVN: ledger-smb: [1132] trunk/sql/upgrade/1.2-1.3.sql

[..hidden..]

Revision: 1132
          http://svn.sourceforge.net/ledger-smb/?rev=1132&view=rev
Author:   einhverfr
Date:     2007-05-06 10:58:43 -0700 (Sun, 06 May 2007)

Log Message:
-----------
Fixing bug 1713288

Modified Paths:
--------------
    trunk/sql/upgrade/1.2-1.3.sql

Modified: trunk/sql/upgrade/1.2-1.3.sql
===================================================================
--- trunk/sql/upgrade/1.2-1.3.sql	2007-05-06 17:56:02 UTC (rev 1131)
+++ trunk/sql/upgrade/1.2-1.3.sql	2007-05-06 17:58:43 UTC (rev 1132)
@@ -19,7 +19,7 @@
 ALTER TABLE employees ADD COLUMN locations_id integer;
 ALTER TABLE employees ADD FOREIGN KEY (locations_id) REFERENCES locations(id);
 ALTER TABLE employees ALTER COLUMN id DROP DEFAULT;
-ALTER TABLE employees ALTER COLUMN id SET DEFAULT  nextval('employee_id_seq');
+ALTER TABLE employees ALTER COLUMN id SET DEFAULT  nextval('employees_id_seq');
 
 DROP RULE employee_id_track_i ON employees; -- no longer needed
 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.