MYSQL_OPTS="-u sYoHWwl0DGvEyt3s -psn9YkZqoLV06CQxAy2qsKi36S7POVShT appwrite -s -N -e"
TABLES=$(python3 ssh_run.py "docker exec appwrite-mariadb-sss6crntvrcs54qbhvhy5728 mysql $MYSQL_OPTS \"SHOW TABLES;\"")

echo "START TRANSACTION;" > drop_col.sql
for TABLE in $TABLES; do
    if [[ $TABLE == *_database_*_collection_* ]]; then
        echo "ALTER TABLE $TABLE DROP COLUMN resourceType;" >> drop_col.sql
    fi
done
echo "COMMIT;" >> drop_col.sql

python3 ssh_run.py "cat << 'SQLEOF' > /tmp/drop_col.sql
$(cat drop_col.sql)
SQLEOF
docker cp /tmp/drop_col.sql appwrite-mariadb-sss6crntvrcs54qbhvhy5728:/tmp/drop_col.sql
docker exec appwrite-mariadb-sss6crntvrcs54qbhvhy5728 mysql -u sYoHWwl0DGvEyt3s -psn9YkZqoLV06CQxAy2qsKi36S7POVShT appwrite -f -e \"source /tmp/drop_col.sql;\"
"