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

(-)a/Koha/Schema/Result/MarcSubfieldStructure.pm (-6 / +6 lines)
Lines 79-85 __PACKAGE__->table("marc_subfield_structure"); Link Here
79
  data_type: 'varchar'
79
  data_type: 'varchar'
80
  is_foreign_key: 1
80
  is_foreign_key: 1
81
  is_nullable: 1
81
  is_nullable: 1
82
  size: 20
82
  size: 32
83
83
84
=head2 authtypecode
84
=head2 authtypecode
85
85
Lines 124-130 __PACKAGE__->table("marc_subfield_structure"); Link Here
124
124
125
=head2 defaultvalue
125
=head2 defaultvalue
126
126
127
  data_type: 'text'
127
  data_type: 'mediumtext'
128
  is_nullable: 1
128
  is_nullable: 1
129
129
130
=head2 maxlength
130
=head2 maxlength
Lines 153-159 __PACKAGE__->add_columns( Link Here
153
  "tab",
153
  "tab",
154
  { data_type => "tinyint", is_nullable => 1 },
154
  { data_type => "tinyint", is_nullable => 1 },
155
  "authorised_value",
155
  "authorised_value",
156
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 20 },
156
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 32 },
157
  "authtypecode",
157
  "authtypecode",
158
  { data_type => "varchar", is_nullable => 1, size => 20 },
158
  { data_type => "varchar", is_nullable => 1, size => 20 },
159
  "value_builder",
159
  "value_builder",
