Page History

...

Replace "freeslick.driverNameHere$" with the name of the driver you are using ("freeslick.OracleProfile$" for Oracle, and "freeslick.MSSQLServerProfile$" for SQL Server).

...

Database Changes

SHRINE 1.22 adds a table of problems to each SHRINE node, to help diagnose problems observed on that node.

• Add a table named "problems" to the shrine_query_history database

/* Working tables in shrine_query_history */
create table `problems` (`id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,`codec` TEXT NOT NULL,`stampText` TEXT NOT NULL,`summary` TEXT NOT NULL,`description` TEXT NOT NULL,`detailsXml` TEXT NOT NULL,`epoch` BIGINT NOT NULL);
create index `idx_epoch` on `problems` (`epoch`)

• Expand the limit on the number of characters in a flag message to the database's limit for unbound text

alter table SHRINE_QUERY change flag_message flag_message text;

• Change the PRIVILEGED_USER table's threshold column to accept nulls (and use the default threshold after resetting for lockout).

alter table PRIVILEGED_USER change threshold threshold int null;

TODO start here, hub and qep and general tables

Create Query Audit Databases

SHRINE 1.2220.4 1 adds query audit databases, which will need to be created in order for SHRINE 1.20.1 to function.

...