Java Reference
In-Depth Information
)
;
CREATE UNIQUE INDEX SQL_PERSON_EMAIL_INDEX ON
"FOREST"."PERSON"(EMAIL)
;
CREATE UNIQUE INDEX SQL_PERSON_ID_INDEX ON "FOREST"."PERSON"(ID)
;
CREATE TABLE "FOREST"."GROUPS"
(
ID int NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY
(START WITH 1, INCREMENT BY 1),
NAME varchar(50) NOT NULL,
DESCRIPTION varchar(300)
)
;
CREATE TABLE "FOREST"."PERSON_GROUPS"
(
GROUPS_ID int NOT NULL,
EMAIL varchar(45) NOT NULL
)
;
ALTER TABLE "FOREST"."PERSON_GROUPS"
ADD CONSTRAINT FK_PERSON_GROUPS_PERSON
FOREIGN KEY (EMAIL)
REFERENCES "FOREST"."PERSON"(EMAIL)
;
ALTER TABLE "FOREST"."PERSON_GROUPS"
ADD CONSTRAINT FK_PERSON_GROUPS_GROUPS
FOREIGN KEY (GROUPS_ID)
REFERENCES "FOREST"."GROUPS"(ID)
;
CREATE INDEX SQL_PERSONGROUPS_EMAIL_INDEX ON
"FOREST"."PERSON_GROUPS"(EMAIL)
;
CREATE INDEX SQL_PERSONGROUPS_ID_INDEX ON
"FOREST"."PERSON_GROUPS"(GROUPS_ID)
;
The Duke's Tutoring case study uses a singleton bean, ConfigBean , to create its
database tables, instead of using SQL commands.
2. Add user credentials to the database tables you created.
How you add user credentials to the database tables depends on the database that
you are using. Duke's Forest uses an Ant task. The create-tables Ant task for
Duke's Forest adds the user credentials to the tables created in the previous step:
Search WWH ::




Custom Search