COmanage Developers List

Author: marie
Date: 2013-09-19 02:01:08 -0400 (Thu, 19 Sep 2013)
New Revision: 608

Modified:
   registry/trunk/app/Config/Schema/schema.xml
Log:
CO693 - Add created/modified columns and index to [co]navigation links

Modified: registry/trunk/app/Config/Schema/schema.xml
===================================================================
--- registry/trunk/app/Config/Schema/schema.xml 2013-09-18 22:31:18 UTC (rev 
607)
+++ registry/trunk/app/Config/Schema/schema.xml 2013-09-19 06:01:08 UTC (rev 
608)
@@ -911,8 +911,12 @@
     <field name="url" type="C" size="256" />
     <field name="ordr" type="I" />
     <field name="location" type="C" size="32" />
+    <field name="created" type="T" />
+    <field name="modified" type="T" />
     
-    <!-- XXX almost certainly need to create some indexes here -->
+    <index name="co_navigation_links_i1">
+      <col>co_id</col>
+    </index>
   </table>
 
   <table name="navigation_links">
@@ -927,7 +931,7 @@
     <field name="url" type="C" size="256" />
     <field name="ordr" type="I" />
     <field name="location" type="C" size="32" />
-    
-    <!-- XXX almost certainly need to create some indexes here -->
+    <field name="created" type="T" />
+    <field name="modified" type="T" />
   </table>
 </schema>