File: nag.oci8.sql

package info (click to toggle)
nag2 2.1.2-1
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 4,120 kB
  • ctags: 766
  • sloc: php: 3,066; xml: 304; sql: 132; makefile: 64; sh: 39
file content (22 lines) | stat: -rw-r--r-- 751 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 
-- $Horde: nag/scripts/sql/nag.oci8.sql,v 1.1.2.2 2005/11/28 21:17:51 selsky Exp $

CREATE TABLE nag_tasks (
    task_id         VARCHAR2(32) NOT NULL,
    task_owner      VARCHAR2(255) NOT NULL,
    task_name       VARCHAR2(255) NOT NULL,
    task_uid        VARCHAR2(255) NOT NULL,
    task_desc       CLOB,
    task_due        INT,
    task_priority   INT DEFAULT 0 NOT NULL,
    task_category   VARCHAR2(80),
    task_completed  SMALLINT DEFAULT 0 NOT NULL,
    task_alarm      INT DEFAULT 0 NOT NULL,
    task_private    INT DEFAULT 0 NOT NULL,
--
    PRIMARY KEY (task_id)
);

CREATE INDEX nag_tasklist_idx ON nag_tasks (task_owner);
CREATE INDEX nag_uid_idx ON nag_tasks (task_uid);

GRANT SELECT, INSERT, UPDATE, DELETE ON nag_tasks TO horde;