class aiyblog_options(db.Model):
__tablename__ = 'aiyblog_options'
name = db.Column(db.String(32),
primary_key=True,
nullable=False,
default="NULL")
user = db.Column(db.Integer, nullable=False, default=0)
value = db.Column(db.Text, default="NULL")
class aiyblog_relationships(db.Model):
__tablename__ = 'aiyblog_relationships'
cid = db.Column(db.Integer,
nullable=False,
default="NULL",
primary_key=True)
mid = db.Column(db.Integer,
nullable=False,
default="NULL",
primary_key=True)
class aiyblog_metas(db.Model):
__tablename__ = 'aiyblog_metas'
mid = db.Column(db.Integer,
primary_key=True,
nullable=False,
autoincrement=True)
name = db.Column(db.String(200), default="NULL")
slug = db.Column(db.String(200), default="NULL")
type = db.Column(db.String(32), nullable=False, default="NULL")
description = db.Column(db.String(200), default="NULL")
count = db.Column(db.Integer, default=0)
order = db.Column(db.Integer, default=0)
parent = db.Column(db.Integer, default=0)
class aiyblog_fields(db.Model):
__tablename__ = 'aiyblog_fields'
cid = db.Column(db.Integer, primary_key=True, nullable=False)
name = db.Column(db.String(200), nullable=False)
type = db.Column(db.String(8), default="str")
str_value = db.Column(db.Text, default="NULL")
int_value = db.Column(db.Integer, default=0)
float_value = db.Column(db.Float, default=0)
class aiyblog_comments(db.Model):
__tablename__ = 'aiyblog_comments'
coid = db.Column(db.Integer,
primary_key=True,
nullable=False,
default="NULL",
autoincrement=True)
cid = db.Column(db.Integer, default=0)
created = db.Column(db.Integer, default=0)
author = db.Column(db.String(200), default="NULL")
authorId = db.Column(db.Integer, default=0)
ownerId = db.Column(db.Integer, default=0)
mail = db.Column(db.String(200), default="NULL")
url = db.Column(db.String(200), default="NULL")
ip = db.Column(db.String(64), default="NULL")
agent = db.Column(db.String(200), default="NULL")
text = db.Column(db.Text, default="NULL")
type = db.Column(db.String(16), default="comment")
status = db.Column(db.String(16), default="approved")
parent = db.Column(db.Integer, default=0)
class aiyblog_contents(db.Model):
__tablename__ = 'aiyblog_contents'
cid = db.Column(db.Integer,
primary_key=True,
nullable=False,
autoincrement=True)
title = db.Column(db.String(200), default="NULL")
slug = db.Column(db.String(200), default="NULL")
created = db.Column(db.Integer, default=0)
modified = db.Column(db.Integer, default=0)
text = db.Column(db.Text, default="NULL")
order = db.Column(db.Integer, default=0)
authorId = db.Column(db.Integer, default=0)
template = db.Column(db.String(32), default="NULL")
type = db.Column(db.String(16), default="post")
status = db.Column(db.String(16), default="publish")
password = db.Column(db.String(32), default="NULL")
commentsNum = db.Column(db.Integer, default=0)
allowComment = db.Column(db.String(16), default="off")
allowPing = db.Column(db.String(16), default="off")
allowFeed = db.Column(db.String(16), default="off")
parent = db.Column(db.Integer, default=0)
class aiyblog_users(db.Model):
__tablename__ = 'aiyblog_users'
uid = db.Column(db.Integer,
primary_key=True,
nullable=False,
autoincrement=True)
name = db.Column(db.String(32), default="NULL")
password = db.Column(db.String(64), default="NULL")
mail = db.Column(db.String(200), default="NULL")
url = db.Column(db.String(200), default="NULL")
screenName = db.Column(db.String(200), default="NULL")
created = db.Column(db.Integer, default=0)
activated = db.Column(db.Integer, default=0)
logged = db.Column(db.Integer, default=0)
group = db.Column(db.String(16), default="visitor")
authCode = db.Column(db.String(64), default="NULL")