From 6dfea503b9df15043d20821d7adb3587e17e20cb Mon Sep 17 00:00:00 2001 From: linuxpoet Date: Thu, 7 Jun 2007 01:11:50 +0000 Subject: added documentationm for tsearch2 requirement git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1257 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/Pg-database.sql | 15 ++++++++++++++- 1 file changed, 14 insertions(+), 1 deletion(-) (limited to 'sql/Pg-database.sql') 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 -- cgit v1.2.3