Download
Getting Started
Members
Projects
Community
Marketplace
Events
Planet Eclipse
Newsletter
Videos
Participate
Report a Bug
Forums
Mailing Lists
Wiki
IRC
How to Contribute
Working Groups
Automotive
Internet of Things
LocationTech
Long-Term Support
PolarSys
Science
OpenMDM
More
Community
Marketplace
Events
Planet Eclipse
Newsletter
Videos
Participate
Report a Bug
Forums
Mailing Lists
Wiki
IRC
How to Contribute
Working Groups
Automotive
Internet of Things
LocationTech
Long-Term Support
PolarSys
Science
OpenMDM
Toggle navigation
Bugzilla – Attachment 149439 Details for
Bug 292146
[DB] create unique constraints on table PKs to prevent data corruption
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Requests
|
Help
|
Log In
[x]
|
Terms of Use
|
Copyright Agent
Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read
this important communication.
[patch]
Patch-v1
clipboard.txt (text/plain), 2.62 KB, created by
Stefan Winkler
on 2009-10-13 09:55:39 EDT
(
hide
)
Description:
Patch-v1
Filename:
MIME Type:
Creator:
Stefan Winkler
Created:
2009-10-13 09:55:39 EDT
Size:
2.62 KB
patch
obsolete
>### Eclipse Workspace Patch 1.0 >#P org.eclipse.emf.cdo.server.db >Index: src/org/eclipse/emf/cdo/server/internal/db/mapping/horizontal/AbstractListTableMapping.java >=================================================================== >RCS file: /cvsroot/modeling/org.eclipse.emf/org.eclipse.emf.cdo/plugins/org.eclipse.emf.cdo.server.db/src/org/eclipse/emf/cdo/server/internal/db/mapping/horizontal/AbstractListTableMapping.java,v >retrieving revision 1.6 >diff -u -r1.6 AbstractListTableMapping.java >--- src/org/eclipse/emf/cdo/server/internal/db/mapping/horizontal/AbstractListTableMapping.java 23 May 2009 17:26:27 -0000 1.6 >+++ src/org/eclipse/emf/cdo/server/internal/db/mapping/horizontal/AbstractListTableMapping.java 13 Oct 2009 13:57:03 -0000 >@@ -118,7 +118,7 @@ > typeMapping.createDBField(table, CDODBSchema.LIST_VALUE); > > // add table indexes >- table.addIndex(Type.NON_UNIQUE, dbFields); >+ table.addIndex(Type.UNIQUE, dbFields); > table.addIndex(Type.NON_UNIQUE, idxField); > } > >Index: src/org/eclipse/emf/cdo/server/internal/db/mapping/horizontal/AbstractHorizontalClassMapping.java >=================================================================== >RCS file: /cvsroot/modeling/org.eclipse.emf/org.eclipse.emf.cdo/plugins/org.eclipse.emf.cdo.server.db/src/org/eclipse/emf/cdo/server/internal/db/mapping/horizontal/AbstractHorizontalClassMapping.java,v >retrieving revision 1.4.2.2 >diff -u -r1.4.2.2 AbstractHorizontalClassMapping.java >--- src/org/eclipse/emf/cdo/server/internal/db/mapping/horizontal/AbstractHorizontalClassMapping.java 25 Sep 2009 10:28:15 -0000 1.4.2.2 >+++ src/org/eclipse/emf/cdo/server/internal/db/mapping/horizontal/AbstractHorizontalClassMapping.java 13 Oct 2009 13:57:03 -0000 >@@ -86,7 +86,7 @@ > table = getMappingStrategy().getStore().getDBSchema().addTable(name); > > IDBField idField = table.addField(CDODBSchema.ATTRIBUTES_ID, DBType.BIGINT, true); >- table.addField(CDODBSchema.ATTRIBUTES_VERSION, DBType.INTEGER, true); >+ IDBField versionField = table.addField(CDODBSchema.ATTRIBUTES_VERSION, DBType.INTEGER, true); > table.addField(CDODBSchema.ATTRIBUTES_CLASS, DBType.BIGINT, true); > table.addField(CDODBSchema.ATTRIBUTES_CREATED, DBType.BIGINT, true); > IDBField revisedField = table.addField(CDODBSchema.ATTRIBUTES_REVISED, DBType.BIGINT, true); >@@ -94,6 +94,7 @@ > table.addField(CDODBSchema.ATTRIBUTES_CONTAINER, DBType.BIGINT, true); > table.addField(CDODBSchema.ATTRIBUTES_FEATURE, DBType.INTEGER, true); > >+ table.addIndex(IDBIndex.Type.UNIQUE, idField, versionField); > table.addIndex(IDBIndex.Type.NON_UNIQUE, idField, revisedField); > } >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
Attachments on
bug 292146
:
149439
|
149509