Index: lams_tool_nb/db/sql/create_lams_tool_nb.sql =================================================================== diff -u -r2769a06599675ceac458c4a6714fd19338e27520 -re1d0de051b86cc7033fc8bd80401bbb16638d156 --- lams_tool_nb/db/sql/create_lams_tool_nb.sql (.../create_lams_tool_nb.sql) (revision 2769a06599675ceac458c4a6714fd19338e27520) +++ lams_tool_nb/db/sql/create_lams_tool_nb.sql (.../create_lams_tool_nb.sql) (revision e1d0de051b86cc7033fc8bd80401bbb16638d156) @@ -1,4 +1,4 @@ -CREATE TABLE lams.tl_lanb11_content ( +CREATE TABLE tl_lanb11_content ( uid BIGINT(20) NOT NULL AUTO_INCREMENT , nb_content_id BIGINT(20) UNIQUE NOT NULL , title TEXT @@ -14,7 +14,7 @@ , PRIMARY KEY (uid) )TYPE=InnoDB; -CREATE TABLE lams.tl_lanb11_session ( +CREATE TABLE 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 @@ -27,7 +27,7 @@ REFERENCES lams.tl_lanb11_content (uid) )TYPE=InnoDB; -CREATE TABLE lams.tl_lanb11_user ( +CREATE TABLE tl_lanb11_user ( uid BIGINT(20) NOT NULL AUTO_INCREMENT , user_id BIGINT(20) UNIQUE NOT NULL , nb_session_uid BIGINT(20) NOT NULL @@ -41,7 +41,7 @@ )TYPE=InnoDB; -CREATE TABLE lams.tl_lanb11_attachment ( +CREATE TABLE tl_lanb11_attachment ( attachment_id BIGINT(20) NOT NULL AUTO_INCREMENT , nb_content_uid BIGINT(20) NOT NULL , filename VARCHAR(255) NOT NULL Index: lams_tool_nb/db/sql/drop_lams_tool_nb.sql =================================================================== diff -u -re31ea6ddbf8f82fdfc668773ebe28d847ccd4ad1 -re1d0de051b86cc7033fc8bd80401bbb16638d156 --- lams_tool_nb/db/sql/drop_lams_tool_nb.sql (.../drop_lams_tool_nb.sql) (revision e31ea6ddbf8f82fdfc668773ebe28d847ccd4ad1) +++ lams_tool_nb/db/sql/drop_lams_tool_nb.sql (.../drop_lams_tool_nb.sql) (revision e1d0de051b86cc7033fc8bd80401bbb16638d156) @@ -1,5 +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; +DROP TABLE IF EXISTS tl_lanb11_user; +DROP TABLE IF EXISTS tl_lanb11_attachment; +DROP TABLE IF EXISTS tl_lanb11_session; +DROP TABLE IF EXISTS tl_lanb11_content; Index: lams_tool_nb/db/sql/init_lams_tool_nb.sql =================================================================== diff -u -ra6857cd86c7c1a7e32287da94351b4db9ee098ef -re1d0de051b86cc7033fc8bd80401bbb16638d156 --- lams_tool_nb/db/sql/init_lams_tool_nb.sql (.../init_lams_tool_nb.sql) (revision a6857cd86c7c1a7e32287da94351b4db9ee098ef) +++ lams_tool_nb/db/sql/init_lams_tool_nb.sql (.../init_lams_tool_nb.sql) (revision e1d0de051b86cc7033fc8bd80401bbb16638d156) @@ -1,13 +1,13 @@ USE lams; -- 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; +DROP TABLE IF EXISTS tl_lanb11_user; +DROP TABLE IF EXISTS tl_lanb11_attachment; +DROP TABLE IF EXISTS tl_lanb11_session; +DROP TABLE IF EXISTS tl_lanb11_content; -- Create a fresh copy of the noticeboard table -CREATE TABLE lams.tl_lanb11_content ( +CREATE TABLE tl_lanb11_content ( uid BIGINT(20) NOT NULL AUTO_INCREMENT , nb_content_id BIGINT(20) UNIQUE NOT NULL , title TEXT @@ -23,7 +23,7 @@ , PRIMARY KEY (uid) )TYPE=InnoDB; -CREATE TABLE lams.tl_lanb11_session ( +CREATE TABLE 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 @@ -36,7 +36,7 @@ REFERENCES lams.tl_lanb11_content (uid) )TYPE=InnoDB; -CREATE TABLE lams.tl_lanb11_user ( +CREATE TABLE tl_lanb11_user ( uid BIGINT(20) NOT NULL AUTO_INCREMENT , user_id BIGINT(20) UNIQUE NOT NULL , nb_session_uid BIGINT(20) NOT NULL @@ -49,7 +49,7 @@ REFERENCES lams.tl_lanb11_session (uid) )TYPE=InnoDB; -CREATE TABLE lams.tl_lanb11_attachment ( +CREATE TABLE tl_lanb11_attachment ( attachment_id BIGINT(20) NOT NULL AUTO_INCREMENT , nb_content_uid BIGINT(20) NOT NULL , filename VARCHAR(255) NOT NULL