Index: openacs-4/packages/organizations/sql/postgresql/organizations-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/organizations/sql/postgresql/organizations-create.sql,v diff -u -r1.7 -r1.8 --- openacs-4/packages/organizations/sql/postgresql/organizations-create.sql 18 Dec 2006 14:10:47 -0000 1.7 +++ openacs-4/packages/organizations/sql/postgresql/organizations-create.sql 12 Apr 2018 07:47:22 -0000 1.8 @@ -31,7 +31,7 @@ -- organization -- this will be a party --- probably should be it's own package +-- probably should be its own package create table organizations ( organization_id integer @@ -45,9 +45,9 @@ -- this can be ein/ssn/vat reg_number varchar(100), -- The internal client_id. You should have your own sequence for that. - client_id varchar(100) constraint orga_client_id_un unique, + client_id varchar(100) constraint orga_client_id_un unique, notes text -); +); create index organization_name_ix on organizations(name); create index organization_cliend_idx on organizations(client_id);