14 lines
426 B
Transact-SQL
14 lines
426 B
Transact-SQL
UPDATE TBDD_MODULES SET DB_VERSION = '2.5.2.1' where NAME = 'Global-Indexer'
|
|
GO
|
|
|
|
IF COL_LENGTH('TBGI_FILES_USER','DocID') IS NOT NULL
|
|
PRINT 'Column DocID Exists';
|
|
ELSE
|
|
ALTER TABLE TBGI_FILES_USER ADD DocID BIGINT NOT NULL DEFAULT 0
|
|
GO
|
|
IF COL_LENGTH('TBGI_FILES_USER','FILE_HASH') IS NOT NULL
|
|
PRINT 'Column FILE_HASH Exists';
|
|
ELSE
|
|
ALTER TABLE TBGI_FILES_USER ADD FILE_HASH VARCHAR(200) DEFAULT ''
|
|
|
|
GO |