mirror of
https://github.com/vmangos/core
synced 2026-08-14 16:29:10 -04:00
31 lines
612 B
Bash
Executable file
31 lines
612 B
Bash
Executable file
#!/usr/bin/env bash
|
|
|
|
DATE=$(date -u +%Y%m%d%H%M%S) # UTC DATE
|
|
FPATH="migrations/${DATE}_world.sql"
|
|
|
|
cat <<EOF > "$FPATH"
|
|
DROP PROCEDURE IF EXISTS add_migration;
|
|
DELIMITER ??
|
|
CREATE PROCEDURE \`add_migration\`()
|
|
BEGIN
|
|
DECLARE v INT DEFAULT 1;
|
|
SET v = (SELECT COUNT(*) FROM \`migrations\` WHERE \`id\`='$DATE');
|
|
IF v = 0 THEN
|
|
INSERT INTO \`migrations\` VALUES ('$DATE');
|
|
-- Add your query below.
|
|
|
|
|
|
|
|
-- End of migration.
|
|
END IF;
|
|
END??
|
|
DELIMITER ;
|
|
CALL add_migration();
|
|
DROP PROCEDURE IF EXISTS add_migration;
|
|
EOF
|
|
|
|
if [ $? -eq 0 ]; then
|
|
echo "File created: $FPATH"
|
|
else
|
|
echo "Error creating file: $FPATH"
|
|
fi
|