Index: lams_tool_nb/db/sql/create_lams_tool_nb.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/create_lams_tool_nb.sql,v
diff -u -r1.3 -r1.4
--- lams_tool_nb/db/sql/create_lams_tool_nb.sql	5 Jul 2005 06:46:21 -0000	1.3
+++ lams_tool_nb/db/sql/create_lams_tool_nb.sql	28 Jul 2005 06:55:09 -0000	1.4
@@ -40,3 +40,17 @@
                   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(50) NOT NULL
+     , uuid BIGINT(20) NOT NULL
+     , version_id BIGINT(20)
+     , isOnline 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/drop_lams_tool_nb.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/drop_lams_tool_nb.sql,v
diff -u -r1.2 -r1.3
--- lams_tool_nb/db/sql/drop_lams_tool_nb.sql	5 Jul 2005 06:46:21 -0000	1.2
+++ lams_tool_nb/db/sql/drop_lams_tool_nb.sql	28 Jul 2005 06:55:09 -0000	1.3
@@ -1,4 +1,5 @@
 DROP TABLE IF EXISTS lams.tl_lanb11_user;
+DROP TABLE IF EXISTS lams.tl_lanb11_attachment;
 DROP TABLE IF EXISTS lams.tl_lanb11_session;
 DROP TABLE IF EXISTS lams.tl_lanb11_content;
 
Index: lams_tool_nb/db/sql/init_lams_tool_nb.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/Attic/init_lams_tool_nb.sql,v
diff -u -r1.3 -r1.4
--- lams_tool_nb/db/sql/init_lams_tool_nb.sql	5 Jul 2005 06:46:21 -0000	1.3
+++ lams_tool_nb/db/sql/init_lams_tool_nb.sql	28 Jul 2005 06:55:09 -0000	1.4
@@ -2,6 +2,7 @@
 
 -- Ensure an existing table does not exist
 DROP TABLE IF EXISTS lams.tl_lanb11_user;
+DROP TABLE IF EXISTS lams.tl_lanb11_attachment;
 DROP TABLE IF EXISTS lams.tl_lanb11_session;
 DROP TABLE IF EXISTS lams.tl_lanb11_content;
 
@@ -47,3 +48,16 @@
      , 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(50) NOT NULL
+     , uuid BIGINT(20) NOT NULL
+     , version_id BIGINT(20)
+     , isOnline 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/lams_tool_noticeboard.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/Attic/lams_tool_noticeboard.sql,v
diff -u -r1.3 -r1.4
Binary files differ