Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/stocktakerecordmanager/StockDiposableGoodBatch.java
===================================================================
diff -u -r12331 -r22882
--- ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/stocktakerecordmanager/StockDiposableGoodBatch.java	(.../StockDiposableGoodBatch.java)	(revision 12331)
+++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/stocktakerecordmanager/StockDiposableGoodBatch.java	(.../StockDiposableGoodBatch.java)	(revision 22882)
@@ -13,9 +13,11 @@
 import javax.persistence.GeneratedValue;
 import javax.persistence.GenerationType;
 import javax.persistence.Id;
+import javax.persistence.Index;
 import javax.persistence.JoinColumn;
 import javax.persistence.ManyToOne;
 import javax.persistence.OneToMany;
+import javax.persistence.Table;
 
 import org.hibernate.annotations.Cache;
 import org.hibernate.annotations.CacheConcurrencyStrategy;
@@ -27,6 +29,7 @@
  * 2013-02-19 上午09:59:00
  */
 @Entity
+@Table(indexes={@Index(columnList="diposablegoods_id",name="sdgb_diposablegoods_id_index")})
 @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
 public class StockDiposableGoodBatch {
 	
Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/stocktakerecordmanager/StockDiposableGoods.java
===================================================================
diff -u -r13209 -r22882
--- ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/stocktakerecordmanager/StockDiposableGoods.java	(.../StockDiposableGoods.java)	(revision 13209)
+++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/stocktakerecordmanager/StockDiposableGoods.java	(.../StockDiposableGoods.java)	(revision 22882)
@@ -9,9 +9,11 @@
 import javax.persistence.GeneratedValue;
 import javax.persistence.GenerationType;
 import javax.persistence.Id;
+import javax.persistence.Index;
 import javax.persistence.JoinColumn;
 import javax.persistence.ManyToOne;
 import javax.persistence.OneToMany;
+import javax.persistence.Table;
 
 import org.hibernate.annotations.Cache;
 import org.hibernate.annotations.CacheConcurrencyStrategy;
@@ -23,6 +25,7 @@
  */
 @Entity
 @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
+@Table(indexes={@Index(name="sdg_dgid_index" , columnList="disposableGoodsId"),@Index(name="sdg_takeRecord_id_index" , columnList="takeRecord_id")})
 public class StockDiposableGoods {
 	
 	public final static String CONSTANT_YES = "能";
Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/stocktakerecordmanager/StockIdentificationOfGoods.java
===================================================================
diff -u -r12331 -r22882
--- ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/stocktakerecordmanager/StockIdentificationOfGoods.java	(.../StockIdentificationOfGoods.java)	(revision 12331)
+++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/stocktakerecordmanager/StockIdentificationOfGoods.java	(.../StockIdentificationOfGoods.java)	(revision 22882)
@@ -8,8 +8,11 @@
 import javax.persistence.GeneratedValue;
 import javax.persistence.GenerationType;
 import javax.persistence.Id;
+import javax.persistence.Index;
 import javax.persistence.JoinColumn;
 import javax.persistence.ManyToOne;
+import javax.persistence.Table;
+
 import org.hibernate.annotations.Cache;
 import org.hibernate.annotations.CacheConcurrencyStrategy;
 
@@ -19,6 +22,7 @@
  *
  */
 @Entity
+@Table(indexes={@Index(columnList="batch_id",name="sig_batch_id_index")})
 @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
 public class StockIdentificationOfGoods {