Lines 169-175 __PACKAGE__->add_columns( Link Here
169
  "link",
169
  "link",
170
  { data_type => "varchar", is_nullable => 1, size => 80 },
170
  { data_type => "varchar", is_nullable => 1, size => 80 },
171
  "defaultvalue",
171
  "defaultvalue",
172
  { data_type => "text", is_nullable => 1 },
172
  { data_type => "mediumtext", is_nullable => 1 },
173
  "maxlength",
173
  "maxlength",
174
  { data_type => "integer", default_value => 9999, is_nullable => 0 },
174
  { data_type => "integer", default_value => 9999, is_nullable => 0 },
175
);
175
);
Lines 213-220 __PACKAGE__->belongs_to( Link Here
213
);
213
);
214
214
215
215
216
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54
216
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-02 18:57:57
217
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:V++tjMyI92SwFjikQAAJFg
217
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:18iBiNNiwTSYtKk28aoLJg
218
218
219
219
220
# You can replace this text with custom content, and it will be preserved on regeneration
220
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/installer/data/mysql/kohastructure.sql (-5 / +5 lines)
Lines 3444-3450 CREATE TABLE uploaded_files ( Link Here
3444
    dir MEDIUMTEXT NOT NULL,
3444
    dir MEDIUMTEXT NOT NULL,
3445
    filesize int(11),
3445
    filesize int(11),
3446
    dtcreated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3446
    dtcreated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3447
    uploadcategorycode tinytext,
3447
    uploadcategorycode TEXT,
3448
    owner int(11),
3448
    owner int(11),
3449
    public tinyint,
3449
    public tinyint,
3450
    permanent tinyint,
3450
    permanent tinyint,
Lines 3967-3973 CREATE TABLE deletedbiblio_metadata ( Link Here
3967
3967
3968
CREATE TABLE IF NOT EXISTS club_templates (
3968
CREATE TABLE IF NOT EXISTS club_templates (
3969
  id int(11) NOT NULL AUTO_INCREMENT,
3969
  id int(11) NOT NULL AUTO_INCREMENT,
3970
  `name` tinytext NOT NULL,
3970
  `name` TEXT NOT NULL,
3971
  description MEDIUMTEXT,
3971
  description MEDIUMTEXT,
3972
  is_enrollable_from_opac tinyint(1) NOT NULL DEFAULT '0',
3972
  is_enrollable_from_opac tinyint(1) NOT NULL DEFAULT '0',
3973
  is_email_required tinyint(1) NOT NULL DEFAULT '0',
3973
  is_email_required tinyint(1) NOT NULL DEFAULT '0',
Lines 3987-3993 CREATE TABLE IF NOT EXISTS club_templates ( Link Here
3987
CREATE TABLE IF NOT EXISTS clubs (
3987
CREATE TABLE IF NOT EXISTS clubs (
3988
  id int(11) NOT NULL AUTO_INCREMENT,
3988
  id int(11) NOT NULL AUTO_INCREMENT,
3989
  club_template_id int(11) NOT NULL,
3989
  club_template_id int(11) NOT NULL,
3990
  `name` tinytext NOT NULL,
3990
  `name` TEXT NOT NULL,
3991
  description MEDIUMTEXT,
3991
  description MEDIUMTEXT,
3992
  date_start date DEFAULT NULL,
3992
  date_start date DEFAULT NULL,
3993
  date_end date DEFAULT NULL,
3993
  date_end date DEFAULT NULL,
Lines 4030-4036 CREATE TABLE IF NOT EXISTS club_enrollments ( Link Here
4030
CREATE TABLE IF NOT EXISTS club_template_enrollment_fields (
4030
CREATE TABLE IF NOT EXISTS club_template_enrollment_fields (
4031
  id int(11) NOT NULL AUTO_INCREMENT,
4031
  id int(11) NOT NULL AUTO_INCREMENT,
4032
  club_template_id int(11) NOT NULL,
4032
  club_template_id int(11) NOT NULL,
4033
  `name` tinytext NOT NULL,
4033
  `name` TEXT NOT NULL,
4034
  description MEDIUMTEXT,
4034
  description MEDIUMTEXT,
4035
  authorised_value_category varchar(16) DEFAULT NULL,
4035
  authorised_value_category varchar(16) DEFAULT NULL,
4036
  PRIMARY KEY (id),
4036
  PRIMARY KEY (id),
Lines 4061-4067 CREATE TABLE IF NOT EXISTS club_enrollment_fields ( Link Here
4061
CREATE TABLE IF NOT EXISTS club_template_fields (
4061
CREATE TABLE IF NOT EXISTS club_template_fields (
4062
  id int(11) NOT NULL AUTO_INCREMENT,
4062
  id int(11) NOT NULL AUTO_INCREMENT,
4063
  club_template_id int(11) NOT NULL,
4063
  club_template_id int(11) NOT NULL,
4064
  `name` tinytext NOT NULL,
4064
  `name` TEXT NOT NULL,
4065
  description MEDIUMTEXT,
4065
  description MEDIUMTEXT,
4066
  authorised_value_category varchar(16) DEFAULT NULL,
4066
  authorised_value_category varchar(16) DEFAULT NULL,
4067
  PRIMARY KEY (id),
4067
  PRIMARY KEY (id),
(-)a/installer/data/mysql/updatedatabase.pl (-3 / +4 lines)
Lines 15468-15474 if( CheckVersion( $DBversion ) ) { Link Here
15468
                        MODIFY COLUMN kohafield
15468
                        MODIFY COLUMN kohafield
15469
                            VARCHAR(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
15469
                            VARCHAR(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
15470
                        MODIFY COLUMN authorised_value
15470
                        MODIFY COLUMN authorised_value
15471
                            VARCHAR(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
15471
                            VARCHAR(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
15472
                        MODIFY COLUMN authtypecode
15472
                        MODIFY COLUMN authtypecode
15473
                            VARCHAR(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
15473
                            VARCHAR(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
15474
                        MODIFY COLUMN value_builder
15474
                        MODIFY COLUMN value_builder
Lines 15478-15484 if( CheckVersion( $DBversion ) ) { Link Here
15478
                        MODIFY COLUMN seealso
15478
                        MODIFY COLUMN seealso
15479
                            VARCHAR(1100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
15479
                            VARCHAR(1100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
15480
                        MODIFY COLUMN link
15480
                        MODIFY COLUMN link
15481
                            VARCHAR(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL
15481
                            VARCHAR(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
15482
                        MODIFY COLUMN defaultvalue
15483
                            MEDIUMTEXT COLLATE utf8mb4_unicode_ci default NULL
15482
                |);
15484
                |);
15483
                $dbh->do(qq|ALTER TABLE $name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci|);
15485
                $dbh->do(qq|ALTER TABLE $name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci|);
15484
            }
15486
            }
15485
- 

Return to bug 18336