OpenACS

dirkg
committed
MAIN:dirkg:20050607195815
on 07 Jun 05
Added package_id to site_wide_index table
/oracle/search-tables-create.sql (+2 -1)
12 12 --  WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
13 13 --  FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more
14 14 --  details.
15 15 --
16 16
17 17 --
18 18 -- Create database tables for .LRN site-wide search
19 19 --
20 20 -- @author <a href="mailto:openacs@dirkgomez.de">openacs@dirkgomez.de</a>
21 21 -- @version $Id$
22 22 -- @creation-date 13-May-2005
23 23 --
24 24 -- Partly ported from ACES.
25 25
26 26 -- Central table for site-wide search.
27 27 create table site_wide_index (
28 28         object_id               integer
29 29                                         constraint sws_index_pk primary key
30 30                                         constraint sws_index_fk references acs_objects(object_id) on delete cascade,
31 31         object_name             varchar(4000),
  32         indexed_content         clob,
32 33         datastore               char(1) not null,
33 34         event_date                      date
34 35                                         default sysdate,
35 36         event                   varchar(6)
36 37                                         constraint site_wide_index_event_ck
37 38                                         check (event in ('INSERT','DELETE','UPDATE')) 
38 39 );
39 40
40 41 -- Intermedia sometimes is painful to debug, so I added a logging
41 42 -- mechanism which relies on Oracle's autonomous transactions: DML
42 43 -- statements are committed immediately so you can access this data
43 44 -- from a different session right away.
44 45
45 46 create table sws_log_messages (
46 47   logmessage varchar2(4000),
47 48   logtime    date default sysdate);
48 49
49 50 exit;