MySql_TableProfileCollectionAuthorisation.sql

select 'losp_BasisElement_profilecollection_writeauthorisation';
CREATE TABLE losp_BasisElement_profilecollection_writeauthorisation (
	PCListID int(11) UNSIGNED NOT NULL ,
	ProfileCollectionID int(11) UNSIGNED NOT NULL,
	PRIMARY KEY (PCListID,ProfileCollectionID),
	INDEX (PCListID, ProfileCollectionID),
	FOREIGN KEY (ProfileCollectionID)
		REFERENCES losp_BasisElement(ID)
		ON DELETE CASCADE
		ON UPDATE CASCADE
) ENGINE=InnoDB;


select 'losp_BasisElement_profilecollection_readauthorisation';
CREATE TABLE losp_BasisElement_profilecollection_readauthorisation (
	PCListID int(11) UNSIGNED NOT NULL,
	ProfileCollectionID int(11) UNSIGNED NOT NULL,
	PRIMARY KEY (PCListID,ProfileCollectionID),
	INDEX (PCListID, ProfileCollectionID),
	FOREIGN KEY (ProfileCollectionID)
		REFERENCES losp_BasisElement(ID)
		ON DELETE CASCADE
		ON UPDATE CASCADE
) ENGINE=InnoDB;