APIJSON-Demo/SQLServer/single/sys_TestRecord.sql at master · jettisonJava/APIJSON-Demo · GitHub

History

59 lines (51 loc) · 2.07 KB

Raw

-- SQLINES DEMO *** Distrib 5.7.17, for macos10.12 (x86_64)

-- SQLINES DEMO *** Database: sys

-- SQLINES DEMO *** -------------------------------------

-- SQLINES DEMO *** 7.33-log

/* SQLINES DEMO *** ARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/* SQLINES DEMO *** ARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/* SQLINES DEMO *** LLATION_CONNECTION=@@COLLATION_CONNECTION */;

/* SQLINES DEMO *** tf8 */;

/* SQLINES DEMO *** ME_ZONE=@@TIME_ZONE */;

/* SQLINES DEMO *** NE='+00:00' */;

/* SQLINES DEMO *** IQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/* SQLINES DEMO *** REIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/* SQLINES DEMO *** L_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/* SQLINES DEMO *** L_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- SQLINES DEMO *** or table `TestRecord`

DROP TABLE IF EXISTS [TestRecord];

/* SQLINES DEMO *** cs_client = @@character_set_client */;

/* SQLINES DEMO *** er_set_client = utf8 */;

-- SQLINES LICENSE FOR EVALUATION USE ONLY

CREATE TABLE TestRecord (

[id] bigint NOT NULL ,

[userId] bigint NOT NULL ,

[testAccountId] bigint NOT NULL DEFAULT '0',

[documentId] bigint NOT NULL ,

[randomId] bigint NOT NULL DEFAULT '0' ,

[host] varchar(1000) DEFAULT NULL,

[date] datetime2(0) NOT NULL DEFAULT GETDATE() ,

[duration] bigint DEFAULT NULL ,

[minDuration] bigint DEFAULT NULL ,

[maxDuration] bigint DEFAULT NULL ,

[response] varchar(max) NOT NULL ,

[compare] varchar(max) ,

[standard] varchar(max) ,

PRIMARY KEY ([id])

) ;

/* SQLINES DEMO *** er_set_client = @saved_cs_client */;

-- SQLINES DEMO *** table `TestRecord`

/* SQLINES DEMO *** NE=@OLD_TIME_ZONE */;

/* SQLINES DEMO *** E=@OLD_SQL_MODE */;

/* SQLINES DEMO *** _KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/* SQLINES DEMO *** CHECKS=@OLD_UNIQUE_CHECKS */;

/* SQLINES DEMO *** ER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/* SQLINES DEMO *** ER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/* SQLINES DEMO *** ON_CONNECTION=@OLD_COLLATION_CONNECTION */;

/* SQLINES DEMO *** ES=@OLD_SQL_NOTES */;

-- SQLINES DEMO *** 2021-06-21 23:26:44

APIJSON-Demo/SQLServer/single/sys_TestRecord.sql at master · jettisonJava/APIJSON-Demo · GitHub

Expand file tree

Breadcrumbs

sys_TestRecord.sql

Latest commit

History

Breadcrumbs

sys_TestRecord.sql

File metadata and controls