mysql的Http会话暂留的JBoss7.x中的默认表创建错误

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    password VARCHAR(50) NOT NULL,
    email VARCHAR(100)
);

<datasource jndi-name="java:/MyDS" pool-name="MyDS">
    <connection-url>jdbc:mysql://localhost:3306/mydatabase</connection-url>
    <driver>com.mysql.jdbc.Driver</driver>
    <security>
        <user-name>dbuser</user-name>
        <password>dbpassword</password>
    </security>
    <validation>
        <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker"/>
        <background-validation>true</background-validation>
        <background-validation-millis>60000</background-validation-millis>
        <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter"/>
    </validation>
</datasource>