spring_security.sql

来自「安全框架实例 入门经典小例子 使用spring hibernate与其集成a」· SQL 代码 · 共 43 行

/*
SQLyog Enterprise Trial - MySQL GUI v5.02
Host - 5.0.18-nt : Database - user
*********************************************************************
Server version : 5.0.18-nt
*/


create database if not exists `user`;

USE `user`;

/*Table structure for table `authentication` */

DROP TABLE IF EXISTS `authentication`;

CREATE TABLE `authentication` (
  `username` varchar(10) default NULL,
  `authority` varchar(10) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `authentication` */

insert into `authentication` values 
('abc','ROLE_USER'),
('accc','ROLE_ADMIN');

/*Table structure for table `user` */

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `username` varchar(10) NOT NULL,
  `password` varchar(10) default NULL,
  `enabled` varchar(10) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `user` */

insert into `user` values 
('abc','abc','true'),
('accc','accc','true');