[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[gfsd]Re: SQL change suggestion
From: |
Bradley M. Kuhn |
Subject: |
[gfsd]Re: SQL change suggestion |
Date: |
Mon, 20 May 2002 11:26:48 -0400 |
User-agent: |
Mutt/1.3.28i |
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
- [gfsd]Re: SQL change suggestion,
Bradley M. Kuhn <=