alter session set nls_date_format = "dd-mm-yy hh24:mi"; insert into APPLICATIONDSS ( APPLICATIONDS_ID, APPLICATIONDSN, APPLICATIONDSDN, DATADIRECTORY, REALM_ID ) values ( 1, 'CFForums', 'Default Conference', NULL, 1 ); /* 1 records written */ insert into APPLICATIONS ( APPLICATION_ID, APPLICATIONNAME, DESCRIPTIVENAME, APPLICATIONTYPE, APPLICATIONDS_ID, ISUSERNAMEREQUIRED, ISUSERAPPROVALREQUIRED, ISSESSIONLOGINREQUIRED ) values ( 1, 'DeClub', 'Discussiebord van de club', 'Forums', 1, 0, 0, 0 ); /* 1 records written */ /* 0 records written */ insert into CENSORED ( CID, NASTY ) values ( 1, 'shit' ); insert into CENSORED ( CID, NASTY ) values ( 2, 'shitter' ); insert into CENSORED ( CID, NASTY ) values ( 3, 'shitty' ); insert into CENSORED ( CID, NASTY ) values ( 4, 'shits' ); insert into CENSORED ( CID, NASTY ) values ( 5, 'piss' ); insert into CENSORED ( CID, NASTY ) values ( 6, 'pisser' ); insert into CENSORED ( CID, NASTY ) values ( 7, 'pissy' ); insert into CENSORED ( CID, NASTY ) values ( 8, 'cunt' ); insert into CENSORED ( CID, NASTY ) values ( 9, 'cuntlicker' ); insert into CENSORED ( CID, NASTY ) values ( 10, 'cuntfucker' ); insert into CENSORED ( CID, NASTY ) values ( 11, 'fuck' ); insert into CENSORED ( CID, NASTY ) values ( 12, 'fucker' ); insert into CENSORED ( CID, NASTY ) values ( 13, 'fucking' ); insert into CENSORED ( CID, NASTY ) values ( 21, 'groningen' ); insert into CENSORED ( CID, NASTY ) values ( 22, 'Hoerenveen' ); /* 15 records written */ insert into CONFERENCES ( CID, CONFERENCE_ID, ISACTIVE, CONFERENCENAME, DESCRIPTIVENAME, ISUSERNAMEREQUIRED, ISUSERAPPROVALREQUIRED, ISSESSIONLOGINREQUIRED, ISMESSAGEAPPROVALREQUIRED, EXITURL, EXITTARGET, DEFAULTAGEFILTER, DISPLAYNEWTHREADSFIRST, ISADVMESSAGEDEFAULT, ISHTMLCODEWINDOWENABLED, ISFILEUPLOADENABLED, ISSEARCHENABLED, AREFRAMESENABLED, AREIMAGEBUTTONSENABLED, IMAGEDIRECTORY, BODYTEXTCOLOR, LABELTEXTCOLOR, BUTTONTEXTCOLOR, LINKCOLOR, VLINKCOLOR, ISBODYBACKGROUNDIMAGEENABLED, BODYBACKGROUNDCOLOR, BUTTONBACKGROUNDCOLOR, LABELBACKGROUNDCOLOR, FORMBACKGROUNDCOLOR, ISEMOTICONACTIVE, ISMSGCENSORED ) values ( 1, 1, -1, 'Test Conference', 'Test conference', 0, 0, 0, 0, 'http://www.hallelujah.com', '_top', 14, -1, 0, 0, 0, -1, -1, -1, 'lib1', '000000', '000000', '000000', '0000ff', '871f78', 0, 'ffffff', 'ffffcc', 'ffffff', 'ffffcc', -1, 0 ); insert into CONFERENCES ( CID, CONFERENCE_ID, ISACTIVE, CONFERENCENAME, DESCRIPTIVENAME, ISUSERNAMEREQUIRED, ISUSERAPPROVALREQUIRED, ISSESSIONLOGINREQUIRED, ISMESSAGEAPPROVALREQUIRED, EXITURL, EXITTARGET, DEFAULTAGEFILTER, DISPLAYNEWTHREADSFIRST, ISADVMESSAGEDEFAULT, ISHTMLCODEWINDOWENABLED, ISFILEUPLOADENABLED, ISSEARCHENABLED, AREFRAMESENABLED, AREIMAGEBUTTONSENABLED, IMAGEDIRECTORY, BODYTEXTCOLOR, LABELTEXTCOLOR, BUTTONTEXTCOLOR, LINKCOLOR, VLINKCOLOR, ISBODYBACKGROUNDIMAGEENABLED, BODYBACKGROUNDCOLOR, BUTTONBACKGROUNDCOLOR, LABELBACKGROUNDCOLOR, FORMBACKGROUNDCOLOR, ISEMOTICONACTIVE, ISMSGCENSORED ) values ( 26, 1, 1, 'DeClub', 'Discussiebord van de club', 0, 0, 0, 0, 'http://127.0.0.1', '_top', 14, 1, 0, 0, 0, 1, 1, 1, 'Default', '000000', '000000', '000000', '0000ff', '871f78', 0, 'ffffff', 'cccccc', 'ffffcc', 'ffffcc', 1, 0 ); /* 2 records written */ insert into CONFERENCES_FORUMS ( CFID, CONFERENCE_ID, FORUM_ID, ISACTIVE, PRECEDENCE ) values ( 1, 1, 1, -1, 1 ); insert into CONFERENCES_FORUMS ( CFID, CONFERENCE_ID, FORUM_ID, ISACTIVE, PRECEDENCE ) values ( 40, 1, 2, 0, NULL ); insert into CONFERENCES_FORUMS ( CFID, CONFERENCE_ID, FORUM_ID, ISACTIVE, PRECEDENCE ) values ( 37, 1, 3, 1, 3 ); insert into CONFERENCES_FORUMS ( CFID, CONFERENCE_ID, FORUM_ID, ISACTIVE, PRECEDENCE ) values ( 38, 1, 1, 1, 2 ); insert into CONFERENCES_FORUMS ( CFID, CONFERENCE_ID, FORUM_ID, ISACTIVE, PRECEDENCE ) values ( 39, 1, 2, 1, 1 ); insert into CONFERENCES_FORUMS ( CFID, CONFERENCE_ID, FORUM_ID, ISACTIVE, PRECEDENCE ) values ( 49, 1, 4, 1, 4 ); insert into CONFERENCES_FORUMS ( CFID, CONFERENCE_ID, FORUM_ID, ISACTIVE, PRECEDENCE ) values ( 50, 1, 4, 0, NULL ); /* 7 records written */ insert into FORUMS ( FORUM_ID, ISACTIVE, TITLE, FID ) values ( NULL, -1, 'Test messages', 1 ); insert into FORUMS ( FORUM_ID, ISACTIVE, TITLE, FID ) values ( 1, 1, 'Seizoen 2000/2001', 22 ); insert into FORUMS ( FORUM_ID, ISACTIVE, TITLE, FID ) values ( 3, 1, 'Divers', 26 ); insert into FORUMS ( FORUM_ID, ISACTIVE, TITLE, FID ) values ( 2, 1, 'Mededelingen', 27 ); insert into FORUMS ( FORUM_ID, ISACTIVE, TITLE, FID ) values ( 4, 1, 'testing', 47 ); /* 5 records written */ insert into FORUMS_GROUPS_RIGHTS ( FORUM_ID, GROUP_ID, RIGHTS, ISACTIVE ) values ( 1, 1, 2, -1 ); insert into FORUMS_GROUPS_RIGHTS ( FORUM_ID, GROUP_ID, RIGHTS, ISACTIVE ) values ( 1, 2, 1, -1 ); insert into FORUMS_GROUPS_RIGHTS ( FORUM_ID, GROUP_ID, RIGHTS, ISACTIVE ) values ( 1, 2, 2, 1 ); insert into FORUMS_GROUPS_RIGHTS ( FORUM_ID, GROUP_ID, RIGHTS, ISACTIVE ) values ( 2, 2, 1, 1 ); insert into FORUMS_GROUPS_RIGHTS ( FORUM_ID, GROUP_ID, RIGHTS, ISACTIVE ) values ( 3, 2, 1, 1 ); insert into FORUMS_GROUPS_RIGHTS ( FORUM_ID, GROUP_ID, RIGHTS, ISACTIVE ) values ( 4, 2, 1, 1 ); insert into FORUMS_GROUPS_RIGHTS ( FORUM_ID, GROUP_ID, RIGHTS, ISACTIVE ) values ( 5, 2, 1, 1 ); /* 7 records written */ insert into GROUPS ( GROUP_ID, GROUPNAME ) values ( 1, 'Administrators' ); insert into GROUPS ( GROUP_ID, GROUPNAME ) values ( 2, 'Everyone' ); /* 2 records written */ insert into MESSAGES ( MESSAGE_ID, ISACTIVE, ISAPPROVED, ISDELETED, THREAD_ID, PARENTMESSAGE_ID, REPLYLEVEL, USER_ID, AUTHOR, EMAIL, SUBJECT, ISMESSAGEPREFORMATED, ISNOTIFICATIONREQUESTED, ARETHREADPARTICIPANTSNOTIFIED, DATECREATED, DATEEDITED, PVT ) values ( 1, 1, 1, 0, 2, 0, 0, 1, 'Administrator', 'webmaster@halleluiah.com', 'first trial on Oracle 8', 0, 0, 0, '01-10-00 19:59', NULL, NULL ); insert into MESSAGES ( MESSAGE_ID, ISACTIVE, ISAPPROVED, ISDELETED, THREAD_ID, PARENTMESSAGE_ID, REPLYLEVEL, USER_ID, AUTHOR, EMAIL, SUBJECT, ISMESSAGEPREFORMATED, ISNOTIFICATIONREQUESTED, ARETHREADPARTICIPANTSNOTIFIED, DATECREATED, DATEEDITED, PVT ) values ( 2, 1, 1, 0, 2, 1, 1, 1, 'Administrator', 'martin@brekhof.nl', 'RE: first trial on Oracle 8', 0, 1, 1, '01-10-00 20:02', NULL, NULL ); insert into MESSAGES ( MESSAGE_ID, ISACTIVE, ISAPPROVED, ISDELETED, THREAD_ID, PARENTMESSAGE_ID, REPLYLEVEL, USER_ID, AUTHOR, EMAIL, SUBJECT, ISMESSAGEPREFORMATED, ISNOTIFICATIONREQUESTED, ARETHREADPARTICIPANTSNOTIFIED, DATECREATED, DATEEDITED, PVT ) values ( 3, 1, 1, 0, 3, 0, 0, 1, 'Administrator', 'martin@brekhof.nl', 'kijken of response te krijgen is', 0, 1, 1, '02-10-00 09:53', NULL, NULL ); insert into MESSAGES ( MESSAGE_ID, ISACTIVE, ISAPPROVED, ISDELETED, THREAD_ID, PARENTMESSAGE_ID, REPLYLEVEL, USER_ID, AUTHOR, EMAIL, SUBJECT, ISMESSAGEPREFORMATED, ISNOTIFICATIONREQUESTED, ARETHREADPARTICIPANTSNOTIFIED, DATECREATED, DATEEDITED, PVT ) values ( 5, 1, 1, 0, 5, 0, 0, 1, 'Administrator', 'martin@brekhof.nl', 'divers', 0, 0, 1, '03-10-00 14:34', '03-10-00 14:34', NULL ); insert into MESSAGES ( MESSAGE_ID, ISACTIVE, ISAPPROVED, ISDELETED, THREAD_ID, PARENTMESSAGE_ID, REPLYLEVEL, USER_ID, AUTHOR, EMAIL, SUBJECT, ISMESSAGEPREFORMATED, ISNOTIFICATIONREQUESTED, ARETHREADPARTICIPANTSNOTIFIED, DATECREATED, DATEEDITED, PVT ) values ( 4, 1, 1, 0, 4, 0, 0, 1, 'Administrator', 'martin@brekhof.nl', 'Dienstmededelingen', 0, 0, 1, '03-10-00 14:29', NULL, NULL ); /* 5 records written */ /* 0 records written */ insert into REALMS ( REALM_ID, REALMNAME, REALMDSN ) values ( 1, 'Default Realm', 'CFRealm' ); /* 1 records written */ insert into RIGHTS_GROUPS_APPLICATIONS ( GROUP_ID, APPLICATION_ID, RIGHTS, ISACTIVE ) values ( 1, 1, 2908, -1 ); insert into RIGHTS_GROUPS_APPLICATIONS ( GROUP_ID, APPLICATION_ID, RIGHTS, ISACTIVE ) values ( 2, 1, 2894, -1 ); insert into RIGHTS_GROUPS_APPLICATIONS ( GROUP_ID, APPLICATION_ID, RIGHTS, ISACTIVE ) values ( 2, 1, 2894, 1 ); /* 3 records written */ insert into RIGHTS_USERS_APPLICATIONS ( USER_ID, APPLICATION_ID, RIGHTS, DATECREATED ) values ( 1, 1, 2, '22-09-00 00:00' ); insert into RIGHTS_USERS_APPLICATIONS ( USER_ID, APPLICATION_ID, RIGHTS, DATECREATED ) values ( 3, 1, 2, '22-09-00 00:00' ); insert into RIGHTS_USERS_APPLICATIONS ( USER_ID, APPLICATION_ID, RIGHTS, DATECREATED ) values ( 4, 1, 2, '22-09-00 00:00' ); insert into RIGHTS_USERS_APPLICATIONS ( USER_ID, APPLICATION_ID, RIGHTS, DATECREATED ) values ( 2, 1, 2, '02-10-00 10:09' ); /* 4 records written */ insert into THREADS ( THREAD_ID, ISACTIVE, FORUM_ID, SUBJECT, MESSAGECOUNT, TIMELASTUPDATED ) values ( 1, -1, 1, 'Thread test', 1, '23-09-00 00:00' ); insert into THREADS ( THREAD_ID, ISACTIVE, FORUM_ID, SUBJECT, MESSAGECOUNT, TIMELASTUPDATED ) values ( 2, 1, 1, 'testing', 2, '01-10-00 20:02' ); insert into THREADS ( THREAD_ID, ISACTIVE, FORUM_ID, SUBJECT, MESSAGECOUNT, TIMELASTUPDATED ) values ( 3, 1, 1, 'response', 1, '02-10-00 09:53' ); insert into THREADS ( THREAD_ID, ISACTIVE, FORUM_ID, SUBJECT, MESSAGECOUNT, TIMELASTUPDATED ) values ( 4, 1, 2, 'Mededeling', 1, '03-10-00 14:29' ); insert into THREADS ( THREAD_ID, ISACTIVE, FORUM_ID, SUBJECT, MESSAGECOUNT, TIMELASTUPDATED ) values ( 5, 1, 3, 'Diverse berichten', 1, '03-10-00 14:34' ); /* 5 records written */ /* 0 records written */ /* 0 records written */ insert into USERS ( USER_ID, CFID, ST, USERNAME, DESCRIPTION, PASSWORD, EMAIL, DATECREATED, ROLE, URL, SITENAME, ADMIN, KOMMENT, CNT, LASTLOGIN ) values ( 1, 2, 40211959, 'Administrator', 'Administrator', 'password', 'martin@brekhof.nl', '23-09-00 00:00', NULL, NULL, NULL, 1, NULL, 2, '16-10-00 10:18' ); insert into USERS ( USER_ID, CFID, ST, USERNAME, DESCRIPTION, PASSWORD, EMAIL, DATECREATED, ROLE, URL, SITENAME, ADMIN, KOMMENT, CNT, LASTLOGIN ) values ( 2, 9, 92512598, NULL, NULL, NULL, NULL, '02-10-00 10:09', NULL, NULL, NULL, NULL, NULL, NULL, NULL ); insert into USERS ( USER_ID, CFID, ST, USERNAME, DESCRIPTION, PASSWORD, EMAIL, DATECREATED, ROLE, URL, SITENAME, ADMIN, KOMMENT, CNT, LASTLOGIN ) values ( 3, 10, 29894867, NULL, NULL, NULL, NULL, '02-10-00 13:10', NULL, NULL, NULL, NULL, NULL, NULL, NULL ); insert into USERS ( USER_ID, CFID, ST, USERNAME, DESCRIPTION, PASSWORD, EMAIL, DATECREATED, ROLE, URL, SITENAME, ADMIN, KOMMENT, CNT, LASTLOGIN ) values ( 4, 0, 0, 'Martin', 'Martin Brekhof', 'bhuijn', 'martin@brekhof.nl', '03-10-00 14:23', NULL, NULL, NULL, 0, NULL, NULL, NULL ); insert into USERS ( USER_ID, CFID, ST, USERNAME, DESCRIPTION, PASSWORD, EMAIL, DATECREATED, ROLE, URL, SITENAME, ADMIN, KOMMENT, CNT, LASTLOGIN ) values ( 5, 0, 0, 'MartinB', 'Martin Brekhof', 'bhuijn', 'martin@brekhof.nl', '15-10-00 21:42', 'Manager', 'http://www.brekhof.nl', 'BCH BV', 0, NULL, NULL, NULL ); /* 5 records written */ insert into USERS_GROUPS ( USER_ID, GROUP_ID ) values ( 1, 1 ); /* 1 records written */ commit;