alter_account_three.py 265 Bytes Raw Blame History Permalink 1 2 3 4 5 6 7 8 9 10 #!/usr/bin/python # coding: utf-8 import config dbname_fix="USER" tablename_fix="t_account" db_name= "%s_%s"%(config.server_index, dbname_fix) print """ ALTER TABLE %s.%s ADD three INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '1:WX'; """ %(db_name,tablename_fix)