SF.net SVN: ledger-smb:[3499] trunk/sql/upgrade/1.2-1.3-work-in-progress. sql

[..hidden..]

Revision: 3499
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3499&view=rev
Author:   einhverfr
Date:     2011-07-13 04:41:00 +0000 (Wed, 13 Jul 2011)

Log Message:
-----------
more work on migration scripts

Modified Paths:
--------------
    trunk/sql/upgrade/1.2-1.3-work-in-progress.sql

Modified: trunk/sql/upgrade/1.2-1.3-work-in-progress.sql
===================================================================
--- trunk/sql/upgrade/1.2-1.3-work-in-progress.sql	2011-07-13 03:19:47 UTC (rev 3498)
+++ trunk/sql/upgrade/1.2-1.3-work-in-progress.sql	2011-07-13 04:41:00 UTC (rev 3499)
@@ -1,9 +1,19 @@
 --Setup
 
+\set contribdir '/usr/share/pgsql/contrib'
 \set default_country '''us'''
 \set ar '''1200'''
 \set ap '''2100'''
 
+
+ALTER SCHEMA public RENAME TO lsmb12;
+CREATE SCHEMA public;
+
+\i :contribdir/pg_trgm.sql
+\i :contribdir/tsearch2.sql
+\i :contribdir/tablefunc.sql
+
+\i sql/Pg-database.sql
 \i sql/modules/Setting.sql
 \i sql/modules/Location.sql
 \i sql/modules/Account.sql


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