private static TypeEnum getType(String type) throws Exception {
		if ("boolean".equals(type)) {
			return TypeEnum.BOOLEAN;
		} else if ("short".equals(type)) {
			return TypeEnum.SHORTINT;
		} else if ("int".equals(type)) {
			return TypeEnum.INT;
		} else if ("bigint".equals(type)) {
			return TypeEnum.BIGINT;
		} else if ("varchar".equals(type)) {
			return TypeEnum.VARCHAR;
		} else if ("char".equals(type)) {
			return TypeEnum.CHAR;
		} else if ("text".equals(type)) {
			return TypeEnum.TEXT;
		} else if ("double".equals(type)) {
			return TypeEnum.DOUBLE;
		} else if ("binary".equals(type)) {
			return TypeEnum.BINARY;
		} else {
			throw new Exception("Unknown data type: " + type);
		}
	}