apijson.sql · APIJSON/APIJSON-Node

Fetch the repository succeeded.

Scan WeChat QR to Pay

Cancel

Complete

richgiteeai

Watch

Unwatch Watching Releases Only Ignoring

1 Star 2 Fork 0

APIJSON/APIJSON-Node

Code Insights Pipelines

Service

Tencent Cloud Serverless

Create your Gitee Account

Explore and code with more than 14 million developers,Free private repositories !:)

Already have an account? Sign in

文件

master

Branches (5)

Manage

master

dependabot/npm_and_yarn/handlebars-4.1.2

dependabot/npm_and_yarn/mixin-deep-1.3.2

dependabot/npm_and_yarn/js-yaml-3.13.1

dependabot/npm_and_yarn/braces-2.3.2

This repository doesn't specify license. Please pay attention to the specific project description and its upstream code dependency when using it.

The license selected for the repository is subject to the license used by the main branch of the repository.

Clone or Download

Clone/Download

HTTPS SSH SVN SVN+SSH Download ZIP

Prompt

To download the code, please copy the following command and execute it in the terminal

To ensure that your submitted code identity is correctly recognized by Gitee, please execute the following command.

git config --global user.name userName 
git config --global user.email userEmail

When using the SSH protocol for the first time to clone or push code, follow the prompts below to complete the SSH configuration.

1 Generate RSA keys.

2 Obtain the content of the RSA public key and configure it in SSH Public Keys

To use SVN on Gitee, please visit the usage guide

When using the HTTPS protocol, the command line will prompt for account and password verification as follows. For security reasons, Gitee recommends configure and use personal access tokens instead of login passwords for cloning, pushing, and other operations.

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # Private Token

Branches 5

Tags 0

APIJSON-Node

apijson.sql

apijson.sql 1.71 KB

/*
 Navicat Premium Data Transfer

Source Server : localhost_3306
 Source Server Type : MySQL
 Source Server Version : 80017
 Source Host : localhost:3306
 Source Schema : apijson

Target Server Type : MySQL
 Target Server Version : 80017
 File Encoding : 65001

Date: 03/09/2019 13:08:54
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `comment` varchar(255) DEFAULT NULL,
 `userId` int(11) DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of comment
-- ----------------------------
BEGIN;
INSERT INTO `comment` VALUES (1, 'test', 2);
INSERT INTO `comment` VALUES (2, 'hello', 3);
INSERT INTO `comment` VALUES (3, 'world', 3);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
 `nickname` varchar(255) DEFAULT NULL,
 `role` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (2, 'kevin', 'coldplay', 'boss');
INSERT INTO `user` VALUES (3, 'tony', 'tiger', 'employee');
INSERT INTO `user` VALUES (4, 'iris', 'cruise', 'employee');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;

Copy Edit Raw Blame History

李晓峰 authored 2019年09月03日 15:17 +08:00 . feature: 增加测试用数据库

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61

/*
 Navicat Premium Data Transfer

 Source Server : localhost_3306
 Source Server Type : MySQL
 Source Server Version : 80017
 Source Host : localhost:3306
 Source Schema : apijson

 Target Server Type : MySQL
 Target Server Version : 80017
 File Encoding : 65001

 Date: 03/09/2019 13:08:54
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `comment` varchar(255) DEFAULT NULL,
 `userId` int(11) DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of comment
-- ----------------------------
BEGIN;
INSERT INTO `comment` VALUES (1, 'test', 2);
INSERT INTO `comment` VALUES (2, 'hello', 3);
INSERT INTO `comment` VALUES (3, 'world', 3);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
 `nickname` varchar(255) DEFAULT NULL,
 `role` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (2, 'kevin', 'coldplay', 'boss');
INSERT INTO `user` VALUES (3, 'tony', 'tiger', 'employee');
INSERT INTO `user` VALUES (4, 'iris', 'cruise', 'employee');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;