Attachment #25680 for bug #10012

View | Details | Raw Unified | Return to bug 10012
Collapse All | Expand All




package Koha::Schema::Result::Nozebra;

# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE

use strict;
use warnings;

use base 'DBIx::Class::Core';


=head1 NAME

Koha::Schema::Result::Nozebra

=cut

__PACKAGE__->table("nozebra");

=head1 ACCESSORS

=head2 server

  data_type: 'varchar'
  is_nullable: 0
  size: 20

=head2 indexname

  data_type: 'varchar'
  is_nullable: 0
  size: 40

=head2 value

  data_type: 'varchar'
  is_nullable: 0
  size: 250

=head2 biblionumbers

  data_type: 'longtext'
  is_nullable: 0

=cut

__PACKAGE__->add_columns(
  "server",
  { data_type => "varchar", is_nullable => 0, size => 20 },
  "indexname",
  { data_type => "varchar", is_nullable => 0, size => 40 },
  "value",
  { data_type => "varchar", is_nullable => 0, size => 250 },
  "biblionumbers",
  { data_type => "longtext", is_nullable => 0 },
);


# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HEbJLtO1Tpyvy9/w8dnS2w


# You can replace this text with custom content, and it will be preserved on regeneration
1;

Lines 41-47 UPDATE systempreferences SET value = 'en,it-IT' WHERE variable = 'language'; Link Here

(-)a/installer/data/mysql/it-IT/necessari/system_preferences.sql (-2 lines)
41	UPDATE systempreferences SET value = '0' WHERE variable = 'LetterLog';	41	UPDATE systempreferences SET value = '0' WHERE variable = 'LetterLog';
42	UPDATE systempreferences SET value = '0' WHERE variable = 'MARCOrgCode';	42	UPDATE systempreferences SET value = '0' WHERE variable = 'MARCOrgCode';
43	UPDATE systempreferences SET value = '2' WHERE variable = 'maxreserves';	43	UPDATE systempreferences SET value = '2' WHERE variable = 'maxreserves';
44	UPDATE systempreferences SET value = '0' WHERE variable = 'NoZebra';
45	UPDATE systempreferences SET value = '0' WHERE variable = 'OpacAuthorities';	44	UPDATE systempreferences SET value = '0' WHERE variable = 'OpacAuthorities';
46	UPDATE systempreferences SET value = 'relevance' WHERE variable = 'OPACdefaultSortField';	45	UPDATE systempreferences SET value = 'relevance' WHERE variable = 'OPACdefaultSortField';
47	UPDATE systempreferences SET value = 'asc' WHERE variable = 'OPACdefaultSortOrder';	46	UPDATE systempreferences SET value = 'asc' WHERE variable = 'OPACdefaultSortOrder';
Lines 67-70 UPDATE systempreferences SET value = '1' WHERE variable = 'XISBN'; Link Here
67		66
68	UPDATE systempreferences SET value = '#200\|<span style=\"font-weight:bold\">\|{200a}{. 200c}{ : 200e}{200d}{ / 200f}{ ; 200g}{. 200h}{. 200i}\|</span>\r\n#210\|. – \|{210a}{ : 210c}{, 210d}\|\r\n#215\|. – \|{215a}{ ; 215d}\|\r\n#225\|. – \|{(225a}{ ; 225v)}\|\r\n#010\|. – \|{ISBN 010a}\|' WHERE variable = 'ISBD';	67	UPDATE systempreferences SET value = '#200\|<span style=\"font-weight:bold\">\|{200a}{. 200c}{ : 200e}{200d}{ / 200f}{ ; 200g}{. 200h}{. 200i}\|</span>\r\n#210\|. – \|{210a}{ : 210c}{, 210d}\|\r\n#215\|. – \|{215a}{ ; 215d}\|\r\n#225\|. – \|{(225a}{ ; 225v)}\|\r\n#010\|. – \|{ISBN 010a}\|' WHERE variable = 'ISBD';
69		68
70	UPDATE systempreferences SET value = '\'title\' => \'200a,200c,200d,200e,225a,225d,225e,225f,225h,225i,225v,500,501,503,510,512,513,514,515,516,517,518,519,520,530,531,532,540,541,545,604t,610t,605a\',\r\n\'author\' => \'200f,600a,601a,604a,700a,700b,700c,700d,700a,701b,701c,701d,702a,702b,702c,702d,710a,710b,710c,710d,711a,711b,711c,711d,712a,712b,712c,712d\',\r\n\'isbn\' => \'010a\',\r\n\'issn\' => \'011a\',\r\n\'biblionumber => \'0909\',\r\n\'itemtype\' => \'200b\',\r\n\'language\' => \'101a\',\r\n\'publisher\' => \'210c\',\r\n\'date\' => \'210d\',\r\n\'note\' => \r\n\'300a,301a,302a,303a,304a,305a,306az,307a,308a,309a,310a,311a,312a,313a,314a,315a,316a,317a,318a,319a,320a,321a,322a,323a,324a,325a,326a,327a,328a,330a,332a,333a,336a,337a,345a\',\r\n\'Koha-Auth-Number\' => \'6009,6019,6029,6039,6049,6059,6069,6109,7009,7019,7029,7109,7119,7129\',\r\n \'subject\' => \'600,601,606,610*\',\r\n \'dewey\' => \'676a\',\r\n \'homebranch\' => \'995a,995b\',\r\n \'lcn\' => \'995k\'' WHERE variable = 'NoZebraIndexes';




    SetVersion($DBversion);
}

