/* required.sql */
SET ECHO OFF
SET VERIFY OFF
SPOOL required.log

/* CONFIGURATION */

INSERT INTO CONFIGURATION ( SERVER_VERSION, SERVER_VERSION_DATE,
 MAC_CLIENT_VERSION, WIN_CLIENT_VERSION, READ_ONLY_ID,
 SAMPLE_QUEUE_ONLY, MPLATE_ID_UPDATABLE,
 PLATE_EXPIRATION_CHECK, LOG_UPLOADED_DUPLICATES)
 VALUES ( 'x','05-DEC-96',
 'y',
 'z', 0, 0, 0, 0,-1 );

/* GROUPS */

INSERT INTO GROUPS ( GROUP_CODE, GROUP_NAME, ROLE_NAME )
 VALUES ('ADMIN','Administration','');
INSERT INTO GROUPS ( GROUP_CODE, GROUP_NAME, ROLE_NAME )
 VALUES ('USER', 'General Users', '');

/* PRIVILEGES */
INSERT INTO PRIVILEGE ( PRIVILEGE_CODE, DESCRIPTION )
VALUES ( '0', 'No Access' );
INSERT INTO PRIVILEGE ( PRIVILEGE_CODE, DESCRIPTION )
VALUES ( '1', 'Read Only' );
INSERT INTO PRIVILEGE ( PRIVILEGE_CODE, DESCRIPTION )
VALUES ( '2', 'Read and Update' );

/* Administration */

INSERT INTO GROUP_PRIVILEGES ( GROUP_CODE, FORM_NAME, PRIVILEGE_CODE)
VALUES ( 'ADMIN','Users','2');
INSERT INTO GROUP_PRIVILEGES ( GROUP_CODE, FORM_NAME, PRIVILEGE_CODE)
VALUES ( 'ADMIN','Groups','2');
INSERT INTO GROUP_PRIVILEGES ( GROUP_CODE, FORM_NAME, PRIVILEGE_CODE)
VALUES ( 'ADMIN','Server Settings','2');
INSERT INTO GROUP_PRIVILEGES ( GROUP_CODE, FORM_NAME, PRIVILEGE_CODE)
VALUES ( 'ADMIN','Form Labels','2');
INSERT INTO GROUP_PRIVILEGES ( GROUP_CODE, FORM_NAME, PRIVILEGE_CODE)
VALUES ( 'ADMIN','Score Definitions','2');
INSERT INTO GROUP_PRIVILEGES ( GROUP_CODE, FORM_NAME, PRIVILEGE_CODE)
VALUES ( 'ADMIN','Transaction Auditing','2');

 
/* USERS */

INSERT INTO USERS ( LOGIN, NAME, PHONE, GROUP_CODE )
 VALUES ('MDLSCREEN','Administrator','','ADMIN');
INSERT INTO USERS ( LOGIN, NAME, PHONE, GROUP_CODE )
 VALUES ('UNDEF','Undefined user.','','USER');
 
COMMIT;

SPOOL OFF