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

[..hidden..]

Revision: 1999
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=1999&view=rev
Author:   einhverfr
Date:     2007-12-21 12:46:04 -0800 (Fri, 21 Dec 2007)

Log Message:
-----------
Documentation changes for installation order of scripts.

Modified Paths:
--------------
    trunk/sql/modules/Defaults.sql
    trunk/sql/modules/Employee.sql
    trunk/sql/modules/README
    trunk/sql/modules/chart.sql

Modified: trunk/sql/modules/Defaults.sql
===================================================================
--- trunk/sql/modules/Defaults.sql	2007-12-21 20:44:30 UTC (rev 1998)
+++ trunk/sql/modules/Defaults.sql	2007-12-21 20:46:04 UTC (rev 1999)
@@ -1,4 +1,4 @@
--- Probably want to move this to the Settings module
+-- Probably want to move this to the Settings module -CT
 
 CREATE OR REPLACE FUNCTION defaults_get_defaultcurrency() 
 RETURNS SETOF char(3) AS

Modified: trunk/sql/modules/Employee.sql
===================================================================
--- trunk/sql/modules/Employee.sql	2007-12-21 20:44:30 UTC (rev 1998)
+++ trunk/sql/modules/Employee.sql	2007-12-21 20:46:04 UTC (rev 1999)
@@ -75,7 +75,6 @@
     JOIN salutation s ON (p.salutation_id = s.id);
     
 
--- why is this like this?
 CREATE OR REPLACE FUNCTION employee_get
 (in_id integer)
 returns employees as

Modified: trunk/sql/modules/README
===================================================================
--- trunk/sql/modules/README	2007-12-21 20:44:30 UTC (rev 1998)
+++ trunk/sql/modules/README	2007-12-21 20:46:04 UTC (rev 1999)
@@ -1,3 +1,26 @@
 This set of files is just for initial testing and proof of concept purposes.
 They will be moved out of here into appropriate upgrade scripts as necessary 
 and are intended only for collaborative development purposes.
+
+For people trying to get 1.3 up and running manually, the following load order 
+should work.  Note that many of these scripts declare types, so if you want to
+redefine functions, you will need to drop the types and reload the scripts.
+
+Account.sql
+Business_Type.sql
+Location.sql
+Company.sql
+Customer.sql 
+Date.sql
+Defaults.sql
+Employee.sql
+Entity.sql
+Payment.sql
+Person.sql
+Report.sql
+Voucher.sql
+
+Note that the Roles.sql is special and must be preprocessed to get it to work.
+A command like:
+sed -e 's/<?lsmb dbname ?>/[dbname]/g' Roles.sql > [dbname]_roles.sql would work
+where [dbname] represents the name of the database you are installing into.

Modified: trunk/sql/modules/chart.sql
===================================================================
--- trunk/sql/modules/chart.sql	2007-12-21 20:44:30 UTC (rev 1998)
+++ trunk/sql/modules/chart.sql	2007-12-21 20:46:04 UTC (rev 1999)
@@ -1,3 +1,5 @@
+-- TODO:  Merge with account.sql -CT
+
 CREATE OR REPLACE FUNCTION chart_list_all()
 RETURNS SETOF chart AS
 $$


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