omega-make/Template/Sql/db.sql

<<ym-item:databaseInfo>>
drop database IF EXISTS <<dbName>>;
CREATE DATABASE <<dbName>> CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
use <<dbName>>;
CREATE USER <<username>> IDENTIFIED BY '<<pwd>>';
GRANT create,alter,drop,select,insert,update,delete ON <<username>>.* TO <<username>>;
<</ym-item:databaseInfo>>
<<ym-loop:databaseTable>>
DROP TABLE IF EXISTS <<tableName>>;
CREATE table <<tableName>>(
<<ym-loop:fields>>
<<fieldName>> <<fieldType>><<ym-if:!isEmpty("<<fieldLength>>")>>(<<fieldLength>>)<</ym-if>><<ym-if:<<notNull>>>> not null<</ym-if>><<ym-if:<<autoIncrement>>>> AUTO_INCREMENT<</ym-if>><<ym-if:!isEmpty("<<fieldDefaultValue>>")>> default <<fieldDefaultValue>><</ym-if>> COMMENT <<fieldTitle>><<fieldDetail>>,
<</ym-loop:fields>>
PRIMARY KEY(<<ym-loop:fields removeEnd=",">><<fieldName>>,<</ym-loop:fields>>)
) COMMENT '<<tableTitle>>' ENGINE=InnoDB DEFAULT charset=utf8mb4 COLLATE utf8mb4_general_ci;
<</ym-loop:databaseTable>>