diff options
| -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, |