example.test1.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of j2mvc-framework-app Show documentation

强烈建议使用J2mvc 2.1以后的版本。 version 2.1.01 1.更换JSON依赖包. version 2.1.02 1.移除com.j2mvc.StringUtils.getUtf8()方法调用. 更改为getCharset() version 2.1.03 1.更新JNDI连接设置 version 2.1.04 1.修改works.xml配置url-pkg-prefixes改为pkg

There is a newer version: 2.1.12

Show newest version

-- 测试系统数据库
drop database test1;
create database test1;
grant all privileges on test1.* to test1@localhost identified by 'test1@123' WITH GRANT OPTION;
flush privileges;
use test1;

-- 用户
DROP TABLE IF EXISTS users;
CREATE TABLE IF NOT EXISTS users(
	id					varchar(30)	NOT NULL,
	username			varchar(50)	NOT NULL COMMENT '用户名',			
	password			varchar(50)	NOT NULL COMMENT '密码',				
	sessionid			varchar(50)	NOT NULL COMMENT '会话ID',				
  	PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;