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.sql,v 1.4.8.1 2005/11/25 21:43:39 chuck Exp $
CREATE TABLE nag_tasks (
task_id VARCHAR(32) NOT NULL,
task_owner VARCHAR(255) NOT NULL,
task_name VARCHAR(255) NOT NULL,
task_uid VARCHAR(255) NOT NULL,
task_desc TEXT,
task_due INT,
task_priority INT NOT NULL DEFAULT 0,
task_category VARCHAR(80),
task_completed SMALLINT NOT NULL DEFAULT 0,
task_alarm INT NOT NULL DEFAULT 0,
task_private INT NOT NULL DEFAULT 0,
--
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;
|
