Ok, I've found the sql file on
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/kohastructure.sql
I've executed:
CREATE TABLE IF NOT EXISTS items_search_fields (
name VARCHAR(255) NOT NULL,
label VARCHAR(255) NOT NULL,
tagfield CHAR(3) NOT NULL,
tagsubfield CHAR(1) NULL DEFAULT NULL,
authorised_values_category VARCHAR(32) NULL DEFAULT NULL,
PRIMARY KEY(name),
CONSTRAINT items_search_fields_authorised_values_category
FOREIGN KEY (authorised_values_category) REFERENCES
authorised_value_categories (category_name)
ON DELETE SET NULL ON UPDATE CASCADE)
ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Then checked if was created: select * from information_schema.columns where
table_name='items_search_fields';
Everything ok.
Then executed: koha-upgrade-schema
It looks that nothing happened...
Do I have to make something else?
Thanks
-----
Koha version: 16.05.05
- -
José Anjos
--
View this message in context:
http://koha.1045719.n5.nabble.com/Migration-erros-from-16-05-to-16-11-tp5912344p5912431.html
Sent from the Koha-general mailing list archive at Nabble.com.
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
