##  看这里

### 文件命名规则

```
V2_4_0_164__Change.java=V+版本号+_+文件序号+__+Change.java
```


### 例子

``` java
package db.migration;

import java.util.List;
import java.util.Map;

import org.flywaydb.core.api.migration.spring.SpringJdbcMigration;
import org.springframework.jdbc.core.JdbcTemplate;

public class V2_4_0_164__Change implements SpringJdbcMigration  {

	@Override
	public void migrate(JdbcTemplate jdbcTemplate) throws Exception {
		List<Map<String, Object>> produceIdMap = jdbcTemplate.queryForList("SELECT id FROM acct_supplier_res where url = '/product'");
		long produceId =(long) produceIdMap.get(0).get("id");
		List<Map<String, Object>> materialIdMap = jdbcTemplate.queryForList("SELECT id FROM acct_supplier_res where url = '/product/material'");
		long materialId =(long) materialIdMap.get(0).get("id");
		
		jdbcTemplate.execute("insert into acct_supplier_role_res(role_id,res_id,sid) select id, " + produceId +" ,sid from acct_supplier_role where name like '%协同采购管理员%' OR `name` like '%管理员(内置)%'");
		jdbcTemplate.execute("insert into acct_supplier_role_res(role_id,res_id,sid) select id, " + materialId + " ,sid from acct_supplier_role where name like '%协同采购管理员%' OR `name` like '%管理员(内置)%'");
	}

}

```