← Back to branch summary

~ubuntu-branches/ubuntu/precise/dspam/precise

« back to all changes in this revision

Viewing changes to src/tools.ora_drv/ora_objects.sql

  • Committer: Bazaar Package Importer
  • Author(s): Julien Valroff, Julien Valroff, Thomas Preud'homme
  • Date: 2011-05-08 13:43:52 UTC
  • mfrom: (1.2.1 upstream) (8.2.2 experimental)
  • mto: This revision was merged to the branch mainline in revision 23.
  • Revision ID: james.westby@ubuntu.com-20110508134352-dxjx9m6tx1cbzlhq
Tags: 3.9.1~rc1+git20110419.29261fb+dfsg-1
http://bugs.debian.org/394443
[ Julien Valroff ]
* New git snapshot
* Install all dspam_* tools setgid so that they can be used by standard
  users
* Add symbols file for libdspam7
* Upload to unstable

[ Thomas Preud'homme ]
* Fix permissions on dspam_stats and missing opt-{in,out} directories
  (Closes: #394443)

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/tools.ora_drv/ora_objects.sql
1
 
REM $Id: ora_objects.sql,v 1.2 2006/01/24 14:39:38 jonz Exp $
2
 
 
3
 
CREATE TABLE DSPAM_TOKEN_DATA (
4
 
  USER_ID NUMBER(5),
5
 
  TOKEN NUMBER,
6
 
  SPAM_HITS NUMBER,
7
 
  INNOCENT_HITS NUMBER,
8
 
  LAST_HIT DATE
9
 
)
10
 
/
11
 
 
12
 
CREATE UNIQUE INDEX ID_TOKEN_DATA_01 ON DSPAM_TOKEN_DATA(USER_ID,TOKEN);
13
 
CREATE INDEX ID_TOKEN_DATA_02 ON DSPAM_TOKEN_DATA(INNOCENT_HITS);
14
 
CREATE INDEX ID_TOKEN_DATA_03 ON DSPAM_TOKEN_DATA(SPAM_HITS);
15
 
 
16
 
CREATE TABLE DSPAM_SIGNATURE_DATA (
17
 
  USER_ID NUMBER(5),
18
 
  SIGNATURE VARCHAR2(128),
19
 
  DATA LONG,
20
 
  LENGTH NUMBER,
21
 
  CREATED_ON DATE
22
 
)
23
 
/
24
 
 
25
 
CREATE UNIQUE INDEX ID_SIGNATURE_DATA_01 ON 
26
 
  DSPAM_SIGNATURE_DATA(USER_ID,SIGNATURE);
27
 
 
28
 
CREATE TABLE DSPAM_STATS (
29
 
  USER_ID NUMBER(5) PRIMARY KEY,
30
 
  TOTAL_SPAM NUMBER,
31
 
  TOTAL_INNOCENT NUMBER,
32
 
  SPAM_MISSES NUMBER,
33
 
  FALSE_POSITIVES NUMBER,
34
 
  SPAM_CORPUSFED NUMBER,
35
 
  INNOCENT_CORPUSFED NUMBER,
36
 
  SPAM_CLASSIFIED NUMBER,
37
 
  INNOCENT_CLASSIFIED NUMBER
38
 
)
39
 
/
40