INST_DATA_ATTACHMENT PRIMARY KEY düzeltmesi
Versiyon geçişlerinde kullanılan eflowGuncelleme.sql script sorgusunu çalıştırdıgımızda zaman zaman Cannot define PRIMARY KEY constraint on nullable column in table 'INST_DATA_ATTACHMENT' hatası vermektedir.
Çözümü için gerekli düzeltme sorgusu aşağıdaki gibidir.
Hata veren satırdan sonrası çalışmayacağı için her sorgu cümlecigi tek tek çalıştırılmalıdır.
UPDATE INST_DATA_ATTACHMENT SET COL_ID=-1 WHERE COL_ID IS NULL
UPDATE INST_DATA_ATTACHMENT SET [VERSION]=0 WHERE [VERSION] IS NULL
UPDATE INST_DATA_ATTACHMENT SET ROW_ID=0 WHERE ROW_ID IS NULL
UPDATE INST_DATA_ATTACHMENT SET EDITABLEID=0 WHERE EDITABLEID IS NULL
UPDATE INST_DATA_ATTACHMENT SET VIEWID=0 WHERE VIEWID IS NULL
UPDATE INST_DATA_ATTACHMENT SET ISONLYOWNER=0 WHERE ISONLYOWNER IS NULL
UPDATE INST_DATA_ATTACHMENT SET ISSTARRED=0 WHERE ISSTARRED IS NULL
UPDATE INST_DATA_ATTACHMENT SET DOC_ID=0 WHERE DOC_ID IS NULL
UPDATE INST_DATA_ATTACHMENT SET ISDELETED=0 WHERE DOC_ID IS NULL
ALTER TABLE INST_DATA_ATTACHMENT ADD DEFAULT((-1)) FOR [COL_ID]
ALTER TABLE INST_DATA_ATTACHMENT ADD DEFAULT((0)) FOR [VERSION]
ALTER TABLE INST_DATA_ATTACHMENT ADD DEFAULT((0)) FOR ROW_ID
ALTER TABLE INST_DATA_ATTACHMENT ADD DEFAULT((0)) FOR EDITABLEID
ALTER TABLE INST_DATA_ATTACHMENT ADD DEFAULT((0)) FOR VIEWID
ALTER TABLE INST_DATA_ATTACHMENT ADD DEFAULT((0)) FOR ISONLYOWNER
ALTER TABLE INST_DATA_ATTACHMENT ADD DEFAULT((0)) FOR ISSTARRED
ALTER TABLE INST_DATA_ATTACHMENT ADD DEFAULT((0)) FOR DOC_ID
ALTER TABLE INST_DATA_ATTACHMENT ADD DEFAULT((0)) FOR ISDELETED
ALTER TABLE INST_DATA_ATTACHMENT drop CONSTRAINT [PK_INST_DATA_ATTACHMENT]
ALTER TABLE INST_DATA_ATTACHMENT ADD PRIMARY KEY ([CIID],[DID],[USERID],[ROW_ID])