| [vhffs-dev] [394] It seems that we had a syntax error... |
[ Thread Index |
Date Index
| More vhffs.org/vhffs-dev Archives
]
Revision: 394
Author: beuss
Date: 2007-01-10 08:10:00 +0000 (Wed, 10 Jan 2007)
Log Message:
-----------
It seems that we had a syntax error...
Modified Paths:
--------------
branches/vhffs_4.1/vhffs-backend/src/pgsql/alter_from4.0pre1_tocurrent.sql
Modified: branches/vhffs_4.1/vhffs-backend/src/pgsql/alter_from4.0pre1_tocurrent.sql
===================================================================
--- branches/vhffs_4.1/vhffs-backend/src/pgsql/alter_from4.0pre1_tocurrent.sql 2007-01-09 00:22:35 UTC (rev 393)
+++ branches/vhffs_4.1/vhffs-backend/src/pgsql/alter_from4.0pre1_tocurrent.sql 2007-01-10 08:10:00 UTC (rev 394)
@@ -101,7 +101,7 @@
ALTER TABLE vhffs_repository ADD CONSTRAINT fk_vhffs_vhffs_repository_vhffs_users FOREIGN KEY (owner_uid) REFERENCES vhffs_users(uid);
ALTER TABLE vhffs_repository ADD CONSTRAINT fk_vhffs_vhffs_repository_vhffs_groups FOREIGN KEY (owner_gid) REFERENCES vhffs_groups(gid);
ALTER TABLE vhffs_repository ADD CONSTRAINT fk_vhffs_vhffs_repository_vhffs_object FOREIGN KEY (object_id) REFERENCES vhffs_object(object_id) ON DELETE CASCADE;
-ALTER TABLE vhffs_history DROP CONSTRAINT $1;
+ALTER TABLE vhffs_history DROP CONSTRAINT "$1";
ALTER TABLE vhffs_history ADD CONSTRAINT "fk_vhffs_history_vhffs_object" FOREIGN KEY (object_id) REFERENCES vhffs_object(object_id) ON DELETE CASCADE;
CREATE VIEW vhffs_forum AS