Index: lams_tool_nb/db/sql/activity_insert.sql
===================================================================
diff -u
--- lams_tool_nb/db/sql/activity_insert.sql (revision 0)
+++ lams_tool_nb/db/sql/activity_insert.sql (revision 2769a06599675ceac458c4a6714fd19338e27520)
@@ -0,0 +1,84 @@
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2005-04-07 11:08:32
+#
+INSERT INTO lams_learning_activity
+(
+activity_ui_id
+, description
+, title
+, help_text
+, xcoord
+, ycoord
+, parent_activity_id
+, parent_ui_id
+, learning_activity_type_id
+, grouping_support_type_id
+, apply_grouping_flag
+, grouping_id
+, grouping_ui_id
+, order_id
+, define_later_flag
+, learning_design_id
+, learning_library_id
+, create_date_time
+, run_offline_flag
+, offline_instructions
+, online_instructions
+, max_number_of_options
+, min_number_of_options
+, options_instructions
+, tool_id
+, tool_content_id
+, activity_category_id
+, gate_activity_level_id
+, gate_open_flag
+, gate_start_time_offset
+, gate_end_time_offset
+, gate_start_date_time
+, gate_end_date_time
+, library_activity_ui_image
+, create_grouping_id
+, create_grouping_ui_id
+, library_activity_id
+)
+VALUES
+(
+NULL
+, 'Displays a Noticeboard'
+, 'Noticeboard'
+, 'Put some help text here.'
+, NULL
+, NULL
+, NULL
+, NULL
+, 1
+, 1
+, 0
+, NULL
+, NULL
+, NULL
+, 0
+, NULL
+, ${learning_library_id}
+, NOW()
+, 0
+, 'Do it yourself'
+, 'Do it in LAMS'
+, NULL
+, NULL
+, NULL
+, ${tool_id}
+, NULL
+, 4
+, NULL
+, NULL
+, NULL
+, NULL
+, NULL
+, NULL
+, '/tool/lanb11/images/icon_noticeboard.swf'
+, NULL
+, NULL
+, NULL
+)
Index: lams_tool_nb/db/sql/create_lams_tool_nb.sql
===================================================================
diff -u -ra6857cd86c7c1a7e32287da94351b4db9ee098ef -r2769a06599675ceac458c4a6714fd19338e27520
--- lams_tool_nb/db/sql/create_lams_tool_nb.sql (.../create_lams_tool_nb.sql) (revision a6857cd86c7c1a7e32287da94351b4db9ee098ef)
+++ lams_tool_nb/db/sql/create_lams_tool_nb.sql (.../create_lams_tool_nb.sql) (revision 2769a06599675ceac458c4a6714fd19338e27520)
@@ -54,3 +54,23 @@
REFERENCES lams.tl_lanb11_content (uid)
)TYPE=InnoDB;
+-- Default Content For Noticeboard Tool
+
+INSERT INTO tl_lanb11_content ( nb_content_id,
+ title,
+ content,
+ online_instructions,
+ offline_instructions,
+ define_later,
+ force_offline,
+ content_in_use,
+ date_created)
+VALUES (${default_content_id},
+ 'Welcome',
+ 'Welcome to these activities',
+ 'Enter the online instructions here',
+ 'Enter the offline instructions here',
+ 0,
+ 0,
+ 0,
+ now());
Fisheye: Tag 2769a06599675ceac458c4a6714fd19338e27520 refers to a dead (removed) revision in file `lams_tool_nb/db/sql/lams_tool_nb.sql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: lams_tool_nb/db/sql/library_insert.sql
===================================================================
diff -u
--- lams_tool_nb/db/sql/library_insert.sql (revision 0)
+++ lams_tool_nb/db/sql/library_insert.sql (revision 2769a06599675ceac458c4a6714fd19338e27520)
@@ -0,0 +1,18 @@
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2005-04-07 10:50:55
+#
+INSERT INTO lams_learning_library
+(
+description,
+title,
+valid_flag,
+create_date_time
+)
+VALUES
+(
+'Displays a Noticeboard',
+'Noticeboard',
+0,
+NOW()
+)
Index: lams_tool_nb/db/sql/test_data_lams_tool_nb.sql
===================================================================
diff -u
--- lams_tool_nb/db/sql/test_data_lams_tool_nb.sql (revision 0)
+++ lams_tool_nb/db/sql/test_data_lams_tool_nb.sql (revision 2769a06599675ceac458c4a6714fd19338e27520)
@@ -0,0 +1,56 @@
+CREATE TABLE lams.tl_lanb11_content (
+ uid BIGINT(20) NOT NULL AUTO_INCREMENT
+ , nb_content_id BIGINT(20) UNIQUE NOT NULL
+ , title TEXT
+ , content TEXT
+ , online_instructions TEXT
+ , offline_instructions TEXT
+ , define_later TINYINT(1)
+ , force_offline TINYINT(1)
+ , content_in_use TINYINT(1)
+ , creator_user_id BIGINT(20)
+ , date_created DATETIME
+ , date_updated DATETIME
+ , PRIMARY KEY (uid)
+)TYPE=InnoDB;
+
+CREATE TABLE lams.tl_lanb11_session (
+ uid BIGINT(20) NOT NULL AUTO_INCREMENT
+ , nb_session_id BIGINT(20) UNIQUE NOT NULL
+ , nb_content_uid BIGINT(20) NOT NULL
+ , session_start_date DATETIME
+ , session_end_date DATETIME
+ , session_status VARCHAR(100)
+ , PRIMARY KEY (uid)
+ , INDEX (nb_content_uid)
+ , CONSTRAINT FK_tl_lanb11_session_1 FOREIGN KEY (nb_content_uid)
+ REFERENCES lams.tl_lanb11_content (uid)
+)TYPE=InnoDB;
+
+CREATE TABLE lams.tl_lanb11_user (
+ uid BIGINT(20) NOT NULL AUTO_INCREMENT
+ , user_id BIGINT(20) UNIQUE NOT NULL
+ , nb_session_uid BIGINT(20) NOT NULL
+ , username VARCHAR(50)
+ , fullname VARCHAR(50)
+ , user_status VARCHAR(50)
+ , PRIMARY KEY (uid)
+ , INDEX (nb_session_uid)
+ , CONSTRAINT FK_tl_lanb11_user_1 FOREIGN KEY (nb_session_uid)
+ REFERENCES lams.tl_lanb11_session (uid)
+)TYPE=InnoDB;
+
+
+CREATE TABLE lams.tl_lanb11_attachment (
+ attachment_id BIGINT(20) NOT NULL AUTO_INCREMENT
+ , nb_content_uid BIGINT(20) NOT NULL
+ , filename VARCHAR(255) NOT NULL
+ , uuid BIGINT(20) NOT NULL
+ , version_id BIGINT(20)
+ , online_file TINYINT(1) NOT NULL
+ , PRIMARY KEY (attachment_id)
+ , INDEX (nb_content_uid)
+ , CONSTRAINT FK_tl_lanb11_attachment_1 FOREIGN KEY (nb_content_uid)
+ REFERENCES lams.tl_lanb11_content (uid)
+)TYPE=InnoDB;
+
Index: lams_tool_nb/db/sql/tool_insert.sql
===================================================================
diff -u
--- lams_tool_nb/db/sql/tool_insert.sql (revision 0)
+++ lams_tool_nb/db/sql/tool_insert.sql (revision 2769a06599675ceac458c4a6714fd19338e27520)
@@ -0,0 +1,50 @@
+# Connection: ROOT LOCAL
+# Host: localhost
+# Saved: 2005-04-07 10:42:43
+#
+INSERT INTO lams_tool
+(
+tool_signature,
+service_name,
+tool_display_name,
+description,
+learning_library_id,
+default_tool_content_id,
+valid_flag,
+grouping_support_type_id,
+supports_define_later_flag,
+supports_run_offline_flag,
+supports_moderation_flag,
+supports_contribute_flag,
+learner_url,
+author_url,
+define_later_url,
+export_portfolio_url,
+monitor_url,
+contribute_url,
+moderation_url,
+create_date_time
+)
+VALUES
+(
+'lanb11',
+'nbService',
+'Noticeboard',
+'Displays a Noticeboard',
+NULL,
+NULL,
+0,
+1,
+1,
+1,
+0,
+0,
+'/tool/lanb11/starter/learner.do',
+'/tool/lanb11/starter/authoring.do',
+'/tool/lanb11/starter/authoring.do?defineLater=true',
+'/tool/lanb11/exportPortfolio.do',
+'/tool/lanb11/starter/monitor.do',
+NULL,
+NULL,
+NOW()
+)
Index: lams_tool_nb/web/template/template.jsp
===================================================================
diff -u -rd05ab5e6dfdfeabebf7a4aeea4581ccb228b0e0d -r2769a06599675ceac458c4a6714fd19338e27520
--- lams_tool_nb/web/template/template.jsp (.../template.jsp) (revision d05ab5e6dfdfeabebf7a4aeea4581ccb228b0e0d)
+++ lams_tool_nb/web/template/template.jsp (.../template.jsp) (revision 2769a06599675ceac458c4a6714fd19338e27520)
@@ -45,7 +45,7 @@
-
+