summaryrefslogtreecommitdiff
path: root/src/share/database/scripts/pgsql/Makefile.am
AgeCommit message (Collapse)Author
2018-07-07[5584] Addressed commentsFrancis Dupont
2018-06-21[5584] Checkpoint: updated schema, code and partially testsFrancis Dupont
2018-02-22[5522] Fixed subnet_id column types in MySQL and Postgres schemasThomas Markwalder
new file: src/share/database/scripts/mysql/upgrade_5.1_to_5.2.sh.in renamed: src/share/database/scripts/mysql/upgrade_5.1_to_6.0.sh.in -> src/share/database/scripts/mysql/upgrade_5.2_to_6.0.sh.in new file: src/share/database/scripts/pgsql/upgrade_3.2_to_3.3.sh.in renamed: src/share/database/scripts/pgsql/upgrade_3.2_to_4.0.sh.in -> src/share/database/scripts/pgsql/upgrade_3.3_to_4.0.sh.in src/lib/dhcpsrv/pgsql_host_data_source.cc changed OID_INT4 to OID_INT8 for subnet_id inputs in TaggedStatements src/lib/dhcpsrv/tests/generic_host_data_source_unittest.h src/lib/dhcpsrv/tests/generic_host_data_source_unittest.cc src/lib/dhcpsrv/tests/mysql_host_data_source_unittest.cc src/lib/dhcpsrv/tests/pgsql_host_data_source_unittest.cc Added new tests to verify maxium value for subnet_id works src/share/database/scripts/mysql/dhcpdb_create.mysql Added 5.1 to 5.2 changes src/share/database/scripts/pgsql/dhcpdb_create.pgsql Added 3.2 to 3.3 changes
2017-12-17[5351] Addressed nearly all commentsFrancis Dupont
2017-11-07[5416] Allow null or 0 values in unique indexes within hosts table.Marcin Siodelski
Also, updated MySQL backend to convert 0 values to null to make sure that multiple reservations are possible when IPv4 address is unspecified.
2017-10-20[5266] Added *.sh from *.sh.in to distcleanFrancis Dupont
2017-05-18[master] scripts upgrade_5.0_to_5.1.sh upgrade_3.0_to_3.1.sh will be now ↵Wlodek Wencel
installed
2016-06-15[4275] Postgresql schema 3.0 now matches MySql schema 4.2Thomas Markwalder
Added 4.1 to 4.2 updates from MySQL and created upgrade script for 2.0 to 3.0 src/share/database/scripts/pgsql/dhcpdb_create.pgsql - Enclosed the entire script in a single transaction - Removed DROP TABLE statements - Added host_identifier_type table and data - Added dhcp_option_scope table and data - Updated unqiue constraints for hosts table - Added scope_id and foreign key constraint to dhcp4_options table - Added scope_id and foreign key constraint to dhcp6_options table - Added unique contraint to ipv6_reservations table - Changed 'HWADDR_SOURCE_DOCSIS' to 'HWADDR_SOURCE_DOCSIS_CMTS' - Inserted row for 'HWADDR_SOURCE_UKNOWN' src/share/database/scripts/pgsql/dhcpdb_drop.pgsql Added drops for host_identifier_type and dhcp_option_scope src/share/database/scripts/pgsql/upgrade_2.0_to_3.0.sh.in New file for upgrading Postgresql from 2.0 to 3.0 configure.ac Added src/share/database/scripts/pgsql/upgrade_2.0_to_3.0.sh src/bin/admin/tests/pgsql_tests.sh.in - pgsql_upgrade_1_0_to_2_0 - new function which contains all the checks used to verify 1.0 to 2.0 upgrade (extracted from pgsql_upgrade_test) - pgsql_upgrade_2_0_to_3_0 - new function which contains all the checks used to verify 2.0 to 3.0 upgrade - pgsql_upgrade_test() - modified use new upgrade check fucntions src/share/database/scripts/pgsql/Makefile.am Added entry for upgrade_2.0_to_3.0.sh
2016-04-12[4239] Moved schema scripts to src/share/database/scriptsThomas Markwalder
Moved schema scripts into a new common location: src/share/database/scripts to make them accessible to both kea-admin and dhcpsrv testing
generated by cgit v1.2.3 (git 2.39.1) at 2026-09-14 07:04:23 +0000