[Logicampus-cvs] logicampus/data lob_class_activity.mysql.sql, NONE, 1.1

[Mark K <har...@us...>]

Update of /cvsroot/logicampus/logicampus/data
In directory sc8-pr-cvs6.sourceforge.net:/tmp/cvs-serv23591/data

Added Files:
	lob_class_activity.mysql.sql 
Log Message:
Small schema changes to support tests and activities at the bare minimum.


--- NEW FILE: lob_class_activity.mysql.sql ---
-- Dumping SQL for project logicampus
-- entity version: 0.0
-- DB type: mysql
-- generated on: 09.29.2007


DROP TABLE IF EXISTS `lob_class_activity`;
CREATE TABLE `lob_class_activity` (
		
	`lob_class_activity_id` integer (11) NOT NULL auto_increment, 
	`lob_class_repo_id` integer (11) NOT NULL, 
	`response_type_id` tinyint (4) NOT NULL,
	PRIMARY KEY (lob_class_activity_id) 
);

CREATE INDEX lob_class_repo_idx ON lob_class_activity (lob_class_repo_id);