[Maintain-dev] [JIRA] Resolved: (MNT-1451) MySQL specific datatypes in database

[Zack Bartel (JIRA)]

     [ http://bugs.osuosl.org/browse/MNT-1451?page=history ]
     
Zack Bartel resolved MNT-1451:
------------------------------

    Resolution: Fixed

bandwidth_usage is now deleted from the host table during update. This could be bad if someone is still using flo and doesn't want to lose that data. However, I think this is an extremely unlikely case

> MySQL specific datatypes in database
> ------------------------------------
>
>          Key: MNT-1451
>          URL: http://bugs.osuosl.org/browse/MNT-1451
>      Project: Maintain
>         Type: Improvement
>   Components: Database
>     Versions: 3.0
>     Reporter: Michael Clay
>     Assignee: Zack Bartel

>
>
> The column 'type' is of type enum, all enums should be eliminated from the database as they are not standard SQL types.  This ends up strapping us to MYSQL.  Further, the DDNS option should be removed.  We do not support it.
> Also, the host table has a field called "bandwidth_rate", which is also an ENUM. Additionally, this field sounds like it was part of the Flow module earlier. In this case (i.e. if it is not used at all anymore), the field has to be removed.
> Tables with enums:
> dhcp_option::scope
> dhcp_option::type
> pointer::type
> ranges::type
> soa::delegated
> subnet::status
> user::host_view
> zone::notify
> zone::purgeable

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://bugs.osuosl.org/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira