diff options
| author | Razvan Becheriu <razvan@isc.org> | 2024-10-25 12:09:51 +0200 |
|---|---|---|
| committer | Razvan Becheriu <razvan@isc.org> | 2024-10-28 10:07:24 +0100 |
| commit | 86c23616ccd71ed0307c8737010723df33a47db7 (patch) | |
| tree | 7a9fc0a96a7a80350a4641a8c685bcf25e70aee9 /src/share/database | |
| parent | [#3602] Add test failure on exception thrown (diff) | |
| download | kea-86c23616ccd71ed0307c8737010723df33a47db7.tar.xz kea-86c23616ccd71ed0307c8737010723df33a47db7.zip | |
[#3631] fixed option_def_data_type int8 entry with id 3
Diffstat (limited to 'src/share/database')
4 files changed, 6 insertions, 2 deletions
diff --git a/src/share/database/scripts/mysql/dhcpdb_create.mysql b/src/share/database/scripts/mysql/dhcpdb_create.mysql index 9bd11a78ba..1466b6584f 100644 --- a/src/share/database/scripts/mysql/dhcpdb_create.mysql +++ b/src/share/database/scripts/mysql/dhcpdb_create.mysql @@ -5972,7 +5972,7 @@ BEGIN (0, 'empty'), (1, 'binary'), (2, 'boolean'), - (3, 'int8"'), + (3, 'int8'), (4, 'int16'), (5, 'int32'), (6, 'uint8'), diff --git a/src/share/database/scripts/mysql/upgrade_025_to_026.sh.in b/src/share/database/scripts/mysql/upgrade_025_to_026.sh.in index cc99a63d82..876079b58b 100644 --- a/src/share/database/scripts/mysql/upgrade_025_to_026.sh.in +++ b/src/share/database/scripts/mysql/upgrade_025_to_026.sh.in @@ -63,6 +63,8 @@ ALTER TABLE dhcp4_options ALTER TABLE dhcp6_options ADD COLUMN client_classes LONGTEXT DEFAULT NULL; +UPDATE option_def_data_type SET name='int8' where id = 3; + -- Update the schema version number. UPDATE schema_version SET version = '26', minor = '0'; diff --git a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql index 8d3e938827..04413cad9d 100644 --- a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql +++ b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql @@ -6432,7 +6432,7 @@ BEGIN (0, 'empty'), (1, 'binary'), (2, 'boolean'), - (3, 'int8"'), + (3, 'int8'), (4, 'int16'), (5, 'int32'), (6, 'uint8'), diff --git a/src/share/database/scripts/pgsql/upgrade_025_to_026.sh.in b/src/share/database/scripts/pgsql/upgrade_025_to_026.sh.in index 6e14f6b100..cd40a1f1a4 100644 --- a/src/share/database/scripts/pgsql/upgrade_025_to_026.sh.in +++ b/src/share/database/scripts/pgsql/upgrade_025_to_026.sh.in @@ -46,6 +46,8 @@ ALTER TABLE dhcp4_options ALTER TABLE dhcp6_options ADD COLUMN client_classes TEXT DEFAULT NULL; +UPDATE option_def_data_type SET name='int8' where id = 3; + -- Update the schema version number. UPDATE schema_version SET version = '26', minor = '0'; |