OpenACS

dirkg
committed
MAIN:dirkg:20050613140435
on 13 Jun 05
removed search callback procs for the calendar object. It doesn't make sense to search in calendar names only. Instead we will add the calen… Show more
removed search callback procs for the calendar object. It doesn't make sense to search in calendar names only. Instead we will add the calendar name to each calendar item

Show less

/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;