# CI_Test

**Repository Path**: liunwcj/CI_Test

## Basic Information

- **Project Name**: CI_Test
- **Description**: No description available
- **Primary Language**: PHP
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2015-03-28
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#message sql
CREATE TABLE `message` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`url`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`title`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`content`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`date`  datetime NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1
ROW_FORMAT=COMPACT
;
#插入测试数据
INSERT INTO message(NAME,url,title,content,DATE) VALUES ('小红','http://www.xiaohong.org - url','小红-fuck-中文-title','小红-fuck-中文-content',NOW());

#user sql
create table `user`(
`id` int(10) not null auto_increment,
`username` varchar(20) not null,
`password` char(32) not null,
`email` varchar(50) not null,
primary key(`id`)
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8
;
#user插入测试数据
INSERT INTO user(username,password,email) VALUES ('admin','admin','admin@admin.com');