source: branches/samhain-2_2-branch/sql_init/samhain.oracle.init@ 400

Last change on this file since 400 was 1, checked in by katerina, 19 years ago

Initial import

File size: 3.2 KB
Line 
1CREATE SEQUENCE log_log_index_seq START WITH 1;
2CREATE TABLE log (
3 log_index INTEGER NOT NULL,
4 log_ref NUMBER(20) NULL,
5 log_host VARCHAR2(64) DEFAULT 'localhost' NOT NULL,
6 log_time DATE NOT NULL,
7 log_sev VARCHAR2(4) NOT NULL,
8 log_msg VARCHAR2(4000),
9 log_hash VARCHAR2(32),
10 entry_status VARCHAR2(16) DEFAULT 'NEW' NOT NULL,
11 path VARCHAR2(4000),
12 userid VARCHAR2(8),
13 grp VARCHAR2(8),
14 program VARCHAR2(8),
15 subroutine VARCHAR2(16),
16 status VARCHAR2(12),
17 hash VARCHAR2(50),
18 path_data VARCHAR2(4000),
19 hash_data VARCHAR2(50),
20 key_uid VARCHAR2(64),
21 key_uid_data VARCHAR2(64),
22 key_id VARCHAR2(16),
23 module VARCHAR2(8),
24 return_code INTEGER,
25 syscall VARCHAR2(16),
26 ip VARCHAR2(16),
27 tty VARCHAR2(16),
28 peer VARCHAR2(64),
29 fromhost VARCHAR2(64),
30 obj VARCHAR2(128),
31 interface VARCHAR2(64),
32 time VARCHAR2(64),
33 dir VARCHAR2(4000),
34 linked_path VARCHAR2(4000),
35 port INTEGER,
36 service VARCHAR2(64),
37 facility VARCHAR2(32),
38 priority VARCHAR2(32),
39 syslog_msg VARCHAR2(4000),
40 mode_old VARCHAR2(16),
41 mode_new VARCHAR2(16),
42 attr_old VARCHAR2(16),
43 attr_new VARCHAR2(16),
44 device_old VARCHAR2(16),
45 device_new VARCHAR2(16),
46 owner_old VARCHAR2(9),
47 owner_new VARCHAR2(9),
48 group_old VARCHAR2(9),
49 group_new VARCHAR2(9),
50 ctime_old VARCHAR2(25),
51 ctime_new VARCHAR2(25),
52 atime_old VARCHAR2(25),
53 atime_new VARCHAR2(25),
54 mtime_old VARCHAR2(25),
55 mtime_new VARCHAR2(25),
56 chksum_old VARCHAR2(50),
57 chksum_new VARCHAR2(50),
58 link_old VARCHAR2(4000),
59 link_new VARCHAR2(4000),
60 size_old NUMBER(20),
61 size_new NUMBER(20),
62 hardlinks_old NUMBER(20),
63 hardlinks_new NUMBER(20),
64 inode_old NUMBER(20),
65 inode_new NUMBER(20),
66 imode_old NUMBER(20),
67 imode_new NUMBER(20),
68 iattr_old NUMBER(20),
69 iattr_new NUMBER(20),
70 idevice_old NUMBER(20),
71 idevice_new NUMBER(20),
72 iowner_old NUMBER(20),
73 iowner_new NUMBER(20),
74 igroup_old NUMBER(20),
75 igroup_new NUMBER(20)
76 );
77
78CREATE OR REPLACE TRIGGER trigger_on_log
79before insert on log
80for each row
81declare
82log_index integer;
83begin
84select log_log_index_seq.NEXTVAL into :new.log_index from dual;
85end trigger_on_log;
86.
87run;
88
89CREATE UNIQUE INDEX log_log_index_key on log (log_index);
90
91CREATE INDEX ix_hash ON log (log_hash);
92
93CREATE INDEX ix_log_host ON log (log_host);
94CREATE INDEX ix_log_ref ON log (log_ref);
95CREATE INDEX ix_entry_status ON log (entry_status);
96
97GRANT INSERT ON log TO samhain;
98GRANT ALTER ON log_log_index_seq TO samhain;
99GRANT SELECT ON log_log_index_seq TO samhain;
100
101
102
Note: See TracBrowser for help on using the repository browser.