[gfsd]Re: SQL change suggestion

[Bradley M. Kuhn]

This is basically done, with some changes from what you say below.

Let me know if you need anything else for the load.

Paul Fisher <address@hidden> wrote:
> We need to be able to sort programs by their release date.  The
> %%updated field is not supposed to be changed when a new release comes
> out.  Only the %%version field is supposed to change.
>
> So I've made changes to the SQL table layout to break out all the
> information that is stored in %%version.
>
> Additions:
>   <table name="program">
> ...
>       <field name="version_id" type="integer"/>
> ...
>   </table>
>
>   <table name="version">
>     <fields>
>       <field name="id" type="auto"/>
>       <field name="status_id" type="integer"/>
>       <field name="date" type="date"/>
>       <field name="note" type="varchar" size="80"/>
>     </fields>
>   </table>
>
>   <table name="status">
>     <fields>
>       <field name="id" type="auto"/>
>       <field name="name" type="varchar" size="20"/>
>     </fields>
>   </table>
>
>   <!-- NULL field = '*' -->
>   <table name="platform">
>     <field>
>       <field name="id" type="auto"/>
>       <field name="cpu" type="varchar" size="20"/>
>       <field name="vendor" type="varchar" size="20"/>
>       <field name="os" type="varchar" size="20"/>
>     </field>
>    </table>
>
>   <table name="platform_mapping">
>     <field>
>       <field name="version_id" type="integer"/>
>       <field name="platform_id" type="integer"/>
>     </field>
>   </table>

   -- bkuhn

pgphccId9MHXX.pgp
Description: PGP signature