COmanage Developers List

[Benn Oshrin <>]

I suspect this table needs indexes. What sort of queries do you perform 
against it? eg: "where co_id=x".

-Benn-

On 7/19/13 4:53 AM, 

 wrote:
> Author: marie
> Date: 2013-07-19 04:53:39 -0400 (Fri, 19 Jul 2013)
> New Revision: 565
>
> Modified:
>     registry/trunk/app/Config/Schema/schema.xml
> Log:
> co222 menu bar link configuration system
>
> Modified: registry/trunk/app/Config/Schema/schema.xml
> ===================================================================
> --- registry/trunk/app/Config/Schema/schema.xml 2013-07-19 08:51:08 UTC (rev 
> 564)
> +++ registry/trunk/app/Config/Schema/schema.xml 2013-07-19 08:53:39 UTC (rev 
> 565)
> @@ -847,4 +847,21 @@
>
>       <!-- XXX almost certainly need to create some indexes here -->
>     </table>
> +
> +  <table name="co_navigation_links">
> +    <field name="id" type="I">
> +      <key />
> +      <autoincrement />
> +    </field>
> +    <field name="co_id" type="I">
> +      <notnull />
> +    </field>
> +    <field name="description" type="C" size="256" />
> +    <field name="title" type="C" size="256" >
> +      <notnull />
> +    </field>
> +    <field name="url" type="C" size="256" />
> +    <field name="ordr" type="I" />
> +    <field name="location" type="C" size="32" />
> +  </table>
>   </schema>