Difference between revisions of "Designate/Blueprints/Records Table Redesign"

Revision as of 22:53, 17 March 2014

Overview

Gerrit Patch	[]
Launchpad Blueprint	[1]

This blueprint proposes to subdivide the Records table, which includes all record types, into a table per record type. For instance, an "a_records" table for A records, "mx_records" table for MX records, and so on.

Database Schema Changes

The existing Records table would become obsolete and be replaced with new tables for each record type.

Existing Records Table

Name	Data Type	Length	Nullable	Details
id	CHAR	32	False	Primary Key, Generated UUID
created_at	DATETIME	-	False	UTC time of creation
updated_at	DATETIME	-	False	UTC time of last update
version	INTEGER	11	False	Designate API version
Example	Example	Example	Example	Example
Example	Example	Example	Example	Example
Example	Example	Example	Example	Example
Example	Example	Example	Example	Example
Example	Example	Example	Example	Example
Example	Example	Example	Example	Example
Example	Example	Example	Example	Example
Example	Example	Example	Example	Example
Example	Example	Example	Example	Example
Example	Example	Example	Example	Example
Example	Example	Example	Example	Example
Example	Example	Example	Example	Example
Example	Example	Example	Example	Example
Example	Example	Example	Example	Example
Example	Example	Example	Example	Example
Example	Example	Example	Example	Example

@@ Line 12: / Line 12: @@
 == Database Schema Changes ==
-The existing Records table would become obsolete.
+The existing Records table would become obsolete and be replaced with new tables for each record type.
 ==== Existing Records Table ====
 {| class="wikitable"