MySql_Tables.Location.sql

select 'create losp_BE_location';
CREATE TABLE losp_BE_location (
	MTextID int(11) UNSIGNED NOT NULL,
	Name varchar(20),
	PRIMARY KEY (MTextID)
-- 	, FOREIGN KEY (MTextID)
-- 		REFERENCES losp_BasisElement(ID)
-- 		ON DELETE CASCADE
-- 		ON UPDATE CASCADE
) ENGINE=InnoDB;

select ' -ALTER losp_BE_location';
	ALTER TABLE losp_BE_location
		ADD	CONSTRAINT BE_location_MTextID__BasisElement_ID
			FOREIGN KEY (MTextID) REFERENCES losp_BasisElement(ID)
			ON DELETE CASCADE
			ON UPDATE CASCADE;

INSERT INTO losp_BasisClipboard_objvar (PartOfObjVarID, PartOfObjVar) VALUES ('300', 'LocationBC');