/** * add index by the name of keys */ public void addIndex(string name, List <string> keys) { if (null == this.getIndexbyName(name)) { MysqlIndexType newIndex = new MysqlIndexType(name); for (int i = 0; i < keys.Count; i++) { MysqlCreateStruct getStruct = this.getStructByName(keys[i]); if (getStruct != null) { newIndex.addRefererStruct(getStruct); } else { throw new Exception("key " + keys[i] + " not exists"); } this.crIndizies.Add(newIndex); } } else { throw new Exception("Index with name " + name + " allready exists"); } }
public void addFieldToIndex(string name, string fieldName) { MysqlIndexType editIndex = this.getIndexbyName(name); if (null != editIndex) { MysqlCreateStruct getStruct = this.getStructByName(fieldName); if (getStruct != null) { editIndex.addRefererStruct(getStruct); } else { throw new Exception("key " + fieldName + " not exists"); } } }