update SYSPARAMETERS set VALUESTRING = '1'  where CONTEXT = 'SYSTEMINFO' and name = 'DBVersionHigh'
/
update SYSPARAMETERS set VALUESTRING = '180' where CONTEXT = 'SYSTEMINFO' and name = 'DBVersionLow'
/
update SYSPARAMETERS set VALUESTRING = '2006-11-6' where CONTEXT = 'SYSTEMINFO' and name = 'DBCreationDate'
/
alter table USERS add (LICENSEID integer null)
/
update USERS set LICENSEID = 0
/
alter table USERS add (ACCEPTED timestamp null)
/
insert into TABVIEWS
            (TABVIEWID, UNIQUENAME, FLAG, STATUS, VIEWTYPEID, ENABLED, HIDE)
     values (26, 'ADMIN_LICENSE_TAB', null, null, 1, 1, 0)
/
insert into TABVIEWS
            (TABVIEWID, UNIQUENAME, FLAG, STATUS, VIEWTYPEID, ENABLED, HIDE)
     values (27, 'LICENSE_TAB', null, null, 1, 1, 0)
/
create table LICENSE (
LICENSEID               INTEGER                        not null,
LICENSEPART				INTEGER						   not null,
LANGUAGEID				INTEGER						   not null,
LICENSETEXT             VARCHAR2(4000)                  not null,
CREATED              TIMESTAMP                      not null,
CREATORID            INTEGER                        not null,
VALIDFROM            TIMESTAMP,
VALIDUNTIL           TIMESTAMP,
constraint PK_LICENSE primary key (LICENSEID,LICENSEPART,LANGUAGEID)
)
/
create sequence LICENSE_SEQ start with 2 increment by 1
/
insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, CONTEXT_KEY, NAME, NAME_KEY, VALUESTRING, DESCRIPTION, DESCR_KEY, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (94, 'LICENSE', 'sysparam.context.license', 'Enable licensemanagement', 'sysparam.context.license.management', '0', 'Enable licensemanagement', 'sysparam.context.license.management.descr', 0, 0, 0, 2)
/
commit
/

