postgresql创建表:
CREATE SEQUENCE “public”.“interface_permissions_id_seq”
INCREMENT 1
MINVALUE 1
MAXVALUE 200000000
START 1
CACHE 1;
CREATE TABLE “public”.“interface_permissions” (
“id” int8 DEFAULT nextval(‘interface_permissions_id_seq’::regclass) NOT NULL,
“organization_id” int8 DEFAULT 0 NOT NULL,
“merchant_id” int8 DEFAULT 0 NOT NULL,
“service” varchar(32) COLLATE “default” DEFAULT ‘’::character varying NOT NULL,
“flag” varchar(1) COLLATE “default” DEFAULT ‘0’::character varying NOT NULL,
“created_at” timestamp(6) NOT NULL,
“updated_at” timestamp(6) NOT NULL,
CONSTRAINT “interface_permissions_pkey” PRIMARY KEY (“id”)
)WITH (OIDS=FALSE);
COMMENT ON COLUMN “public”.“interface_permissions”.“organization_id” IS ’ 存管机构id’;
COMMENT ON COLUMN “public”.“interface_permissions”.“merchant_id” IS ‘商户id’;
COMMENT ON COLUMN “public”.“interface_permissions”.“service” IS ‘