1. 23 Jun, 2016 9 commits
  2. 21 Jun, 2016 1 commit
    • Thomas Markwalder's avatar
      [4275] Addressed review comments · 0433e62c
      Thomas Markwalder authored
      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.
      0433e62c
  3. 15 Jun, 2016 1 commit
    • Thomas Markwalder's avatar
      [4275] Postgresql schema 3.0 now matches MySql schema 4.2 · a7db3554
      Thomas Markwalder authored
      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
      a7db3554
  4. 14 Jun, 2016 1 commit
    • Thomas Markwalder's avatar
      [4275] Brought Postgresql schema up to MySQL 4.1 content · 67e12a02
      Thomas Markwalder authored
      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
      67e12a02
  5. 25 May, 2016 1 commit
  6. 28 Apr, 2016 1 commit
  7. 25 Apr, 2016 1 commit
    • Thomas Markwalder's avatar
      [4239] Addressed review comments · f1162218
      Thomas Markwalder authored
      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
      f1162218
  8. 12 Apr, 2016 1 commit