BMXAA6818I - ConfigDB 已針對綱目 dbo 啟動，已連接至資料庫 jdbc:sqlserver://localhost:1433;database=maxdb71;integratedSecurity=false; Tue Dec 05 16:19:51 CST 2023
BMXAA0344I - 重新整理屬性 meta 資料 Tue Dec 05 16:19:51 CST 2023
delete from autokey where not exists (select * from maxattributecfg c where c.autokeyname = autokey.autokeyname and c.changed != 'R')
go
delete from l_maxattrcfg where ownerid in (select maxattributeid from maxattributecfg where changed = 'R')
go
delete from maxattributecfg where changed = 'R'
go
delete from maxviewcolumncfg where changed = 'R'
go
delete from maxattribute
go
delete from l_maxattribute
go
insert into maxattribute (objectname, attributename, attributeno, alias, autokeyname, canautonum, classname, columnname, defaultvalue, domainid, eauditenabled, entityname, esigenabled, isldowner, ispositive, length, maxtype, mustbe, required, persistent, primarykeycolseq, remarks, sameasattribute, sameasobject, scale, title, userdefined, searchtype, mlsupported, mlinuse, handlecolumnname, maxattributeid, restricted, localizable, textdirection, complexexpression, extended) 
select objectname, attributename, attributeno, alias, autokeyname, canautonum, classname, columnname, defaultvalue, domainid, eauditenabled, entityname, esigenabled, isldowner, ispositive, length, maxtype, mustbe, required, persistent, primarykeycolseq, remarks, sameasattribute, sameasobject, scale, title, userdefined, searchtype, mlsupported, mlinuse, handlecolumnname, maxattributeid, restricted, localizable, textdirection, complexexpression, extended
 from maxattributecfg
go
insert into l_maxattribute (l_maxattributeid, ownerid, langcode, remarks, title) 
select l_maxattrcfgid, ownerid, langcode, remarks, title
 from l_maxattrcfg
go
update maxattributecfg set changed = 'N' where changed != 'N'
go
delete from maxviewcolumn
go
insert into maxviewcolumn (viewname, viewcolumnname, samestorageas, tablename, tablecolumnname, maxviewcolumnid) 
select viewname, viewcolumnname, samestorageas, tablename, tablecolumnname, maxviewcolumnid
 from maxviewcolumncfg
go
update maxviewcolumncfg set changed = 'N' where changed != 'N'
go
commit
go
BMXAA0343I - 重新整理物件 meta 資料 Tue Dec 05 16:19:53 CST 2023
delete from maxtable
go
delete from maxtablecfg where tablename in (select entityname from maxobjectcfg where isview = 0 and changed = 'R')
go
delete from maxview
go
delete from maxviewcfg where viewname in (select entityname from maxobjectcfg where isview = 1 and changed = 'R')
go
delete from maxobject
go
delete from l_maxobject
go
delete from l_maxobjectcfg where ownerid in (select maxobjectid from maxobjectcfg where changed = 'R')
go
delete from maxobjectcfg where changed = 'R'
go
update maxobjectcfg set changed = 'N'
go
insert into maxobject (objectname, classname, description, eauditenabled, eauditfilter, entityname, esigfilter, extendsobject, hasld, imported, internal, isview, langcode, mainobject, maxobjectid, persistent, resourcetype, servicename, siteorgtype, textdirection, userdefined) 
select objectname, classname, description, eauditenabled, eauditfilter, entityname, esigfilter, extendsobject, hasld, imported, internal, isview, langcode, mainobject, maxobjectid, persistent, resourcetype, servicename, siteorgtype, textdirection, userdefined
 from maxobjectcfg
go
insert into l_maxobject (l_maxobjectid, ownerid, langcode, description) 
select l_maxobjectcfgid, ownerid, langcode, description
 from l_maxobjectcfg
go
insert into maxtable (tablename, addrowstamp, eaudittbname, isaudittable, restoredata, storagepartition, textsearchenabled, langtablename, langcolumnname, uniquecolumnname, islangtable, maxtableid, altixname, trigroot, contentattribute, storagetype, exttablename) 
select tablename, addrowstamp, eaudittbname, isaudittable, restoredata, storagepartition, textsearchenabled, langtablename, langcolumnname, uniquecolumnname, islangtable, maxtableid, altixname, trigroot, contentattribute, storagetype, exttablename
 from maxtablecfg
go
insert into maxview (viewname, viewselect, viewwhere, autoselect, maxviewid, viewfrom) 
select viewname, viewselect, viewwhere, autoselect, maxviewid, viewfrom
 from maxviewcfg
go
commit
go
delete from appfielddefaults where not exists  (select * from maxattribute where maxattribute.objectname = appfielddefaults.objectname and  		maxattribute.attributename = appfielddefaults.attributename)
go
commit
go
update maxsequence set maxreserved = 36585 where sequencename = 'MAXVIEWCOLUMNCFGSEQ'
go
update maxsequence set maxreserved = 76597 where sequencename = 'MAXOBJECTSEQ'
go
update maxsequence set maxreserved = 1 where sequencename = 'L_MAXOBJECTCFGSEQ'
go
update maxsequence set maxreserved = 36585 where sequencename = 'MAXVIEWCOLUMNSEQ'
go
update maxsequence set maxreserved = 58920 where sequencename = 'MAXTABLESEQ'
go
update maxsequence set maxreserved = 58920 where sequencename = 'MAXTABLECFGSEQ'
go
update maxsequence set maxreserved = 1 where sequencename = 'L_MAXOBJECTUSEQ'
go
update maxsequence set maxreserved = 1968 where sequencename = 'MAXVIEWCFGSEQ'
go
update maxsequence set maxreserved = 278253 where sequencename = 'MAXATTRIBUTECFGSEQ'
go
update maxsequence set maxreserved = 1 where sequencename = 'L_MAXATTRIBUTEUSEQ'
go
update maxsequence set maxreserved = 278253 where sequencename = 'MAXATTRIBUTESEQ'
go
update maxsequence set maxreserved = 1968 where sequencename = 'MAXVIEWSEQ'
go
update maxsequence set maxreserved = 76597 where sequencename = 'MAXOBJECTCFGSEQ'
go
update maxsequence set maxreserved = 1 where sequencename = 'L_MAXATTRCFGSEQ'
go
update maxvars set varvalue = '790' where varname = 'DBVERSION'
go
commit
go
update maxvars set varvalue = '5' where varname = 'NUMBEROFTAXCODES'
go
commit
go
delete from maxattributeskipcopy where maxattributeskipcopyid not in (select maxattributeskipcopyid from maxattributeskipcopy masc, maxattributecfg macfg where masc.attributename = macfg.attributename and masc.objectname = macfg.objectname)
go
commit
go
BMXAA6820I - ConfigDB 已完成，而且沒發生錯誤。 Tue Dec 05 16:19:53 CST 2023