DB_51Aspx/BlogDB.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
 Navicat Premium Data Transfer

 Source Server         : postgres
 Source Server Type    : PostgreSQL
 Source Server Version : 160002 (160002)
 Source Host           : localhost:5432
 Source Catalog        : BlogDB
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 160002 (160002)
 File Encoding         : 65001

 Date: 15/03/2024 13:21:22
*/


-- ----------------------------
-- Sequence structure for Blogs_BlogId_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."Blogs_BlogId_seq";
CREATE SEQUENCE "public"."Blogs_BlogId_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 2147483647
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for Posts_PostId_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."Posts_PostId_seq";
CREATE SEQUENCE "public"."Posts_PostId_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 2147483647
START 1
CACHE 1;

-- ----------------------------
-- Table structure for Blogs
-- ----------------------------
DROP TABLE IF EXISTS "public"."Blogs";
CREATE TABLE "public"."Blogs" (
  "BlogId" int4 NOT NULL GENERATED BY DEFAULT AS IDENTITY (
INCREMENT 1
MINVALUE  1
MAXVALUE 2147483647
START 1
CACHE 1
),
  "Url" text COLLATE "pg_catalog"."default" NOT NULL
)
;

-- ----------------------------
-- Records of Blogs
-- ----------------------------
INSERT INTO "public"."Blogs" VALUES (1, 'http://blogs.msdn.com/p1');