[pal-cvs 3634] [1369] changed index name.

Back to archive index

svnno****@sourc***** svnno****@sourc*****
2008年 11月 18日 (火) 21:17:30 JST


Revision: 1369
          http://svn.sourceforge.jp/view?root=pal&view=rev&rev=1369
Author:   shinsuke
Date:     2008-11-18 21:17:30 +0900 (Tue, 18 Nov 2008)

Log Message:
-----------
changed index name.

Modified Paths:
--------------
    notepad/trunk/src/main/config/erd/notepad.erd
    notepad/trunk/src/main/config/sql/notepad.ddl
    notepad/trunk/src/main/webapp/WEB-INF/db/notepad.1.log.db
    notepad/trunk/src/main/webapp/WEB-INF/db/notepad.data.db


-------------- next part --------------
Modified: notepad/trunk/src/main/config/erd/notepad.erd
===================================================================
--- notepad/trunk/src/main/config/erd/notepad.erd	2008-11-18 11:22:54 UTC (rev 1368)
+++ notepad/trunk/src/main/config/erd/notepad.erd	2008-11-18 12:17:30 UTC (rev 1369)
@@ -1055,7 +1055,7 @@
             </columns>
             <indices>
               <net.java.amateras.db.visual.model.IndexModel>
-                <indexName>IDX_created_by_and_category_id_for_link</indexName>
+                <indexName>IDX_created_by_and_category_id_for_notepad</indexName>
                 <indexType class="net.java.amateras.db.dialect.IndexType">
                   <name>INDEX</name>
                 </indexType>
@@ -1242,7 +1242,7 @@
                   </columns>
                   <indices>
                     <net.java.amateras.db.visual.model.IndexModel>
-                      <indexName>IDX_created_by_for_category</indexName>
+                      <indexName>IDX_created_by_for_notepad_category</indexName>
                       <indexType class="net.java.amateras.db.dialect.IndexType" reference="../../../../../../indices/net.java.amateras.db.visual.model.IndexModel/indexType"/>
                       <columns>
                         <string>created_by</string>
@@ -1257,7 +1257,7 @@
                   </constraint>
                   <sourceConnections>
                     <net.java.amateras.db.visual.model.ForeignKeyModel>
-                      <foreignKeyName>FK_from_category_createdby_to_user</foreignKeyName>
+                      <foreignKeyName>FK_from_notepad_category_createdby_to_user</foreignKeyName>
                       <references>
                         <entry>
                           <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel"/>
@@ -1277,7 +1277,7 @@
                       </listeners>
                     </net.java.amateras.db.visual.model.ForeignKeyModel>
                     <net.java.amateras.db.visual.model.ForeignKeyModel>
-                      <foreignKeyName>FK_from_category_updatedby_to_user</foreignKeyName>
+                      <foreignKeyName>FK_from_notepad_category_updatedby_to_user</foreignKeyName>
                       <references>
                         <entry>
                           <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel"/>
@@ -1344,7 +1344,7 @@
             </sourceConnections>
             <targetConnections>
               <net.java.amateras.db.visual.model.ForeignKeyModel>
-                <foreignKeyName>FK_from_content_to_user</foreignKeyName>
+                <foreignKeyName>FK_from_notepad_content_to_user</foreignKeyName>
                 <references>
                   <entry>
                     <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../columns/net.java.amateras.db.visual.model.ColumnModel"/>

Modified: notepad/trunk/src/main/config/sql/notepad.ddl
===================================================================
--- notepad/trunk/src/main/config/sql/notepad.ddl	2008-11-18 11:22:54 UTC (rev 1368)
+++ notepad/trunk/src/main/config/sql/notepad.ddl	2008-11-18 12:17:30 UTC (rev 1369)
@@ -145,7 +145,7 @@
 );
 
 
-CREATE INDEX IDX_created_by_for_category ON notepad_category (created_by);
+CREATE INDEX IDX_created_by_for_notepad_category ON notepad_category (created_by);
 
-CREATE INDEX IDX_created_by_and_category_id_for_link ON notepad (created_by, category_id);
+CREATE INDEX IDX_created_by_and_category_id_for_notepad ON notepad (created_by, category_id);
 

Modified: notepad/trunk/src/main/webapp/WEB-INF/db/notepad.1.log.db
===================================================================
(Binary files differ)

Modified: notepad/trunk/src/main/webapp/WEB-INF/db/notepad.data.db
===================================================================
(Binary files differ)


pal-cvs メーリングリストの案内
Back to archive index