Index: lams_common/db/sql/create_lams_11_tables.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/create_lams_11_tables.sql,v diff -u -r1.167.2.7 -r1.167.2.8 --- lams_common/db/sql/create_lams_11_tables.sql 2 Mar 2017 05:54:48 -0000 1.167.2.7 +++ lams_common/db/sql/create_lams_11_tables.sql 26 Mar 2017 09:50:13 -0000 1.167.2.8 @@ -531,12 +531,12 @@ , PRIMARY KEY (condition_id) ); -CREATE TABLE lams_TEXT_search_condition ( +CREATE TABLE lams_text_search_condition ( condition_id BIGINT(20) NOT NULL - , TEXT_search_all_words TEXT - , TEXT_search_phrase TEXT - , TEXT_search_any_words TEXT - , TEXT_search_excluded_words TEXT + , text_search_all_words TEXT + , text_search_phrase TEXT + , text_search_any_words TEXT + , text_search_excluded_words TEXT , PRIMARY KEY (condition_id) , CONSTRAINT TextSearchConditionInheritance FOREIGN KEY (condition_id) REFERENCES lams_branch_condition(condition_id) ON DELETE CASCADE ON UPDATE CASCADE @@ -1528,4 +1528,4 @@ REFERENCES lams_organisation (organisation_id) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT FK_lams_favorite_organisation_2 FOREIGN KEY (user_id) REFERENCES lams_user (user_id) ON DELETE NO ACTION ON UPDATE NO ACTION -); \ No newline at end of file +);