You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
53 lines
1.3 KiB
SQL
53 lines
1.3 KiB
SQL
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : imagedb(本地)
|
|
Source Server Type : Oracle
|
|
Source Server Version : 110200
|
|
Source Host : localhost:1521
|
|
Source Schema : IMAGEDB
|
|
|
|
Target Server Type : Oracle
|
|
Target Server Version : 110200
|
|
File Encoding : 65001
|
|
|
|
Date: 02/12/2022 09:38:20
|
|
*/
|
|
|
|
|
|
-- ----------------------------
|
|
-- Table structure for CHANGERECORD
|
|
-- ----------------------------
|
|
DROP TABLE "IMAGEDB"."CHANGERECORD";
|
|
CREATE TABLE "IMAGEDB"."CHANGERECORD" (
|
|
"UUID" VARCHAR2(255 BYTE) NOT NULL,
|
|
"MODIFYTIME" DATE,
|
|
"EXPLAINTEXT" VARCHAR2(255 BYTE)
|
|
)
|
|
TABLESPACE "USERS"
|
|
LOGGING
|
|
NOCOMPRESS
|
|
PCTFREE 10
|
|
INITRANS 1
|
|
STORAGE (
|
|
INITIAL 65536
|
|
NEXT 1048576
|
|
MINEXTENTS 1
|
|
MAXEXTENTS 2147483645
|
|
BUFFER_POOL DEFAULT
|
|
)
|
|
PARALLEL 1
|
|
NOCACHE
|
|
DISABLE ROW MOVEMENT
|
|
;
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table CHANGERECORD
|
|
-- ----------------------------
|
|
ALTER TABLE "IMAGEDB"."CHANGERECORD" ADD CONSTRAINT "PK__ChangeRe__7F427930511FB049" PRIMARY KEY ("UUID");
|
|
|
|
-- ----------------------------
|
|
-- Checks structure for table CHANGERECORD
|
|
-- ----------------------------
|
|
ALTER TABLE "IMAGEDB"."CHANGERECORD" ADD CONSTRAINT "SYS_C0015740" CHECK ("UUID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
|