LogFile_INDX_I30-schema.sql

CREATE TABLE LogFile_INDX_I30(
	Id							INT(11) NOT NULL AUTO_INCREMENT
	,lf_Offset					VARCHAR(18) NOT NULL
	,lf_LSN						BIGINT NOT NULL
	,lf_EntryNumber				INTEGER NOT NULL
	,lf_MFTReference			BIGINT  NOT NULL
	,lf_MFTReferenceSeqNo		INT(5) NOT NULL
	,lf_IndexFlags				INTEGER NOT NULL
	,lf_MFTParentReference		BIGINT  NOT NULL
	,lf_MFTParentReferenceSeqNo	INT(5) NOT NULL
	,lf_CTime					DATETIME(6) NOT NULL
	,lf_ATime					DATETIME(6) NOT NULL
	,lf_MTime					DATETIME(6) NOT NULL
	,lf_RTime					DATETIME(6) NOT NULL
	,lf_AllocSize				BIGINT NOT NULL
	,lf_RealSize				BIGINT NOT NULL
	,lf_FileFlags				VARCHAR(128) NOT NULL
	,lf_ReparseTag				VARCHAR(32) NOT NULL
	,lf_EaSize					INT(8)
	,lf_FileName				VARCHAR(255) NOT NULL
	,lf_FileNameModified		INT(3) NOT NULL
	,lf_NameSpace				VARCHAR(9) NOT NULL
	,lf_SubNodeVCN				BIGINT NULL DEFAULT NULL
	,IsRedo						TINYINT(1) NOT NULL
	,PRIMARY KEY (Id)
);