CREATE TABLE MEDIA_CREATION_DEINFO
(
	DERowID varchar (64) NOT NULL,
	SOPInstanceUID varchar (64) NOT NULL,
	VRType integer NOT NULL,
	GroupNumber integer NOT NULL,
	ElementNumber integer NOT NULL,
	IsSQ varchar (64) NOT NULL,
	ParentSQUID varchar (64) DEFAULT '',
	Value varchar (64) DEFAULT '',
	SQUUID varchar (64) DEFAULT '',
	ItemUUID varchar (64) DEFAULT ''
);

ALTER TABLE MEDIA_CREATION_DEINFO ADD 
	CONSTRAINT MEDIA_CREATION_DEINFO_PK PRIMARY KEY 
	(
		DERowID
	);

CREATE TABLE MEDIA_SCHEDULE_DEINFO
(
	DERowID varchar (64) NOT NULL,
	SOPInstanceUID varchar (64) NOT NULL,
	VRType integer NOT NULL,
	GroupNumber integer NOT NULL,
	ElementNumber integer NOT NULL,
	IsSQ varchar (64) NOT NULL,
	ParentSQUID varchar (64) DEFAULT '',
	Value varchar (64) DEFAULT '',
	SQUUID varchar (64) DEFAULT '',
	ItemUUID varchar (64) DEFAULT ''
);

ALTER TABLE MEDIA_SCHEDULE_DEINFO ADD 
	CONSTRAINT MEDIA_SCHEDULE_DEINFO_PK PRIMARY KEY 
	(
		DERowID
	);