Vehicle SOLD DATE & Inquiry NOTES have been added.

nechromancer · nechromancer · commit 3fd9f782204f · 2012-03-01T01:07:32.000-05:00
diff --git a/JavaSource/sql/db-schema.sql b/JavaSource/sql/db-schema.sql
@@ -95,6 +95,7 @@ STATUS INT(3) NOT NULL, -- AVAILABLE, SOLD, ONHOLD
 CONDITION INT(3), -- NEW, USED, CERTIFIED
 CARFAX_APPRV_URL VARCHAR(200), -- IF THE VEHICLE IS CARFAX APPROVED, THEN ENTER THE URL HERE.
 ADDITIONAL_INFO VARCHAR(1000),
+DATE_SOLD DATE,
 CREATE_DATE TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 CREATED_BY INT NOT NULL
 );
@@ -218,6 +219,7 @@ CREATE TABLE INQUIRY (
 	PHONE_NUMBER VARCHAR(20) NOT NULL,
 	EMAIL VARCHAR(50) NOT NULL,
 	INQUIRY_TYPE INT(3), -- FUTURE USE
+	NOTES VARCHAR(800),
 	VEHICLE_ID INT, -- IF AN INQUIRY IS PLACED FOR THIS VEHICLE
 	USER_INFO_ID INT, -- IF THIS IS AN EXISTING USER, THEN POPULATE.	
 	CREATE_DATE TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
