summaryrefslogtreecommitdiff
path: root/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
AgeCommit message (Collapse)Author
2022-07-22[#2452] Addressed review commentsThomas Markwalder
share/database/scripts/pgsql/dhcpdb_create.pgsql share/database/scripts/pgsql/upgrade_012_to_013.sh.in Removed extraneous index
2022-07-22[#2452] Fixed diff in postgresql scriptsThomas Markwalder
2022-07-22[#2452] Improve postgresl indexes on hosts tableThomas Markwalder
src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_012_to_013.sh.in Added host index for dhcp identifier + type only - v4 and v6 Modified existing host index to include subnet-id = 0 - v4 and v6
2022-06-30[#2445] change lease_type to smallint in PostgreSQL trigger functionsAndrei Pavel
2022-06-30[#2445] trim double quotes from classes in PostgreSQL update triggersAndrei Pavel
2022-06-29[#2445] PostgreSQL schema changes in support of lease limitingAndrei Pavel
2022-06-22[#2438] MySQL schema changes in support of lease limitingAndrei Pavel
2022-06-14[#2430] Addressed review commentsThomas Markwalder
src/lib/dhcpsrv/parsers/client_class_def_parser.cc ClientClassDefParser::parse() - throws if user-context is not a map src/lib/dhcpsrv/tests/client_class_def_parser_unittest.cc TEST_F(ClientClassDefParserTest, invalidUserContext) - new test src/hooks/dhcp/pgsql_cb/pgsql_cb_dhcp6.cc src/share/database/scripts/mysql/dhcpdb_create.mysql src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_011_to_012.sh.in typos
2022-06-14[#2430] PostgreSQL CB now supports class user-contextThomas Markwalder
src/bin/admin/tests/pgsql_tests.sh.in Updated pgsql_upgrade_11_0_to_12_0() src/hooks/dhcp/pgsql_cb/pgsql_cb_dhcp4.cc src/hooks/dhcp/pgsql_cb/pgsql_cb_dhcp6.cc src/hooks/dhcp/pgsql_cb/pgsql_query_macros_dhcp.h added user_context to necessary statements, bindings src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_011_to_012.sh.in added user_context column to class tables
2022-06-07[#2299] are-scripts-in-sync.py is now explicit about missing delimitersAndrei Pavel
2022-06-07[#2299] Fixed minor review commentsThomas Markwalder
modified: src/share/database/scripts/mysql/dhcpdb_create.mysql src/share/database/scripts/mysql/upgrade_013_to_014.sh.in src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_011_to_012.sh.in
2022-06-03[#2299] Create subnet audit entry when network is deletedThomas Markwalder
Update subnets in shared-network BDEL trigger rather than relying on foreign key update action new files: src/share/database/scripts/mysql/upgrade_013_to_014.sh.in src/share/database/scripts/pgsql/upgrade_011_to_012.sh.in configure.ac added: src/share/database/scripts/mysql/upgrade_013_to_014.sh src/share/database/scripts/pgsql/upgrade_011_to_012.sh src/bin/admin/tests/mysql_tests.sh.in added 13 to 14 checks src/bin/admin/tests/pgsql_tests.sh.in added 11 to 12 checks src/hooks/dhcp/mysql_cb/tests/mysql_cb_dhcp4_unittest.cc src/hooks/dhcp/mysql_cb/tests/mysql_cb_dhcp6_unittest.cc enabled disabled tests src/lib/dhcpsrv/testutils/generic_cb_dhcp4_unittest.cc GenericConfigBackendDHCPv4Test::getAllSharedNetworks4Test() - updated expected audit entry order src/lib/dhcpsrv/testutils/generic_cb_dhcp6_unittest.cc GenericConfigBackendDHCPv6Test::getAllSharedNetworks6Test() - updated expected audit entry order src/lib/mysql/mysql_constants.h Updated schema version to 14 src/lib/pgsql/pgsql_connection.h Updated schema version to 12 src/share/database/scripts/mysql/.gitignore src/share/database/scripts/mysql/Makefile.am added upgrade_013_to_014.sh src/share/database/scripts/mysql/dhcpdb_create.mysql subnet rows are now updated directly in shared-network BEFORE delete triggers (v4 and v6) src/share/database/scripts/pgsql/Makefile.am added upgrade_011_to_012.sh src/share/database/scripts/pgsql/dhcpdb_create.pgsql subnet rows are now updated directly in shared-network BEFORE delete triggers (v4 and v6)
2022-03-10[#2349] PgSql CB V6 shared-networks, subnets, poolsThomas Markwalder
configure.ac Added src/share/database/scripts/pgsql/upgrade_010_to_011.sh src/bin/admin/tests/pgsql_tests.sh.in Updated for upgrade from 10 to 11. src/hooks/dhcp/pgsql_cb/pgsql_cb_dhcp4.cc Make use of PgSqlConfigBackendImpl::addDdnsReplaceClientNameBinding() Add universe paramter to createUpdateOptionDef() calls src/hooks/dhcp/pgsql_cb/pgsql_cb_dhcp6.cc PgSqlConfigBackendDHCPv6Impl - implemented methods for shared-networks, subnets, pools, subordinate option defs and options getInterfaceId() addInterfaceIdBinding()- new convenience functions for reading and writing interface id options src/hooks/dhcp/pgsql_cb/pgsql_cb_impl.* PgSqlConfigBackendImpl::createUpdateOptionDef() - added universe parameter to replace incorrect use of space name PgSqlConfigBackendImpl::addDdnsReplaceClientNameBinding() - new convenience function src/hooks/dhcp/pgsql_cb/tests/pgsql_cb_dhcp6_unittest.cc Added tests for networks, subnets, pools src/lib/dhcpsrv/testutils/generic_cb_dhcp6_unittest.cc Replaced EXPECT_THROWs with ASSER_THROWs - simplifies debugging tremendously src/lib/pgsql/pgsql_connection.h Updated schema version to 11 src/share/database/scripts/pgsql/Makefile.am src/share/database/scripts/pgsql/.gitignore Added upgrade_010_to_011.sh src/share/database/scripts/pgsql/dhcpdb_create.pgsql Added replacement of createOptionAuditDHCP6() to correct assocation of options to PD pools src/share/database/scripts/pgsql/upgrade_010_to_011.sh.in - new file
2022-02-28[#2322] addressed review commentsRazvan Becheriu
2022-02-24[#2322] Adds client classes to Postgresql CB v4Thomas Markwalder
configure.ac added src/share/database/scripts/pgsql/upgrade_009_to_010.sh src/bin/admin/tests/pgsql_tests.sh.in pgsql_upgrade_8_0_to_9_0() pgsql_upgrade_9_0_to_10_0() - added/improved upgrade tests src/hooks/dhcp/pgsql_cb/pgsql_cb_dhcp4.cc Implemented client class functions src/hooks/dhcp/pgsql_cb/pgsql_query_macros_dhcp.h Modified client class related queries src/hooks/dhcp/pgsql_cb/tests/pgsql_cb_dhcp4_unittest.cc TEST_F(PgSqlConfigBackendDHCPv4Test, setAndGetAllClientClasses4Test) TEST_F(PgSqlConfigBackendDHCPv4Test, getClientClass4Test) TEST_F(PgSqlConfigBackendDHCPv4Test, createUpdateClientClass4OptionsTest) TEST_F(PgSqlConfigBackendDHCPv4Test, getModifiedClientClasses4Test) TEST_F(PgSqlConfigBackendDHCPv4Test, deleteClientClass4Test) TEST_F(PgSqlConfigBackendDHCPv4Test, deleteAllClientClasses4Test) TEST_F(PgSqlConfigBackendDHCPv4Test, clientClassDependencies4Test) TEST_F(PgSqlConfigBackendDHCPv4Test, multipleAuditEntriesTest) - new tests src/lib/pgsql/pgsql_connection.h Updated schema version to 10.0 src/share/database/scripts/pgsql/Makefile.am Added upgrade_009_to_010.sh src/share/database/scripts/pgsql/dhcpdb_create.pgsql Schema updated to 10.0: Replace setClientClass<4/6>Order() - wrong local variable type, replace int constants with boolean constants dhcp<4/6>_client_class_dependency tables - - primary key needs to be composite to allow muliptle rows per class id func_dhcp<4/6>_client_class_check_dependency_BINS() - trigger functions need to return NEW not NULL
2022-02-21[#2323] PostgreSQL CB function needs cast to BIGINTKea-2.1.3Thomas Markwalder
src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_008_to_009.sh.in Add cast to BIGINT to gmt_epoch(). Postgresql 9x is unhappy without it.
2022-02-17[#95] Fix time handling and make installableThomas Markwalder
src/hooks/dhcp/pgsql_cb/pgsql_query_macros_dhcp.h Use gmt_epoch() to fetch timestamps src/lib/pgsql/pgsql_exchange.* PsqlBindArray::addTimestamp() PsqlBindArray::addTimestamp() - use convertLocaltoDatabaseTime() PgSqlExchange::convertLocalToDatabaseTime() - new function for converting local times src/lib/pgsql/tests/pgsql_basics.* Add LOCALTIME_COL column src/lib/pgsql/tests/pgsql_exchange_unittest.cc Update unit tests src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_008_to_009.sh.in src/share/database/scripts/pgsql/dhcpdb_drop.pgsql Add gmt_epoch() function src/share/database/scripts/pgsql/wipe_data.sh.in Fix order of tables
2022-02-17[#95] Addressed minor review commentsThomas Markwalder
src/hooks/dhcp/pgsql_cb/pgsql_cb_dhcp4.cc Explicitly handle ddns-replace-cient-name-mode binding src/lib/dhcpsrv/testutils/generic_cb_dhcp4_unittest.cc GenericConfigBackendDHCPv4Test::testNewAuditEntry(0 - Fail on empty tag list. src/lib/dhcpsrv/testutils/generic_cb_dhcp4_unittest.h Add doxygen src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_008_to_009.sh.in Fix function discrepancies on argument types
2022-02-17[#95] fixed comments and indentationRazvan Becheriu
2022-02-17[#95] Adds v4 support for networks,subnets,pools,optionsThomas Markwalder
configure.ac added pgsql/upgrade_008_to_009.sh src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_008_to_009.sh.in Corrected typo dhcp4_option_def_server_option_def_id_fkey Add missing cascade to constraint on dhcp4/6_subnet_server tables. Dropped extraneous dhcp4/6_shared_network_ADEL triggers Replaced createOptionAuditDHCP4() and createOptionAuditDHCP6() with corrected local variable type src/bin/admin/tests/pgsql_tests.sh.in updated expected schema version added pgsql_upgrade_8_0_to_9_0() src/hooks/dhcp/mysql_cb/tests/mysql_cb_dhcp4_unittest.cc Disabled TEST_F(MySqlConfigBackendDHCPv4Test, getAllSharedNetworks4Test) src/hooks/dhcp/pgsql_cb/pgsql_cb_dhcp4.cc implemented functions for shared-networks, subnets, pools, options, and option-defs src/hooks/dhcp/pgsql_cb/pgsql_cb_impl.* PgSqlConfigBackendImpl:: setRelays() setRequireClasses() - new convenience functions getAllOptions() getOptions() - implemented Changed reference tracking from bool to counter processOptionRow() addOptionValueBinding() - corrected buffer handling src/hooks/dhcp/pgsql_cb/tests/pgsql_cb_dhcp4_unittest.cc Added tests subnets, shared networks, pools, options, option defs, src/lib/dhcpsrv/testutils/generic_cb_dhcp4_unittest.* GenericConfigBackendDHCPv4Test::testNewAuditEntry() new variant which accepts a list of expected audit entries GenericConfigBackendDHCPv4Test::getAllSharedNetworks4Test() - now tests for an expected list of audit entries
2022-01-25[#2290] release changesKea-2.1.2Andrei Pavel
2022-01-23[#2039] kea-admin lease-upload pgsqlAndrei Pavel
2022-01-18[#2038] kea-admin lease-dump: compatibility with earlier versions of pgsqlAndrei Pavel
2022-01-18[#2038] kea-admin lease-dump pgsql outputs a memfile-ready CSVAndrei Pavel
2022-01-07[#2244] More review commentsThomas Markwalder
src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_007_to_008.sh.in Added missing constraints: - fk_dhcp6_options_subnet - fk_dhcp4_options_subnet
2022-01-07[#2244] Addressed review commentsThomas Markwalder
src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_007_to_008.sh.in Added missing indexes for foreign keys fixed commentary src/share/database/scripts/pgsql/wipe_data.sh.in fixed commentary
2022-01-07[#2244] Fix mangled constraints on dhcp4_subnet_serverThomas Markwalder
src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_007_to_008.sh.in - fixed mangled names in contraints
2022-01-07[#2244] option scopes and createOptionAuditDHCP6Thomas Markwalder
src/share/database/scripts/pgsql/dhcpdb_create.pgsql Added missing option scope values Replaced procedure createOptionAuditDHCP6() src/share/database/scripts/pgsql/dhcpdb_drop.pgsql added drop
2022-01-07[#2244] Added missing columns to PostgreSQL schemaThomas Markwalder
configure.ac added src/share/database/scripts/pgsql/upgrade_7.0_to_8.0.sh src/bin/admin/tests/pgsql_tests.sh.in Updated to test upgrading to 8.0 pgsql_upgrade_7_0_to_8_0() - new function src/lib/pgsql/pgsql_connection.h Updated schema version src/share/database/scripts/pgsql/Makefile.am added upgrade_7.0_to_8.0.sh.in src/share/database/scripts/pgsql/dhcpdb_create.pgsql Adds class_id column and constraints to dhcp4/6_option_def tables Adds preferred lifetime columns to dhcp6_client_class src/share/database/scripts/pgsql/upgrade_7.0_to_8.0.sh.in - new file Adds class_id column and constraints to dhcp4/6_option_def tables Adds preferred lifetime columns to dhcp6_client_class
2021-11-22[#2197] release changesAndrei Pavel
2021-11-09[#2166] Addressed further review commentsThomas Markwalder
src/share/database/scripts/pgsql/dhcpdb_drop.pgsql src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_6.2_to_7.0.sh.in Changed server_tag parameter size to 64 to match tag column size
2021-11-09[#2166] Addressed review commentsThomas Markwalder
src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_6.2_to_7.0.sh.in Replaced use of SMALLINT with BOOLEAN where appropriate. Added missing returns to two class functions src/share/database/scripts/pgsql/dhcpdb_drop.pgsql updated to match new boolean funcs
2021-11-09[#2166] More client class function correctionstmark
src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/update_6.2_to_7.0.sh.in Corrected column/variable ambiguity more issues with client class functions
2021-11-09[#2166] Fixed errors in client class functionsThomas Markwalder
src/bin/admin/tests/pgsql_tests.sh.in Fixeda another shell check complaint. src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_6.2_to_7.0.sh.in - Changed subnet id columns in options tables to BIGINT - Fixed column/variable ambiguities in client class functions
2021-11-09[#2166] More corrections based on manual testingThomas Markwalder
src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_6.2_to_7.0.sh.in - Removed id=1 from dhcpX_server inserts, id is SERIAL and must increment itself - Changed dhcpX_subnet::subnet_id from SERIAL to BIGINT to allow for manual ID assignments - Removed 'STRICT' from SELECT INTO statements, this causes NULL returns to throw - Return OLD from all BEFORE triggers
2021-11-09[#2166] Added session value setter functionsThomas Markwalder
src/bin/admin/tests/pgsql_tests.sh.in pgsql_upgrade_6_2_to_7_0() - added session variable tests src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_6.2_to_7.0.sh.in Added set_session_value functions Cleaned up get_session_* functions Whitespace cleanup src/share/database/scripts/pgsql/dhcpdb_drop.pgsql Added session variable functions
2021-11-09[#2166] Added pgsql session value fetch functionstmark
src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_6.2_to_7.0.sh.in src/share/database/scripts/pgsql/dhcpdb_drop.pgsql Added functions for getting config session values that handle unset and NULL values
2021-11-09[#2166] create-drop fixes and 9.2 compatibilityThomas Markwalder
src/share/database/scripts/pgsql/dhcpdb_create.pgsql src/share/database/scripts/pgsql/upgrade_6.2_to_7.0.sh.in added "OR REPLACE" to function creates made all TIMESTAMP elements "WITH TIME ZONE" replaced use of ON CONFLICT src/share/database/scripts/pgsql/dhcpdb_drop.pgsql Added arguments to function drops. Posgresql requires argument lists to match to drop a function.
2021-11-09[#2166] Added missing CB elements to postgresql schematmark
Initial commit. src/bin/admin/tests/pgsql_tests.sh.in pgsql_upgrade_6_2_to_7_0() - replaced insert into dhcp6_server with selects. Inserting fails without an audit-revision to match. src/share/database/scripts/pgsql/dhcpdb_create.pgsql Reduced to a single transaction and commit to avoid partial creations. Added CB audit procedures, trigger functions, triggers, and client class elements for v4 and v6. src/share/database/scripts/pgsql/dhcpdb_drop.pgsql Added drops of new elements. src/share/database/scripts/pgsql/upgrade_6.2_to_7.0.sh.in Added CB audit procedures, trigger functions, triggers, and client class elements for v4 and v6.
2021-10-28[#1848] createAuditRevisionDHCP4 proc addedTomek Mrugalski
2021-10-28[#90] add ON DELETE action on dhcp6_subnet_serverAndrei Pavel
2021-10-28[#90] tag shortened to 64 bytesTomek Mrugalski
2021-10-28[#90] Added dhcp4_shared_network_server tableTomek Mrugalski
2021-10-28[#90] Added dhcp4_subnet_server tableTomek Mrugalski
2021-10-28[#90] Added missing constraintsTomek Mrugalski
2021-10-28[#90] Updated capitalization, removed extra byte for \0Tomek Mrugalski
2021-10-28[#90] Spurious space removedTomek Mrugalski
2021-10-28[#90] 2 issues fixed in 7.0 schema creationTomek Mrugalski
- data inserted into incorrect dhcpX_server table - duplicate creation of dhcp4_options_server removed
2021-10-28[#90] Updated pgsql schema creation scriptTomek Mrugalski
2021-10-28[#90] Added 7.0 code to dhcpdb_create.pgsqlTomek Mrugalski
generated by cgit v1.2.3 (git 2.39.1) at 2026-09-11 13:32:55 +0000