SF.net SVN: ledger-smb:[3554] trunk/sql/upgrade

[..hidden..]

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

Log Message:
-----------
accidently ommitted upgrade scripts

Added Paths:
-----------
    trunk/sql/upgrade/3302-menu_changes.sql
    trunk/sql/upgrade/3333-location-function-drop.sql
    trunk/sql/upgrade/3445-drop-save-user.sql
    trunk/sql/upgrade/3448-drop-location-search.sql
    trunk/sql/upgrade/3450-drop-user-function.sql
    trunk/sql/upgrade/3532-drop-used-function.sql
    trunk/sql/upgrade/3547-constraints-upgrade.sql

Added: trunk/sql/upgrade/3302-menu_changes.sql
===================================================================
--- trunk/sql/upgrade/3302-menu_changes.sql	                        (rev 0)
+++ trunk/sql/upgrade/3302-menu_changes.sql	2011-07-21 19:54:09 UTC (rev 3554)
@@ -0,0 +1,18 @@
+update menu_attribute 
+   set node_id = 49,
+       attribute = 'l_last_name',
+       value = '1'
+ WHERE id = 115;
+update menu_attribute 
+   set node_id = 49,
+       attribute = 'l_employeenumber',
+       value = '1'
+ WHERE id = 116;
+update menu_attribute 
+   set node_id = 49,
+       attribute = 'module',
+       value = 'employee.pl'
+ WHERE id = 118;
+
+
+

Added: trunk/sql/upgrade/3333-location-function-drop.sql
===================================================================
Added: trunk/sql/upgrade/3445-drop-save-user.sql
===================================================================
--- trunk/sql/upgrade/3445-drop-save-user.sql	                        (rev 0)
+++ trunk/sql/upgrade/3445-drop-save-user.sql	2011-07-21 19:54:09 UTC (rev 3554)
@@ -0,0 +1,2 @@
+DROP FUNCTION admin__save_user
+(in_id int,in_entity_id INT, in_username text, in_password TEXT);

Added: trunk/sql/upgrade/3448-drop-location-search.sql
===================================================================
--- trunk/sql/upgrade/3448-drop-location-search.sql	                        (rev 0)
+++ trunk/sql/upgrade/3448-drop-location-search.sql	2011-07-21 19:54:09 UTC (rev 3554)
@@ -0,0 +1,7 @@
+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;
+

Added: trunk/sql/upgrade/3450-drop-user-function.sql
===================================================================
--- trunk/sql/upgrade/3450-drop-user-function.sql	                        (rev 0)
+++ trunk/sql/upgrade/3450-drop-user-function.sql	2011-07-21 19:54:09 UTC (rev 3554)
@@ -0,0 +1 @@
+DROP FUNCTION admin__delete_user (in_username TEXT);

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

Added: trunk/sql/upgrade/3547-constraints-upgrade.sql
===================================================================
--- trunk/sql/upgrade/3547-constraints-upgrade.sql	                        (rev 0)
+++ trunk/sql/upgrade/3547-constraints-upgrade.sql	2011-07-21 19:54:09 UTC (rev 3554)
@@ -0,0 +1,16 @@
+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.