-- H2 2.1.214;
SET DB_CLOSE_DELAY -1;

CREATE MEMORY TABLE "PUBLIC"."ANDROID"(
    "USER_ID" INTEGER NOT NULL,
    "REGID" VARCHAR(1024) NOT NULL,
    "TS" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANDROID;
CREATE MEMORY TABLE "PUBLIC"."MAIL"(
    "USER_ID" INTEGER NOT NULL,
    "HASH" CHARACTER(16) NOT NULL,
    "TS" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL
);
ALTER TABLE "PUBLIC"."MAIL" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_23" PRIMARY KEY("USER_ID");
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MAIL;
CREATE MEMORY TABLE "PUBLIC"."BL_TAGS"(
    "USER_ID" INTEGER NOT NULL,
    "TAG_ID" INTEGER NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.BL_TAGS;
CREATE MEMORY TABLE "PUBLIC"."BL_USERS"(
    "USER_ID" INTEGER NOT NULL,
    "BL_USER_ID" INTEGER NOT NULL,
    "TS" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
);
ALTER TABLE "PUBLIC"."BL_USERS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_2" PRIMARY KEY("USER_ID", "BL_USER_ID");
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.BL_USERS;
CREATE MEMORY TABLE "PUBLIC"."REACTIONS"(
    "LIKE_ID" INTEGER NOT NULL,
    "DESCRIPTION" CHARACTER VARYING(100) NOT NULL
);
CREATE MEMORY TABLE "PUBLIC"."FAVORITES"(
    "USER_ID" INTEGER NOT NULL,
    "MESSAGE_ID" INTEGER NOT NULL,
    "TS" TIMESTAMP NOT NULL,
    "LIKE_ID" INTEGER,
    "USER_URI" VARCHAR(255) DEFAULT '' NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FAVORITES;
CREATE MEMORY TABLE "PUBLIC"."AUTH"(
    "USER_ID" INTEGER,
    "PROTOCOL" ENUM('xmpp', 'email', 'sms') NOT NULL,
    "ACCOUNT" CHARACTER(64) NOT NULL,
    "AUTHCODE" CHARACTER(8) NOT NULL,
    "TS" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AUTH;
CREATE MEMORY TABLE "PUBLIC"."IMAGES"(
    "MID" INTEGER NOT NULL,
    "RID" INTEGER NOT NULL,
    "THUMB" INTEGER NOT NULL,
    "SMALL" INTEGER NOT NULL,
    "MEDIUM" INTEGER NOT NULL,
    "HEIGHT" INTEGER NOT NULL,
    "WIDTH" INTEGER NOT NULL
);
ALTER TABLE "PUBLIC"."IMAGES" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_8" PRIMARY KEY("MID", "RID");
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.IMAGES;
CREATE MEMORY TABLE "PUBLIC"."MESSAGES_PROPERTIES"(
    "MESSAGE_ID" INTEGER NOT NULL,
    "REPLY_ID" SMALLINT NOT NULL,
    "PROPERTY_KEY" CHARACTER VARYING(255) NOT NULL,
    "PROPERTY_VALUE" CHARACTER VARYING NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MESSAGES_PROPERTIES;
CREATE MEMORY TABLE "PUBLIC"."MEON"(
    "ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) DEFAULT ON NULL NOT NULL,
    "USER_ID" INTEGER NOT NULL,
    "LINK" CHARACTER(255) NOT NULL,
    "NAME" CHARACTER(32) NOT NULL,
    "ICO" SMALLINT DEFAULT NULL
);
ALTER TABLE "PUBLIC"."MEON" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_24" PRIMARY KEY("ID");
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEON;
CREATE MEMORY TABLE "PUBLIC"."MESSAGES_ACCESS"(
    "MESSAGE_ID" INTEGER NOT NULL,
    "USER_ID" INTEGER NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MESSAGES_ACCESS;
CREATE MEMORY TABLE "PUBLIC"."MESSAGES_TAGS"(
    "MESSAGE_ID" INTEGER NOT NULL,
    "TAG_ID" INTEGER NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MESSAGES_TAGS;
CREATE MEMORY TABLE "PUBLIC"."USEROPTIONS"(
    "USER_ID" INTEGER NOT NULL,
    "JNOTIFY" TINYINT DEFAULT '1' NOT NULL,
    "SUBSCR_ACTIVE" TINYINT DEFAULT '1' NOT NULL,
    "XMPPXHTML" TINYINT DEFAULT '0' NOT NULL,
    "SUBSCR_NOTIFY" TINYINT DEFAULT '1' NOT NULL,
    "OFF_TS" TIMESTAMP,
    "RECOMMENDATIONS" TINYINT DEFAULT '1' NOT NULL,
    "PRIVACY_VIEW" TINYINT DEFAULT '1' NOT NULL,
    "PRIVACY_REPLY" TINYINT DEFAULT '1' NOT NULL,
    "PRIVACY_PM" TINYINT DEFAULT '1' NOT NULL,
    "REPLIESVIEW" TINYINT DEFAULT '0' NOT NULL
);
ALTER TABLE "PUBLIC"."USEROPTIONS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_C0" PRIMARY KEY("USER_ID");
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.USEROPTIONS;
CREATE MEMORY TABLE "PUBLIC"."PM"(
    "USER_ID" INTEGER NOT NULL,
    "USER_ID_TO" INTEGER NOT NULL,
    "TS" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "TXT" CHARACTER VARYING NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.PM;
CREATE MEMORY TABLE "PUBLIC"."FOLLOWERS"(
    "USER_ID" INTEGER DEFAULT NULL,
    "TS" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "ACCT" VARCHAR(64) NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FOLLOWERS;
CREATE MEMORY TABLE "PUBLIC"."SUBSCR_USERS"(
    "USER_ID" INTEGER NOT NULL,
    "SUSER_ID" INTEGER NOT NULL,
    "TS" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SUBSCR_USERS;
CREATE MEMORY TABLE "PUBLIC"."MESSENGER"(
    "USER_ID" INTEGER DEFAULT NULL,
    "SENDER_ID" BIGINT NOT NULL,
    "DISPLAY_NAME" CHARACTER(64) NOT NULL,
    "TS" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "LOGINHASH" CHARACTER(36) DEFAULT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MESSENGER;
CREATE MEMORY TABLE "PUBLIC"."PLACES"(
    "PLACE_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) DEFAULT ON NULL NOT NULL,
    "LAT" DECIMAL(10, 7) NOT NULL,
    "LON" DECIMAL(10, 7) NOT NULL,
    "NAME" CHARACTER(64) NOT NULL,
    "DESCR" CHARACTER(255) DEFAULT NULL,
    "URL" CHARACTER(128) DEFAULT NULL,
    "USER_ID" INTEGER NOT NULL,
    "TS" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
);
ALTER TABLE "PUBLIC"."PLACES" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_8C" PRIMARY KEY("PLACE_ID");
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.PLACES;
CREATE MEMORY TABLE "PUBLIC"."PLACES_TAGS"(
    "PLACE_ID" INTEGER NOT NULL,
    "TAG_ID" INTEGER NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.PLACES_TAGS;
CREATE MEMORY TABLE "PUBLIC"."REPLIES"(
    "MESSAGE_ID" INTEGER NOT NULL,
    "REPLY_ID" SMALLINT NOT NULL,
    "USER_ID" INTEGER NOT NULL,
    "REPLYTO" SMALLINT DEFAULT '0' NOT NULL,
    "TS" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "ATTACH" CHARACTER(3),
    "TXT" CHARACTER VARYING NOT NULL,
    "UPDATED_AT" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "USER_URI" VARCHAR(255) DEFAULT NULL,
    "REPLY_URI" VARCHAR(255) DEFAULT NULL,
    "HTML" TINYINT DEFAULT '0' NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPLIES;
CREATE INDEX "PUBLIC"."REPLY_URI_INDEX" ON "PUBLIC"."REPLIES"("REPLY_URI" NULLS FIRST);
CREATE MEMORY TABLE "PUBLIC"."MESSAGES_TXT"(
    "MESSAGE_ID" INTEGER NOT NULL,
    "REPLIESBY" CHARACTER VARYING(96) DEFAULT NULL,
    "TXT" CHARACTER VARYING NOT NULL,
    "UPDATED_AT" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL
);
ALTER TABLE "PUBLIC"."MESSAGES_TXT" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_3E" PRIMARY KEY("MESSAGE_ID");
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MESSAGES_TXT;
CREATE MEMORY TABLE "PUBLIC"."MESSAGES"(
    "MESSAGE_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) DEFAULT ON NULL NOT NULL,
    "USER_ID" INTEGER NOT NULL,
    "LANG" ENUM('en', 'ru', 'fr', 'fa', '__') DEFAULT '__' NOT NULL,
    "TS" TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "REPLIES" SMALLINT DEFAULT '0' NOT NULL,
    "MAXREPLYID" SMALLINT DEFAULT '0' NOT NULL,
    "PRIVACY" TINYINT DEFAULT '1' NOT NULL,
    "READONLY" TINYINT DEFAULT '0' NOT NULL,
    "ATTACH" CHARACTER(3),
    "PLACE_ID" INTEGER DEFAULT NULL,
    "LAT" DECIMAL(10, 7) DEFAULT NULL,
    "LON" DECIMAL(10, 7) DEFAULT NULL,
    "POPULAR" TINYINT DEFAULT '0' NOT NULL,
    "HIDDEN" TINYINT DEFAULT '0' NOT NULL,
    "LIKES" SMALLINT DEFAULT '0' NOT NULL,
    "UPDATED" TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP NOT NULL
);
ALTER TABLE "PUBLIC"."MESSAGES" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_13" PRIMARY KEY("MESSAGE_ID");
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MESSAGES;
CREATE MEMORY TABLE "PUBLIC"."VK"(
    "USER_ID" INTEGER DEFAULT NULL,
    "VK_ID" BIGINT NOT NULL,
    "LOGINHASH" CHARACTER(36) DEFAULT NULL,
    "ACCESS_TOKEN" CHARACTER VARYING(64),
    "TS" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "VK_NAME" CHARACTER(64) NOT NULL,
    "VK_LINK" CHARACTER(64) NOT NULL,
    "CROSSPOST" SMALLINT DEFAULT '1' NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.VK;
CREATE MEMORY TABLE "PUBLIC"."SUBSCR_MESSAGES"(
    "MESSAGE_ID" INTEGER NOT NULL,
    "SUSER_ID" INTEGER NOT NULL,
    "LAST_READ_RID" SMALLINT DEFAULT '0' NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SUBSCR_MESSAGES;
CREATE MEMORY TABLE "PUBLIC"."SUBSCR_TAGS"(
    "TAG_ID" INTEGER NOT NULL,
    "SUSER_ID" INTEGER NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.SUBSCR_TAGS;
CREATE MEMORY TABLE "PUBLIC"."USERS"(
    "ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0 RESTART WITH 6 MINVALUE 0) DEFAULT ON NULL NOT NULL,
    "NICK" VARCHAR(64) NOT NULL,
    "PASSW" VARCHAR(32) NOT NULL,
    "LANG" ENUM('en', 'ru', 'fr', 'fa', '__') DEFAULT '__' NOT NULL,
    "BANNED" TINYINT DEFAULT '0' NOT NULL,
    "LASTMESSAGE" TIMESTAMP(6) NOT NULL,
    "LASTPM" INTEGER DEFAULT '0' NOT NULL,
    "LASTPHOTO" INTEGER DEFAULT '0' NOT NULL,
    "KARMA" SMALLINT DEFAULT '0' NOT NULL,
    "LAST_SEEN" TIMESTAMP(6)
);
ALTER TABLE "PUBLIC"."USERS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_4" PRIMARY KEY("ID");
CREATE MEMORY TABLE "PUBLIC"."TAGS"(
    "TAG_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1 RESTART WITH 3) DEFAULT ON NULL NOT NULL,
    "SYNONYM_ID" INTEGER DEFAULT NULL,
    "NAME" VARCHAR_IGNORECASE(70) DEFAULT NULL,
    "TOP" BOOLEAN DEFAULT FALSE NOT NULL,
    "NOINDEX" BOOLEAN DEFAULT FALSE NOT NULL,
    "STAT_MESSAGES" INTEGER DEFAULT '0' NOT NULL,
    "STAT_USERS" SMALLINT DEFAULT '0' NOT NULL
);
ALTER TABLE "PUBLIC"."TAGS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_27" PRIMARY KEY("TAG_ID");
CREATE MEMORY TABLE "PUBLIC"."TAGS_IGNORE"(
    "TAG_ID" INTEGER NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAGS_IGNORE;
CREATE MEMORY TABLE "PUBLIC"."TAGS_SYNONYMS"(
    "NAME" CHARACTER(64) NOT NULL,
    "CHANGETO" CHARACTER(64) NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAGS_SYNONYMS;
CREATE MEMORY TABLE "PUBLIC"."TELEGRAM"(
    "USER_ID" INTEGER DEFAULT NULL,
    "TG_ID" BIGINT NOT NULL,
    "TG_NAME" CHARACTER(64) DEFAULT NULL,
    "TS" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "LOGINHASH" CHARACTER(36) DEFAULT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TELEGRAM;
CREATE MEMORY TABLE "PUBLIC"."TOP_IGNORE_MESSAGES"(
    "MESSAGE_ID" INTEGER NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TOP_IGNORE_MESSAGES;
CREATE MEMORY TABLE "PUBLIC"."TOP_IGNORE_TAGS"(
    "TAG_ID" INTEGER NOT NULL
);
ALTER TABLE "PUBLIC"."TOP_IGNORE_TAGS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_7" PRIMARY KEY("TAG_ID");
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TOP_IGNORE_TAGS;
CREATE MEMORY TABLE "PUBLIC"."TOP_IGNORE_USERS"(
    "USER_ID" INTEGER NOT NULL
);
ALTER TABLE "PUBLIC"."TOP_IGNORE_USERS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_B2" PRIMARY KEY("USER_ID");
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TOP_IGNORE_USERS;
CREATE MEMORY TABLE "PUBLIC"."FACEBOOK"(
    "USER_ID" INTEGER DEFAULT NULL,
    "FB_ID" BIGINT,
    "LOGINHASH" CHARACTER(36) DEFAULT NULL,
    "ACCESS_TOKEN" CHARACTER VARYING(64),
    "TS" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "FB_NAME" CHARACTER(64),
    "FB_LINK" CHARACTER(255),
    "CROSSPOST" TINYINT DEFAULT '1' NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.FACEBOOK;
CREATE MEMORY TABLE "PUBLIC"."TWITTER"(
    "USER_ID" INTEGER NOT NULL,
    "ACCESS_TOKEN" CHARACTER VARYING(64),
    "ACCESS_TOKEN_SECRET" CHARACTER(64) NOT NULL,
    "UNAME" CHARACTER(64) NOT NULL,
    "TS" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "CROSSPOST" TINYINT DEFAULT '1' NOT NULL
);
ALTER TABLE "PUBLIC"."TWITTER" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_F" PRIMARY KEY("USER_ID");
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TWITTER;
CREATE MEMORY TABLE "PUBLIC"."USERS_SUBSCR"(
    "USER_ID" INTEGER NOT NULL,
    "CNT" SMALLINT DEFAULT '0' NOT NULL
);
ALTER TABLE "PUBLIC"."USERS_SUBSCR" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_BB" PRIMARY KEY("USER_ID");
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.USERS_SUBSCR;
CREATE MEMORY TABLE "PUBLIC"."USERSINFO"(
    "USER_ID" INTEGER NOT NULL,
    "JID" CHARACTER(32) DEFAULT NULL,
    "FULLNAME" VARCHAR(32) DEFAULT NULL,
    "COUNTRY" VARCHAR(32) DEFAULT NULL,
    "URL" CHARACTER(64) DEFAULT NULL,
    "GENDER" CHARACTER(32) DEFAULT NULL,
    "BDAY" CHARACTER(10) DEFAULT NULL,
    "DESCR" CHARACTER VARYING(255) DEFAULT NULL
);
ALTER TABLE "PUBLIC"."USERSINFO" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_BB6" PRIMARY KEY("USER_ID");
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.USERSINFO;
CREATE MEMORY TABLE "PUBLIC"."EMAILS"(
    "USER_ID" INTEGER NOT NULL,
    "EMAIL" VARCHAR(64) NOT NULL,
    "SUBSCR_HOUR" TINYINT DEFAULT NULL
);
ALTER TABLE "PUBLIC"."EMAILS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_7A" PRIMARY KEY("EMAIL");
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.EMAILS;
CREATE MEMORY TABLE "PUBLIC"."IOS"(
    "USER_ID" INTEGER NOT NULL,
    "TOKEN" VARCHAR(64) NOT NULL,
    "TS" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.IOS;
CREATE MEMORY TABLE "PUBLIC"."JIDS"(
    "USER_ID" INTEGER DEFAULT NULL,
    "JID" CHARACTER(64) NOT NULL,
    "ACTIVE" TINYINT DEFAULT '1' NOT NULL,
    "LOGINHASH" CHARACTER(36) DEFAULT NULL,
    "TS" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.JIDS;
CREATE MEMORY TABLE "PUBLIC"."LOGINS"(
    "USER_ID" INTEGER NOT NULL,
    "HASH" CHARACTER(16) NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.LOGINS;
CREATE MEMORY TABLE "PUBLIC"."PM_INROSTER"(
    "USER_ID" INTEGER NOT NULL,
    "JID" CHARACTER(64) NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.PM_INROSTER;
CREATE MEMORY TABLE "PUBLIC"."VERSION"(
    "VERSION" BIGINT NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.VERSION;
CREATE MEMORY TABLE "PUBLIC"."WINPHONE"(
    "USER_ID" INTEGER NOT NULL,
    "URL" CHARACTER(255) NOT NULL,
    "TS" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WINPHONE;
CREATE MEMORY TABLE "PUBLIC"."WL_USERS"(
    "USER_ID" INTEGER NOT NULL,
    "WL_USER_ID" INTEGER NOT NULL
);
ALTER TABLE "PUBLIC"."WL_USERS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_A8" PRIMARY KEY("USER_ID", "WL_USER_ID");
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WL_USERS;
ALTER TABLE "PUBLIC"."MESSAGES" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_131" CHECK("ATTACH" IN('jpg', 'mp4', 'png')) NOCHECK;
ALTER TABLE "PUBLIC"."REPLIES" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_6C" CHECK("ATTACH" IN('jpg', 'mp4', 'png')) NOCHECK;
ALTER TABLE "PUBLIC"."LOGINS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_86" UNIQUE("USER_ID");
ALTER TABLE "PUBLIC"."PM_INROSTER" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_5" UNIQUE("USER_ID", "JID");
ALTER TABLE "PUBLIC"."REACTIONS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_6" UNIQUE("LIKE_ID");
ALTER TABLE "PUBLIC"."IOS" ADD CONSTRAINT "PUBLIC"."TOKEN" UNIQUE("TOKEN");
ALTER TABLE "PUBLIC"."SUBSCR_TAGS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_B" UNIQUE("TAG_ID", "SUSER_ID");
ALTER TABLE "PUBLIC"."SUBSCR_USERS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_C" UNIQUE("USER_ID", "SUSER_ID");
ALTER TABLE "PUBLIC"."MESSAGES_PROPERTIES" ADD CONSTRAINT "PUBLIC"."MESSAGE_KEY" UNIQUE("MESSAGE_ID", "REPLY_ID", "PROPERTY_KEY");
ALTER TABLE "PUBLIC"."USERS" ADD CONSTRAINT "PUBLIC"."NICK" UNIQUE("NICK");
ALTER TABLE "PUBLIC"."MESSAGES_TAGS" ADD CONSTRAINT "PUBLIC"."MESSAGE_ID_2" UNIQUE("MESSAGE_ID", "TAG_ID");
ALTER TABLE "PUBLIC"."SUBSCR_MESSAGES" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_6D" UNIQUE("MESSAGE_ID", "SUSER_ID");
ALTER TABLE "PUBLIC"."JIDS" ADD CONSTRAINT "PUBLIC"."JID" UNIQUE("JID");
ALTER TABLE "PUBLIC"."WINPHONE" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_EC" UNIQUE("URL");
ALTER TABLE "PUBLIC"."VK" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_A" FOREIGN KEY("USER_ID") REFERENCES "PUBLIC"."USERS"("ID") NOCHECK;
ALTER TABLE "PUBLIC"."FAVORITES" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_3" FOREIGN KEY("LIKE_ID") REFERENCES "PUBLIC"."REACTIONS"("LIKE_ID") NOCHECK;
ALTER TABLE "PUBLIC"."IOS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_1" FOREIGN KEY("USER_ID") REFERENCES "PUBLIC"."USERS"("ID") NOCHECK;
ALTER TABLE "PUBLIC"."MESSAGES" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_131A" FOREIGN KEY("USER_ID") REFERENCES "PUBLIC"."USERS"("ID") NOCHECK;
ALTER TABLE "PUBLIC"."FOLLOWERS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_D" FOREIGN KEY("USER_ID") REFERENCES "PUBLIC"."USERS"("ID") NOCHECK;
ALTER TABLE "PUBLIC"."JIDS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_22" FOREIGN KEY("USER_ID") REFERENCES "PUBLIC"."USERS"("ID") NOCHECK;
ALTER TABLE "PUBLIC"."EMAILS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_7A1" FOREIGN KEY("USER_ID") REFERENCES "PUBLIC"."USERS"("ID") NOCHECK;
ALTER TABLE "PUBLIC"."PM_INROSTER" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_54" FOREIGN KEY("USER_ID") REFERENCES "PUBLIC"."USERS"("ID") NOCHECK;
ALTER TABLE "PUBLIC"."WINPHONE" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_ECD" FOREIGN KEY("USER_ID") REFERENCES "PUBLIC"."USERS"("ID") NOCHECK;