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
*/

insert into
        USERS_GROUPS
        (
        USER_ID,
        GROUP_ID
        )
values
        (
        1,
        1
        );

/*
        1 records written
*/
commit;
