-- Tabla donde se registra la información de Pergamon de los archivos
-- de los que no se encuentra registro en la tabla GesDoc.
CREATE TABLE TSSGESDOC.dbo.LogGesDoc (
	ID INT IDENTITY(1,1) NOT NULL,
	EmpID SMALLINT DEFAULT 0 NOT NULL,
	ApaID CHAR(15) COLLATE Modern_Spanish_CI_AI DEFAULT '' NOT NULL,
	TipDocID CHAR(10) COLLATE Modern_Spanish_CI_AI DEFAULT '' NULL,
	DocFecAlta DATETIME DEFAULT '1753-01-01 00:00:00.000' NULL,
	DocUseAlta SMALLINT DEFAULT 0 NULL,
	DocDes CHAR(200) COLLATE Modern_Spanish_CI_AI DEFAULT '' NULL,
	DocName CHAR(200) COLLATE Modern_Spanish_CI_AI DEFAULT '' NULL,
	DocBytes DECIMAL(12,0) DEFAULT 0 NULL,
	DocWVis CHAR(1) COLLATE Modern_Spanish_CI_AI DEFAULT '' NULL,
	DocWVisP CHAR(1) COLLATE Modern_Spanish_CI_AI DEFAULT '' NULL,
	DocFolDerID INT DEFAULT 0 NULL,
	DocTBMID CHAR(100) COLLATE Modern_Spanish_CI_AI NULL,
	DocApiID INT DEFAULT 0 NULL,
	CONSTRAINT PK_Log_GesDoc PRIMARY KEY (ID)
);
