Index: lams_common/db/sql/create_lams_11_tables.sql =================================================================== diff -u -r2c19eb23283367bcade16c0a5a1b5cfb2f5d02cf -r70385b8ba08ee1068d32470d35129e22d551a960 --- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 2c19eb23283367bcade16c0a5a1b5cfb2f5d02cf) +++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 70385b8ba08ee1068d32470d35129e22d551a960) @@ -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 +);