Jump to: navigation, search

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

(Database Schema Changes WIP)
(Existing Records Table)
Line 28: Line 28:
 
| version || INTEGER || 11 || False || Designate API version
 
| version || INTEGER || 11 || False || Designate API version
 
|-
 
|-
| Example || Example || Example || Example || Example
+
| data || MEDIUMTEXT || - || False || Data unique to a specific record
 +
|-
 +
| priority || INTEGER || 11 || True || Priority value for certain types of records
 +
|-
 +
| domain_id || CHAR || 32 || False || Non-unique Key, Domain ID
 +
|-
 +
| managed || TINYINT || 1 || True || Boolean value to indicate if it is a managed resource
 
|-
 
|-
 
| Example || Example || Example || Example || Example
 
| Example || Example || Example || Example || Example

Revision as of 18:08, 18 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.

At this time, the migration of data from the existing Records table to the new separate tables is not included in this specification document.

Database Schema Changes - WIP

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
data MEDIUMTEXT - False Data unique to a specific record
priority INTEGER 11 True Priority value for certain types of records
domain_id CHAR 32 False Non-unique Key, Domain ID
managed TINYINT 1 True Boolean value to indicate if it is a managed resource
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