Index: lams_tool_nb/db/sql/create_lams_tool_nb.sql =================================================================== diff -u -rcc796564ee86ee3e7427d66c174fa4d407116f7b -re31ea6ddbf8f82fdfc668773ebe28d847ccd4ad1 --- lams_tool_nb/db/sql/create_lams_tool_nb.sql (.../create_lams_tool_nb.sql) (revision cc796564ee86ee3e7427d66c174fa4d407116f7b) +++ lams_tool_nb/db/sql/create_lams_tool_nb.sql (.../create_lams_tool_nb.sql) (revision e31ea6ddbf8f82fdfc668773ebe28d847ccd4ad1) @@ -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 =================================================================== diff -u -rcc796564ee86ee3e7427d66c174fa4d407116f7b -re31ea6ddbf8f82fdfc668773ebe28d847ccd4ad1 --- lams_tool_nb/db/sql/drop_lams_tool_nb.sql (.../drop_lams_tool_nb.sql) (revision cc796564ee86ee3e7427d66c174fa4d407116f7b) +++ lams_tool_nb/db/sql/drop_lams_tool_nb.sql (.../drop_lams_tool_nb.sql) (revision e31ea6ddbf8f82fdfc668773ebe28d847ccd4ad1) @@ -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 =================================================================== diff -u -rcc796564ee86ee3e7427d66c174fa4d407116f7b -re31ea6ddbf8f82fdfc668773ebe28d847ccd4ad1 --- lams_tool_nb/db/sql/init_lams_tool_nb.sql (.../init_lams_tool_nb.sql) (revision cc796564ee86ee3e7427d66c174fa4d407116f7b) +++ lams_tool_nb/db/sql/init_lams_tool_nb.sql (.../init_lams_tool_nb.sql) (revision e31ea6ddbf8f82fdfc668773ebe28d847ccd4ad1) @@ -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 =================================================================== diff -u -rcc796564ee86ee3e7427d66c174fa4d407116f7b -re31ea6ddbf8f82fdfc668773ebe28d847ccd4ad1 --- lams_tool_nb/db/sql/lams_tool_noticeboard.sql (.../lams_tool_noticeboard.sql) (revision cc796564ee86ee3e7427d66c174fa4d407116f7b) +++ lams_tool_nb/db/sql/lams_tool_noticeboard.sql (.../lams_tool_noticeboard.sql) (revision e31ea6ddbf8f82fdfc668773ebe28d847ccd4ad1) @@ -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; +