Caption added to Client Table

nechromancer · nechromancer · commit 528080c8b4fb · 2012-05-19T23:57:02.000-04:00
diff --git a/JavaSource/com/acminds/acuteauto/persistence/entities/AbstractClient.java b/JavaSource/com/acminds/acuteauto/persistence/entities/AbstractClient.java
@@ -26,6 +26,7 @@ public abstract class AbstractClient extends
 
 	private Integer clientId;
 	private String clientName;
+	private String caption;
 	private String clientDesc;
 	private Integer yearEstd;
 	private String registeredName;
@@ -52,6 +53,15 @@ public void setClientName(String clientName) {
 		this.clientName = clientName;
 	}
 
+	@Column(name = "CAPTION", length = 100)
+	public String getCaption() {
+		return this.caption;
+	}
+
+	public void setCaption(String caption) {
+		this.caption = caption;
+	}
+
 	@Column(name = "CLIENT_DESC", length = 200)
 	public String getClientDesc() {
 		return this.clientDesc;
diff --git a/JavaSource/sql/db-schema-core.sql b/JavaSource/sql/db-schema-core.sql
@@ -52,6 +52,7 @@ DROP TABLE CLIENT;
 CREATE TABLE CLIENT (
 CLIENT_ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
 CLIENT_NAME VARCHAR(60) NOT NULL,
+CAPTION VARCHAR(100),
 CLIENT_DESC VARCHAR(200),
 YEAR_ESTD INT(4),
 REGISTERED_NAME VARCHAR(60)
