Opened 4 years ago

Last modified 4 years ago

#4487 new enhancement

Add drop tables command to kea-admin

Reported by: tmark Owned by:
Priority: medium Milestone: Outstanding Tasks
Component: database-all Version: git
Keywords: Cc:
CVSS Scoring: Parent Tickets:
Sensitive: no Defect Severity: N/A
Sub-Project: DHCP Feature Depending on Ticket:
Estimated Difficulty: 8 Add Hours to Ticket: 0
Total Hours: 0 Internal?: no

Description (last modified by tmark)

With the advent of 4239, there are now "drop" schema scripts for both MySQL and Postgresql. It might be handy to add a "drop tables/schema" command to kea-admin. Note the drop scripts only drop the schema content created by the create scripts, (e.g tables, functions, triggers), they do not delete the database itself.

Subtickets

Change History (3)

comment:1 Changed 4 years ago by tomek

Do we really need this? if we add support for drop database, people will soon request for add database capability, just to keep parity. I believe our lease-init command does not create the db and actually expects it to already be there. This cleverly leaves the mundane aspects of the creation (managing privileges, write rights, assuring name uniqueness etc.) to the user. So I'm somewhat tempted to not do drop database. But I'm open to be convinced otherwise.

comment:2 Changed 4 years ago by hschempf

  • Milestone changed from Kea-proposed to Outstanding Tasks

per team meeting apr 28, move to outstanding. this is a good candidate for Kea 1.2

comment:3 Changed 4 years ago by tmark

  • Description modified (diff)
  • Summary changed from Add drop database command to kea-admin to Add drop tables command to kea-admin
Note: See TracTickets for help on using tickets.