Skip to content

Commit ffea533

Browse files
TommyLemonTommyLemon
committed
更新table
1 parent 3f1d8ab commit ffea533

5 files changed

Lines changed: 62 additions & 8 deletions

File tree

‎table/sys_Comment.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -55,4 +55,4 @@ UNLOCK TABLES;
5555
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5656
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5757

58-
-- Dump completed on 2016-11-24 19:27:04
58+
-- Dump completed on 2017-01-01 19:21:37

‎table/sys_Request.sql‎

Lines changed: 53 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,53 @@
1+
-- MySQL dump 10.13 Distrib 5.7.12, for osx10.9 (x86_64)
2+
--
3+
-- Host: localhost Database: sys
4+
-- ------------------------------------------------------
5+
-- Server version 5.7.16
6+
7+
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8+
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9+
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10+
/*!40101 SET NAMES utf8 */;
11+
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12+
/*!40103 SET TIME_ZONE='+00:00' */;
13+
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14+
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15+
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16+
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17+
18+
--
19+
-- Table structure for table `Request`
20+
--
21+
22+
DROP TABLE IF EXISTS `Request`;
23+
/*!40101 SET @saved_cs_client = @@character_set_client */;
24+
/*!40101 SET character_set_client = utf8 */;
25+
CREATE TABLE `Request` (
26+
`id` int(11) NOT NULL,
27+
`name` varchar(45) NOT NULL,
28+
`structure` varchar(1000) NOT NULL,
29+
`description` varchar(10000) DEFAULT NULL,
30+
PRIMARY KEY (`id`)
31+
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
32+
/*!40101 SET character_set_client = @saved_cs_client */;
33+
34+
--
35+
-- Dumping data for table `Request`
36+
--
37+
38+
LOCK TABLES `Request` WRITE;
39+
/*!40000 ALTER TABLE `Request` DISABLE KEYS */;
40+
INSERT INTO `Request` VALUES (1,'获取用户','{\"User\":{}}','传id'),(2,'获取作品','{\"Work\":{}}',NULL),(3,'获取用户及作品列表','{\"User\":{}, \"[]\":{\"Work\":{}}}','作品按发布时间倒序排列');
41+
/*!40000 ALTER TABLE `Request` ENABLE KEYS */;
42+
UNLOCK TABLES;
43+
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
44+
45+
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
46+
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
47+
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
48+
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
49+
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
50+
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
51+
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
52+
53+
-- Dump completed on 2017-01-01 19:21:36

‎table/sys_User.sql‎

Lines changed: 5 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -23,14 +23,15 @@ DROP TABLE IF EXISTS `User`;
2323
/*!40101 SET @saved_cs_client = @@character_set_client */;
2424
/*!40101 SET character_set_client = utf8 */;
2525
CREATE TABLE `User` (
26-
`id` int(5) NOT NULL,
26+
`id` int(5) NOT NULL AUTO_INCREMENT,
2727
`head` varchar(300) DEFAULT NULL,
2828
`name` varchar(20) NOT NULL,
2929
`phone` varchar(14) DEFAULT NULL,
3030
`picture` varchar(3000) DEFAULT NULL,
3131
`sex` int(11) NOT NULL,
32+
`certified` tinyint(1) NOT NULL DEFAULT '0',
3233
PRIMARY KEY (`id`)
33-
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
34+
) ENGINE=InnoDB AUTO_INCREMENT=93835 DEFAULT CHARSET=utf8;
3435
/*!40101 SET character_set_client = @saved_cs_client */;
3536

3637
--
@@ -39,7 +40,7 @@ CREATE TABLE `User` (
3940

4041
LOCK TABLES `User` WRITE;
4142
/*!40000 ALTER TABLE `User` DISABLE KEYS */;
42-
INSERT INTO `User` VALUES (38710,'http://www.tooopen.com/view/38710.html','Name-38710','1300038710','',0),(70793,'http://www.tooopen.com/view/70793.html','Name-70793','1300070793','',0),(82001,'http://www.tooopen.com/view/82002.html','Name-82002','1300082002','',0),(82002,'http','Name-82002','1300082002','sd',1),(82003,'http://www.tooopen.com/view/82002.html','Name-82002','1300082002','sd',1),(82005,'http://www.tooopen.com/view/82002.html','Name-82002','1300082002','',1),(82006,'http://www.tooopen.com/view/82002.html','Name-82002','1300082002','',1),(82012,'http://www.tooopen.com/view/82002.html','Name-82002','1300082002','',0),(90814,'http://www.tooopen.com/view/90814.html','Name-90814','1300090814','',0),(93793,'http://www.tooopen.com/view/93793.html','Name-93793','1300093793','',0);
43+
INSERT INTO `User` VALUES (38710,'http://www.tooopen.com/view/38710.html','Name-38710','1300038710',NULL,0,0),(70793,'http://www.tooopen.com/view/70793.html','Name-70793','1300070793','',0,0),(82001,'http://www.tooopen.com/view/82002.html','Name-82002','1300082002','',0,1),(82002,'http','Name-82002','1300082002','',1,1),(82003,'http://www.tooopen.com/view/82002.html','Name-82002','1300082002','',1,1),(82005,'http://www.tooopen.com/view/82002.html','Name-82002','1300082002','[\"http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000\",\"http://common.cnblogs.com/images/icon_weibo_24.png\",\"http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000\"]',1,0),(82006,'http://www.tooopen.com/view/82002.html','Name-82002','1300082002','',1,0),(82012,'http://www.tooopen.com/view/82002.html','Name-82002','1300082002','',0,0),(90814,'http://www.tooopen.com/view/90814.html','Name-90814','1300090814','',0,1),(93793,'http://www.tooopen.com/view/93793.html','Name-93793','1300093793','',0,1),(93794,NULL,'Lemon','999999999',NULL,0,0);
4344
/*!40000 ALTER TABLE `User` ENABLE KEYS */;
4445
UNLOCK TABLES;
4546
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -52,4 +53,4 @@ UNLOCK TABLES;
5253
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5354
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5455

55-
-- Dump completed on 2016-11-24 19:27:04
56+
-- Dump completed on 2017-01-01 19:21:36

‎table/sys_Wallet.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -36,7 +36,7 @@ CREATE TABLE `Wallet` (
3636

3737
LOCK TABLES `Wallet` WRITE;
3838
/*!40000 ALTER TABLE `Wallet` DISABLE KEYS */;
39-
INSERT INTO `Wallet` VALUES (1,38710,10000.50),(2,70793,500.00);
39+
INSERT INTO `Wallet` VALUES (1,38710,10000.50),(2,70793,500.00),(4,82003,2000.00),(5,82003,2000.00),(6,82005,700.00),(7,82005,100.00),(8,82005,700.00);
4040
/*!40000 ALTER TABLE `Wallet` ENABLE KEYS */;
4141
UNLOCK TABLES;
4242
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -49,4 +49,4 @@ UNLOCK TABLES;
4949
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5050
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5151

52-
-- Dump completed on 2016-12-11 16:36:08
52+
-- Dump completed on 2017-01-01 19:21:37

‎table/sys_Work.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -51,4 +51,4 @@ UNLOCK TABLES;
5151
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5252
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5353

54-
-- Dump completed on 2016-11-24 19:27:04
54+
-- Dump completed on 2017-01-01 19:21:36

0 commit comments

Comments
 (0)