# - #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 = "18.12.00.060";
+$VERSION = "18.12.00.061";
sub version {
return $VERSION;
data_type: 'mediumtext'
is_nullable: 1
-=head2 flgAnonymized
+=head2 anonymized
- accessor: 'flg_anonymized'
data_type: 'tinyint'
default_value: 0
- is_nullable: 1
+ is_nullable: 0
=cut
{ data_type => "integer", default_value => 0, is_nullable => 1 },
"overdrive_auth_token",
{ data_type => "mediumtext", is_nullable => 1 },
- "flgAnonymized",
- {
- accessor => "flg_anonymized",
- data_type => "tinyint",
- default_value => 0,
- is_nullable => 1,
- },
+ "anonymized",
+ { data_type => "tinyint", default_value => 0, is_nullable => 0 },
);
=head1 PRIMARY KEY
__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-04-17 11:11:33
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZkPU/EUsZVXiRoQ1E8NMbw
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-04-25 10:08:38
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3qd/l8OkObSn8gTKTsHrkA
__PACKAGE__->belongs_to(
"guarantor",
data_type: 'mediumtext'
is_nullable: 1
-=head2 flgAnonymized
+=head2 anonymized
- accessor: 'flg_anonymized'
data_type: 'tinyint'
default_value: 0
- is_nullable: 1
+ is_nullable: 0
=cut
{ data_type => "integer", default_value => 0, is_nullable => 1 },
"overdrive_auth_token",
{ data_type => "mediumtext", is_nullable => 1 },
- "flgAnonymized",
- {
- accessor => "flg_anonymized",
- data_type => "tinyint",
- default_value => 0,
- is_nullable => 1,
- },
+ "anonymized",
+ { data_type => "tinyint", default_value => 0, is_nullable => 0 },
);
-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-04-17 11:11:33
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9XbNY+E7YqzsiUldTFg6Zg
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-04-25 10:08:38
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hzKeGjtecf3VyEvaBhDmUg
# You can replace this text with custom code or comments, and it will be preserved on regeneration
+++ /dev/null
-$DBversion = 'XXX';
-if( CheckVersion( $DBversion ) ) {
-
- if ( column_exists( 'borrowers', 'flgAnonymized' ) ) {
- $dbh->do(q{
- UPDATE borrowers SET flgAnonymized = 0 WHERE flgAnonymized IS NULL
- });
- $dbh->do(q{
- ALTER TABLE borrowers
- CHANGE `flgAnonymized` `anonymized` TINYINT(1) NOT NULL DEFAULT 0
- });
- }
-
- if ( column_exists( 'deletedborrowers', 'flgAnonymized' ) ) {
- $dbh->do(q{
- UPDATE deletedborrowers SET flgAnonymized = 0 WHERE flgAnonymized IS NULL
- });
- $dbh->do(q{
- ALTER TABLE deletedborrowers
- CHANGE `flgAnonymized` `anonymized` TINYINT(1) NOT NULL DEFAULT 0
- });
- }
-
- SetVersion( $DBversion );
- print "Upgrade to $DBversion done (Bug 21336 - (follow-up) Rename flgAnonymized column)\n";
-}
printf "Upgrade to $DBversion done (Bug 22564 - Fix accounttype 'Rep' - %d updated)\n", $rows;
}
+$DBversion = '18.12.00.061';
+if( CheckVersion( $DBversion ) ) {
+
+ if ( column_exists( 'borrowers', 'flgAnonymized' ) ) {
+ $dbh->do(q{
+ UPDATE borrowers SET flgAnonymized = 0 WHERE flgAnonymized IS NULL
+ });
+ $dbh->do(q{
+ ALTER TABLE borrowers
+ CHANGE `flgAnonymized` `anonymized` TINYINT(1) NOT NULL DEFAULT 0
+ });
+ }
+
+ if ( column_exists( 'deletedborrowers', 'flgAnonymized' ) ) {
+ $dbh->do(q{
+ UPDATE deletedborrowers SET flgAnonymized = 0 WHERE flgAnonymized IS NULL
+ });
+ $dbh->do(q{
+ ALTER TABLE deletedborrowers
+ CHANGE `flgAnonymized` `anonymized` TINYINT(1) NOT NULL DEFAULT 0
+ });
+ }
+
+ SetVersion( $DBversion );
+ print "Upgrade to $DBversion done (Bug 21336 - (follow-up) Rename flgAnonymized column)\n";
+}
+
# SEE bug 13068
# if there is anything in the atomicupdate, read and execute it.