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)