itms.sql

Internet Task Management System可以让用户分配和管理一个组织内的任务。ITMS可以发送任务管理通知

-- ValleyData Programming Group - April 29, 2001
-- created by Matt Palmerlee, Aaron McBride, Ryan Mahoney,
-- Jaspreet Singh, and Charles Smothers

-- --------------------------------------------------------
--
-- Table structure for table 'error_log'
--

CREATE TABLE error_log (
   eid number(11) NOT NULL PRIMARY KEY,
   priority number(11) DEFAULT '0' NOT NULL,
   message long NOT NULL
);

create sequence s_error_log;

create trigger t_error_log before insert on error_log
for each row
when (new.eid is null)
begin
 select s_error_log.nextval into :new.eid from dual;
end;

--
-- Dumping data for table 'error_log'
--


-- --------------------------------------------------------
--
-- Table structure for table 'groups'
--

CREATE TABLE groups (
   gid number(11) NOT NULL PRIMARY KEY,
   groupname varchar2(255)
);

create sequence s_groups;

create trigger t_groups before insert on groups
for each row
when (new.gid is null)
begin
 select s_groups.nextval into :new.gid from dual;
end;

--
-- Dumping data for table 'groups'
--

INSERT INTO groups VALUES ( '1', 'default');

-- --------------------------------------------------------
--
-- Table structure for table 'ldap'
--

CREATE TABLE ldap (
   name varchar2(255) NOT NULL,
   password varchar2(255)
);

--
-- Dumping data for table 'ldap'
--

INSERT INTO ldap VALUES ( 'root', '.bxZh9KCGVIvI');

-- --------------------------------------------------------
--
-- Table structure for table 'pending_tasks'
--

CREATE TABLE pending_tasks (
   tid number(11) NOT NULL PRIMARY KEY,
   user_id number(11) DEFAULT '0' NOT NULL,
   original_id number(11) DEFAULT '0' NOT NULL,
   title varchar2(255),
   info long,
   assigner number(11) DEFAULT '0' NOT NULL,
   date_assigned date NOT NULL,
   notify number(1) DEFAULT '0' NOT NULL,
   priority number(2) DEFAULT '0' NOT NULL,
   due_date date NOT NULL,
   period number(11) DEFAULT '0',
   period_unit number(11) DEFAULT '0'
);

create sequence s_pending_tasks;

create trigger t_pending_tasks before insert on pending_tasks
for each row
when (new.tid is null)
begin
 select s_pending_tasks.nextval into :new.tid from dual;
end;

--
-- Dumping data for table 'pending_tasks'
--


-- --------------------------------------------------------
--
-- Table structure for table 'process_tasks'
--

CREATE TABLE process_tasks (
   pid number(11) NOT NULL,
   ttid number(11) DEFAULT '0' NOT NULL,
   CONSTRAINT pk_process_tasks 
   PRIMARY KEY (pid, ttid)
);

create sequence s_process_tasks;

create trigger t_process_tasks before insert on process_tasks
for each row
when (new.pid is null)
begin
 select s_process_tasks.nextval into :new.pid from dual;
end;

--
-- Dumping data for table 'process_tasks'
--


-- --------------------------------------------------------
--
-- Table structure for table 'processes'
--

CREATE TABLE processes (
   pid number(11) NOT NULL PRIMARY KEY,
   title varchar2(255) NOT NULL,
   owner number(11) DEFAULT '0' NOT NULL,
   group_owned number(1) DEFAULT '0' NOT NULL,
   default_info long
);

create sequence s_processes;

create trigger t_processes before insert on processes
for each row
when (new.pid is null)
begin
 select s_processes.nextval into :new.pid from dual;
end;

--
-- Dumping data for table 'processes'
--


-- --------------------------------------------------------
--
-- Table structure for table 'task_types'
--

CREATE TABLE task_types (
   ttid number(11) NOT NULL PRIMARY KEY,
   title varchar2(255) NOT NULL,
   owner number(11) DEFAULT '0' NOT NULL,
   default_info long,
   default_user number(11),
   last_time_used date NOT NULL,
   group_owned number(1) DEFAULT '0' NOT NULL
);

create sequence s_task_types;

create trigger t_task_types before insert on task_types
for each row
when (new.ttid is null)
begin
 select s_task_types.nextval into :new.ttid from dual;
end;

--
-- Dumping data for table 'task_types'
--


-- --------------------------------------------------------
--
-- Table structure for table 'user_groups'
--

CREATE TABLE user_groups (
   gid number(11) NOT NULL,
   user_id number(11) DEFAULT '0' NOT NULL,
   CONSTRAINT pk_user_groups 
   PRIMARY KEY (gid, user_id)
);

create sequence s_user_groups;

create trigger t_user_groups before insert on user_groups
for each row
when (new.gid is null)
begin
 select s_user_groups.nextval into :new.gid from dual;
end;

--
-- Dumping data for table 'user_groups'
--

INSERT INTO user_groups VALUES ( '1', '1');

-- --------------------------------------------------------
--
-- Table structure for table 'users'
--

CREATE TABLE users (
   user_id number(11) NOT NULL PRIMARY KEY,
   name varchar2(255) NOT NULL,
   isadmin number(1) DEFAULT '0' NOT NULL,
   email varchar2(255),
   html number(1) DEFAULT '0' NOT NULL,
   remindS number(1) DEFAULT '0' NOT NULL,
   remindM number(1) DEFAULT '0' NOT NULL,
   remindT number(1) DEFAULT '0' NOT NULL,
   remindW number(1) DEFAULT '0' NOT NULL,
   remindR number(1) DEFAULT '0' NOT NULL,
   remindF number(1) DEFAULT '0' NOT NULL,
   remindA number(1) DEFAULT '0' NOT NULL,
   last_logged_in date
);

create sequence s_users;

create trigger t_users before insert on users
for each row
when (new.user_id is null)
begin
 select s_users.nextval into :new.user_id from dual;
end;

--
-- Dumping data for table 'users'
--

INSERT INTO users VALUES ( '1', 'root', '1', '', '0', '0', '0', '0', '0', '0', '0', '0', to_date('2001-01-01 01:00:00', 'YYYY-MM-DD HH:MI:SS'));