From 6dfea503b9df15043d20821d7adb3587e17e20cb Mon Sep 17 00:00:00 2001
From: linuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46>
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

