diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-03-12 16:43:13 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-03-12 16:43:13 +0000 |
| commit | c1fe248cb1ec9979a615ae0673191c92034b0ab3 (patch) | |
| tree | 7f02b46062ae7c8372ff68e48de05f3770716d24 /sql/modules | |
| parent | 91fe1a1dc728a17094739e1b9b450dd261ff86bb (diff) | |
Adding version numbers to modules that are ready to load
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@885 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql/modules')
| -rw-r--r-- | sql/modules/Account.sql | 2 | ||||
| -rw-r--r-- | sql/modules/Employee.sql | 1 | ||||
| -rw-r--r-- | sql/modules/Location.sql | 2 | ||||
| -rw-r--r-- | sql/modules/Settings.sql | 2 | ||||
| -rw-r--r-- | sql/modules/security.sql | 2 |
5 files changed, 8 insertions, 1 deletions
diff --git a/sql/modules/Account.sql b/sql/modules/Account.sql index c03280d4..3b85f8f9 100644 --- a/sql/modules/Account.sql +++ b/sql/modules/Account.sql @@ -1,3 +1,5 @@ +-- VERSION 1.3.0 + CREATE OR REPLACE FUNCTION account_get (in_id) RETURNS chart AS $$ DECLARE diff --git a/sql/modules/Employee.sql b/sql/modules/Employee.sql index dc63bf24..c407e244 100644 --- a/sql/modules/Employee.sql +++ b/sql/modules/Employee.sql @@ -1,3 +1,4 @@ +-- VERSION 1.3.0 CREATE OR REPLACE FUNCTION employee_save (in_id integer, in_location_id integer, in_employeenumber varchar(32), in_name varchar(64), in_address1 varchar(32), in_address2 varchar(32), diff --git a/sql/modules/Location.sql b/sql/modules/Location.sql index 665b8197..565b7e1b 100644 --- a/sql/modules/Location.sql +++ b/sql/modules/Location.sql @@ -1,4 +1,4 @@ - +-- VERSION 1.3.0 CREATE OR REPLACE FUNCTION location_save (in_id int, in_companyname text, in_address1 text, in_address2 text, in_city text, in_state text, in_zipcode text, in_country text) diff --git a/sql/modules/Settings.sql b/sql/modules/Settings.sql index d977550b..e86450c3 100644 --- a/sql/modules/Settings.sql +++ b/sql/modules/Settings.sql @@ -1,3 +1,5 @@ +-- VERSION 1.3.0 + CREATE OR REPLACE FUNCTION setting_set (in_key varchar, in_value varchar) RETURNS VOID AS $$ diff --git a/sql/modules/security.sql b/sql/modules/security.sql index fe790f22..61828b64 100644 --- a/sql/modules/security.sql +++ b/sql/modules/security.sql @@ -1,3 +1,5 @@ + + create table modules ( id SERIAL PRIMARY KEY, mod_name TEXT UNIQUE NOT NULL, |