[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SF.net SVN: ledger-smb:[3555] trunk/sql/modules



Revision: 3555
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3555&view=rev
Author:   einhverfr
Date:     2011-07-21 19:55:56 +0000 (Thu, 21 Jul 2011)

Log Message:
-----------
deleting misplaced upgrade scripts

Removed Paths:
-------------
    trunk/sql/modules/3448-drop-location-search.sql
    trunk/sql/modules/3532-drop-used-function.sql
    trunk/sql/modules/3547-constraints-upgrade.sql

Deleted: trunk/sql/modules/3448-drop-location-search.sql
===================================================================
--- trunk/sql/modules/3448-drop-location-search.sql	2011-07-21 19:54:09 UTC (rev 3554)
+++ trunk/sql/modules/3448-drop-location-search.sql	2011-07-21 19:55:56 UTC (rev 3555)
@@ -1,7 +0,0 @@
-DROP FUNCTION location_search
-(in_companyname varchar, in_address1 varchar, in_address2 varchar,
-        in_city varchar, in_state varchar, in_zipcode varchar,
-        in_country varchar);
-
-DROP TYPE location_result CASCADE;
-

Deleted: trunk/sql/modules/3532-drop-used-function.sql
===================================================================
--- trunk/sql/modules/3532-drop-used-function.sql	2011-07-21 19:54:09 UTC (rev 3554)
+++ trunk/sql/modules/3532-drop-used-function.sql	2011-07-21 19:55:56 UTC (rev 3555)
@@ -1,3 +0,0 @@
-DROP FUNCTION person__all_locations (
-    in_entity_id int
-);

Deleted: trunk/sql/modules/3547-constraints-upgrade.sql
===================================================================
--- trunk/sql/modules/3547-constraints-upgrade.sql	2011-07-21 19:54:09 UTC (rev 3554)
+++ trunk/sql/modules/3547-constraints-upgrade.sql	2011-07-21 19:55:56 UTC (rev 3555)
@@ -1,16 +0,0 @@
-ALTER TABLE audittrail DROP CONSTRAINT "audittrail_person_id_fkey";
-
-\echo If the update below fails, it may be because the table is set up correctly
-\echo already.  It's safe to ignore constraint errors there.
---'
-UPDATE audittrail 
-  SET person_id = (select entity_id from person where id = person_id);
-
-\echo If the alter table below fails, there is something wrong.  Please correct
-\echo before proceding.
-ALTER TABLE audittrail ADD FOREIGN KEY (person_id) REFERENCES person(entity_id);
-
-ALTER TABLE lsmb_roles DROP CONSTRAINT "lsmb_roles_user_id_fkey";
-
-ALTER TABLE lsmb_roles ADD foreign key (user_id) references users(id) 
-  ON DELETE CASCADE;


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