python - web框架 - Flask Mysql 创建表的外键

代码：

from flask import Flask, render_template, session, redirect, url_for, flash
from flask.ext.bootstrap import Bootstrap
from flask.ext.wtf import Form
from wtforms import StringField, SubmitField
from wtforms.validators import Required, Length
from flask.ext.sqlalchemy import SQLAlchemy

app = Flask(__name__)
username='qatest'
password='qatest'
server='122.30.100.12:3388'
dbname='qatest'
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://'+username+':'+password+'@'+server+'/'+dbname
app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN'] = True

db = SQLAlchemy(app)

class Role(db.Model):
    __tablename__ = 'py_roles'
    id = db.Column(db.Integer,primary_key=True)
    name = db.Column(db.String(64),unique=True)
    users = db.relationship('User',backref=