summaryrefslogtreecommitdiff
path: root/src/share/database/scripts/pgsql
AgeCommit message (Collapse)Author
2018-09-05[#15,!11] Added new scripts and netconf tests to .gitignoreMarcin Siodelski
2018-08-24[#15,!11] Schema upgrades for Kea 1.5, now update subnet ids in existing ↵Thomas Markwalder
host reservations src/bin/admin/tests/pgsql_tests.sh.in src/bin/admin/tests/cql_tests.sh.in src/bin/admin/tests/mysql_tests.sh.in Added functions that verify subnet id values are updated src/share/database/scripts/cql/upgrade_2.0_to_3.0.sh.in src/share/database/scripts/mysql/upgrade_6.0_to_7.0.sh.in src/share/database/scripts/pgsql/upgrade_4.0_to_5.0.sh.in Added logic to update subnet id values in existing reservations and options
2018-07-23[github88] CQL/SQL scripts corrected (unit-tests in src/bin/admin now pass)Tomek Mrugalski
2018-07-23fixed minor issuesmayya
2018-07-23review comments 2mayya
review comments 2 test1 fixed unit tests fixed cassandra fixed cassandra2
2018-07-23[lib] Address review comments for #83mayya
See #88 for review comments modified upgrade files modified tests
2018-07-23[lib] Extend host structure to support auth keys for reconfiguration.mayya
See issue #83
2018-07-07[5584] Addressed commentsFrancis Dupont
2018-07-06[5584] Minor changes after review.Tomek Mrugalski
2018-06-22[5584] Checkpoint: core code and test doneFrancis Dupont
2018-06-21[5584] Checkpoint: updated schema, code and partially testsFrancis Dupont
2018-05-09[5587] PostgreSQL support for shared lease stats implementationThomas Markwalder
src/share/database/scripts/pgsql/dhcpdb_create.pgsql Adds lease<4/6>_stat tables and triggers src/share/database/scripts/pgsql/dhcpdb_drop.pgsql Added drops for lease<4/6>_stat tables and triggers src/share/database/scripts/pgsql/upgrade_3.3_to_4.0.sh.in Adds lease<4/6>_stat tables and triggers Populates stat tables from existing lease table content src/bin/admin/tests/mysql_tests.sh.in mysql_lease6_stat_per_type() - fixed typo in test src/bin/admin/tests/pgsql_tests.sh.in run_statement() - new convenience fucntion for running statement with option expected outcome pgsql_upgrade_schema_to_version() - new function which converts the existing schema to a target version pgsql_lease4_stat_test() - tests v4 stat table and triggers in an new database pgsql_lease6_stat_test() - tests v6 stat table and triggers in an new database. pgsql_lease6_stat_per_type() - helper function which tests v6 stat table and triggers using a given address and lease type pgsql_lease_stat_upgrade_test() - tests data migration, stat table and trigger operations on an upgraded database src/lib/dhcpsrv/pgsql_lease_mgr.* Added new SQL statements for lease stats queries PgSqlLeaseStatsQuery Constructors - added variants to support where clause params start() - modified to support query variants based on where clause params PgSqlLeaseMgr Added start variants: - startSubnetLeaseStatsQuery4(const SubnetID& subnet_id) - startSubnetRangeLeaseStatsQuery4(const SubnetID& first_subnet_id, const SubnetID& last_subnet_id) src/lib/dhcpsrv/tests/pgsql_lease_mgr_unittest.cc New unit tests: - TEST_F(PgSqlLeaseMgrTest, leaseStatsQuery4) - TEST_F(PgSqlLeaseMgrTest, leaseStatsQuery6)
2018-03-12[master] Merge branch 'github70' (missing CQL backend features)Tomek Mrugalski
- host delete - user-contexts - DHCPv4 fixed fields - also PostgreSQL now stores hwaddr type and hwaddr source # Conflicts: # src/lib/dhcpsrv/tests/pgsql_host_data_source_unittest.cc
2018-03-05[master] subnet_id column types now consistent in schemasThomas Markwalder
Merges in branch 'trac5522'
2018-03-05Merge branch 'cassandra_improvements' of ↵Tomek Mrugalski
https://github.com/razvan-becheriu/kea into github70
2018-03-02[5522] Removed whitespace errors in a couple of files.Marcin Siodelski
2018-02-27[5437] Replaced index by iaid_subnet_id_duid with duid_iaid_subnet_id.Marcin Siodelski
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
2018-02-15minor changesRazvan Becheriu
2018-02-14fixed compilationRazvan Becheriu
2018-02-13added missing tables, columns and values in cql schema, ordered declarations ↵Razvan Becheriu
and definitions in lease and host managers
2018-01-09[5468] Added lease indexing by subnet identifiers and lease type.Marcin Siodelski
2017-12-17[5351] Addressed nearly all commentsFrancis Dupont
2017-12-03[5351] Checkpoint: todo host DB testsFrancis Dupont
2017-12-01[5351] Checkpoint: added user context in options stored in DBs, todo add testsFrancis 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
2017-04-20[5195] flex-id value added to know identifiers list.Tomek Mrugalski
2017-04-14[5102] Updated MySQL and PgSQL schemas with 'client-id' host id type.Marcin Siodelski
2017-04-12[v_1_2_0] copy right dates updatedWlodek Wencel
2016-12-14Corrected typosAndrei Pavel
2016-08-23[4552] Added siaddr, sname and file into the hosts table.Marcin Siodelski
2016-06-23change requests from iscTomek Mrugalski
# Conflicts: # src/bin/admin/tests/data/pgsql.lease6_dump_test.reference.csv
2016-06-21[4275] Addressed review commentsThomas Markwalder
bin/admin/tests/pgsql_tests.sh.in Typos share/database/scripts/pgsql/.gitignore Added upgrade_2.0_to_3.0.sh share/database/scripts/pgsql/dhcpdb_create.pgsql Added entry for client_id to hosts_identifier Added commentrary for dhcp_option_scope Added periods to the ends of sentences.
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-06-14[4275] Brought Postgresql schema up to MySQL 4.1 contentThomas Markwalder
Postresql schema now supports host reservations with options, and lease6 table now includes hardware address and source src/share/database/scripts/pgsql/dhcpdb_create.pgsql Added Schema 3.0 upgrade section: - new tables: hosts, dhcp4_options, dhcp6_options, ipv6_reservations, lease_hwaddr_source - lease4Dumpdata() - results now sorted by lease address - lease6 table - added columns hwaddr, hwtype, hwaddr_source - lease6DumpHeader() - added labels for new columns - lease6DumpData() - added new columns, results now sorted by lease address - schema_vesion - bumped version to 3 src/share/database/scripts/pgsql/dhcpdb_drop.pgsql Added drops of new tables src/lib/dhcpsrv/pgsql_lease_mgr.cc - PgSqlLeaseMgr::PgSqlLeaseMgr() - added logic to detect schema mismatch between the code and configured database src/lib/dhcpsrv/pgsql_lease_mgr.h - Bumped PG_CURRENT_VERSION from 2 to 3 src/bin/admin/tests/data/pgsql.lease6_dump_test.reference.csv - Reordered entries to account for dump function sort order - Added values for new columns on lease6 table src/bin/admin/tests/pgsql_tests.sh.in - pgsql_lease_version_test() - changed expected version to 3.0 - pgsql_lease6_dump_test() - added new column values to inserted rows
2016-04-25[4239] Addressed review commentsThomas Markwalder
src/lib/dhcpsrv/pgsql_lease_mgr.cc Amended commentary for getColumnValue() variants Added decription of Uiaid union Changed std::system to ::system src/lib/dhcpsrv/testutils/mysql_schema.cc Changed std::system to ::system src/lib/dhcpsrv/testutils/mysql_schema.h Fixed typo src/lib/dhcpsrv/testutils/pgsql_schema.cc Removed extraneous include Changed std::system to ::system
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-13 05:36:43 +0000