update SYSPARAMETERS set VALUESTRING = '1'  where CONTEXT = 'SYSTEMINFO' and name = 'DBVersionHigh';
update SYSPARAMETERS set VALUESTRING = '178' where CONTEXT = 'SYSTEMINFO' and name = 'DBVersionLow';
update SYSPARAMETERS set VALUESTRING = '2006-09-07' where CONTEXT = 'SYSTEMINFO' and name = 'DBCreationDate';

delete from TABVIEWS where UNIQUENAME = 'ADMINISTRATION_TAB';
delete from TABVIEWS where UNIQUENAME = 'PROJECT_TAB';
delete from TABVIEWS where UNIQUENAME = 'STATISTICS_TAB';

insert into TABVIEWS
            (TABVIEWID, UNIQUENAME, FLAG, STATUS, VIEWTYPEID, ENABLED, HIDE)
     values (16, 'ADMIN_USERMANAGEMENT_TAB', null, null, 1, 1, 0);

insert into TABVIEWS
            (TABVIEWID, UNIQUENAME, FLAG, STATUS, VIEWTYPEID, ENABLED, HIDE)
     values (17, 'ADMIN_GROUPMANAGEMENT_TAB', null, null, 1, 1, 0);

insert into TABVIEWS
            (TABVIEWID, UNIQUENAME, FLAG, STATUS, VIEWTYPEID, ENABLED, HIDE)
     values (18, 'ADMIN_ACTIVEUSERS_TAB', null, null, 1, 1, 0);

insert into TABVIEWS
            (TABVIEWID, UNIQUENAME, FLAG, STATUS, VIEWTYPEID, ENABLED, HIDE)
     values (19, 'ADMIN_SENDEMAIL_TAB', null, null, 1, 1, 0);

insert into TABVIEWS
            (TABVIEWID, UNIQUENAME, FLAG, STATUS, VIEWTYPEID, ENABLED, HIDE)
     values (20, 'ADMIN_SYSTEMPARAMETERS_TAB', null, null, 1, 1, 0);

insert into TABVIEWS
            (TABVIEWID, UNIQUENAME, FLAG, STATUS, VIEWTYPEID, ENABLED, HIDE)
     values (21, 'ADMIN_SYSTEMDEFAULTS_TAB', null, null, 1, 1, 0);

insert into TABVIEWS
            (TABVIEWID, UNIQUENAME, FLAG, STATUS, VIEWTYPEID, ENABLED, HIDE)
     values (22, 'ADMIN_SYSTEMMAINTENANCE_TAB', null, null, 1, 1, 0);

insert into TABVIEWS
            (TABVIEWID, UNIQUENAME, FLAG, STATUS, VIEWTYPEID, ENABLED, HIDE)
     values (23, 'ADMIN_NEWSMANAGEMENT_TAB', null, null, 1, 1, 0);

insert into TABVIEWS
            (TABVIEWID, UNIQUENAME, FLAG, STATUS, VIEWTYPEID, ENABLED, HIDE)
     values (24, 'ADMIN_SHOWSTATISTICS_TAB', null, null, 1, 1, 0);

insert into TABVIEWS
            (TABVIEWID, UNIQUENAME, FLAG, STATUS, VIEWTYPEID, ENABLED, HIDE)
     values (25, 'ADMIN_LDAP_TAB', null, null, 1, 1, 0);

commit;