diff options
Diffstat (limited to 'sql')
-rw-r--r-- | sql/modules/Defaults.sql | 2 | ||||
-rw-r--r-- | sql/modules/Employee.sql | 1 | ||||
-rw-r--r-- | sql/modules/README | 23 | ||||
-rw-r--r-- | sql/modules/chart.sql | 2 |
4 files changed, 26 insertions, 2 deletions
diff --git a/sql/modules/Defaults.sql b/sql/modules/Defaults.sql index 62597faf..9f92b06e 100644 --- a/sql/modules/Defaults.sql +++ b/sql/modules/Defaults.sql @@ -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 diff --git a/sql/modules/Employee.sql b/sql/modules/Employee.sql index 1efc5169..bd3445f6 100644 --- a/sql/modules/Employee.sql +++ b/sql/modules/Employee.sql @@ -75,7 +75,6 @@ create view employees as 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 diff --git a/sql/modules/README b/sql/modules/README index cd89d7b9..4c082a5a 100644 --- a/sql/modules/README +++ b/sql/modules/README @@ -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. diff --git a/sql/modules/chart.sql b/sql/modules/chart.sql index 0a6b6e58..53460766 100644 --- a/sql/modules/chart.sql +++ b/sql/modules/chart.sql @@ -1,3 +1,5 @@ +-- TODO: Merge with account.sql -CT + CREATE OR REPLACE FUNCTION chart_list_all() RETURNS SETOF chart AS $$ |