16.3.2 发送数据库管理员命名

<target name="mysql-drop-db" depends="mysql-init" 
description="create the database and account"> 
<ext:mysql-admin onerror="continue"> 
DROP DATABASE diary; 
</ext:mysql-admin> 
</target> 

<target name="mysql-create-db" 
depends="mysql-init,mysql-drop-db" 
description="create the database and account"> 
<ext:mysql-admin> 
CREATE DATABASE diary; 
GRANT ALL PRIVILEGES ON diary.* TO 'diary'@'localhost'; 
SET PASSWORD FOR 'diary'@'localhost' = 
PASSWORD('${mysql.diary.pass}'); 
</ext:mysql-admin> 
</target> 

mysql-drop-db: 
[ext:mysql-admin] Executing commands 
[ext:mysql-admin] 1 rows affected 
[ext:mysql-admin] 1 of 1 SQL statements executed successfully 
mysql-create-db: 
[ext:mysql-admin] Executing commands 
[ext:mysql-admin] 1 rows affected 
[ext:mysql-admin] 0 rows affected 
[ext:mysql-admin] 0 rows affected 
[ext:mysql-admin] 3 of 3 SQL statements executed successfully 

<target name="mysql-create-events" depends="mysql-init" 
description="create the event table"> 
<ext:mysql> 
CREATE TABLE EVENTS ( 
EVENT_ID varchar(64) not null, 
EVENT_NAME varchar(255) not null, 
EVENT_DATE timestamp not null, 
EVENT_VERSION integer, 
EVENT_LASTMODIFIED timestamp, 
EVENT_TEXT varchar(8192), 
primary key (EVENT_ID)); 
</ext:mysql> 
</target> 

mysql-create-events: 
[ext:mysql] Executing commands 
[ext:mysql] 0 rows affected 
[ext:mysql] 1 of 1 SQL statements executed successfully