Email-message-move-with-plpython/usermail.sql at main · ondrej337/Email-message-move-with-plpython · GitHub

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
/*

 Source Schema         : mycron

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

 Date: 14/02/2023 14:47:06
*/


-- ----------------------------
-- Table structure for usermail
-- ----------------------------
DROP TABLE IF EXISTS "mycron"."usermail";
CREATE TABLE "mycron"."usermail" (
  "id_mail" int4 NOT NULL DEFAULT nextval('"mycron".usermail_id_mail_seq'::regclass),
  "hostname" varchar(255) COLLATE "pg_catalog"."default",
  "email" text COLLATE "pg_catalog"."default" NOT NULL,
  "password" text COLLATE "pg_catalog"."default",
  "audit_date" timestamp(6) DEFAULT now()
)
;

-- ----------------------------
-- Uniques structure for table usermail
-- ----------------------------
ALTER TABLE "mycron"."usermail" ADD CONSTRAINT "umail" UNIQUE ("email");

-- ----------------------------
-- Primary Key structure for table usermail
-- ----------------------------
ALTER TABLE "mycron"."usermail" ADD CONSTRAINT "usermail_pkey" PRIMARY KEY ("id_mail");