/*
--TTV_RESOURCEGROUPQUEUEITEM
ALTER TABLE WFS.TTV_RESOURCEGROUPQUEUEITEM ADD (ALLOCATIONKEY VARCHAR2(255) NULL);

--PMM_PROGRESSITEM
ALTER TABLE WFS.PMM_PROGRESSITEM ADD (TokenID NUMBER NULL);
ALTER TABLE WFS.PMM_PROGRESSITEM ADD (CONSTRAINT PMM_PrgItem#JBPM_Token 
                                  			FOREIGN KEY (TOKENID) 
                                  			REFERENCES WFS.JBPM_TOKEN(ID_));

--PMM_Title
ALTER TABLE WFS.PMM_Title MODIFY(InternalLocation VARCHAR2(1024), MetaDataLocation VARCHAR2(1024));

--PMM_PROPERTIES
ALTER TABLE WFS.PMM_PROPERTIES MODIFY(Name VARCHAR2(32) NOT NULL, Value VARCHAR2(256));

-- DATA CHANGES

UPDATE	WFS.PMM_TITLELISTSTATUS 
SET  		Description='NEW' 
WHERE 	Description ='DRAFT';
select * from WFS.PMM_TITLELISTSTATUS;
*/


--2.8 RELEASE 3 to QA
	ALTER TABLE WFS.PMM_TitleMetaData MODIFY(Value VARCHAR(4000));

	INSERT INTO WFS.PMM_RuleType (ID_, NAME, TitlesAssociated, CreateDate, UpdateDate)
	VALUES(2,'OnDate',0,TO_DATE('30/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.PMM_RuleType (ID_, NAME, TitlesAssociated, CreateDate, UpdateDate)
	VALUES(3,'EveryNDays',0,TO_DATE('30/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.PMM_RuleType (ID_, NAME, TitlesAssociated, CreateDate, UpdateDate)
	VALUES(4,'OnDayEveryNWeeks',0,TO_DATE('30/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));

	INSERT INTO WFS.PMM_RuleTypeParameter (ID_, NAME ,RULETYPEID, Order_, DataTypeID, ISREQUIRED,CreateDate, UpdateDate)
	VALUES(5,'Date',2,1,1,1,TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM')); 
	INSERT INTO WFS.PMM_RuleTypeParameter (ID_, NAME ,RULETYPEID, Order_, DataTypeID, ISREQUIRED,CreateDate, UpdateDate)
	VALUES(6,'Time',2,2,2,0,TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM')); 
	INSERT INTO WFS.PMM_RuleTypeParameter (ID_, NAME ,RULETYPEID, Order_, DataTypeID, ISREQUIRED,CreateDate, UpdateDate)
	VALUES(7,'Number of days',3,1,3,1,TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM')); 
	INSERT INTO WFS.PMM_RuleTypeParameter (ID_, NAME ,RULETYPEID, Order_, DataTypeID, ISREQUIRED,CreateDate, UpdateDate)
	VALUES(8,'Time',3,2,2,0,TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM')); 
	INSERT INTO WFS.PMM_RuleTypeParameter (ID_, NAME ,RULETYPEID, Order_, DataTypeID, ISREQUIRED,CreateDate, UpdateDate)
	VALUES(9,'Day',4,1,6,1,TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM')); 
	INSERT INTO WFS.PMM_RuleTypeParameter (ID_, NAME ,RULETYPEID, Order_, DataTypeID, ISREQUIRED,CreateDate, UpdateDate)
	VALUES(10,'Number of weeks',4,2,3,1,TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM')); 
	INSERT INTO WFS.PMM_RuleTypeParameter (ID_, NAME ,RULETYPEID, Order_, DataTypeID, ISREQUIRED,CreateDate, UpdateDate)
	VALUES(11,'Time',4,3,2,0,TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM')); 

	INSERT INTO WFS.ttv_MONITOREDDRIVE (monitoreddriveid, name, description, path, internaldriveid, totalcapacity, warningthresholdpercent, errorthresholdpercent, currentbytesused, currentdrivestatusid,CreateDate, UpdateDate) 
	VALUES (WFS.ttv_MONITOREDDRIVE_SEQ.NEXTVAL, 'Unmapped Assets', 'Drive for unmapped assets in PMM', '/content/unmapped', 1, 100000000000, 50, 75, 0, 0, TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.ttv_MONITOREDDRIVE (monitoreddriveid, name, description, path, internaldriveid, totalcapacity, warningthresholdpercent, errorthresholdpercent, currentbytesused, currentdrivestatusid,CreateDate, UpdateDate) 
	VALUES (WFS.ttv_MONITOREDDRIVE_SEQ.NEXTVAL, 'Mapped Assets', 'Drive for mapped assets in PMM', '/content/mapped', 2, 100000000000, 50, 75, 0, 0, TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 11:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));
commit;

--2.8 Release 4.1 to QA

ALTER TABLE WFS.PMM_SERVICE MODIFY (Name varchar2(50));

-- 2.8 Release 5 to QA

ALTER TABLE WFS.PMM_PARTNER ADD isactive NUMBER(1,0) DEFAULT (1) NOT NULL;
ALTER TABLE WFS.PMM_SERVICE ADD isactive NUMBER(1,0) DEFAULT (1) NOT NULL;
desc WFS.PMM_PARTNER
desc WFS.PMM_SERVICE

-- 2.8 Release 6 to QA

ALTER TABLE wfs.pmm_service ADD lookupkey varchar2(25 char) NULL; 
ALTER TABLE wfs.pmm_partner ADD lookupkey varchar2(25 char) NULL;
update wfs.system_release set setting_value = '2.8.0.6';

----------------------------------------------------------------------------------------------
--*****************************Create QRTZ****************************************************
----------------------------------------------------------------------------------------------	
CREATE TABLE WFS.qrtz_job_details
  (
    JOB_NAME  VARCHAR2(80) NOT NULL,
    JOB_GROUP VARCHAR2(80) NOT NULL,
    DESCRIPTION VARCHAR2(120) NULL,
    JOB_CLASS_NAME   VARCHAR2(128) NOT NULL, 
    IS_DURABLE VARCHAR2(1) NOT NULL,
    IS_VOLATILE VARCHAR2(1) NOT NULL,
    IS_STATEFUL VARCHAR2(1) NOT NULL,
    REQUESTS_RECOVERY VARCHAR2(1) NOT NULL,
    JOB_DATA BLOB NULL,
    PRIMARY KEY (JOB_NAME,JOB_GROUP) USING INDEX TABLESPACE WFS_INDEX
)TABLESPACE WFS_DATA;
CREATE TABLE WFS.qrtz_job_listeners
  (
    JOB_NAME  VARCHAR2(80) NOT NULL, 
    JOB_GROUP VARCHAR2(80) NOT NULL,
    JOB_LISTENER VARCHAR2(80) NOT NULL,
    PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER) USING INDEX TABLESPACE WFS_INDEX,
    FOREIGN KEY (JOB_NAME,JOB_GROUP) 
	REFERENCES WFS.QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP)
)TABLESPACE WFS_DATA;
CREATE TABLE WFS.qrtz_triggers
  (
    TRIGGER_NAME VARCHAR2(80) NOT NULL,
    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
    JOB_NAME  VARCHAR2(80) NOT NULL, 
    JOB_GROUP VARCHAR2(80) NOT NULL,
    IS_VOLATILE VARCHAR2(1) NOT NULL,
    DESCRIPTION VARCHAR2(120) NULL,
    NEXT_FIRE_TIME NUMBER(13) NULL,
    PREV_FIRE_TIME NUMBER(13) NULL,
    PRIORITY NUMBER(13) NULL,
    TRIGGER_STATE VARCHAR2(16) NOT NULL,
    TRIGGER_TYPE VARCHAR2(8) NOT NULL,
    START_TIME NUMBER(13) NOT NULL,
    END_TIME NUMBER(13) NULL,
    CALENDAR_NAME VARCHAR2(80) NULL,
    MISFIRE_INSTR NUMBER(2) NULL,
    JOB_DATA BLOB NULL,
    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP) USING INDEX TABLESPACE WFS_INDEX,
    FOREIGN KEY (JOB_NAME,JOB_GROUP) 
	REFERENCES WFS.QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP) 
)TABLESPACE WFS_DATA;
CREATE TABLE WFS.qrtz_simple_triggers
  (
    TRIGGER_NAME VARCHAR2(80) NOT NULL,
    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
    REPEAT_COUNT NUMBER(7) NOT NULL,
    REPEAT_INTERVAL NUMBER(12) NOT NULL,
    TIMES_TRIGGERED NUMBER(7) NOT NULL,
    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP) USING INDEX TABLESPACE WFS_INDEX,
    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
	REFERENCES WFS.QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
)TABLESPACE WFS_DATA;
CREATE TABLE WFS.qrtz_cron_triggers
  (
    TRIGGER_NAME VARCHAR2(80) NOT NULL,
    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
    CRON_EXPRESSION VARCHAR2(80) NOT NULL,
    TIME_ZONE_ID VARCHAR2(80),
    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP) USING INDEX TABLESPACE WFS_INDEX,
    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
	REFERENCES WFS.QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
)TABLESPACE WFS_DATA;
CREATE TABLE WFS.qrtz_blob_triggers
  (
    TRIGGER_NAME VARCHAR2(80) NOT NULL,
    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
    BLOB_DATA BLOB NULL,
    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP) USING INDEX TABLESPACE WFS_INDEX,
    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
        REFERENCES WFS.QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
)TABLESPACE WFS_DATA;
CREATE TABLE WFS.qrtz_trigger_listeners
  (
    TRIGGER_NAME  VARCHAR2(80) NOT NULL, 
    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
    TRIGGER_LISTENER VARCHAR2(80) NOT NULL,
    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER) USING INDEX TABLESPACE WFS_INDEX,
    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
	REFERENCES WFS.QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
)TABLESPACE WFS_DATA;
CREATE TABLE WFS.qrtz_calendars
  (
    CALENDAR_NAME  VARCHAR2(80) NOT NULL, 
    CALENDAR BLOB NOT NULL,
    PRIMARY KEY (CALENDAR_NAME) USING INDEX TABLESPACE WFS_INDEX
)TABLESPACE WFS_DATA;
CREATE TABLE WFS.qrtz_paused_trigger_grps
  (
    TRIGGER_GROUP  VARCHAR2(80) NOT NULL, 
    PRIMARY KEY (TRIGGER_GROUP) USING INDEX TABLESPACE WFS_INDEX
)TABLESPACE WFS_DATA;
CREATE TABLE WFS.qrtz_fired_triggers 
  (
    ENTRY_ID VARCHAR2(95) NOT NULL,
    TRIGGER_NAME VARCHAR2(80) NOT NULL,
    TRIGGER_GROUP VARCHAR2(80) NOT NULL,
    IS_VOLATILE VARCHAR2(1) NOT NULL,
    INSTANCE_NAME VARCHAR2(80) NOT NULL,
    FIRED_TIME NUMBER(13) NOT NULL,
    PRIORITY NUMBER(13) NOT NULL,
    STATE VARCHAR2(16) NOT NULL,
    JOB_NAME VARCHAR2(80) NULL,
    JOB_GROUP VARCHAR2(80) NULL,
    IS_STATEFUL VARCHAR2(1) NULL,
    REQUESTS_RECOVERY VARCHAR2(1) NULL,
    PRIMARY KEY (ENTRY_ID) USING INDEX TABLESPACE WFS_INDEX
)TABLESPACE WFS_DATA;
CREATE TABLE WFS.qrtz_scheduler_state 
  (
    INSTANCE_NAME VARCHAR2(80) NOT NULL,
    LAST_CHECKIN_TIME NUMBER(13) NOT NULL,
    CHECKIN_INTERVAL NUMBER(13) NOT NULL,
    PRIMARY KEY (INSTANCE_NAME) USING INDEX TABLESPACE WFS_INDEX
)TABLESPACE WFS_DATA;
CREATE TABLE WFS.qrtz_locks
  (
    LOCK_NAME  VARCHAR2(40) NOT NULL, 
    PRIMARY KEY (LOCK_NAME) USING INDEX TABLESPACE WFS_INDEX
)TABLESPACE WFS_DATA;
INSERT INTO wfs.qrtz_locks values('TRIGGER_ACCESS');
INSERT INTO wfs.qrtz_locks values('JOB_ACCESS');
INSERT INTO wfs.qrtz_locks values('CALENDAR_ACCESS');
INSERT INTO wfs.qrtz_locks values('STATE_ACCESS');
INSERT INTO wfs.qrtz_locks values('MISFIRE_ACCESS');
commit;
create index idx_qrtz_j_req_recovery on WFS.qrtz_job_details(REQUESTS_RECOVERY)TABLESPACE WFS_INDEX;
create index idx_qrtz_t_next_fire_time ON WFS.qrtz_triggers(NEXT_FIRE_TIME)TABLESPACE WFS_INDEX;
create index idx_qrtz_t_state ON WFS.qrtz_triggers(TRIGGER_STATE)TABLESPACE WFS_INDEX;
create index idx_qrtz_t_nft_st ON WFS.qrtz_triggers(NEXT_FIRE_TIME,TRIGGER_STATE)TABLESPACE WFS_INDEX;
create index idx_qrtz_t_volatile ON WFS.qrtz_triggers(IS_VOLATILE)TABLESPACE WFS_INDEX;
create index idx_qrtz_ft_trig_name ON WFS.qrtz_fired_triggers(TRIGGER_NAME)TABLESPACE WFS_INDEX;
create index idx_qrtz_ft_trig_group ON WFS.qrtz_fired_triggers(TRIGGER_GROUP)TABLESPACE WFS_INDEX;
create index idx_qrtz_ft_trig_nm_gp ON WFS.qrtz_fired_triggers(TRIGGER_NAME,TRIGGER_GROUP)TABLESPACE WFS_INDEX;
create index idx_qrtz_ft_trig_volatile ON WFS.qrtz_fired_triggers(IS_VOLATILE)TABLESPACE WFS_INDEX;
create index idx_qrtz_ft_trig_inst_name ON WFS.qrtz_fired_triggers(INSTANCE_NAME)TABLESPACE WFS_INDEX;
create index idx_qrtz_ft_job_name ON WFS.qrtz_fired_triggers(JOB_NAME)TABLESPACE WFS_INDEX;
create index idx_qrtz_ft_job_group ON WFS.qrtz_fired_triggers(JOB_GROUP)TABLESPACE WFS_INDEX;
create index idx_qrtz_ft_job_stateful ON WFS.qrtz_fired_triggers(IS_STATEFUL)TABLESPACE WFS_INDEX;
create index idx_qrtz_ft_job_req_recovery ON WFS.qrtz_fired_triggers(REQUESTS_RECOVERY)TABLESPACE WFS_INDEX;
----------------------------------------------------------------------------------------------
--**************************Recreate authorization********************************************
----------------------------------------------------------------------------------------------	

DECLARE
	err_msg varchar2(500);
BEGIN
	delete from install_table;
	COMMIT;
	EXECUTE IMMEDIATE 'CREATE TABLE WFS.TTV_PERMISSION_OLD ( 
          PERMISSIONID	NUMBER NOT NULL,
          NAME        	VARCHAR2(50) NOT NULL,
          SECTIONNAME 	VARCHAR2(50) NULL,
          MODULEID    	NUMBER NOT NULL)';
	
	
	EXECUTE IMMEDIATE 'INSERT INTO WFS.TTV_PERMISSION_OLD
	SELECT PERMISSIONID, NAME, SECTIONNAME, MODULEID FROM WFS.TTV_PERMISSION';	
	commit;
	EXECUTE IMMEDIATE 'ALTER TABLE WFS.TTV_BIGROLEPERMISSION DISABLE CONSTRAINT FK_TTV_BIGROLEPERMISSION_PERM';
	DELETE FROM WFS.TTV_MENUITEM;
	DELETE FROM WFS.TTV_ACTION;
	DELETE FROM WFS.TTV_PERMISSION;
	DELETE FROM wfs.TTV_MODULE;
	DELETE FROM wfs.TTV_BIGROLEPERMISSION WHERE BIGROLE = 'Admin';

	--TTV_MODULE
	INSERT INTO WFS.TTV_MODULE(MODULEID, NAME, CREATEDATE, UPDATEDATE)
	VALUES(1, 'Home', TO_DATE('12/08/2006 12:05:13 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('12/08/2006 12:05:13 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MODULE(MODULEID, NAME, CREATEDATE, UPDATEDATE)
	VALUES(2, 'Work Order Management', TO_DATE('12/08/2006 12:05:28 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('12/08/2006 12:05:40 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MODULE(MODULEID, NAME, CREATEDATE, UPDATEDATE)
	VALUES(3, 'Resource Management', TO_DATE('12/08/2006 12:05:55 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('12/08/2006 12:05:55 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MODULE(MODULEID, NAME, CREATEDATE, UPDATEDATE)
	VALUES(4, 'User Management', TO_DATE('12/08/2006 01:13:38 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('12/08/2006 01:13:38 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MODULE(MODULEID, NAME, CREATEDATE, UPDATEDATE)
	VALUES(5, 'Role Management', TO_DATE('12/08/2006 01:13:48 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('12/08/2006 01:13:48 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MODULE(MODULEID, NAME, CREATEDATE, UPDATEDATE)
	VALUES(6, 'User Tasks', TO_DATE('12/08/2006 01:14:01 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('18/08/2006 07:24:38 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MODULE(MODULEID, NAME, CREATEDATE, UPDATEDATE)
	VALUES(7, 'Monitoring', TO_DATE('12/08/2006 01:14:10 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('18/08/2006 07:24:43 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MODULE(MODULEID, NAME, CREATEDATE, UPDATEDATE)
	VALUES(8, 'Reporting', TO_DATE('17/08/2006 11:12:39 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('18/08/2006 07:24:22 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MODULE(MODULEID, NAME, CREATEDATE, UPDATEDATE)
	VALUES(9, 'Plugins', TO_DATE('15/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('15/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MODULE(ModuleID, NAME, CREATEDATE, UPDATEDATE)
	VALUES(10, 'Schedules', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MODULE(ModuleID, NAME, CREATEDATE, UPDATEDATE)
	VALUES(11, 'Partners', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MODULE(ModuleID, NAME, CREATEDATE, UPDATEDATE)
	VALUES(12, 'Titles', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MODULE(ModuleID, NAME, CREATEDATE, UPDATEDATE)
	VALUES(13, 'Services', TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.ttv_module (moduleid, name, CREATEDATE, UPDATEDATE) 
	VALUES (14, 'Jobs', TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	--TTV_PERMISSION
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(1, 'Dashboard', 'DEFAULT', 1, TO_DATE('12/08/2006 02:13:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('18/08/2006 09:35:13 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(2, 'View', 'View Work Orders', 2, TO_DATE('12/08/2006 02:13:21 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('12/08/2006 02:13:21 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(3, 'Create', 'Create Work Orders', 2, TO_DATE('12/08/2006 02:13:43 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('12/08/2006 02:13:43 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(4, 'Modify', 'Update Work Orders', 2, TO_DATE('12/08/2006 02:33:50 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('12/08/2006 02:33:50 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(5, 'Delete', 'Delete Work Orders', 2, TO_DATE('12/08/2006 03:08:35 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('12/08/2006 03:08:35 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(6, 'View', 'View Resources', 3, TO_DATE('14/08/2006 10:24:23 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('14/08/2006 10:24:23 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(7, 'Create', 'Create Resources', 3, TO_DATE('14/08/2006 10:24:40 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('14/08/2006 10:24:40 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(8, 'Modify', 'Update Resources', 3, TO_DATE('14/08/2006 10:24:57 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('14/08/2006 10:24:57 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(9, 'Delete', 'Delete Resources', 3, TO_DATE('14/08/2006 10:25:16 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('14/08/2006 10:25:16 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(10, 'View', 'View User List', 4, TO_DATE('18/08/2006 06:43:56 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('18/08/2006 06:43:56 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(11, 'Create', 'Create User', 4, TO_DATE('18/08/2006 06:43:56 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('18/08/2006 06:43:56 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(12, 'Modify', 'Update User', 4, TO_DATE('18/08/2006 06:43:56 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('18/08/2006 06:44:05 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(13, 'Delete', 'Delete User', 4, TO_DATE('18/08/2006 06:43:56 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('18/08/2006 06:43:56 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(14, 'View', 'View Roles', 5, TO_DATE('18/08/2006 06:45:27 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('18/08/2006 06:45:27 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(15, 'Create', 'Create Role', 5, TO_DATE('18/08/2006 06:45:27 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('18/08/2006 06:45:27 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(16, 'Modify', 'Update Role', 5, TO_DATE('18/08/2006 06:45:27 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('18/08/2006 06:45:27 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(17, 'Delete', 'Delete Role', 5, TO_DATE('18/08/2006 06:45:27 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('18/08/2006 06:45:27 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(18, 'Perform Task', 'Perform Task', 6, TO_DATE('18/08/2006 09:36:39 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('18/08/2006 09:36:39 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(19, 'Perform Other''s Tasks', 'Perform Tasks', 6, TO_DATE('18/08/2006 09:36:39 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('18/08/2006 09:36:39 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(20, 'View', 'View Alerts', 7, TO_DATE('29/08/2006 06:08:31 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('29/08/2006 06:08:31 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(21, 'Create', 'Create Alerts', 7, TO_DATE('29/08/2006 06:08:55 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('29/08/2006 06:08:55 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(22, 'Modify', 'Modify Alerts', 7, TO_DATE('29/08/2006 06:09:23 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('29/08/2006 06:09:23 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(23, 'Delete', 'Delete Alerts', 7, TO_DATE('29/08/2006 08:36:02 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('29/08/2006 08:36:02 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(24, 'View', 'View Report', 8, TO_DATE('20/10/2006 08:36:02 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('20/10/2006 08:36:02 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PERMISSIONID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(25, 'View', 'Plugins', 9, TO_DATE('15/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('15/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PermissionID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(26, 'View', 'View Schedules', 10, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_PERMISSION(PermissionID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(27, 'Create', 'Create Schedules', 10, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_PERMISSION(PermissionID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(28, 'Modify', 'Modify Schedules', 10, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_PERMISSION(PermissionID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(29, 'Delete', 'Delete Schedules', 10, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_PERMISSION(PermissionID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(30, 'Approve', 'Approve Schedules', 10, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_PERMISSION(PermissionID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(31, 'View', 'View Partners', 11, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_PERMISSION(PermissionID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(32, 'Create', 'Create Partners', 11, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_PERMISSION(PermissionID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(33, 'Modify', 'Modify Partners', 11, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_PERMISSION(PermissionID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(34, 'Delete', 'Delete Partners', 11, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_PERMISSION(PermissionID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(35, 'View', 'View Titles', 12, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_PERMISSION(PermissionID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(36, 'Create', 'Create Titles', 12, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_PERMISSION(PermissionID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(37, 'Modify', 'Modify Titles', 12, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_PERMISSION(PermissionID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(38, 'Delete', 'Delete Titles', 12, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_PERMISSION(PermissionID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(39, 'View', 'View Services', 13, TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_PERMISSION(PermissionID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(40, 'Create', 'Create Services', 13, TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_PERMISSION(PermissionID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(41, 'Modify', 'Modify Services', 13, TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_PERMISSION(PermissionID, NAME, SECTIONNAME, MODULEID, CREATEDATE, UPDATEDATE)
	VALUES(42, 'Delete', 'Delete Services', 13, TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.ttv_permission(permissionid, name, sectionname, moduleid, CREATEDATE, UPDATEDATE)
	VALUES(43, 'View', 'View Jobs', 14, TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.ttv_permission(permissionid, name, sectionname, moduleid, CREATEDATE, UPDATEDATE)
	VALUES(44, 'Create', 'Create Jobs', 14, TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.ttv_permission(permissionid, name, sectionname, moduleid, CREATEDATE, UPDATEDATE)
	VALUES(45, 'Modify', 'Modify Jobs', 14, TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.ttv_permission(permissionid, name, sectionname, moduleid, CREATEDATE, UPDATEDATE)
	VALUES(46, 'Delete', 'Delete Jobs', 14, TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.ttv_permission (permissionid, name, sectionname, moduleid, CREATEDATE, UPDATEDATE) 
	VALUES(47, 'Approve', 'Approve Titles', 12, TO_DATE('26/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('26/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM')) ;
		
	--TTV_BIGROLEPERMISSION
		INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(1, 1, 'Admin', TO_DATE('12/08/2006 02:46:17 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(2, 2, 'Admin', TO_DATE('12/08/2006 02:46:58 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(3, 3, 'Admin', TO_DATE('12/08/2006 02:46:58 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(4, 4, 'Admin', TO_DATE('12/08/2006 02:46:58 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(5, 5, 'Admin', TO_DATE('12/08/2006 04:41:44 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(6, 6, 'Admin', TO_DATE('14/08/2006 11:00:01 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(7, 7, 'Admin', TO_DATE('14/08/2006 11:00:14 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(8, 8, 'Admin', TO_DATE('21/08/2006 09:39:54 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(9, 9, 'Admin', TO_DATE('21/08/2006 09:39:54 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(10, 10, 'Admin', TO_DATE('25/08/2006 07:54:21 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(11, 11, 'Admin', TO_DATE('25/08/2006 07:55:23 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(12, 12, 'Admin', TO_DATE('25/08/2006 07:55:29 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(13, 13, 'Admin', TO_DATE('25/08/2006 07:55:35 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(14, 14, 'Admin', TO_DATE('25/08/2006 07:55:41 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(15, 15, 'Admin', TO_DATE('25/08/2006 07:55:53 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(16, 16, 'Admin', TO_DATE('25/08/2006 07:56:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(17, 17, 'Admin', TO_DATE('25/08/2006 07:56:07 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(25, 25, 'Admin', TO_DATE('15/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(300, 18, 'Admin', TO_DATE('29/08/2006 01:47:46 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(301, 19, 'Admin', TO_DATE('29/08/2006 01:48:08 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(302, 20, 'Admin', TO_DATE('29/08/2006 06:46:23 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(303, 21, 'Admin', TO_DATE('29/08/2006 06:46:39 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(305, 22, 'Admin', TO_DATE('29/08/2006 06:48:15 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(319, 23, 'Admin', TO_DATE('30/08/2006 10:26:35 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE)
	VALUES(441, 24, 'Admin', TO_DATE('20/10/2006 10:26:35 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 26, 'Admin', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 27, 'Admin', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 28, 'Admin', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 29, 'Admin', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 30, 'Admin', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 31, 'Admin', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 32, 'Admin', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 33, 'Admin', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 34, 'Admin', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 35, 'Admin', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 36, 'Admin', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 37, 'Admin', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 38, 'Admin', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 39, 'Admin', TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 40, 'Admin', TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 41, 'Admin', TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 42, 'Admin', TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL,43,'Admin', TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL,44,'Admin', TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL,45,'Admin', TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_BIGROLEPERMISSION(BIGROLEPERMISSIONID, PERMISSIONID, BIGROLE, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL,46,'Admin', TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.ttv_bigrolepermission (bigrolepermissionid, permissionid, bigrole, CREATEDATE) 
	VALUES(WFS.TTV_BigRolePermission_SEQ.NEXTVAL, 47, 'Admin', TO_DATE('26/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	--TTV_MENUITEM
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(1, 'TabbedHome', 1, TO_DATE('12/08/2006 02:32:21 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('12/08/2006 02:32:21 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(2, 'TabbedWorkOrders', 2, TO_DATE('12/08/2006 02:32:33 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('12/08/2006 02:32:33 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(3, 'TabbedWorkOrderSearch', 2, TO_DATE('12/08/2006 02:33:11 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('12/08/2006 02:33:11 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(4, 'TabbedWorkOrdersCreate', 3, TO_DATE('12/08/2006 02:33:30 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('12/08/2006 02:33:30 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(5, 'TabbedWorkOrdersPauseAllResumeAll', 4, TO_DATE('12/08/2006 02:34:37 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('12/08/2006 02:34:37 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(6, 'TabbedResources', 6, TO_DATE('14/08/2006 10:58:31 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('14/08/2006 10:58:31 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(7, 'TabbedList', 6, TO_DATE('14/08/2006 10:59:08 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('14/08/2006 10:59:08 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(8, 'TabbedCreate', 7, TO_DATE('15/08/2006 11:31:48 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('15/08/2006 11:31:48 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(9, 'TabbedModify', 7, TO_DATE('15/08/2006 11:31:48 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('15/08/2006 11:31:48 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(10, 'TabbedUsers', 10, TO_DATE('25/08/2006 07:41:09 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('25/08/2006 07:41:09 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(11, 'TabbedUsersView', 10, TO_DATE('25/08/2006 07:44:07 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('25/08/2006 07:44:07 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(12, 'TabbedUsersCreate', 11, TO_DATE('25/08/2006 07:45:04 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('25/08/2006 07:45:04 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(13, 'TabbedUsersModify', 12, TO_DATE('25/08/2006 07:45:32 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('25/08/2006 07:45:32 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(14, 'TabbedRoles', 14, TO_DATE('25/08/2006 07:50:19 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('25/08/2006 07:50:19 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(15, 'TabbedRolesView', 14, TO_DATE('25/08/2006 07:50:53 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('25/08/2006 07:50:53 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(16, 'TabbedRolesCreate', 15, TO_DATE('25/08/2006 07:51:20 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('25/08/2006 07:51:20 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(17, 'TabbedRolesModify', 16, TO_DATE('25/08/2006 07:51:47 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('25/08/2006 07:51:47 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(18, 'TabbedAlertList', 20, TO_DATE('29/08/2006 06:12:11 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('29/08/2006 06:12:11 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(19, 'TabbedAlertsCreate', 21, TO_DATE('29/08/2006 06:35:58 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('29/08/2006 06:35:58 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(20, 'TabbedAlertPatternList', 20, TO_DATE('29/08/2006 06:38:55 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('29/08/2006 06:38:55 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(21, 'TabbedQueue', 6, TO_DATE('25/08/2006 05:42:12 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('25/08/2006 05:42:12 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(22, 'TabbedAlertPatternCreate', 21, TO_DATE('29/08/2006 06:39:18 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('29/08/2006 06:39:18 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(23, 'TabbedAlertHistory', 20, TO_DATE('29/08/2006 06:39:43 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('29/08/2006 06:39:43 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(24, 'TabbedMonitoring', 20, TO_DATE('29/08/2006 07:15:35 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('29/08/2006 07:15:35 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(25, 'TabbedAlertsModify', 22, TO_DATE('29/08/2006 08:39:01 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('29/08/2006 08:39:01 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(26, 'TabbedAlertPatternModify', 22, TO_DATE('29/08/2006 09:04:17 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('29/08/2006 09:04:17 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(27, 'TabbedWorkOrdersTemplateDetails', 2, TO_DATE('03/10/2006 07:12:48 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('03/10/2006 07:12:48 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(28, 'TabbedUserTasks', 18, TO_DATE('03/10/2006 07:12:48 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('03/10/2006 07:12:48 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(29, 'TabbedUserTasksList', 19, TO_DATE('03/10/2006 07:12:48 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('03/10/2006 07:12:48 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(30, 'TabbedRepositoryBrowsing', 20, TO_DATE('14/10/2006 01:19:39 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('14/10/2006 01:19:39 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(41, 'TabbedReporting', 24, TO_DATE('14/10/2006 01:19:39 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('14/10/2006 01:19:39 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(42, 'TabbedReportingList', 24, TO_DATE('14/10/2006 01:19:39 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('14/10/2006 01:19:39 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES(43, 'TabbedPlugins', 25, TO_DATE('15/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('15/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));  
	
	INSERT INTO WFS.TTV_MENUITEM (MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES (44, 'TabbedResourceTypePlugins',25, TO_DATE('30/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM (MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES (45,'TabbedResourceGroupPlugins',25, TO_DATE('30/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM (MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE)
	VALUES (46,'TabbedSelectorKeysDetails',2, TO_DATE('30/11/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/11/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	VALUES(47, 'TabbedPMMSchedules', 26, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	VALUES(48, 'TabbedPMMSchedulesView', 26, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	VALUES(49, 'TabbedPMMSchedulesCreate', 27, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	VALUES(50, 'TabbedPMMSchedulesModify_', 28, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('19/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	VALUES(51, 'TabbedPMMPartners', 31, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	VALUES(52, 'TabbedPMMPartnersView', 31, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	VALUES(53, 'TabbedPMMPartnersCreate', 32, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	VALUES(54, 'TabbedPMMPartnersModify', 33, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	VALUES(55, 'TabbedPMMTitles', 35, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	VALUES(56, 'TabbedPMMTitlesView_', 35, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	VALUES(57, 'TabbedPMMTitlesInternalSearch', 35, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	VALUES(58, 'TabbedPMMTitlesCreate', 36, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	VALUES(59, 'TabbedPMMTitlesModify_', 37, TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	VALUES(60, 'TabbedPMMPartnersGeneral', 31, TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	VALUES(61, 'TabbedPMMPartnersJobs', 43, TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	VALUES(62, 'TabbedPMMPartnersSchedules', 26, TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	 VALUES(63, 'TabbedPMMServices',39 , TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	 VALUES(64, 'TabbedPMMServicesView', 39, TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	 VALUES(65, 'TabbedPMMServicesCreate', 40, TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	 VALUES(67, 'TabbedPMMServicesModify', 41, TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	 VALUES(68, 'TabbedPMMServicesPartners', 31, TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	 VALUES(69, 'TabbedPMMServicesGeneral', 39, TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	 VALUES(70, 'TabbedPMMServicesJobs',43 , TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('09/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	 VALUES(71, 'TabbedPMMServicesSchedules',26 , TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	 VALUES(72, 'TabbedPMMPartnersServices', 39, TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	 VALUES(73, 'TabbedPMMTitlesExternalSearch', 35, TO_DATE('30/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	 VALUES(74, 'TabbedPMMTitleProperties', 35, TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_MENUITEM(MENUITEMID, NAME, PERMISSIONID, CREATEDATE, UPDATEDATE) 
	 VALUES(75, 'TabbedPMMTitleActivity', 35, TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));

	--TTV_ACTION
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(1, 'View Dashboard', 1, 'dashboardview.do?method=getDashBoard', TO_DATE('12/08/2006 02:14:22 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(2, 'List Work Orders', 2, 'workOrderDetailsAction.do?method=getWorkOrdersBySearch', TO_DATE('12/08/2006 02:14:44 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(3, 'List Work Orders by Status', 2, 'workOrderSearch.do?method=getWorkOrderSearchPage', TO_DATE('12/08/2006 02:15:11 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(4, 'Create Work Order', 3, 'wfsprocess.do?method=createWorkOrder', TO_DATE('12/08/2006 02:15:33 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(5, 'Pause Work Order', 4, 'workorderview.do?method=pauseWorkOrder', TO_DATE('12/08/2006 02:35:23 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(6, 'Resume Work Order', 4, 'workorderview.do?method=resumeWorkOrder', TO_DATE('12/08/2006 02:36:02 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(7, 'Cancel Work Order', 4, 'workorderview.do?method=cancelWorkOrder', TO_DATE('12/08/2006 02:36:30 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(8, 'Change Work Order Priority', 4, 'workorderview.do?method=saveWorkOrder', TO_DATE('12/08/2006 02:36:46 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(9, 'Pause All Work Orders', 4, 'pauseResumeAction.do?method=pauseAllWorkOrder', TO_DATE('12/08/2006 02:37:14 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(10, 'Resume All Work Orders', 4, 'pauseResumeAction.do?method=resumeAllWorkOrder', TO_DATE('12/08/2006 02:37:27 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(11, 'Delete Work Order', 5, 'workorderview.do?method=deleteWorkOrder', TO_DATE('17/08/2006 11:25:38 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(12, 'Dashboard Internal', 1, 'setPermissions.do', TO_DATE('19/08/2006 02:27:02 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(13, 'View Work Order', 2, 'workorderview.do?method=getWorkOrder', TO_DATE('19/08/2006 03:23:52 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(14, 'Create Work Order Page', 3, 'wfsprocess.do?method=createWorkOrderSetup', TO_DATE('19/08/2006 03:24:55 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(15, 'Pause and Resume All Login', 4, 'pauseResumeAction.do?method=goToLogin', TO_DATE('19/08/2006 03:30:18 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(16, 'View Work Order Steps', 2, 'workOrderTask.do?method=getWorkOrderTask', TO_DATE('19/08/2006 03:36:02 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(17, 'Search Work Orders Page', 2, 'workOrderSearch.do?method=getWorkOrderSearchPage', TO_DATE('19/08/2006 04:16:35 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('22/08/2006 01:24:42 AM','DD/MM/YYYY HH12:MI:SS PM')); 
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(18, 'Resume Selected Work Orders', 4, 'workOrderDetailsAction.do?method=resumeSelectedWorkOrders', TO_DATE('19/08/2006 04:18:13 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM')); 
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(19, 'Pause Selected Work Orders', 4, 'workOrderDetailsAction.do?method=pauseSelectedWorkOrders', TO_DATE('19/08/2006 04:18:13 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 08:44:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(20, 'View Resources', 6, 'resourcesListManagement.do?method=getResourcesList', TO_DATE('21/08/2006 09:14:34 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 09:14:34 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(21, 'View Resource', 6, 'resourceManagement.do?method=getResourceDetails', TO_DATE('21/08/2006 09:14:34 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 09:14:34 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(22, 'View Resource Type', 7, 'resourceManagement.do?method=getResourceTypeDetails', TO_DATE('21/08/2006 09:14:34 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('27/09/2006 09:04:28 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(23, 'Take Resource Offline', 8, 'resourceManagement.do?method=setResourceOffline', TO_DATE('21/08/2006 09:14:34 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 09:14:34 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(24, 'Update Resource', 8, 'resourceManagement.do?method=updateResource', TO_DATE('21/08/2006 09:14:34 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 05:38:24 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(26, 'Set Resources Offline', 8, 'resourceManagement.do?method=setMultipleResourceOffline', TO_DATE('21/08/2006 09:14:34 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 09:14:34 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(27, 'Create Resource', 7, 'resourceManagement.do?method=createResource', TO_DATE('21/08/2006 09:14:34 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 09:14:34 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(28, 'Delete Resource', 9, 'resourceManagement.do?method=deleteResource', TO_DATE('21/08/2006 09:14:34 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 09:14:34 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(29, 'Delete Resources', 9, 'resourceManagement.do?method=deleteResources', TO_DATE('21/08/2006 09:14:34 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('21/08/2006 09:14:34 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(30, 'View Template List', 2, 'wfsprocess.do?method=selectTemplate', TO_DATE('22/08/2006 01:22:33 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('22/08/2006 01:22:33 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(31, 'Search Work Orders', 2, 'workOrderSearch.do?method=getWorkOrdersBySearch', TO_DATE('22/08/2006 01:24:42 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('22/08/2006 01:24:42 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(32, 'View Resource Group', 6, 'resourceGroupQueueManagement.do?method=getResourceGroupQueue', TO_DATE('25/08/2006 05:42:56 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('25/08/2006 05:42:56 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(33, 'View Alerts', 20, 'checkAlertServerStatus.do?method=toListAlerts', TO_DATE('31/08/2006 01:18:40 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 12:42:09 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(34, 'Create Alert', 21, 'checkAlertServerStatus.do?method=toCreateAlert', TO_DATE('31/08/2006 01:19:30 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 12:47:06 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(35, 'Modify Alert', 22, 'checkAlertServerStatus.do?method=toEditAlert', TO_DATE('31/08/2006 01:20:26 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 12:48:24 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(36, 'Delete Alert', 23, 'checkAlertServerStatus.do?method=toModifyAlerts', TO_DATE('31/08/2006 01:23:17 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 12:49:41 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(37, 'View Alert Patterns', 20, 'checkAlertServerStatus.do?method=toListAlertPatterns', TO_DATE('31/08/2006 01:24:13 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 12:56:03 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(38, 'Create Alert Pattern', 21, 'checkAlertServerStatus.do?method=toCreateAlertPattern', TO_DATE('31/08/2006 01:25:18 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 01:01:39 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(39, 'Modify Alert Pattern', 23, 'checkAlertServerStatus.do?method=toEditAlertPattern', TO_DATE('31/08/2006 01:27:39 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 01:02:36 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(40, 'Delete Alert Pattern', 23, 'checkAlertServerStatus.do?method=toModifyAlertPatterns', TO_DATE('31/08/2006 01:28:28 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 01:03:22 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(41, 'View Alert History', 20, 'checkAlertServerStatus.do?method=toListAlertHistory', TO_DATE('31/08/2006 01:29:19 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 01:07:07 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(42, 'View Detailed History', 20, 'checkAlertServerStatus.do?method=toAlertHistoryDetail', TO_DATE('31/08/2006 01:30:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 01:11:11 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(43, 'Save Alerts', 21, 'checkAlertServerStatus.do?method=toSaveCreatedAlert', TO_DATE('31/08/2006 01:30:59 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 12:53:08 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(44, 'Save Alert Patterns', 21, 'checkAlertServerStatus.do?method=toSaveCreatedAlertPattern', TO_DATE('31/08/2006 01:31:32 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 01:05:25 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(45, 'View Other User Tasks', 19, 'userTasksAction.do?method=getUserTasks', TO_DATE('31/08/2006 10:59:46 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('31/08/2006 10:59:46 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(46, 'Perform User Task', 18, 'wfstask.do?method=saveAndCloseTask', TO_DATE('31/08/2006 11:00:08 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('31/08/2006 11:00:08 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(47, 'View User Task', 18, 'wfstask.do?method=selectTaskInstance', TO_DATE('31/08/2006 11:00:30 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('31/08/2006 11:00:30 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(48, 'View User Tasks', 18, 'userTasksAction.do?method=getUserTasks', TO_DATE('31/08/2006 11:00:50 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('31/08/2006 11:00:50 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(49, 'Resource Queue Move To Top', 8, 'resourceGroupQueueManagement.do?method=moveToTop', TO_DATE('31/08/2006 11:25:05 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('31/08/2006 11:25:05 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(50, 'Resource Queue Move To Bottom', 8, 'resourceGroupQueueManagement.do?method=moveToBottom', TO_DATE('31/08/2006 11:25:58 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('31/08/2006 11:25:58 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(51, 'Resource Queue Move To Up', 8, 'resourceGroupQueueManagement.do?method=moveUp', TO_DATE('31/08/2006 11:26:34 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('31/08/2006 11:26:34 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(52, 'Resource Queue Move To Down', 8, 'resourceGroupQueueManagement.do?method=moveDown', TO_DATE('31/08/2006 11:27:19 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('31/08/2006 11:27:19 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(53, 'View Roles', 14, 'listRoles.do', TO_DATE('01/09/2006 01:06:57 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('01/09/2006 01:06:57 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(54, 'View Role Details', 14, 'editRole.do', TO_DATE('01/09/2006 01:08:39 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('01/09/2006 01:08:39 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(55, 'Create Role', 15, 'addRole.do', TO_DATE('01/09/2006 01:18:59 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('01/09/2006 01:19:59 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(56, 'Save Role', 15, 'saveRole.do?method=create', TO_DATE('01/09/2006 01:21:07 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('01/09/2006 01:21:07 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(57, 'Update Role', 16, 'saveRole.do?method=update', TO_DATE('01/09/2006 01:22:38 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('01/09/2006 01:22:38 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(58, 'Delete Roles', 17, 'modifyRoles.do', TO_DATE('01/09/2006 01:24:09 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('01/09/2006 01:24:09 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(59, 'View Users', 10, 'listUsers.do', TO_DATE('01/09/2006 01:25:38 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('01/09/2006 01:25:38 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(60, 'View User Details', 10, 'editUser.do', TO_DATE('01/09/2006 01:26:38 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('01/09/2006 01:26:38 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(61, 'Create User', 11, 'addUser.do', TO_DATE('01/09/2006 01:28:16 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('01/09/2006 01:28:16 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(62, 'Save User', 11, 'saveUser.do?method=create', TO_DATE('01/09/2006 01:29:16 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('01/09/2006 01:29:16 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(63, 'Update User', 12, 'saveUser.do?method=update', TO_DATE('01/09/2006 01:30:06 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('01/09/2006 01:30:06 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(64, 'Users status change', 12, 'modifyUsers.do?method=changeStatus', TO_DATE('01/09/2006 01:31:38 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('01/09/2006 01:33:01 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(65, 'Delete Users', 13, 'modifyUsers.do?method=delete', TO_DATE('01/09/2006 01:33:01 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('01/09/2006 01:33:01 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(66, 'Save Alerts', 22, 'checkAlertServerStatus.do?method=toSaveModifiedAlert', TO_DATE('01/09/2006 04:39:12 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 01:54:55 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(67, 'Save Alert Patterns', 22, 'checkAlertServerStatus.do?method=toSaveModifiedAlertPattern', TO_DATE('01/09/2006 04:40:01 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 01:06:10 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(68, 'View Template Details', 2, 'viewtemplate.do', TO_DATE('27/09/2006 10:15:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('27/09/2006 10:15:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(69, 'Restart Selected Work Orders', 4, 'workOrderDetailsAction.do?method=restartSelectedWorkOrders', TO_DATE('27/09/2006 10:18:01 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('27/09/2006 10:48:33 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(70, 'Retry Selected  Work Orders', 4, 'workOrderDetailsAction.do?method=retrySelectedWorkOrders', TO_DATE('27/09/2006 10:19:35 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('27/09/2006 10:48:49 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(71, 'Cancel Selected Work Orders', 4, 'workOrderDetailsAction.do?method=cancelSelectedWorkOrders', TO_DATE('27/09/2006 10:22:28 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('27/09/2006 10:22:28 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(72, 'Delete Selected Work Orders', 5, 'workOrderDetailsAction.do?method=deleteSelectedWorkOrders', TO_DATE('27/09/2006 10:43:37 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('27/09/2006 10:43:37 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(73, 'Restart Work Order', 4, 'workorderview.do?method=restartWorkOrder', TO_DATE('27/09/2006 10:48:15 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('27/09/2006 10:48:15 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(74, 'View Work Order Task Details', 2, 'workOrderTaskDetails.do?method=getWorkOrderTaskDetails', TO_DATE('27/09/2006 11:57:04 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('27/09/2006 11:57:04 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(75, 'Alert System Down', 20, 'checkAlertServerStatus.do?method=toSystemDown', TO_DATE('28/09/2006 01:14:52 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 01:14:52 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(76, 'Report Alerts', 20, 'checkAlertServerStatus.do?method=toReportAlerts', TO_DATE('28/09/2006 01:18:44 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 01:19:58 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(77, 'Report Alert Patterns', 20, 'checkAlertServerStatus.do?method=toReportAlertPatterns', TO_DATE('28/09/2006 01:19:58 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 01:19:58 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(78, 'Filter Alert History', 20, 'checkAlertServerStatus.do?method=toFilterAlertHistory', TO_DATE('28/09/2006 01:20:45 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 01:20:45 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(79, 'Report Alert History', 20, 'checkAlertServerStatus.do?method=toReportAlertsHistory', TO_DATE('28/09/2006 01:21:20 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 01:21:20 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(80, 'View Alerts', 20, 'listAlertPatterns.do', TO_DATE('28/09/2006 02:00:41 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 02:00:41 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(81, 'Retry Work Order', 4, 'workorderview.do?method=retryWorkOrder', TO_DATE('28/09/2006 02:07:48 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 02:07:48 AM','DD/MM/YYYY HH12:MI:SS PM')); 
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(82, 'Bring Resources Online', 8, 'resourceManagement.do?method=bringMultipleResourcesOnline', TO_DATE('28/09/2006 05:37:14 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 05:37:14 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(83, 'Bring Resource Online', 8, 'resourceManagement.do?method=bringResourceOnline', TO_DATE('28/09/2006 05:37:14 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/09/2006 05:37:14 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(84, 'Save User Task', 18, 'wfstask.do?method=saveTask', TO_DATE('29/09/2006 06:25:42 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('29/09/2006 06:25:42 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(85, 'Report Users', 10, 'modifyUsers.do', TO_DATE('29/09/2006 09:50:15 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('29/09/2006 09:50:15 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(86, 'Repository Browser', 20, 'repositoryBrowsing.do?method=getRepository', TO_DATE('20/10/2006 01:50:15 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('20/10/2006 09:50:15 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(87, 'View Report', 24, 'reports.do?method=getReportsList', TO_DATE('20/10/2006 01:50:15 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('20/10/2006 09:50:15 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(91, 'Update Resource Group Queue UI Visiblity', 8, 'resourceGroupQueueManagement.do?method=updateUIVisibility', TO_DATE('15/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('15/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION (ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(92, 'View Resource Type Plugins',25,'plugins.do?method=getResourceTypePlugins', TO_DATE('30/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION (ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(93, 'Sort Resource Type Plugins',25,'plugins.do?method=sortResourceTypePlugins', TO_DATE('30/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION (ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(94, 'View Resource Group Plugins',25,'plugins.do?method=getResourceGroupPlugins', TO_DATE('30/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION (ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(95, 'Sort Resource Group Plugins',25,'plugins.do?method=sortResourceGroupPlugins', TO_DATE('30/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION (ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(96,'Image Fetcher',2,'imageFetcher.do', TO_DATE('30/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/08/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION (ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(97,'Help',1,'help.do?method=getHelp', TO_DATE('28/11/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/11/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION (ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(98,'View Selector Keys',2,'viewselectorkeys.do?method=getSelectorKeyDetails', TO_DATE('30/11/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/11/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION (ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(99,'Add Selector Key',3,'viewselectorkeys.do?method=addSelectorKey', TO_DATE('30/11/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/11/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION (ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE)
	VALUES(100,'Delete Selector Key',5,'viewselectorkeys.do?method=deleteSelectorKey', TO_DATE('30/11/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('28/11/2007 12:00:00 AM','DD/MM/YYYY HH12:MI:SS PM'));

	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(101, 'View Schedule', 26, 'schedules.do?method=getSchedulesDefaultView', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(102, 'Create Schedule', 27, 'schedules.do?method=createSchedule', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(103, 'View Partner', 31, 'partners.do?method=getPartnersView', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(104, 'Create Partner', 32, 'partners.do?method=createPartner', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(105, 'View Title', 35, 'viewTitle.do', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(106, 'Internal Search', 35, 'titlesearch.do', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(107, 'Create Title', 36, 'createTitle.do', TO_DATE('13/05/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(108, 'Get template parameters for job', 43, 'jobManagement.do?method=getTemplateParameters', TO_DATE('03/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('03/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(109, 'Show job page', 43, 'jobManagement.do?method=showJobPage', TO_DATE('03/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('19/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(110, 'Create Job', 44, 'jobManagement.do?method=createJob', TO_DATE('03/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('19/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(111, 'Delete jobs', 46, 'jobListManagement.do?method=deleteJobs', TO_DATE('03/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('19/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(112, 'View Titles', 35, 'titlelist.do', TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(113, 'Schedule View', 26, 'getschedule.do', TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(114, 'Schedule Activity View', 26, 'scheduleactivity.do', TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(115, 'Schedule Basic View', 26, 'scheduletitles.do', TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(116, 'Show Create Schedule Page', 27, 'createschedule.do', TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(117, 'Create Schedule', 27, 'saveschedule.do', TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(118, 'Schedule Add Titles - Search', 28, 'addtitles.do', TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(119, 'Delete Titles From Schedule', 28, 'deletetitles.do', TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(120, 'Add Titles To Schedule', 28, 'addtitlestoschedule.do', TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(121, 'Approve Schedule', 30, 'approveschedule.do', TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(122, 'Delete Schedule', 29, 'deleteschedule.do', TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('09/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(123, 'View rules and menu', 43, 'jobManagement.do?method=getScheduleRulesAndMenu', TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('19/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(124, 'View job', 43, 'jobManagement.do?method=getJob', TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('19/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(125, 'Modify Title', 37, 'editTitle.do?method=save', TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('30/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(126, 'Create Partner', 32, 'partnerManagement.do?method=createPartnerSetup', TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(127, 'Delete Partners', 34, 'partnerManagement.do?method=deletePartners', TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(128, 'Save Partner', 32, 'partnerManagement.do?method=createPartner', TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(129, 'Get Partner', 31, 'partnerManagement.do?method=getPartnerDetails', TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(130, 'Update Partner', 33, 'partnerManagement.do?method=updatePartner', TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(131, 'Jobs For Partner', 43, 'partnerJobsManagement.do?method=getJobsForPartner', TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(132, 'Schedules For Partner', 26, 'partnerSchedulesManagement.do?method=getCurrentSchedulesForPartner', TO_DATE('16/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(133, 'Schedule Timetable', 26, 'schedules.do', TO_DATE('17/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('17/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(134, 'Export Schedule', 26, 'scheduleexport.do', TO_DATE('25/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('25/06/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));

	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(135, 'View Services', 39, 'services.do?method=getServicesView', TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(136, 'getCurrentSchedulesForService', 26, 'serviceSchedulesManagement.do?method=getCurrentSchedulesForService', TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(137, 'getJobsForService', 43, 'serviceJobsManagement.do?method=getJobsForService', TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(138, 'getPartnersForService', 31, 'servicePartnersManagement.do?method=getPartnersForService', TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(139, 'getServiceDetails', 39, 'serviceManagement.do?method=getServiceDetails', TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(140, 'Delete Services', 42, 'serviceManagement.do?method=deleteServices', TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(141, 'createService', 40, 'serviceManagement.do?method=createService', TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(142, 'updateService', 41, 'serviceManagement.do?method=updateService', TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(143, 'createServiceSetup', 40, 'serviceManagement.do?method=createServiceSetup', TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(144, 'savePartnersForService', 41, 'servicePartnersManagement.do?method=savePartnersForService', TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(145, 'getServicesForPartner', 39, 'partnerServicesManagement.do?method=getServicesForPartner', TO_DATE('02/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(146, 'forwardToPartnerOrService', 35, 'contextManagement.do?method=forwardToPartnerOrService', TO_DATE('07/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('07/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(150, 'Import Title', 36, 'titleimport.do', TO_DATE('31/07/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION(ACTIONID, NAME, PERMISSIONID, PATH, CREATEDATE, UPDATEDATE) 
	VALUES(151, 'Import Titles', 36, 'titlebatchimport.do', TO_DATE('05/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION (ACTIONID,NAME,PERMISSIONID,PATH, CREATEDATE, UPDATEDATE)
	VALUES(152,'Sync Title',37,'titlesync.do', TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION (ACTIONID,NAME,PERMISSIONID,PATH, CREATEDATE, UPDATEDATE) 
	VALUES(153,'Sync Titles',37,'titlebatchsync.do', TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION (ACTIONID,NAME,PERMISSIONID,PATH, CREATEDATE, UPDATEDATE)
	VALUES(154,'Delete Title', 38, 'deleteTitle.do', TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('15/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION (ACTIONID,NAME,PERMISSIONID,PATH, CREATEDATE, UPDATEDATE)
	VALUES(155,'Modify Job', 45, 'jobManagement.do?method=updateJob', TO_DATE('19/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('19/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION (ACTIONID,NAME,PERMISSIONID,PATH, CREATEDATE, UPDATEDATE)
	VALUES(156,'Modify Schedule', 28, 'modifyschedule.do', TO_DATE('21/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('02/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));

	INSERT INTO WFS.ttv_action (actionid, name, permissionid, path, CREATEDATE, UPDATEDATE) 
	VALUES (157, 'Approve Title', 47, 'approveTitle.do', TO_DATE('26/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('26/08/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION (ACTIONID,NAME,PERMISSIONID,PATH, CREATEDATE, UPDATEDATE)
	VALUES(158,'View Title Activity', 35, 'titleactivity.do?method=viewActivity', TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));
	INSERT INTO WFS.TTV_ACTION (ACTIONID,NAME,PERMISSIONID,PATH, CREATEDATE, UPDATEDATE)
	VALUES(159,'View Editable Title', 35, 'editTitle.do?method=edit', TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'), TO_DATE('05/09/2008 12:00:00 PM','DD/MM/YYYY HH12:MI:SS PM'));

	EXECUTE IMMEDIATE 'UPDATE WFS.TTV_BIGROLEPERMISSION brp
							SET PERMISSIONID = (	SELECT	CASE WHEN p.PermissionId IS NULL THEN -1 ELSE p.PermissionId END
														FROM		wfs.TTV_PERMISSION_OLD o
														LEFT JOIN		WFS.TTV_PERMISSION p
														ON(		o.Name = p.Name AND o.SECTIONNAME = p.SECTIONNAME AND o.MODULEID = p.MODULEID)
														WHERE		o.PermissionID = brp.PermissionId)
							WHERE	BIGROLE <> ''Admin''';
	DELETE FROM WFS.TTV_BIGROLEPERMISSION WHERE PERMISSIONID = -1;
    EXECUTE IMMEDIATE 'ALTER TABLE WFS.TTV_BIGROLEPERMISSION ENABLE CONSTRAINT FK_TTV_BIGROLEPERMISSION_PERM';
    EXECUTE IMMEDIATE 'DROP TABLE WFS.TTV_PERMISSION_OLD';
    INSERT INTO INSTALL_TABLE VALUES ('IT WORKED YO');
	 COMMIT;
EXCEPTION
	WHEN OTHERS THEN
		ROLLBACK;
		err_msg :=SUBSTR(SQLERRM, 1, 500);
		INSERT INTO install_table VALUES (err_msg);
		COMMIT;
END;
/
SELECT * FROM INSTALL_TABLE;