$DBversion = "3.15.00.XXX";
if ( CheckVersion($DBversion) ) {
    $dbh->do(q{
        DELETE FROM systempreferences WHERE variable = 'NoZebraIndexes'
    });
    print "Upgrade to $DBversion done (Bug 10012 - remove last vestiges of NoZebra)\n";
    SetVersion($DBversion);
}

=head1 FUNCTIONS

=head2 TableExists($table)
- 

Return to bug 10012

Lines 8012-8017 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +9 lines)
8012	SetVersion($DBversion);	8012	SetVersion($DBversion);
8013	}	8013	}
8014		8014
		8015	$DBversion = "3.15.00.XXX";
		8016	if ( CheckVersion($DBversion) ) {
		8017	$dbh->do(q{
		8018	DELETE FROM systempreferences WHERE variable = 'NoZebraIndexes'
		8019	});
		8020	print "Upgrade to $DBversion done (Bug 10012 - remove last vestiges of NoZebra)\n";
		8021	SetVersion($DBversion);
		8022	}
		8023
8015	=head1 FUNCTIONS	8024	=head1 FUNCTIONS
8016		8025
8017	=head2 TableExists($table)	8026	=head2 TableExists($table)
8018	-

Lines 1-64 Link Here

(-)a/Koha/Schema/Result/Nozebra.pm (-64 lines)
1	package Koha::Schema::Result::Nozebra;
2
3	# Created by DBIx::Class::Schema::Loader
4	# DO NOT MODIFY THE FIRST PART OF THIS FILE
5
6	use strict;
7	use warnings;
8
9	use base 'DBIx::Class::Core';
10
11
12	=head1 NAME
13
14	Koha::Schema::Result::Nozebra
15
16	=cut
17
18	__PACKAGE__->table("nozebra");
19
20	=head1 ACCESSORS
21
22	=head2 server
23
24	data_type: 'varchar'
25	is_nullable: 0
26	size: 20
27
28	=head2 indexname
29
30	data_type: 'varchar'
31	is_nullable: 0
32	size: 40
33
34	=head2 value
35
36	data_type: 'varchar'
37	is_nullable: 0
38	size: 250
39
40	=head2 biblionumbers
41
42	data_type: 'longtext'
43	is_nullable: 0
44
45	=cut
46
47	__PACKAGE__->add_columns(
48	"server",
49	{ data_type => "varchar", is_nullable => 0, size => 20 },
50	"indexname",
51	{ data_type => "varchar", is_nullable => 0, size => 40 },
52	"value",
53	{ data_type => "varchar", is_nullable => 0, size => 250 },
54	"biblionumbers",
55	{ data_type => "longtext", is_nullable => 0 },
56	);
57
58
59	# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
60	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HEbJLtO1Tpyvy9/w8dnS2w
61
62
63	# You can replace this text with custom content, and it will be preserved on regeneration
64	1;