考勤sql修改
diff --git a/src/main/java/com/supwisdom/dlpay/atte/domain/TAtteDtl.java b/src/main/java/com/supwisdom/dlpay/atte/domain/TAtteDtl.java
index 38a046e..8b22126 100644
--- a/src/main/java/com/supwisdom/dlpay/atte/domain/TAtteDtl.java
+++ b/src/main/java/com/supwisdom/dlpay/atte/domain/TAtteDtl.java
@@ -21,7 +21,7 @@
@Id
- @Column(name = "atteno")
+ @Column(name = "atteno",length = 14)
public String getAtteno() {
return atteno;
}
@@ -29,7 +29,7 @@
public void setAtteno(String atteno) {
this.atteno = atteno;
}
- @Column(name = "custid")
+ @Column(name = "custid",length = 32)
public String getCustid() {
return custid;
}
@@ -37,7 +37,7 @@
public void setCustid(String custid) {
this.custid = custid;
}
- @Column(name = "attedate")
+ @Column(name = "attedate",length = 8)
public String getAttedate() {
return attedate;
}
@@ -45,7 +45,7 @@
public void setAttedate(String attedate) {
this.attedate = attedate;
}
- @Column(name = "timeid")
+ @Column(name = "timeid",length = 32)
public Integer getTimeid() {
return timeid;
}
@@ -53,7 +53,7 @@
public void setTimeid(Integer timeid) {
this.timeid = timeid;
}
- @Column(name = "state")
+ @Column(name = "state",length = 32)
public Integer getState() {
return state;
}
@@ -61,7 +61,7 @@
public void setState(Integer state) {
this.state = state;
}
- @Column(name = "status")
+ @Column(name = "status",length = 16)
public Integer getStatus() {
return status;
}
@@ -70,7 +70,7 @@
this.status = status;
}
- @Column(name = "remark")
+ @Column(name = "remark",length = 255)
public String getRemark() {
return remark;
}
@@ -78,7 +78,7 @@
public void setRemark(String remark) {
this.remark = remark;
}
- @Column(name = "oldstate")
+ @Column(name = "oldstate",length = 32)
public Integer getOldstate() {
return oldstate;
}
@@ -86,7 +86,7 @@
public void setOldstate(Integer oldstate) {
this.oldstate = oldstate;
}
- @Column(name = "operid")
+ @Column(name = "operid",length = 32)
public String getOperid() {
return operid;
}
@@ -94,7 +94,7 @@
public void setOperid(String operid) {
this.operid = operid;
}
- @Column(name = "updatetime")
+ @Column(name = "updatetime",length = 14)
public String getUpdatetime() {
return updatetime;
}
diff --git a/src/main/java/com/supwisdom/dlpay/atte/domain/TAtteReview.java b/src/main/java/com/supwisdom/dlpay/atte/domain/TAtteReview.java
index 455c63c..043f2e8 100644
--- a/src/main/java/com/supwisdom/dlpay/atte/domain/TAtteReview.java
+++ b/src/main/java/com/supwisdom/dlpay/atte/domain/TAtteReview.java
@@ -14,7 +14,7 @@
private String updatetime;
@Id
- @Column(name="custid")
+ @Column(name="custid",length = 32)
public String getCustid() {
return custid;
}
@@ -22,7 +22,7 @@
public void setCustid(String custid) {
this.custid = custid;
}
- @Column(name="opercode")
+ @Column(name="opercode",length = 255)
public String getOpercode() {
return opercode;
}
@@ -30,7 +30,7 @@
public void setOpercode(String opercode) {
this.opercode = opercode;
}
- @Column(name="updatetime")
+ @Column(name="updatetime",length = 14)
public String getUpdatetime() {
return updatetime;
}
diff --git a/src/main/java/com/supwisdom/dlpay/atte/domain/TClassCust.java b/src/main/java/com/supwisdom/dlpay/atte/domain/TClassCust.java
index 493391f..5596abc 100644
--- a/src/main/java/com/supwisdom/dlpay/atte/domain/TClassCust.java
+++ b/src/main/java/com/supwisdom/dlpay/atte/domain/TClassCust.java
@@ -10,7 +10,7 @@
private String custid;
private String attedate;
- @Column(name="classid")
+ @Column(name="classid",length = 64)
public Integer getClassid() {
return classid;
}
@@ -19,7 +19,7 @@
this.classid = classid;
}
@Id
- @Column(name="custid")
+ @Column(name="custid",length = 32)
public String getCustid() {
return custid;
}
@@ -27,7 +27,7 @@
public void setCustid(String custid) {
this.custid = custid;
}
- @Column(name="attedate")
+ @Column(name="attedate",length = 14)
public String getAttedate() {
return attedate;
}
diff --git a/src/main/java/com/supwisdom/dlpay/atte/domain/TSeason.java b/src/main/java/com/supwisdom/dlpay/atte/domain/TSeason.java
index 7cea29a..3a00f8d 100644
--- a/src/main/java/com/supwisdom/dlpay/atte/domain/TSeason.java
+++ b/src/main/java/com/supwisdom/dlpay/atte/domain/TSeason.java
@@ -19,7 +19,7 @@
private String deptcode;
@Id
- @Column(name = "id", unique = true, nullable = false)
+ @Column(name = "id", unique = true, nullable = false,length = 32)
public Integer getId() {
return id;
}
@@ -27,7 +27,7 @@
public void setId(Integer id) {
this.id = id;
}
- @Column(name = "rulename")
+ @Column(name = "rulename",length = 255)
public String getSeason() {
return season;
}
@@ -35,7 +35,7 @@
public void setSeason(String season) {
this.season = season;
}
- @Column(name = "weekid", nullable = false)
+ @Column(name = "weekid", nullable = false,length = 32)
public Integer getWeekid() {
return weekid;
}
@@ -43,7 +43,7 @@
public void setWeekid(Integer weekid) {
this.weekid = weekid;
}
-
+ @Column(name = "status", nullable = false,length = 32)
public Integer getStatus() {
return status;
}
@@ -51,7 +51,7 @@
public void setStatus(Integer status) {
this.status = status;
}
- @Column(name = "addtime")
+ @Column(name = "addtime",length = 14)
public String getAddtime() {
return addtime;
}
@@ -59,7 +59,7 @@
public void setAddtime(String addtime) {
this.addtime = addtime;
}
- @Column(name = "updatetime")
+ @Column(name = "updatetime",length = 14)
public String getUpdatetime() {
return updatetime;
}
@@ -67,7 +67,7 @@
public void setUpdatetime(String updatetime) {
this.updatetime = updatetime;
}
- @Column(name="custtypeid")
+ @Column(name="custtypeid",length = 64)
public Integer getCusttypeid() {
return custtypeid;
}
@@ -75,7 +75,7 @@
public void setCusttypeid(Integer custtypeid) {
this.custtypeid = custtypeid;
}
- @Column(name="deptcode")
+ @Column(name="deptcode",length = 32)
public String getDeptcode() {
return deptcode;
}
diff --git a/src/main/resources/atte.sql b/src/main/resources/atte.sql
index 0d1fcae..510750b 100644
--- a/src/main/resources/atte.sql
+++ b/src/main/resources/atte.sql
@@ -83,3 +83,11 @@
INSERT INTO "tb_function" ("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid", "grade") VALUES ('42', NULL, '1', NULL, '', '/atte/class/index', '手动排班', NULL, '36', NULL);
INSERT INTO "tb_function" ("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid", "grade") VALUES ('48', NULL, '1', NULL, '', '/atte/review/index', '审核人管理', NULL, '36', NULL);
+
+CREATE SEQUENCE seq_attedtl
+INCREMENT 1
+MINVALUE 1
+MAXVALUE 9223372036854775807
+START 1
+CACHE 1
+CYCLE;