appserver/tests/appserv-tests/devtests/ejb/bmp/readonly/sql/create_pointbase.sql

create table ReadOnlyStudent
(studentid varchar(15) constraint pk_ReadOnlystudent primary key not null,
name varchar(36));

insert into ReadOnlyStudent
values ('student0', 'Student_ID_0');
insert into ReadOnlyStudent
values ('student1', 'Student_ID_1');
insert into ReadOnlyStudent
values ('student2', 'Student_ID_2');
insert into ReadOnlyStudent
values ('student3', 'Student_ID_3');
insert into ReadOnlyStudent
values ('student4', 'Student_ID_4');
insert into ReadOnlyStudent
values ('student5', 'Student_ID_5');


create table ReadOnlyCourse
(courseid varchar(15) constraint pk_ReadOnlycourse primary key not null,
name varchar(36));

insert into ReadOnlyCourse
values ('course0', 'Course_ID_0');
insert into ReadOnlyCourse
values ('course1', 'Course_ID_1');
insert into ReadOnlyCourse
values ('course2', 'Course_ID_2');
insert into ReadOnlyCourse
values ('course3', 'Course_ID_3');
insert into ReadOnlyCourse
values ('course4', 'Course_ID_4');
insert into ReadOnlyCourse
values ('course5', 'Course_ID_5');

create table ReadOnlyEnrollment
(studentid varchar(15),
courseid varchar(15),
constraint fk_studentid
foreign key (studentid)
references ReadOnlystudent(studentid),
constraint fk_courseid
foreign key (courseid)
references ReadOnlycourse(courseid));