You don't have javascript enabled. Good luck! :(

欢迎页

Welcome to Ganace's Blog

欢迎您来到Ganace 的个人博客。

在茫茫互联网的海洋里能够遇见您，实在是一份不小的幸运。

诚挚地向您问候一声:您好，朋友！

这里是属于Ganace个人的隐秘小空间，记录了工作学习中遇到的知识点与灵感，以及生活中的碎碎念与吐槽、突如其来的中二病、尬尬的文艺时间、锻炼腹肌的时刻、惊喜的小发现等等。

想要在自己的平淡无奇的人生长河中留下些什么，

或者只是为了拯救老人家岌岌可危的记忆力，

仅此而已。

来到此地，分享与你。

也期待与您的再次相遇！

Share with Me

有任何的分享或者建议与吐槽，都可以Email我：ganace@foxmail.com

欢迎您的来信！

【PHP|Yii2|RABC】关于Yii2中RABC所有表的SQL语句

  Oct 14, 2017     Ganace     Back-end-Development

PHP
Yii2
Yii2-Admin

这里是一篇Ganace记录的关于Yii2中RABC所有表的SQL语句的文章。

SQL语句如下

CREATE TABLE `auth_rule` (
  `name` VARCHAR(64) CHARACTER SET utf8 NOT NULL,
  `data` BLOB,
  `created_at` INT(11) DEFAULT NULL,
  `updated_at` INT(11) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `auth_item` (
  `name` VARCHAR(64) CHARACTER SET utf8 NOT NULL,
  `type` SMALLINT(6) NOT NULL,
  `description` TEXT CHARACTER SET utf8,
  `rule_name` VARCHAR(64) CHARACTER SET utf8 DEFAULT NULL,
  `data` BLOB,
  `created_at` INT(11) DEFAULT NULL,
  `updated_at` INT(11) DEFAULT NULL,
  PRIMARY KEY (`name`),
  KEY `rule_name` (`rule_name`),
  KEY `type` (`type`),
  CONSTRAINT `auth_item_ibfk_1` FOREIGN KEY (`rule_name`) REFERENCES `auth_rule` (`name`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `auth_item_child` (
  `parent` VARCHAR(64) CHARACTER SET utf8 NOT NULL,
  `child` VARCHAR(64) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`parent`,`child`),
  KEY `child` (`child`),
  CONSTRAINT `auth_item_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `auth_item_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `auth_assignment` (
  `item_name` VARCHAR(64) CHARACTER SET utf8 NOT NULL,
  `user_id` VARCHAR(64) CHARACTER SET utf8 NOT NULL,
  `created_at` INT(11) DEFAULT NULL,
  PRIMARY KEY (`item_name`,`user_id`),
  CONSTRAINT `auth_assignment_ibfk_1` FOREIGN KEY (`item_name`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `menu` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(128) CHARACTER SET utf8 DEFAULT NULL,
  `parent` INT(11) DEFAULT NULL,
  `route` VARCHAR(256) CHARACTER SET utf8 DEFAULT NULL,
  `order` INT(11) DEFAULT NULL,
  `data` BLOB,
  PRIMARY KEY (`id`),
  KEY `parent` (`parent`),
  CONSTRAINT `menu_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `menu` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `user` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(32) CHARACTER SET utf8 NOT NULL,
  `auth_key` VARCHAR(32) CHARACTER SET utf8 NOT NULL,
  `password_hash` VARCHAR(256) CHARACTER SET utf8 NOT NULL,
  `password_reset_token` VARCHAR(256) CHARACTER SET utf8 DEFAULT NULL,
  `email` VARCHAR(256) CHARACTER SET utf8 NOT NULL,
  `status` INT(11) NOT NULL DEFAULT '10',
  `created_at` INT(11) NOT NULL,
  `updated_at` INT(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;