-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathbug_create.sql
More file actions
42 lines (35 loc) · 780 Bytes
/
bug_create.sql
File metadata and controls
42 lines (35 loc) · 780 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
protocol 'jdbc:derby:';
connect 'bug;create=true';
CREATE TABLE BUG (
DATE_MODIFIED DATE,
BUG_ID INTEGER NOT NULL UNIQUE,
COMP_ID INTEGER NOT NULL,
DATE_SUBMITTED DATE,
PEOPLE_ID INTEGER NOT NULL,
PR_ID INTEGER NOT NULL,
STATE_ID INTEGER,
SUBJECT CHAR(100),
WAS_READ INTEGER,
DESCRIPTION CHAR(100),
ORIGINATOR_ID INTEGER
);
CREATE TABLE COMPONENT (
COMP_ID INTEGER NOT NULL UNIQUE,
PEOPLE_ID INTEGER,
DESCRIPTION CHAR(30) NOT NULL
);
CREATE TABLE PEOPLE (
FIRSTNAME CHAR(30),
IS_ADMIN INTEGER,
LASTNAME CHAR(30),
PASSWORD CHAR(10),
PEOPLE_ID INTEGER NOT NULL UNIQUE
);
CREATE TABLE PRIORITY (
PR_ID INTEGER NOT NULL UNIQUE,
DESCRIPTION CHAR(30)
);
CREATE TABLE STATE (
STATE_ID INTEGER NOT NULL UNIQUE,
DESCRIPTION CHAR(30)
);