INSERT INTO forum(forumname, password, defaultSortOrder, stylesheet)
VALUES ('Inls258', '1234', 'bydate', 'style1.xsl');

INSERT INTO forum(forumname, password, defaultSortOrder, stylesheet)
VALUES ('Web Database', '1234', 'bydate', 'style2.xsl');

INSERT INTO forum(forumname, password, defaultSortOrder, stylesheet)
VALUES ('Cplusplus', '1234', 'bythread', 'style1.xsl');

INSERT INTO forum(forumname, password, defaultSortOrder, stylesheet)
VALUES ('Java', '1234', 'bydate', 'style2.xsl');

INSERT INTO forum(forumname, password, defaultSortOrder, stylesheet)
VALUES ('Web Programming', '1234', 'byname', 'style1.xsl');

SELECT * FROM forum;

INSERT INTO interact(username, forumname)
VALUES ('w10', 'Inls258');

INSERT INTO interact(username,forumname)
VALUES ('w10', 'Web Database');

INSERT INTO interact(username, forumname)
VALUES ('w11', 'Web Database');

INSERT INTO interact(username,forumname)
VALUES ('w12', 'Web Database');

INSERT INTO interact(username, forumname)
VALUES ('w13', 'Inls258');

INSERT INTO interact(username,forumname)
VALUES ('w14', 'Java');

INSERT INTO interact(username, forumname)
VALUES ('w15', 'Java');

INSERT INTO interact(username,forumname)
VALUES ('w16', 'Java');

INSERT INTO interact(username, forumname)
VALUES ('w15', 'Inls258');

INSERT INTO interact(username,forumname)
VALUES ('w12', 'Web Programming');

INSERT INTO interact(username, forumname)
VALUES ('w13', 'Cpluplus');

SELECT * FROM interact;


INSERT INTO adm_moderator(username, name, email)
VALUES ('w10', 'Carl Hultman', 'ch@some.edu');

INSERT INTO adm_moderator(username, name, email)
VALUES ('w11', 'Dunn Stephen', 'ds@some.edu');

SELECT * FROM adm_moderator;



INSERT INTO usertable(username, password, role)
VALUES ('w10', '1111', 'administrator');

INSERT INTO usertable(username, password, role)
VALUES ('w11', '2222', 'moderator');

INSERT INTO usertable(username, password, role)
VALUES ('w12', '1233', 'user');

INSERT INTO usertable(username, password, role)
VALUES ('w13', '1233', 'user');

INSERT INTO usertable(username, password, role)
VALUES ('w14', '1233', 'user');

INSERT INTO usertable(username, password, role)
VALUES ('w15', '1233', 'user');

INSERT INTO usertable(username, password, role)
VALUES ('w16', '1233', 'user');

SELECT * FROM usertable;

INSERT INTO standard_user(username,email)
VALUES ('w12','tt@some.edu');

INSERT INTO standard_user(username,email)
VALUES ('w13','ee@some.edu');

INSERT INTO standard_user(username)
VALUES ('w14');

INSERT INTO standard_user(username)
VALUES ('w15');

INSERT INTO standard_user(username)
VALUES ('w16');

SELECT * FROM standard_user;


INSERT INTO message (MID, subject, author, body, datePosted, in_reply_to, forumname)
VALUES (NULL, 'enrollment', 'w10', 'How to get enrolled in class inls256', '2002-07-28', '', 'Inls258');

INSERT INTO message (MID, subject, author, body, datePosted, in_reply_to, forumname)
VALUES (NULL, 'textbook', 'w11', 'Does anyone know what textbooks are to be used?', '2002-08-14', '', 'Web Database');

INSERT INTO message (MID, subject, author, body, datePosted, in_reply_to, forumname)
VALUES (NULL, 'textbook', 'w12', 'No required textbook. But the professor provides many electronic resources', '2002-08-14', '2', 'Web Database');

INSERT INTO message (MID, subject, author, body, datePosted, in_reply_to, forumname)
VALUES (NULL, 'enrollment', 'w13', 'First you need to get your PIN from your advisor. Then just go to studentcentral.unc.edu.', '2002-07-29', '1', 'Inls258');

INSERT INTO message (MID, subject, author, body, datePosted, in_reply_to, forumname)
VALUES (NULL, 'Help', 'w14', 'Can any one take a look at my code?', '2002-08-22', '', 'Java');

INSERT INTO message (MID, subject, author, body, datePosted, in_reply_to, forumname)
VALUES (NULL, 'Help', 'w15', 'Where is the code', '2002-08-28', '5', 'Java');

INSERT INTO message (MID, subject, author, body, datePosted, in_reply_to, forumname)
VALUES (NULL, 'Help', 'w16', 'I have problem too', '2002-08-28', '5', 'Java');

INSERT INTO message (MID, subject, author, body, datePosted, in_reply_to, forumname)
VALUES (NULL, 'project proposal', 'w10', 'Project proposal', '2002-08-31', '', 'Web Database');

INSERT INTO message (MID, subject, author, body, datePosted, in_reply_to, forumname)
VALUES (NULL, 'presentation', 'w15', 'Who wants to partner with me for our presentation', '2002-09-01', '', 'Inls258');

INSERT INTO message (MID, subject, author, body, datePosted, in_reply_to, forumname)
VALUES (NULL, 'presentation', 'w16', 'Count me in', '2002-09-01', '9', 'Inls258');

SELECT * FROM message;