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

Zack Bartel (JIRA) jira at osuosl.org
Thu Jun 22 10:54:51 PDT 2006


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

Zack Bartel updated MNT-1451:
-----------------------------

    Description: 
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





  was:
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.


> 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



More information about the Maintain-dev mailing list