UNIQUE indexes added to PRIVILEGE, ROLE & VEHICLE

nechromancer · nechromancer · commit 6b4e6959eeed · 2012-06-13T23:01:18.000-04:00
diff --git a/JavaSource/sql/db-relationships.sql b/JavaSource/sql/db-relationships.sql
@@ -2,7 +2,11 @@
 
 -- ADDING INDEXES
 
-ALTER TABLE USER_INFO ADD UNIQUE INDEX UNIQUE_USERNAME(USER_NAME);      
+ALTER TABLE USER_INFO ADD UNIQUE INDEX UNIQUE_USERNAME(USER_NAME);
+ALTER TABLE PRIVILEGE ADD UNIQUE INDEX UNIQUE_PRIVCODE(PRIV_CODE);
+ALTER TABLE ROLE ADD UNIQUE INDEX UNIQUE_ROLENAME(ROLE_NAME);
+ALTER TABLE VEHICLE ADD UNIQUE INDEX UNIQUE_STKNBR(STOCK_NBR);
+
 	
 -- ADDING FK RELATION SHIPS
 
