CREATE TABLE `activities` (
	activityID	int,
	activityName	char(20),
	published	int,
	unique key	activity (activityID),
	unique key	name (activityName)
);

INSERT INTO `activities` 
	( activityID, activityName, published ) 
VALUES
	(0, 'None', 0),
	(1, 'Manufacturing', 1),
	(2, 'Research Technology', 0),
	(3, 'Research PE', 1),
	(4, 'Research ME', 1),
	(5, 'Copying', 1),
	(6, 'Duplicating', 0),
	(7, 'Reverse Engineering', 0),
	(8, 'Invention', 1);