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

Revision as of 22:51, 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.

Records

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 20: / Line 20: @@
 | id || CHAR || 32 || False || Primary Key, Generated UUID
 |-
-| Example || Example || Example || Example || Example
+| created_at || DATETIME || - || False || UTC time of creation
 |-
-| Example || Example || Example || Example || Example
+| updated_at || DATETIME || - || False || UTC time of last update
 |-
-| Example || Example || Example || Example || Example
+| version || INTEGER || 11 || False || Designate API version
 |-
 | Example || Example || Example || Example || Example