SF.net SVN: ledger-smb: [1257] trunk

[..hidden..]

Revision: 1257
          http://svn.sourceforge.net/ledger-smb/?rev=1257&view=rev
Author:   linuxpoet
Date:     2007-06-06 18:11:50 -0700 (Wed, 06 Jun 2007)

Log Message:
-----------
added documentationm for tsearch2 requirement

Modified Paths:
--------------
    trunk/INSTALL
    trunk/sql/Pg-database.sql

Modified: trunk/INSTALL
===================================================================
--- trunk/INSTALL	2007-06-05 03:48:30 UTC (rev 1256)
+++ trunk/INSTALL	2007-06-07 01:11:50 UTC (rev 1257)
@@ -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 @@
   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.
 

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-06-05 03:48:30 UTC (rev 1256)
+++ trunk/sql/Pg-database.sql	2007-06-07 01:11:50 UTC (rev 1257)
@@ -97,7 +97,6 @@
   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,7 +190,21 @@
 
 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   
 
 --


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