MySql

Run the following sql with the database user of codeBeamer:

CREATE FULLTEXT INDEX task_details_fidx ON task(details);

Oracle

Run the following sql with a system administrator user. The 'user' should be the database user of codeBeamer:

GRANT EXECUTE ON CTXSYS.CTX_DDL TO user

Run the following sql with the database user of codeBeamer:

begin
        begin
            CTX_DDL.DROP_STOPLIST ('TASK_DETAILS_STOPLIST');
    	EXCEPTION
    		WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('NOT EXIST');
    	end;
    CTX_DDL.CREATE_STOPLIST ('TASK_DETAILS_STOPLIST', 'BASIC_STOPLIST');
    CTX_DDL.ADD_STOPWORD ('TASK_DETAILS_STOPLIST', 'a');
    CTX_DDL.ADD_STOPWORD ('TASK_DETAILS_STOPLIST', 'an');
    CTX_DDL.ADD_STOPWORD ('TASK_DETAILS_STOPLIST', 'no');
    CTX_DDL.ADD_STOPWORD ('TASK_DETAILS_STOPLIST', 'not');
    EXECUTE IMMEDIATE 'CREATE INDEX task_details_fidx ON TASK(DETAILS) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS(''SYNC(ON COMMIT) STOPLIST TASK_DETAILS_STOPLIST'')';
    end;