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

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

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

CREATE TABLE T_Paragraph(
	ObjectId		INT				NOT NULL,
	DocumentId		INT				NOT NULL,
	ReviewId		INT				NOT NULL,
	ParentParagraphId	NVARCHAR2(256)	NOT NULL,
	SourceParagraphId		NVARCHAR2(256)	NULL,
	ParagraphId		NVARCHAR2(256)	NOT NULL,
	ParagraphNumber 	INT 		NOT NULL,
	ParagraphViewHtml	NCLOB			NOT NULL,
	ParagraphEditHtml	NCLOB			NOT NULL,
	Position		INT				NOT NULL,
	ParagraphType	NCHAR(3)		NULL,
	ModificationCount 	INT 		NOT NULL,
	SubjectId 	INT 		NOT NULL,
	CreateDate		TIMESTAMP(3) NOT NULL,
	UpdateDate		TIMESTAMP(3) NOT NULL
);
CREATE UNIQUE INDEX IX_Paragraph ON T_Paragraph (ObjectId);
CREATE UNIQUE INDEX IX_Paragraph2 ON T_Paragraph (ReviewId, DocumentId, ParagraphId);
COMMIT;

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