/* Schema Versioning */
UPDATE T_SchemaInfo SET SchemaVersion = '7.2.0';
GO

UPDATE T_Config SET TextParam1 = StringParam1, StringParam1 = '' WHERE EntryName = 'AllowPassword';
GO

UPDATE T_Config SET TextParam1 = StringParam1, StringParam1 = '' WHERE EntryName = 'DenyPassword';
GO

CREATE TABLE T_Paragraph(
	ObjectId		INT				NOT NULL,
	DocumentId		INT				NOT NULL,
	ReviewId		INT				NOT NULL,
	ParentParagraphId	NVARCHAR(256)	NOT NULL,
	SourceParagraphId		NVARCHAR(256)	NULL,
	ParagraphId		NVARCHAR(256)	NOT NULL,
	ParagraphNumber 	INT 		NOT NULL,
	ParagraphViewHtml	NTEXT			NOT NULL,
	ParagraphEditHtml	NTEXT			NOT NULL,
	Position		INT				NOT NULL,
	ParagraphType	NCHAR(3)		NULL,
	ModificationCount 	INT 		NOT NULL,
	SubjectId 	INT 		NOT NULL,
	CreateDate		DATETIME NOT NULL,
	UpdateDate		DATETIME NOT NULL,
);
CREATE UNIQUE CLUSTERED INDEX IX_Paragraph ON T_Paragraph (ObjectId);
CREATE UNIQUE NONCLUSTERED INDEX IX_Paragraph2 ON T_Paragraph (ReviewId, DocumentId, ParagraphId);
GO

ALTER TABLE T_Document
ADD LastParagraphNumber INT NOT NULL DEFAULT 0;
GO