diff options
| -rw-r--r-- | INSTALL | 16 | ||||
| -rw-r--r-- | sql/Pg-database.sql | 15 |
2 files changed, 26 insertions, 5 deletions
@@ -1,4 +1,4 @@ -Installing LedgerSMB 1.2 +Installing LedgerSMB 1.3 This document contains information on how to install LedgerSMB. We recommend @@ -39,18 +39,26 @@ recommend as follows: b) Multicompany installations should use user tables in a separate dataset from any accounting data. -4) Create central database +4) Install Tsearch2 Full Text indexing engine for PostgreSQL (not optional) + a) If you installed PostgreSQL from source, Tsearch2 is in contrib. + b) If you installed from package, you will need the package + postgresql-contrib or equivelant + c) Use psql to apply the tsearch2.sql. The file is normally installed to + /usr/share/postgresql/contrib/tsearch2.sql or + //usr/share/postgresql/<version>/contrib/tsearch2.sql + +5) Create central database a) cd to the sql/ directory of the new ledger directory. b) run "psql" with appropriate options to connect to your database. c) Run the SQL script Pg-central.sql. -5) Set the admin password: +6) Set the admin password: a) From psql, determine what admin password you wish to use. Then type: "update users_conf set password = md5('my_password');" Naturally you would use your password instead of my_password. 6) Edit the ledger-smb.conf file as appropriate. -Congratulations, you have manually installed LedgerSMB 1.2. +Congratulations, you have manually installed LedgerSMB 1.3. diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index a599c3ad..43e6b657 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -97,7 +97,6 @@ CREATE TABLE company_to_location ( company_id integer references company(id) not null, PRIMARY KEY(location_id,company_id)); - CREATE TABLE salutation ( id serial unique, salutation text primary key); @@ -191,6 +190,20 @@ CREATE TABLE company_to_contact ( COMMENT ON TABLE company_to_contact IS $$ To keep track of the relationship between multiple contact methods and a single company $$; +-- Begin rocking notes interface +CREATE TABLE note_class(id serial primary key, class text not null check (class ~ '[[:alnum:]_]'), vectors tsvector not null, created date not null default current_date); +INSERT INTO note_class(id,class) VALUES (1,'Entity'); +INSERT INTO note_class(id,class) VALUES (2,'Invoice'); +CREATE UNIQUE INDEX note_class_idx ON notes_class(lower(class)); + +CREATE TABLE note (id serial primary key, note_class integer not null references note_class(id), note text not null); +CREATE TABLE entity_note() INHERITS notes_class(); +ALTER TABLE entity_note ADD CHECK (id = 1); +CREATE INDEX entity_note_id_idx ON entity_note(id); +CREATE TABLE invoice_note() INHERITS notes_class(); +CREATE INDEX invoice_note_id_idx ON invoice_note(id); +ALTER TABLE invoice_note ADD CHECK (id = 2); + -- END entity |