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.8 -r1.9 --- lams_tool_nb/db/sql/create_lams_tool_nb.sql 10 Aug 2005 06:54:34 -0000 1.8 +++ lams_tool_nb/db/sql/create_lams_tool_nb.sql 10 Aug 2005 23:48:38 -0000 1.9 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/drop_lams_tool_nb.sql,v diff -u -r1.3 -r1.4 --- lams_tool_nb/db/sql/drop_lams_tool_nb.sql 28 Jul 2005 06:55:09 -0000 1.3 +++ lams_tool_nb/db/sql/drop_lams_tool_nb.sql 10 Aug 2005 23:48:38 -0000 1.4 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/Attic/init_lams_tool_nb.sql,v diff -u -r1.7 -r1.8 --- lams_tool_nb/db/sql/init_lams_tool_nb.sql 5 Aug 2005 05:03:50 -0000 1.7 +++ lams_tool_nb/db/sql/init_lams_tool_nb.sql 10 Aug 2005 23:48:38 -0000 1.8 @@ -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