Difference between revisions of "Designate/Blueprints/Records Table Redesign"
< Designate | Blueprints
(→Database Schema Changes) |
(→Database Schema Changes WIP) |
||
Line 12: | Line 12: | ||
At this time, the migration of data from the existing Records table to the new separate tables is not included in this specification document. | 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 == | + | == Database Schema Changes - WIP == |
The existing Records table would become obsolete and be replaced with new tables for each record type. | The existing Records table would become obsolete and be replaced with new tables for each record type. |
Revision as of 22:58, 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.
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 |
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 |