Index: lams_common/db/sql/updatescripts/alter_203_editonfly.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/updatescripts/Attic/alter_203_editonfly.sql,v
diff -u -r1.4 -r1.5
--- lams_common/db/sql/updatescripts/alter_203_editonfly.sql	31 May 2007 06:39:08 -0000	1.4
+++ lams_common/db/sql/updatescripts/alter_203_editonfly.sql	18 Jun 2007 07:30:15 -0000	1.5
@@ -19,4 +19,12 @@
 
 insert into lams_configuration (config_key, config_value) values ('AllowLiveEdit','true');
 insert into lams_configuration (config_key, config_value) values ('ServerURLContextPath','lams/');
-insert into lams_learning_activity_type values (9, 'GATE_SYSTEM');
\ No newline at end of file
+insert into lams_learning_activity_type values (9, 'GATE_SYSTEM');
+
+INSERT INTO lams_system_tool (system_tool_id, learning_activity_type_id, tool_display_name, description, 
+	learner_url, learner_preview_url, learner_progress_url, export_pfolio_learner_url, 
+	export_pfolio_class_url, monitor_url, contribute_url, create_date_time)
+VALUES (5, 9, 'System Gate', 'Gate: Opens under system control.', 
+	'learning/gate.do?method=knockGate', 'learning/gate.do?method=knockGate', null, null, 
+	'monitoring/gateExportPortfolio?mode=teacher', 'monitoring/gate.do?method=viewGate', 
+	'monitoring/gate.do?method=viewGate', now()	);