sql缺少create table about pybbs-go HOT 3 CLOSED

@fengss Beego自动创建表你不知道吗？

from pybbs-go.

CREATE TABLE permission (
id int(11) NOT NULL AUTO_INCREMENT,
pid int(11) DEFAULT NULL,
name varchar(100) COLLATE utf8_bin DEFAULT NULL,
description varchar(100) COLLATE utf8_bin DEFAULT NULL,
url varchar(100) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE reply (
id int(11) NOT NULL AUTO_INCREMENT,
topic_id int(11) DEFAULT NULL,
content text COLLATE utf8_bin,
user_id int(11) DEFAULT NULL,
up int(11) DEFAULT NULL,
in_time datetime DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE role (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(100) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE role_permissions (
id int(11) NOT NULL AUTO_INCREMENT,
role_id int(11) DEFAULT NULL,
permission_id int(11) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE section (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(100) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE topic (
id int(11) NOT NULL AUTO_INCREMENT,
title varchar(100) COLLATE utf8_bin DEFAULT NULL,
content varchar(100) COLLATE utf8_bin DEFAULT NULL,
in_time datetime DEFAULT NULL,
user_id int(11) DEFAULT NULL,
section_id int(11) DEFAULT NULL,
view int(11) DEFAULT NULL,
reply_count int(11) DEFAULT NULL,
last_reply_user_id int(11) DEFAULT NULL,
last_reply_time datetime DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE user (
id int(11) NOT NULL AUTO_INCREMENT,
username varchar(100) COLLATE utf8_bin DEFAULT NULL,
password varchar(100) COLLATE utf8_bin DEFAULT NULL,
token varchar(100) COLLATE utf8_bin DEFAULT NULL,
avatar varchar(100) COLLATE utf8_bin DEFAULT NULL,
email varchar(100) COLLATE utf8_bin DEFAULT NULL,
url varchar(100) COLLATE utf8_bin DEFAULT NULL,
signature varchar(100) COLLATE utf8_bin DEFAULT NULL,
in_time datetime DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE user_roles (
id int(11) NOT NULL AUTO_INCREMENT,
user_id int(11) DEFAULT NULL,
role_id int(11) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

from pybbs-go.

感谢 😆

from pybbs-go.