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:databaseField>>
<<fieldName>> <<fieldType>><<ym-if:!isEmpty(<<fieldLength>>)>>(<<fieldLength>>)<</ym-if>><<ym-if:<<notNull>>=1>> not null<</ym-if>><<ym-if:<<autoIncrement>>=1>> AUTO_INCREMENT<</ym-if>><<ym-if:!isEmpty(<<fieldDefaultValue>>)>> default <<fieldDefaultValue>><</ym-if>> COMMENT <<fieldTitle>><<fieldDetail>>,
<</ym-loop:databaseField>>
PRIMARY KEY(<<ym-loop:databaseField removeEnd=",">><<fieldName>>,<</ym-loop:databaseField>>)
) COMMENT '<<tableTitle>>' ENGINE=InnoDB DEFAULT charset=utf8mb4 COLLATE utf8mb4_general_ci;
<</ym-loop:databaseTable>>