# - #4 : the developer version. The 4th number is the database subversion.
# used by developers when the database changes. updatedatabase take care of the changes itself
# and is automatically called by Auth.pm when needed.
-$VERSION = "19.12.00.082";
+$VERSION = "19.12.00.083";
sub version {
return $VERSION;
+++ /dev/null
-$DBversion = 'XXX'; # will be replaced by the RM
-if( CheckVersion( $DBversion ) ) {
-
- unless ( column_exists( 'authorised_value_categories', 'is_system' ) ) {
- $dbh->do(q|
- ALTER TABLE authorised_value_categories
- ADD COLUMN is_system TINYINT(1) DEFAULT 0 AFTER category_name
- |);
- }
-
- $dbh->do(q|
- UPDATE authorised_value_categories
- SET is_system = 1
- WHERE category_name IN ('LOC', 'LOST', 'WITHDRAWN', 'Bsort1', 'Bsort2', 'Asort1', 'Asort2', 'SUGGEST', 'DAMAGED', 'LOST', 'BOR_NOTES', 'CCODE', 'NOT_LOAN')
- |);
-
- $dbh->do(q|
- UPDATE authorised_value_categories
- SET is_system = 1
- WHERE category_name IN ('branches', 'itemtypes', 'cn_source')
- |);
-
- # Always end with this (adjust the bug info)
- NewVersion( $DBversion, 17355, "Add is_system to authorised_value_categories table");
-}
NewVersion( $DBversion, 23794, \@detail);
}
+$DBversion = '19.12.00.083';
+if( CheckVersion( $DBversion ) ) {
+
+ unless ( column_exists( 'authorised_value_categories', 'is_system' ) ) {
+ $dbh->do(q|
+ ALTER TABLE authorised_value_categories
+ ADD COLUMN is_system TINYINT(1) DEFAULT 0 AFTER category_name
+ |);
+ }
+
+ $dbh->do(q|
+ UPDATE authorised_value_categories
+ SET is_system = 1
+ WHERE category_name IN ('LOC', 'LOST', 'WITHDRAWN', 'Bsort1', 'Bsort2', 'Asort1', 'Asort2', 'SUGGEST', 'DAMAGED', 'LOST', 'BOR_NOTES', 'CCODE', 'NOT_LOAN')
+ |);
+
+ $dbh->do(q|
+ UPDATE authorised_value_categories
+ SET is_system = 1
+ WHERE category_name IN ('branches', 'itemtypes', 'cn_source')
+ |);
+
+ # Always end with this (adjust the bug info)
+ NewVersion( $DBversion, 17355, "Add is_system to authorised_value_categories table");
+}
+
# SEE bug 13068
# if there is anything in the atomicupdate, read and execute it.
my $update_dir = C4::Context->config('intranetdir') . '/installer/data/mysql/atomicupdate/';