text: --------------------------------------------------------
  --  DDL for Table API2_TOKEN
  --------------------------------------------------------
  
    CREATE TABLE "API2_TOKEN" 
     (	"KEY" NVARCHAR2(40), 
  	"USER" NVARCHAR2(255), 
  	"CREATED" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table API2_TOKENV2
  --------------------------------------------------------
  
    CREATE TABLE "API2_TOKENV2" 
     (	"KEY" NVARCHAR2(40), 
  	"USER" NVARCHAR2(255), 
  	"PLATFORM" NVARCHAR2(32), 
  	"DEVICE_ID" NVARCHAR2(40), 
  	"DEVICE_NAME" NVARCHAR2(40), 
  	"PLATFORM_VERSION" NVARCHAR2(16), 
  	"CLIENT_VERSION" NVARCHAR2(16), 
  	"LAST_ACCESSED" TIMESTAMP (6), 
  	"LAST_LOGIN_IP" VARCHAR2(39 BYTE), 
  	"CREATED_AT" TIMESTAMP (6), 
  	"WIPED_AT" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table AVATAR_AVATAR
  --------------------------------------------------------
  
    CREATE TABLE "AVATAR_AVATAR" 
     (	"ID" NUMBER(11,0), 
  	"EMAILUSER" NVARCHAR2(255), 
  	"PRIMARY" NUMBER(1,0), 
  	"AVATAR" NVARCHAR2(1024), 
  	"DATE_UPLOADED" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table AVATAR_GROUPAVATAR
  --------------------------------------------------------
  
    CREATE TABLE "AVATAR_GROUPAVATAR" 
     (	"ID" NUMBER(11,0), 
  	"GROUP_ID" NVARCHAR2(255), 
  	"AVATAR" NVARCHAR2(1024), 
  	"DATE_UPLOADED" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table BASE_CLIENTLOGINTOKEN
  --------------------------------------------------------
  
    CREATE TABLE "BASE_CLIENTLOGINTOKEN" 
     (	"TOKEN" NVARCHAR2(32), 
  	"USERNAME" NVARCHAR2(255), 
  	"TIMESTAMP" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table BASE_COMMANDSLASTCHECK
  --------------------------------------------------------
  
    CREATE TABLE "BASE_COMMANDSLASTCHECK" 
     (	"ID" NUMBER(11,0), 
  	"COMMAND_TYPE" NVARCHAR2(100), 
  	"LAST_CHECK" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table BASE_DEVICETOKEN
  --------------------------------------------------------
  
    CREATE TABLE "BASE_DEVICETOKEN" 
     (	"ID" NUMBER(11,0), 
  	"TOKEN" NVARCHAR2(80), 
  	"USER" NVARCHAR2(255), 
  	"PLATFORM" NVARCHAR2(32), 
  	"VERSION" NVARCHAR2(16), 
  	"PVERSION" NVARCHAR2(16)
     ) ;
  --------------------------------------------------------
  --  DDL for Table BASE_FILECOMMENT
  --------------------------------------------------------
  
    CREATE TABLE "BASE_FILECOMMENT" 
     (	"ID" NUMBER(11,0), 
  	"REPO_ID" NVARCHAR2(36), 
  	"PARENT_PATH" NCLOB, 
  	"REPO_ID_PARENT_PATH_MD5" NVARCHAR2(100), 
  	"ITEM_NAME" NCLOB, 
  	"AUTHOR" NVARCHAR2(255), 
  	"COMMENT" NCLOB, 
  	"CREATED_AT" TIMESTAMP (6), 
  	"UPDATED_AT" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table BASE_FILEDISCUSS
  --------------------------------------------------------
  
    CREATE TABLE "BASE_FILEDISCUSS" 
     (	"ID" NUMBER(11,0), 
  	"GROUP_MESSAGE_ID" NUMBER(11,0), 
  	"REPO_ID" NVARCHAR2(36), 
  	"PATH" NCLOB, 
  	"PATH_HASH" NVARCHAR2(12)
     ) ;
  --------------------------------------------------------
  --  DDL for Table BASE_GROUPENABLEDMODULE
  --------------------------------------------------------
  
    CREATE TABLE "BASE_GROUPENABLEDMODULE" 
     (	"ID" NUMBER(11,0), 
  	"GROUP_ID" NVARCHAR2(10), 
  	"MODULE_NAME" NVARCHAR2(20)
     ) ;
  --------------------------------------------------------
  --  DDL for Table BASE_INNERPUBMSG
  --------------------------------------------------------
  
    CREATE TABLE "BASE_INNERPUBMSG" 
     (	"ID" NUMBER(11,0), 
  	"FROM_EMAIL" NVARCHAR2(254), 
  	"MESSAGE" NVARCHAR2(500), 
  	"TIMESTAMP" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table BASE_INNERPUBMSGREPLY
  --------------------------------------------------------
  
    CREATE TABLE "BASE_INNERPUBMSGREPLY" 
     (	"ID" NUMBER(11,0), 
  	"REPLY_TO_ID" NUMBER(11,0), 
  	"FROM_EMAIL" NVARCHAR2(254), 
  	"MESSAGE" NVARCHAR2(150), 
  	"TIMESTAMP" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table BASE_USERENABLEDMODULE
  --------------------------------------------------------
  
    CREATE TABLE "BASE_USERENABLEDMODULE" 
     (	"ID" NUMBER(11,0), 
  	"USERNAME" NVARCHAR2(255), 
  	"MODULE_NAME" NVARCHAR2(20)
     ) ;
  --------------------------------------------------------
  --  DDL for Table BASE_USERLASTLOGIN
  --------------------------------------------------------
  
    CREATE TABLE "BASE_USERLASTLOGIN" 
     (	"ID" NUMBER(11,0), 
  	"USERNAME" NVARCHAR2(255), 
  	"LAST_LOGIN" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table BASE_USERSTARREDFILES
  --------------------------------------------------------
  
    CREATE TABLE "BASE_USERSTARREDFILES" 
     (	"ID" NUMBER(11,0), 
  	"EMAIL" NVARCHAR2(254), 
  	"ORG_ID" NUMBER(11,0), 
  	"REPO_ID" NVARCHAR2(36), 
  	"PATH" NCLOB, 
  	"IS_DIR" NUMBER(1,0)
     ) ;
  --------------------------------------------------------
  --  DDL for Table CAPTCHA_CAPTCHASTORE
  --------------------------------------------------------
  
    CREATE TABLE "CAPTCHA_CAPTCHASTORE" 
     (	"ID" NUMBER(11,0), 
  	"CHALLENGE" NVARCHAR2(32), 
  	"RESPONSE" NVARCHAR2(32), 
  	"HASHKEY" NVARCHAR2(40), 
  	"EXPIRATION" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table CONSTANCE_CONFIG
  --------------------------------------------------------
  
    CREATE TABLE "CONSTANCE_CONFIG" 
     (	"ID" NUMBER(11,0), 
  	"KEY" NVARCHAR2(255), 
  	"VALUE" NCLOB
     ) ;
  --------------------------------------------------------
  --  DDL for Table CONTACTS_CONTACT
  --------------------------------------------------------
  
    CREATE TABLE "CONTACTS_CONTACT" 
     (	"ID" NUMBER(11,0), 
  	"USER_EMAIL" NVARCHAR2(255), 
  	"CONTACT_EMAIL" NVARCHAR2(255), 
  	"CONTACT_NAME" NVARCHAR2(255), 
  	"NOTE" NVARCHAR2(255)
     ) ;
  --------------------------------------------------------
  --  DDL for Table DJANGO_CONTENT_TYPE
  --------------------------------------------------------
  
    CREATE TABLE "DJANGO_CONTENT_TYPE" 
     (	"ID" NUMBER(11,0), 
  	"APP_LABEL" NVARCHAR2(100), 
  	"MODEL" NVARCHAR2(100)
     ) ;
  --------------------------------------------------------
  --  DDL for Table DJANGO_MIGRATIONS
  --------------------------------------------------------
  
    CREATE TABLE "DJANGO_MIGRATIONS" 
     (	"ID" NUMBER(11,0), 
  	"APP" NVARCHAR2(255), 
  	"NAME" NVARCHAR2(255), 
  	"APPLIED" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table DJANGO_SESSION
  --------------------------------------------------------
  
    CREATE TABLE "DJANGO_SESSION" 
     (	"SESSION_KEY" NVARCHAR2(40), 
  	"SESSION_DATA" NCLOB, 
  	"EXPIRE_DATE" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table GROUP_GROUPMESSAGE
  --------------------------------------------------------
  
    CREATE TABLE "GROUP_GROUPMESSAGE" 
     (	"ID" NUMBER(11,0), 
  	"GROUP_ID" NUMBER(11,0), 
  	"FROM_EMAIL" NVARCHAR2(255), 
  	"MESSAGE" NCLOB, 
  	"TIMESTAMP" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table GROUP_MESSAGEATTACHMENT
  --------------------------------------------------------
  
    CREATE TABLE "GROUP_MESSAGEATTACHMENT" 
     (	"ID" NUMBER(11,0), 
  	"GROUP_MESSAGE_ID" NUMBER(11,0), 
  	"REPO_ID" NVARCHAR2(40), 
  	"ATTACH_TYPE" NVARCHAR2(5), 
  	"PATH" NCLOB, 
  	"SRC" NVARCHAR2(20)
     ) ;
  --------------------------------------------------------
  --  DDL for Table GROUP_MESSAGEREPLY
  --------------------------------------------------------
  
    CREATE TABLE "GROUP_MESSAGEREPLY" 
     (	"ID" NUMBER(11,0), 
  	"REPLY_TO_ID" NUMBER(11,0), 
  	"FROM_EMAIL" NVARCHAR2(255), 
  	"MESSAGE" NCLOB, 
  	"TIMESTAMP" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table GROUP_PUBLICGROUP
  --------------------------------------------------------
  
    CREATE TABLE "GROUP_PUBLICGROUP" 
     (	"ID" NUMBER(11,0), 
  	"GROUP_ID" NUMBER(11,0)
     ) ;
  --------------------------------------------------------
  --  DDL for Table INSTITUTIONS_INSTITUTION
  --------------------------------------------------------
  
    CREATE TABLE "INSTITUTIONS_INSTITUTION" 
     (	"ID" NUMBER(11,0), 
  	"NAME" NVARCHAR2(200), 
  	"CREATE_TIME" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table INSTITUTIONS_INSTITUTIONADMIN
  --------------------------------------------------------
  
    CREATE TABLE "INSTITUTIONS_INSTITUTIONADMIN" 
     (	"ID" NUMBER(11,0), 
  	"USER" NVARCHAR2(254), 
  	"INSTITUTION_ID" NUMBER(11,0)
     ) ;
  --------------------------------------------------------
  --  DDL for Table INVITATIONS_INVITATION
  --------------------------------------------------------
  
    CREATE TABLE "INVITATIONS_INVITATION" 
     (	"ID" NUMBER(11,0), 
  	"TOKEN" NVARCHAR2(40), 
  	"INVITER" NVARCHAR2(255), 
  	"ACCEPTER" NVARCHAR2(255), 
  	"INVITE_TIME" TIMESTAMP (6), 
  	"ACCEPT_TIME" TIMESTAMP (6), 
  	"INVITE_TYPE" NVARCHAR2(20) DEFAULT NULL, 
  	"EXPIRE_TIME" TIMESTAMP (6) DEFAULT NULL
     ) ;
  --------------------------------------------------------
  --  DDL for Table MESSAGE_USERMESSAGE
  --------------------------------------------------------
  
    CREATE TABLE "MESSAGE_USERMESSAGE" 
     (	"MESSAGE_ID" NUMBER(11,0), 
  	"MESSAGE" NVARCHAR2(512), 
  	"FROM_EMAIL" NVARCHAR2(255), 
  	"TO_EMAIL" NVARCHAR2(255), 
  	"TIMESTAMP" TIMESTAMP (6), 
  	"IFREAD" NUMBER(1,0), 
  	"SENDER_DELETED_AT" TIMESTAMP (6), 
  	"RECIPIENT_DELETED_AT" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table MESSAGE_USERMSGATTACHMENT
  --------------------------------------------------------
  
    CREATE TABLE "MESSAGE_USERMSGATTACHMENT" 
     (	"ID" NUMBER(11,0), 
  	"USER_MSG_ID" NUMBER(11,0), 
  	"PRIV_FILE_DIR_SHARE_ID" NUMBER(11,0)
     ) ;
  --------------------------------------------------------
  --  DDL for Table MESSAGE_USERMSGLASTCHECK
  --------------------------------------------------------
  
    CREATE TABLE "MESSAGE_USERMSGLASTCHECK" 
     (	"ID" NUMBER(11,0), 
  	"CHECK_TIME" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table NOTIFICATIONS_NOTIFICATION
  --------------------------------------------------------
  
    CREATE TABLE "NOTIFICATIONS_NOTIFICATION" 
     (	"ID" NUMBER(11,0), 
  	"MESSAGE" NVARCHAR2(512), 
  	"PRIMARY" NUMBER(1,0)
     ) ;
  --------------------------------------------------------
  --  DDL for Table NOTIFICATIONS_USERNOTIFICATION
  --------------------------------------------------------
  
    CREATE TABLE "NOTIFICATIONS_USERNOTIFICATION" 
     (	"ID" NUMBER(11,0), 
  	"TO_USER" NVARCHAR2(255), 
  	"MSG_TYPE" NVARCHAR2(30), 
  	"DETAIL" NCLOB, 
  	"TIMESTAMP" TIMESTAMP (6), 
  	"SEEN" NUMBER(1,0)
     ) ;
  --------------------------------------------------------
  --  DDL for Table OPTIONS_USEROPTIONS
  --------------------------------------------------------
  
    CREATE TABLE "OPTIONS_USEROPTIONS" 
     (	"ID" NUMBER(11,0), 
  	"EMAIL" NVARCHAR2(255), 
  	"OPTION_KEY" NVARCHAR2(50), 
  	"OPTION_VAL" NVARCHAR2(50)
     ) ;
  --------------------------------------------------------
  --  DDL for Table ORGANIZATIONS_ORGMEMBERQUOTA
  --------------------------------------------------------
  
    CREATE TABLE "ORGANIZATIONS_ORGMEMBERQUOTA" 
     (	"ID" NUMBER(11,0), 
  	"ORG_ID" NUMBER(11,0), 
  	"QUOTA" NUMBER(11,0)
     ) ;
  --------------------------------------------------------
  --  DDL for Table POST_OFFICE_ATTACHMENT
  --------------------------------------------------------
  
    CREATE TABLE "POST_OFFICE_ATTACHMENT" 
     (	"ID" NUMBER(11,0), 
  	"FILE" NVARCHAR2(100), 
  	"NAME" NVARCHAR2(255)
     ) ;
  --------------------------------------------------------
  --  DDL for Table POST_OFFICE_ATTACHMENT_EMAILS
  --------------------------------------------------------
  
    CREATE TABLE "POST_OFFICE_ATTACHMENT_EMAILS" 
     (	"ID" NUMBER(11,0), 
  	"ATTACHMENT_ID" NUMBER(11,0), 
  	"EMAIL_ID" NUMBER(11,0)
     ) ;
  --------------------------------------------------------
  --  DDL for Table POST_OFFICE_EMAIL
  --------------------------------------------------------
  
    CREATE TABLE "POST_OFFICE_EMAIL" 
     (	"ID" NUMBER(11,0), 
  	"FROM_EMAIL" NVARCHAR2(254), 
  	"TO" NCLOB, 
  	"CC" NCLOB, 
  	"BCC" NCLOB, 
  	"SUBJECT" NVARCHAR2(255), 
  	"MESSAGE" NCLOB, 
  	"HTML_MESSAGE" NCLOB, 
  	"STATUS" NUMBER(11,0), 
  	"PRIORITY" NUMBER(11,0), 
  	"CREATED" TIMESTAMP (6), 
  	"LAST_UPDATED" TIMESTAMP (6), 
  	"SCHEDULED_TIME" TIMESTAMP (6), 
  	"HEADERS" NCLOB, 
  	"CONTEXT" NCLOB, 
  	"TEMPLATE_ID" NUMBER(11,0) DEFAULT NULL, 
  	"BACKEND_ALIAS" NVARCHAR2(64) DEFAULT NULL
     ) ;
  --------------------------------------------------------
  --  DDL for Table POST_OFFICE_EMAILTEMPLATE
  --------------------------------------------------------
  
    CREATE TABLE "POST_OFFICE_EMAILTEMPLATE" 
     (	"ID" NUMBER(11,0), 
  	"NAME" NVARCHAR2(255), 
  	"DESCRIPTION" NCLOB, 
  	"SUBJECT" NVARCHAR2(255), 
  	"CONTENT" NCLOB, 
  	"HTML_CONTENT" NCLOB, 
  	"CREATED" TIMESTAMP (6), 
  	"LAST_UPDATED" TIMESTAMP (6), 
  	"DEFAULT_TEMPLATE_ID" NUMBER(11,0), 
  	"LANGUAGE" NVARCHAR2(12) DEFAULT NULL
     ) ;
  --------------------------------------------------------
  --  DDL for Table POST_OFFICE_LOG
  --------------------------------------------------------
  
    CREATE TABLE "POST_OFFICE_LOG" 
     (	"ID" NUMBER(11,0), 
  	"DATE" TIMESTAMP (6), 
  	"STATUS" NUMBER(11,0), 
  	"EXCEPTION_TYPE" NVARCHAR2(255), 
  	"MESSAGE" NCLOB, 
  	"EMAIL_ID" NUMBER(11,0)
     ) ;
  --------------------------------------------------------
  --  DDL for Table PROFILE_DETAILEDPROFILE
  --------------------------------------------------------
  
    CREATE TABLE "PROFILE_DETAILEDPROFILE" 
     (	"ID" NUMBER(11,0), 
  	"USER" NVARCHAR2(255), 
  	"DEPARTMENT" NVARCHAR2(512), 
  	"TELEPHONE" NVARCHAR2(100)
     ) ;
  --------------------------------------------------------
  --  DDL for Table PROFILE_PROFILE
  --------------------------------------------------------
  
    CREATE TABLE "PROFILE_PROFILE" 
     (	"ID" NUMBER(11,0), 
  	"USER" NVARCHAR2(254), 
  	"NICKNAME" NVARCHAR2(64), 
  	"INTRO" NCLOB, 
  	"LANG_CODE" NCLOB, 
  	"LOGIN_ID" NVARCHAR2(225), 
  	"CONTACT_EMAIL" NVARCHAR2(225), 
  	"INSTITUTION" NVARCHAR2(225)
     ) ;
  --------------------------------------------------------
  --  DDL for Table REGISTRATION_REGISTRATIONP238A
  --------------------------------------------------------
  
    CREATE TABLE "REGISTRATION_REGISTRATIONP238A" 
     (	"ID" NUMBER(11,0), 
  	"EMAILUSER_ID" NUMBER(11,0), 
  	"ACTIVATION_KEY" NVARCHAR2(40)
     ) ;
  --------------------------------------------------------
  --  DDL for Table SHARE_ANONYMOUSSHARE
  --------------------------------------------------------
  
    CREATE TABLE "SHARE_ANONYMOUSSHARE" 
     (	"ID" NUMBER(11,0), 
  	"REPO_OWNER" NVARCHAR2(255), 
  	"REPO_ID" NVARCHAR2(36), 
  	"ANONYMOUS_EMAIL" NVARCHAR2(255), 
  	"TOKEN" NVARCHAR2(25)
     ) ;
  --------------------------------------------------------
  --  DDL for Table SHARE_FILESHARE
  --------------------------------------------------------
  
    CREATE TABLE "SHARE_FILESHARE" 
     (	"ID" NUMBER(11,0), 
  	"USERNAME" NVARCHAR2(255), 
  	"REPO_ID" NVARCHAR2(36), 
  	"PATH" NCLOB, 
  	"TOKEN" NVARCHAR2(10), 
  	"CTIME" TIMESTAMP (6), 
  	"VIEW_CNT" NUMBER(11,0), 
  	"S_TYPE" NVARCHAR2(2), 
  	"PASSWORD" NVARCHAR2(128), 
  	"EXPIRE_DATE" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table SHARE_ORGFILESHARE
  --------------------------------------------------------
  
    CREATE TABLE "SHARE_ORGFILESHARE" 
     (	"ID" NUMBER(11,0), 
  	"ORG_ID" NUMBER(11,0), 
  	"FILE_SHARE_ID" NUMBER(11,0)
     ) ;
  --------------------------------------------------------
  --  DDL for Table SHARE_PRIVATEFILEDIRSHARE
  --------------------------------------------------------
  
    CREATE TABLE "SHARE_PRIVATEFILEDIRSHARE" 
     (	"ID" NUMBER(11,0), 
  	"FROM_USER" NVARCHAR2(255), 
  	"TO_USER" NVARCHAR2(255), 
  	"REPO_ID" NVARCHAR2(36), 
  	"PATH" NCLOB, 
  	"TOKEN" NVARCHAR2(10), 
  	"PERMISSION" NVARCHAR2(5), 
  	"S_TYPE" NVARCHAR2(5)
     ) ;
  --------------------------------------------------------
  --  DDL for Table SHARE_UPLOADLINKSHARE
  --------------------------------------------------------
  
    CREATE TABLE "SHARE_UPLOADLINKSHARE" 
     (	"ID" NUMBER(11,0), 
  	"USERNAME" NVARCHAR2(255), 
  	"REPO_ID" NVARCHAR2(36), 
  	"PATH" NCLOB, 
  	"TOKEN" NVARCHAR2(10), 
  	"CTIME" TIMESTAMP (6), 
  	"VIEW_CNT" NUMBER(11,0), 
  	"PASSWORD" NVARCHAR2(128), 
  	"EXPIRE_DATE" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table SYSADMIN_EXTRA_USERLOGINLOG
  --------------------------------------------------------
  
    CREATE TABLE "SYSADMIN_EXTRA_USERLOGINLOG" 
     (	"ID" NUMBER(11,0), 
  	"USERNAME" NVARCHAR2(255), 
  	"LOGIN_DATE" TIMESTAMP (6), 
  	"LOGIN_IP" NVARCHAR2(128)
     ) ;
  --------------------------------------------------------
  --  DDL for Table TERMSANDCONDITIONS_TERMSAN0233
  --------------------------------------------------------
  
    CREATE TABLE "TERMSANDCONDITIONS_TERMSAN0233" 
     (	"ID" NUMBER(11,0), 
  	"SLUG" NVARCHAR2(50), 
  	"NAME" NCLOB, 
  	"VERSION_NUMBER" NUMBER(6,2), 
  	"TEXT" NCLOB, 
  	"INFO" NCLOB, 
  	"DATE_ACTIVE" TIMESTAMP (6), 
  	"DATE_CREATED" TIMESTAMP (6)
     ) ;
  --------------------------------------------------------
  --  DDL for Table TERMSANDCONDITIONS_USERTERF56C
  --------------------------------------------------------
  
    CREATE TABLE "TERMSANDCONDITIONS_USERTERF56C" 
     (	"ID" NUMBER(11,0), 
  	"USERNAME" NVARCHAR2(255), 
  	"IP_ADDRESS" VARCHAR2(39 BYTE), 
  	"DATE_ACCEPTED" TIMESTAMP (6), 
  	"TERMS_ID" NUMBER(11,0)
     ) ;
  --------------------------------------------------------
  --  DDL for Table TWO_FACTOR_PHONEDEVICE
  --------------------------------------------------------
  
    CREATE TABLE "TWO_FACTOR_PHONEDEVICE" 
     (	"ID" NUMBER(11,0), 
  	"USER" NVARCHAR2(255), 
  	"NAME" NVARCHAR2(64), 
  	"CONFIRMED" NUMBER(1,0), 
  	"NUMBER" NVARCHAR2(40), 
  	"KEY" NVARCHAR2(40), 
  	"METHOD" NVARCHAR2(4)
     ) ;
  --------------------------------------------------------
  --  DDL for Table TWO_FACTOR_STATICDEVICE
  --------------------------------------------------------
  
    CREATE TABLE "TWO_FACTOR_STATICDEVICE" 
     (	"ID" NUMBER(11,0), 
  	"USER" NVARCHAR2(255), 
  	"NAME" NVARCHAR2(64), 
  	"CONFIRMED" NUMBER(1,0)
     ) ;
  --------------------------------------------------------
  --  DDL for Table TWO_FACTOR_STATICTOKEN
  --------------------------------------------------------
  
    CREATE TABLE "TWO_FACTOR_STATICTOKEN" 
     (	"ID" NUMBER(11,0), 
  	"TOKEN" NVARCHAR2(16), 
  	"DEVICE_ID" NUMBER(11,0)
     ) ;
  --------------------------------------------------------
  --  DDL for Table TWO_FACTOR_TOTPDEVICE
  --------------------------------------------------------
  
    CREATE TABLE "TWO_FACTOR_TOTPDEVICE" 
     (	"ID" NUMBER(11,0), 
  	"USER" NVARCHAR2(255), 
  	"NAME" NVARCHAR2(64), 
  	"CONFIRMED" NUMBER(1,0), 
  	"KEY" NVARCHAR2(80), 
  	"STEP" NUMBER(11,0), 
  	"T0" NUMBER(19,0), 
  	"DIGITS" NUMBER(11,0), 
  	"TOLERANCE" NUMBER(11,0), 
  	"DRIFT" NUMBER(11,0), 
  	"LAST_T" NUMBER(19,0)
     ) ;
  --------------------------------------------------------
  --  DDL for Table WIKI_GROUPWIKI
  --------------------------------------------------------
  
    CREATE TABLE "WIKI_GROUPWIKI" 
     (	"ID" NUMBER(11,0), 
  	"GROUP_ID" NUMBER(11,0), 
  	"REPO_ID" NVARCHAR2(36)
     ) ;
  --------------------------------------------------------
  --  DDL for Table WIKI_PERSONALWIKI
  --------------------------------------------------------
  
    CREATE TABLE "WIKI_PERSONALWIKI" 
     (	"ID" NUMBER(11,0), 
  	"USERNAME" NVARCHAR2(255), 
  	"REPO_ID" NVARCHAR2(36)
     ) ;
  --------------------------------------------------------
  --  DDL for Sequence AVATAR_AVATAR_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "AVATAR_AVATAR_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence AVATAR_GROUPAVATAR_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "AVATAR_GROUPAVATAR_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence BASE_COMMANDSLASTCHECK_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "BASE_COMMANDSLASTCHECK_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence BASE_DEVICETOKEN_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "BASE_DEVICETOKEN_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence BASE_FILECOMMENT_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "BASE_FILECOMMENT_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence BASE_FILEDISCUSS_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "BASE_FILEDISCUSS_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence BASE_GROUPENABLEDMODULE_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "BASE_GROUPENABLEDMODULE_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence BASE_INNERPUBMSGREPLY_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "BASE_INNERPUBMSGREPLY_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence BASE_INNERPUBMSG_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "BASE_INNERPUBMSG_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence BASE_USERENABLEDMODULE_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "BASE_USERENABLEDMODULE_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence BASE_USERLASTLOGIN_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "BASE_USERLASTLOGIN_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence BASE_USERSTARREDFILES_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "BASE_USERSTARREDFILES_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence CAPTCHA_CAPTCHASTORE_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "CAPTCHA_CAPTCHASTORE_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence CONSTANCE_CONFIG_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "CONSTANCE_CONFIG_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence CONTACTS_CONTACT_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "CONTACTS_CONTACT_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence DJANGO_CONTENT_TYPE_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "DJANGO_CONTENT_TYPE_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 61 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence DJANGO_MIGRATIONS_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "DJANGO_MIGRATIONS_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence GROUP_GROUPMESSAGE_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "GROUP_GROUPMESSAGE_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence GROUP_MESSAGEATTACHMENT_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "GROUP_MESSAGEATTACHMENT_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence GROUP_MESSAGEREPLY_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "GROUP_MESSAGEREPLY_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence GROUP_PUBLICGROUP_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "GROUP_PUBLICGROUP_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence INSTITUTIONS_INSTITUTIO2836_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "INSTITUTIONS_INSTITUTIO2836_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence INSTITUTIONS_INSTITUTION_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "INSTITUTIONS_INSTITUTION_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence INVITATIONS_INVITATION_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "INVITATIONS_INVITATION_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence MESSAGE_USERMESSAGE_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "MESSAGE_USERMESSAGE_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence MESSAGE_USERMSGATTACHMENT_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "MESSAGE_USERMSGATTACHMENT_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence MESSAGE_USERMSGLASTCHECK_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "MESSAGE_USERMSGLASTCHECK_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence NOTIFICATIONS_NOTIFICATION_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "NOTIFICATIONS_NOTIFICATION_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence NOTIFICATIONS_USERNOTIF3BBF_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "NOTIFICATIONS_USERNOTIF3BBF_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence OPTIONS_USEROPTIONS_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "OPTIONS_USEROPTIONS_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence ORGANIZATIONS_ORGMEMBER6B70_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "ORGANIZATIONS_ORGMEMBER6B70_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence POST_OFFICE_ATTACHMENT_D670_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "POST_OFFICE_ATTACHMENT_D670_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence POST_OFFICE_ATTACHMENT_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "POST_OFFICE_ATTACHMENT_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence POST_OFFICE_EMAILTEMPLATE_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "POST_OFFICE_EMAILTEMPLATE_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence POST_OFFICE_EMAIL_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "POST_OFFICE_EMAIL_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence POST_OFFICE_LOG_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "POST_OFFICE_LOG_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence PROFILE_DETAILEDPROFILE_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "PROFILE_DETAILEDPROFILE_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence PROFILE_PROFILE_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "PROFILE_PROFILE_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence REGISTRATION_REGISTRATI2179_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "REGISTRATION_REGISTRATI2179_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence SHARE_ANONYMOUSSHARE_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "SHARE_ANONYMOUSSHARE_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence SHARE_FILESHARE_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "SHARE_FILESHARE_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence SHARE_ORGFILESHARE_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "SHARE_ORGFILESHARE_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence SHARE_PRIVATEFILEDIRSHARE_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "SHARE_PRIVATEFILEDIRSHARE_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence SHARE_UPLOADLINKSHARE_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "SHARE_UPLOADLINKSHARE_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence SYSADMIN_EXTRA_USERLOGINLOG_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "SYSADMIN_EXTRA_USERLOGINLOG_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence TERMSANDCONDITIONS_TERM6123_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "TERMSANDCONDITIONS_TERM6123_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence TERMSANDCONDITIONS_USERCF1A_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "TERMSANDCONDITIONS_USERCF1A_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence TWO_FACTOR_PHONEDEVICE_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "TWO_FACTOR_PHONEDEVICE_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence TWO_FACTOR_STATICDEVICE_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "TWO_FACTOR_STATICDEVICE_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence TWO_FACTOR_STATICTOKEN_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "TWO_FACTOR_STATICTOKEN_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence TWO_FACTOR_TOTPDEVICE_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "TWO_FACTOR_TOTPDEVICE_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence WIKI_GROUPWIKI_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "WIKI_GROUPWIKI_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  --------------------------------------------------------
  --  DDL for Sequence WIKI_PERSONALWIKI_SQ
  --------------------------------------------------------
  
     CREATE SEQUENCE  "WIKI_PERSONALWIKI_SQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;
  REM INSERTING into API2_TOKEN
  SET DEFINE OFF;
  REM INSERTING into API2_TOKENV2
  SET DEFINE OFF;
  REM INSERTING into AVATAR_AVATAR
  SET DEFINE OFF;
  REM INSERTING into AVATAR_GROUPAVATAR
  SET DEFINE OFF;
  REM INSERTING into BASE_CLIENTLOGINTOKEN
  SET DEFINE OFF;
  REM INSERTING into BASE_COMMANDSLASTCHECK
  SET DEFINE OFF;
  REM INSERTING into BASE_DEVICETOKEN
  SET DEFINE OFF;
  REM INSERTING into BASE_FILECOMMENT
  SET DEFINE OFF;
  REM INSERTING into BASE_FILEDISCUSS
  SET DEFINE OFF;
  REM INSERTING into BASE_GROUPENABLEDMODULE
  SET DEFINE OFF;
  REM INSERTING into BASE_INNERPUBMSG
  SET DEFINE OFF;
  REM INSERTING into BASE_INNERPUBMSGREPLY
  SET DEFINE OFF;
  REM INSERTING into BASE_USERENABLEDMODULE
  SET DEFINE OFF;
  REM INSERTING into BASE_USERLASTLOGIN
  SET DEFINE OFF;
  REM INSERTING into BASE_USERSTARREDFILES
  SET DEFINE OFF;
  REM INSERTING into CAPTCHA_CAPTCHASTORE
  SET DEFINE OFF;
  REM INSERTING into CONSTANCE_CONFIG
  SET DEFINE OFF;
  REM INSERTING into CONTACTS_CONTACT
  SET DEFINE OFF;
  REM INSERTING into DJANGO_CONTENT_TYPE
  SET DEFINE OFF;
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (1,'contenttypes','contenttype');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (2,'sessions','session');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (3,'registration','registrationprofile');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (4,'captcha','captchastore');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (5,'database','constance');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (6,'post_office','attachment');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (7,'post_office','emailtemplate');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (8,'post_office','email');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (9,'post_office','log');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (10,'termsandconditions','termsandconditions');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (11,'termsandconditions','usertermsandconditions');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (12,'api2','token');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (13,'api2','tokenv2');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (14,'avatar','avatar');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (15,'avatar','groupavatar');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (16,'base','groupenabledmodule');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (17,'base','clientlogintoken');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (18,'base','userenabledmodule');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (19,'base','filecomment');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (20,'base','filediscuss');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (21,'base','devicetoken');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (22,'base','commandslastcheck');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (23,'base','innerpubmsg');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (24,'base','innerpubmsgreply');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (25,'base','userlastlogin');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (26,'base','userstarredfiles');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (27,'contacts','contact');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (28,'institutions','institutionadmin');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (29,'institutions','institution');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (30,'invitations','invitation');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (31,'wiki','personalwiki');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (32,'wiki','groupwiki');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (33,'group','publicgroup');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (34,'group','groupmessage');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (35,'group','messageattachment');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (36,'group','messagereply');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (37,'message','usermsgattachment');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (38,'message','usermsglastcheck');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (39,'message','usermessage');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (40,'notifications','notification');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (41,'notifications','usernotification');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (42,'options','useroptions');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (43,'profile','profile');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (44,'profile','detailedprofile');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (45,'share','privatefiledirshare');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (46,'share','uploadlinkshare');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (47,'share','fileshare');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (48,'share','anonymousshare');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (49,'share','orgfileshare');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (50,'sysadmin_extra','userloginlog');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (51,'organizations','orgmemberquota');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (52,'two_factor','phonedevice');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (53,'two_factor','statictoken');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (54,'two_factor','totpdevice');
  Insert into DJANGO_CONTENT_TYPE (ID,APP_LABEL,MODEL) values (55,'two_factor','staticdevice');
  REM INSERTING into DJANGO_MIGRATIONS
  SET DEFINE OFF;
  REM INSERTING into DJANGO_SESSION
  SET DEFINE OFF;
  REM INSERTING into GROUP_GROUPMESSAGE
  SET DEFINE OFF;
  REM INSERTING into GROUP_MESSAGEATTACHMENT
  SET DEFINE OFF;
  REM INSERTING into GROUP_MESSAGEREPLY
  SET DEFINE OFF;
  REM INSERTING into GROUP_PUBLICGROUP
  SET DEFINE OFF;
  REM INSERTING into INSTITUTIONS_INSTITUTION
  SET DEFINE OFF;
  REM INSERTING into INSTITUTIONS_INSTITUTIONADMIN
  SET DEFINE OFF;
  REM INSERTING into INVITATIONS_INVITATION
  SET DEFINE OFF;
  REM INSERTING into MESSAGE_USERMESSAGE
  SET DEFINE OFF;
  REM INSERTING into MESSAGE_USERMSGATTACHMENT
  SET DEFINE OFF;
  REM INSERTING into MESSAGE_USERMSGLASTCHECK
  SET DEFINE OFF;
  REM INSERTING into NOTIFICATIONS_NOTIFICATION
  SET DEFINE OFF;
  REM INSERTING into NOTIFICATIONS_USERNOTIFICATION
  SET DEFINE OFF;
  REM INSERTING into OPTIONS_USEROPTIONS
  SET DEFINE OFF;
  REM INSERTING into ORGANIZATIONS_ORGMEMBERQUOTA
  SET DEFINE OFF;
  REM INSERTING into POST_OFFICE_ATTACHMENT
  SET DEFINE OFF;
  REM INSERTING into POST_OFFICE_ATTACHMENT_EMAILS
  SET DEFINE OFF;
  REM INSERTING into POST_OFFICE_EMAIL
  SET DEFINE OFF;
  REM INSERTING into POST_OFFICE_EMAILTEMPLATE
  SET DEFINE OFF;
  REM INSERTING into POST_OFFICE_LOG
  SET DEFINE OFF;
  REM INSERTING into PROFILE_DETAILEDPROFILE
  SET DEFINE OFF;
  REM INSERTING into PROFILE_PROFILE
  SET DEFINE OFF;
  REM INSERTING into REGISTRATION_REGISTRATIONP238A
  SET DEFINE OFF;
  REM INSERTING into SHARE_ANONYMOUSSHARE
  SET DEFINE OFF;
  REM INSERTING into SHARE_FILESHARE
  SET DEFINE OFF;
  REM INSERTING into SHARE_ORGFILESHARE
  SET DEFINE OFF;
  REM INSERTING into SHARE_PRIVATEFILEDIRSHARE
  SET DEFINE OFF;
  REM INSERTING into SHARE_UPLOADLINKSHARE
  SET DEFINE OFF;
  REM INSERTING into SYSADMIN_EXTRA_USERLOGINLOG
  SET DEFINE OFF;
  REM INSERTING into TERMSANDCONDITIONS_TERMSAN0233
  SET DEFINE OFF;
  REM INSERTING into TERMSANDCONDITIONS_USERTERF56C
  SET DEFINE OFF;
  REM INSERTING into TWO_FACTOR_PHONEDEVICE
  SET DEFINE OFF;
  REM INSERTING into TWO_FACTOR_STATICDEVICE
  SET DEFINE OFF;
  REM INSERTING into TWO_FACTOR_STATICTOKEN
  SET DEFINE OFF;
  REM INSERTING into TWO_FACTOR_TOTPDEVICE
  SET DEFINE OFF;
  REM INSERTING into WIKI_GROUPWIKI
  SET DEFINE OFF;
  REM INSERTING into WIKI_PERSONALWIKI
  SET DEFINE OFF;
  --------------------------------------------------------
  --  DDL for Index GROUP_PUBLICGROUP_0E939A4F
  --------------------------------------------------------
  
    CREATE INDEX "GROUP_PUBLICGROUP_0E939A4F" ON "GROUP_PUBLICGROUP" ("GROUP_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index POST_OFFICE_EMAIL_E2FA5388
  --------------------------------------------------------
  
    CREATE INDEX "POST_OFFICE_EMAIL_E2FA5388" ON "POST_OFFICE_EMAIL" ("CREATED") 
    ;
  --------------------------------------------------------
  --  DDL for Index SHARE_FILESHARE_14C4B06B
  --------------------------------------------------------
  
    CREATE INDEX "SHARE_FILESHARE_14C4B06B" ON "SHARE_FILESHARE" ("USERNAME") 
    ;
  --------------------------------------------------------
  --  DDL for Index BASE_CLIENTLOGINTOKEN_14C4B06B
  --------------------------------------------------------
  
    CREATE INDEX "BASE_CLIENTLOGINTOKEN_14C4B06B" ON "BASE_CLIENTLOGINTOKEN" ("USERNAME") 
    ;
  --------------------------------------------------------
  --  DDL for Index BASE_FILEDISCUSS_B57D9B6B
  --------------------------------------------------------
  
    CREATE INDEX "BASE_FILEDISCUSS_B57D9B6B" ON "BASE_FILEDISCUSS" ("PATH_HASH") 
    ;
  --------------------------------------------------------
  --  DDL for Index BASE_FILECOMMENT_C5BF47D4
  --------------------------------------------------------
  
    CREATE INDEX "BASE_FILECOMMENT_C5BF47D4" ON "BASE_FILECOMMENT" ("REPO_ID_PARENT_PATH_MD5") 
    ;
  --------------------------------------------------------
  --  DDL for Index PROFILE_DETAILEDPROFILE_EE955F
  --------------------------------------------------------
  
    CREATE INDEX "PROFILE_DETAILEDPROFILE_EE955F" ON "PROFILE_DETAILEDPROFILE" ("USER") 
    ;
  --------------------------------------------------------
  --  DDL for Index SHARE_ORGFILESHARE_9CF869AA
  --------------------------------------------------------
  
    CREATE INDEX "SHARE_ORGFILESHARE_9CF869AA" ON "SHARE_ORGFILESHARE" ("ORG_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index MESSAGE_USERMESSAGE_ACC047CF
  --------------------------------------------------------
  
    CREATE INDEX "MESSAGE_USERMESSAGE_ACC047CF" ON "MESSAGE_USERMESSAGE" ("TO_EMAIL") 
    ;
  --------------------------------------------------------
  --  DDL for Index SHARE_FILESHARE_1ABD88B5
  --------------------------------------------------------
  
    CREATE INDEX "SHARE_FILESHARE_1ABD88B5" ON "SHARE_FILESHARE" ("S_TYPE") 
    ;
  --------------------------------------------------------
  --  DDL for Index DJANGO_SESSION_DE54FA62
  --------------------------------------------------------
  
    CREATE INDEX "DJANGO_SESSION_DE54FA62" ON "DJANGO_SESSION" ("EXPIRE_DATE") 
    ;
  --------------------------------------------------------
  --  DDL for Index BASE_GROUPENABLEDMODULE_0EB6FF
  --------------------------------------------------------
  
    CREATE INDEX "BASE_GROUPENABLEDMODULE_0EB6FF" ON "BASE_GROUPENABLEDMODULE" ("GROUP_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index POST_OFFICE_EMAIL_74F53564
  --------------------------------------------------------
  
    CREATE INDEX "POST_OFFICE_EMAIL_74F53564" ON "POST_OFFICE_EMAIL" ("TEMPLATE_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index TWO_FACTOR_STATICTOKEN_94A39D5
  --------------------------------------------------------
  
    CREATE INDEX "TWO_FACTOR_STATICTOKEN_94A39D5" ON "TWO_FACTOR_STATICTOKEN" ("TOKEN") 
    ;
  --------------------------------------------------------
  --  DDL for Index MESSAGE_USERMSGATTACHMENT_7620
  --------------------------------------------------------
  
    CREATE INDEX "MESSAGE_USERMSGATTACHMENT_7620" ON "MESSAGE_USERMSGATTACHMENT" ("USER_MSG_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index D85D5DBB541FAB8F1DF26BA8B130BE
  --------------------------------------------------------
  
    CREATE UNIQUE INDEX "D85D5DBB541FAB8F1DF26BA8B130BE" ON "DJANGO_CONTENT_TYPE" ("APP_LABEL", "MODEL") 
    ;
  --------------------------------------------------------
  --  DDL for Index BASE_FILECOMMENT_9A8C79BF
  --------------------------------------------------------
  
    CREATE INDEX "BASE_FILECOMMENT_9A8C79BF" ON "BASE_FILECOMMENT" ("REPO_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index NOTIFICATIONS_USERNOTIFICA0E9C
  --------------------------------------------------------
  
    CREATE INDEX "NOTIFICATIONS_USERNOTIFICA0E9C" ON "NOTIFICATIONS_USERNOTIFICATION" ("TO_USER") 
    ;
  --------------------------------------------------------
  --  DDL for Index BASE_FILEDISCUSS_06A351D8
  --------------------------------------------------------
  
    CREATE INDEX "BASE_FILEDISCUSS_06A351D8" ON "BASE_FILEDISCUSS" ("GROUP_MESSAGE_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index POST_OFFICE_ATTACHMENT_EMA4D2F
  --------------------------------------------------------
  
    CREATE INDEX "POST_OFFICE_ATTACHMENT_EMA4D2F" ON "POST_OFFICE_ATTACHMENT_EMAILS" ("ATTACHMENT_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index TERMSANDCONDITIONS_USERTER2708
  --------------------------------------------------------
  
    CREATE INDEX "TERMSANDCONDITIONS_USERTER2708" ON "TERMSANDCONDITIONS_USERTERF56C" ("TERMS_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index BASE_USERENABLEDMODULE_14C60A0
  --------------------------------------------------------
  
    CREATE INDEX "BASE_USERENABLEDMODULE_14C60A0" ON "BASE_USERENABLEDMODULE" ("USERNAME") 
    ;
  --------------------------------------------------------
  --  DDL for Index GROUP_GROUPMESSAGE_0E939A4F
  --------------------------------------------------------
  
    CREATE INDEX "GROUP_GROUPMESSAGE_0E939A4F" ON "GROUP_GROUPMESSAGE" ("GROUP_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index OPTIONS_USEROPTIONS_0C83F57C
  --------------------------------------------------------
  
    CREATE INDEX "OPTIONS_USEROPTIONS_0C83F57C" ON "OPTIONS_USEROPTIONS" ("EMAIL") 
    ;
  --------------------------------------------------------
  --  DDL for Index SYSADMIN_EXTRA_USERLOGINLO3F5D
  --------------------------------------------------------
  
    CREATE INDEX "SYSADMIN_EXTRA_USERLOGINLO3F5D" ON "SYSADMIN_EXTRA_USERLOGINLOG" ("USERNAME") 
    ;
  --------------------------------------------------------
  --  DDL for Index BASE_FILECOMMENT_02BD92FA
  --------------------------------------------------------
  
    CREATE INDEX "BASE_FILECOMMENT_02BD92FA" ON "BASE_FILECOMMENT" ("AUTHOR") 
    ;
  --------------------------------------------------------
  --  DDL for Index GROUP_MESSAGEREPLY_6EC85D95
  --------------------------------------------------------
  
    CREATE INDEX "GROUP_MESSAGEREPLY_6EC85D95" ON "GROUP_MESSAGEREPLY" ("REPLY_TO_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index SHARE_FILESHARE_9A8C79BF
  --------------------------------------------------------
  
    CREATE INDEX "SHARE_FILESHARE_9A8C79BF" ON "SHARE_FILESHARE" ("REPO_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index POST_OFFICE_EMAIL_ED24D584
  --------------------------------------------------------
  
    CREATE INDEX "POST_OFFICE_EMAIL_ED24D584" ON "POST_OFFICE_EMAIL" ("SCHEDULED_TIME") 
    ;
  --------------------------------------------------------
  --  DDL for Index ORGANIZATIONS_ORGMEMBERQUO73CD
  --------------------------------------------------------
  
    CREATE INDEX "ORGANIZATIONS_ORGMEMBERQUO73CD" ON "ORGANIZATIONS_ORGMEMBERQUOTA" ("ORG_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index BASE_USERLASTLOGIN_14C4B06B
  --------------------------------------------------------
  
    CREATE INDEX "BASE_USERLASTLOGIN_14C4B06B" ON "BASE_USERLASTLOGIN" ("USERNAME") 
    ;
  --------------------------------------------------------
  --  DDL for Index PROFILE_PROFILE_B9973D8C
  --------------------------------------------------------
  
    CREATE INDEX "PROFILE_PROFILE_B9973D8C" ON "PROFILE_PROFILE" ("CONTACT_EMAIL") 
    ;
  --------------------------------------------------------
  --  DDL for Index CONTACTS_CONTACT_40C27BDC
  --------------------------------------------------------
  
    CREATE INDEX "CONTACTS_CONTACT_40C27BDC" ON "CONTACTS_CONTACT" ("USER_EMAIL") 
    ;
  --------------------------------------------------------
  --  DDL for Index POST_OFFICE_EMAIL_9ACB4454
  --------------------------------------------------------
  
    CREATE INDEX "POST_OFFICE_EMAIL_9ACB4454" ON "POST_OFFICE_EMAIL" ("STATUS") 
    ;
  --------------------------------------------------------
  --  DDL for Index SHARE_UPLOADLINKSHARE_9A8C79BF
  --------------------------------------------------------
  
    CREATE INDEX "SHARE_UPLOADLINKSHARE_9A8C79BF" ON "SHARE_UPLOADLINKSHARE" ("REPO_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index FF9556696FEEA12226069FE6564DB9
  --------------------------------------------------------
  
    CREATE UNIQUE INDEX "FF9556696FEEA12226069FE6564DB9" ON "POST_OFFICE_EMAILTEMPLATE" ("LANGUAGE", "DEFAULT_TEMPLATE_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index SHARE_PRIVATEFILEDIRSHARE_A423
  --------------------------------------------------------
  
    CREATE INDEX "SHARE_PRIVATEFILEDIRSHARE_A423" ON "SHARE_PRIVATEFILEDIRSHARE" ("FROM_USER") 
    ;
  --------------------------------------------------------
  --  DDL for Index POST_OFFICE_EMAIL_3ACC0B7A
  --------------------------------------------------------
  
    CREATE INDEX "POST_OFFICE_EMAIL_3ACC0B7A" ON "POST_OFFICE_EMAIL" ("LAST_UPDATED") 
    ;
  --------------------------------------------------------
  --  DDL for Index FA265FB080B978BD0FE0BF3E4B445B
  --------------------------------------------------------
  
    CREATE UNIQUE INDEX "FA265FB080B978BD0FE0BF3E4B445B" ON "TERMSANDCONDITIONS_USERTERF56C" ("USERNAME", "TERMS_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index POST_OFFICE_EMAILTEMPLATE_0A6B
  --------------------------------------------------------
  
    CREATE INDEX "POST_OFFICE_EMAILTEMPLATE_0A6B" ON "POST_OFFICE_EMAILTEMPLATE" ("DEFAULT_TEMPLATE_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index SHARE_PRIVATEFILEDIRSHARE_ECC3
  --------------------------------------------------------
  
    CREATE INDEX "SHARE_PRIVATEFILEDIRSHARE_ECC3" ON "SHARE_PRIVATEFILEDIRSHARE" ("REPO_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index TERMSANDCONDITIONS_TERMSANC405
  --------------------------------------------------------
  
    CREATE INDEX "TERMSANDCONDITIONS_TERMSANC405" ON "TERMSANDCONDITIONS_TERMSAN0233" ("SLUG") 
    ;
  --------------------------------------------------------
  --  DDL for Index NOTIFICATIONS_USERNOTIFICAC70C
  --------------------------------------------------------
  
    CREATE INDEX "NOTIFICATIONS_USERNOTIFICAC70C" ON "NOTIFICATIONS_USERNOTIFICATION" ("MSG_TYPE") 
    ;
  --------------------------------------------------------
  --  DDL for Index GROUP_MESSAGEATTACHMENT_061B3A
  --------------------------------------------------------
  
    CREATE INDEX "GROUP_MESSAGEATTACHMENT_061B3A" ON "GROUP_MESSAGEATTACHMENT" ("GROUP_MESSAGE_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index PROFILE_PROFILE_955BFFF7
  --------------------------------------------------------
  
    CREATE INDEX "PROFILE_PROFILE_955BFFF7" ON "PROFILE_PROFILE" ("INSTITUTION") 
    ;
  --------------------------------------------------------
  --  DDL for Index INVITATIONS_INVITATION_D5D9837
  --------------------------------------------------------
  
    CREATE INDEX "INVITATIONS_INVITATION_D5D9837" ON "INVITATIONS_INVITATION" ("INVITER") 
    ;
  --------------------------------------------------------
  --  DDL for Index MESSAGE_USERMSGATTACHMENT_CA70
  --------------------------------------------------------
  
    CREATE INDEX "MESSAGE_USERMSGATTACHMENT_CA70" ON "MESSAGE_USERMSGATTACHMENT" ("PRIV_FILE_DIR_SHARE_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index MESSAGE_USERMESSAGE_F50BD8C4
  --------------------------------------------------------
  
    CREATE INDEX "MESSAGE_USERMESSAGE_F50BD8C4" ON "MESSAGE_USERMESSAGE" ("FROM_EMAIL") 
    ;
  --------------------------------------------------------
  --  DDL for Index SHARE_PRIVATEFILEDIRSHARE_1A9E
  --------------------------------------------------------
  
    CREATE INDEX "SHARE_PRIVATEFILEDIRSHARE_1A9E" ON "SHARE_PRIVATEFILEDIRSHARE" ("TO_USER") 
    ;
  --------------------------------------------------------
  --  DDL for Index INSTITUTIONS_INSTITUTIONAD53E9
  --------------------------------------------------------
  
    CREATE INDEX "INSTITUTIONS_INSTITUTIONAD53E9" ON "INSTITUTIONS_INSTITUTIONADMIN" ("INSTITUTION_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index BASE_USERSTARREDFILES_0C83F57C
  --------------------------------------------------------
  
    CREATE INDEX "BASE_USERSTARREDFILES_0C83F57C" ON "BASE_USERSTARREDFILES" ("EMAIL") 
    ;
  --------------------------------------------------------
  --  DDL for Index TWO_FACTOR_STATICTOKEN_937438C
  --------------------------------------------------------
  
    CREATE INDEX "TWO_FACTOR_STATICTOKEN_937438C" ON "TWO_FACTOR_STATICTOKEN" ("DEVICE_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index POST_OFFICE_ATTACHMENT_EMAE208
  --------------------------------------------------------
  
    CREATE INDEX "POST_OFFICE_ATTACHMENT_EMAE208" ON "POST_OFFICE_ATTACHMENT_EMAILS" ("EMAIL_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index BASE_INNERPUBMSGREPLY_6EC85D95
  --------------------------------------------------------
  
    CREATE INDEX "BASE_INNERPUBMSGREPLY_6EC85D95" ON "BASE_INNERPUBMSGREPLY" ("REPLY_TO_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index IN_TOKEN_1961FBB98C05E5FD_UNIQ
  --------------------------------------------------------
  
    CREATE INDEX "IN_TOKEN_1961FBB98C05E5FD_UNIQ" ON "INVITATIONS_INVITATION" ("TOKEN") 
    ;
  --------------------------------------------------------
  --  DDL for Index BASE_USERSTARREDFILES_9A8C79BF
  --------------------------------------------------------
  
    CREATE INDEX "BASE_USERSTARREDFILES_9A8C79BF" ON "BASE_USERSTARREDFILES" ("REPO_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index POST_OFFICE_LOG_FDFD0EBF
  --------------------------------------------------------
  
    CREATE INDEX "POST_OFFICE_LOG_FDFD0EBF" ON "POST_OFFICE_LOG" ("EMAIL_ID") 
    ;
  --------------------------------------------------------
  --  DDL for Index SHARE_UPLOADLINKSHARE_14C4B06B
  --------------------------------------------------------
  
    CREATE INDEX "SHARE_UPLOADLINKSHARE_14C4B06B" ON "SHARE_UPLOADLINKSHARE" ("USERNAME") 
    ;
  --------------------------------------------------------
  --  DDL for Index SYSADMIN_EXTRA_USERLOGINLO3B65
  --------------------------------------------------------
  
    CREATE INDEX "SYSADMIN_EXTRA_USERLOGINLO3B65" ON "SYSADMIN_EXTRA_USERLOGINLOG" ("LOGIN_DATE") 
    ;
  --------------------------------------------------------
  --  DDL for Trigger AVATAR_AVATAR_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "AVATAR_AVATAR_TR" 
  BEFORE INSERT ON "AVATAR_AVATAR"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "AVATAR_AVATAR_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "AVATAR_AVATAR_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger AVATAR_GROUPAVATAR_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "AVATAR_GROUPAVATAR_TR" 
  BEFORE INSERT ON "AVATAR_GROUPAVATAR"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "AVATAR_GROUPAVATAR_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "AVATAR_GROUPAVATAR_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger BASE_COMMANDSLASTCHECK_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "BASE_COMMANDSLASTCHECK_TR" 
  BEFORE INSERT ON "BASE_COMMANDSLASTCHECK"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "BASE_COMMANDSLASTCHECK_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "BASE_COMMANDSLASTCHECK_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger BASE_DEVICETOKEN_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "BASE_DEVICETOKEN_TR" 
  BEFORE INSERT ON "BASE_DEVICETOKEN"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "BASE_DEVICETOKEN_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "BASE_DEVICETOKEN_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger BASE_FILECOMMENT_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "BASE_FILECOMMENT_TR" 
  BEFORE INSERT ON "BASE_FILECOMMENT"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "BASE_FILECOMMENT_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "BASE_FILECOMMENT_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger BASE_FILEDISCUSS_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "BASE_FILEDISCUSS_TR" 
  BEFORE INSERT ON "BASE_FILEDISCUSS"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "BASE_FILEDISCUSS_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "BASE_FILEDISCUSS_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger BASE_GROUPENABLEDMODULE_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "BASE_GROUPENABLEDMODULE_TR" 
  BEFORE INSERT ON "BASE_GROUPENABLEDMODULE"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "BASE_GROUPENABLEDMODULE_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "BASE_GROUPENABLEDMODULE_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger BASE_INNERPUBMSGREPLY_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "BASE_INNERPUBMSGREPLY_TR" 
  BEFORE INSERT ON "BASE_INNERPUBMSGREPLY"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "BASE_INNERPUBMSGREPLY_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "BASE_INNERPUBMSGREPLY_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger BASE_INNERPUBMSG_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "BASE_INNERPUBMSG_TR" 
  BEFORE INSERT ON "BASE_INNERPUBMSG"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "BASE_INNERPUBMSG_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "BASE_INNERPUBMSG_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger BASE_USERENABLEDMODULE_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "BASE_USERENABLEDMODULE_TR" 
  BEFORE INSERT ON "BASE_USERENABLEDMODULE"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "BASE_USERENABLEDMODULE_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "BASE_USERENABLEDMODULE_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger BASE_USERLASTLOGIN_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "BASE_USERLASTLOGIN_TR" 
  BEFORE INSERT ON "BASE_USERLASTLOGIN"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "BASE_USERLASTLOGIN_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "BASE_USERLASTLOGIN_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger BASE_USERSTARREDFILES_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "BASE_USERSTARREDFILES_TR" 
  BEFORE INSERT ON "BASE_USERSTARREDFILES"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "BASE_USERSTARREDFILES_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "BASE_USERSTARREDFILES_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger CAPTCHA_CAPTCHASTORE_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "CAPTCHA_CAPTCHASTORE_TR" 
  BEFORE INSERT ON "CAPTCHA_CAPTCHASTORE"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "CAPTCHA_CAPTCHASTORE_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "CAPTCHA_CAPTCHASTORE_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger CONSTANCE_CONFIG_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "CONSTANCE_CONFIG_TR" 
  BEFORE INSERT ON "CONSTANCE_CONFIG"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "CONSTANCE_CONFIG_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "CONSTANCE_CONFIG_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger CONTACTS_CONTACT_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "CONTACTS_CONTACT_TR" 
  BEFORE INSERT ON "CONTACTS_CONTACT"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "CONTACTS_CONTACT_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "CONTACTS_CONTACT_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger DJANGO_CONTENT_TYPE_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "DJANGO_CONTENT_TYPE_TR" 
  BEFORE INSERT ON "DJANGO_CONTENT_TYPE"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "DJANGO_CONTENT_TYPE_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "DJANGO_CONTENT_TYPE_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger DJANGO_MIGRATIONS_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "DJANGO_MIGRATIONS_TR" 
  BEFORE INSERT ON "DJANGO_MIGRATIONS"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "DJANGO_MIGRATIONS_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "DJANGO_MIGRATIONS_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger GROUP_GROUPMESSAGE_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "GROUP_GROUPMESSAGE_TR" 
  BEFORE INSERT ON "GROUP_GROUPMESSAGE"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "GROUP_GROUPMESSAGE_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "GROUP_GROUPMESSAGE_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger GROUP_MESSAGEATTACHMENT_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "GROUP_MESSAGEATTACHMENT_TR" 
  BEFORE INSERT ON "GROUP_MESSAGEATTACHMENT"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "GROUP_MESSAGEATTACHMENT_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "GROUP_MESSAGEATTACHMENT_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger GROUP_MESSAGEREPLY_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "GROUP_MESSAGEREPLY_TR" 
  BEFORE INSERT ON "GROUP_MESSAGEREPLY"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "GROUP_MESSAGEREPLY_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "GROUP_MESSAGEREPLY_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger GROUP_PUBLICGROUP_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "GROUP_PUBLICGROUP_TR" 
  BEFORE INSERT ON "GROUP_PUBLICGROUP"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "GROUP_PUBLICGROUP_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "GROUP_PUBLICGROUP_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger INSTITUTIONS_INSTITUTIO2836_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "INSTITUTIONS_INSTITUTIO2836_TR" 
  BEFORE INSERT ON "INSTITUTIONS_INSTITUTIONADMIN"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "INSTITUTIONS_INSTITUTIO2836_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "INSTITUTIONS_INSTITUTIO2836_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger INSTITUTIONS_INSTITUTION_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "INSTITUTIONS_INSTITUTION_TR" 
  BEFORE INSERT ON "INSTITUTIONS_INSTITUTION"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "INSTITUTIONS_INSTITUTION_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "INSTITUTIONS_INSTITUTION_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger INVITATIONS_INVITATION_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "INVITATIONS_INVITATION_TR" 
  BEFORE INSERT ON "INVITATIONS_INVITATION"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "INVITATIONS_INVITATION_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "INVITATIONS_INVITATION_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger MESSAGE_USERMESSAGE_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "MESSAGE_USERMESSAGE_TR" 
  BEFORE INSERT ON "MESSAGE_USERMESSAGE"
  FOR EACH ROW
   WHEN (new."MESSAGE_ID" IS NULL) BEGIN
          SELECT "MESSAGE_USERMESSAGE_SQ".nextval
          INTO :new."MESSAGE_ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "MESSAGE_USERMESSAGE_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger MESSAGE_USERMSGATTACHMENT_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "MESSAGE_USERMSGATTACHMENT_TR" 
  BEFORE INSERT ON "MESSAGE_USERMSGATTACHMENT"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "MESSAGE_USERMSGATTACHMENT_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "MESSAGE_USERMSGATTACHMENT_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger MESSAGE_USERMSGLASTCHECK_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "MESSAGE_USERMSGLASTCHECK_TR" 
  BEFORE INSERT ON "MESSAGE_USERMSGLASTCHECK"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "MESSAGE_USERMSGLASTCHECK_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "MESSAGE_USERMSGLASTCHECK_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger NOTIFICATIONS_NOTIFICATION_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "NOTIFICATIONS_NOTIFICATION_TR" 
  BEFORE INSERT ON "NOTIFICATIONS_NOTIFICATION"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "NOTIFICATIONS_NOTIFICATION_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "NOTIFICATIONS_NOTIFICATION_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger NOTIFICATIONS_USERNOTIF3BBF_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "NOTIFICATIONS_USERNOTIF3BBF_TR" 
  BEFORE INSERT ON "NOTIFICATIONS_USERNOTIFICATION"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "NOTIFICATIONS_USERNOTIF3BBF_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "NOTIFICATIONS_USERNOTIF3BBF_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger OPTIONS_USEROPTIONS_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "OPTIONS_USEROPTIONS_TR" 
  BEFORE INSERT ON "OPTIONS_USEROPTIONS"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "OPTIONS_USEROPTIONS_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "OPTIONS_USEROPTIONS_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger ORGANIZATIONS_ORGMEMBER6B70_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "ORGANIZATIONS_ORGMEMBER6B70_TR" 
  BEFORE INSERT ON "ORGANIZATIONS_ORGMEMBERQUOTA"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "ORGANIZATIONS_ORGMEMBER6B70_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "ORGANIZATIONS_ORGMEMBER6B70_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger POST_OFFICE_ATTACHMENT_D670_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "POST_OFFICE_ATTACHMENT_D670_TR" 
  BEFORE INSERT ON "POST_OFFICE_ATTACHMENT_EMAILS"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "POST_OFFICE_ATTACHMENT_D670_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "POST_OFFICE_ATTACHMENT_D670_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger POST_OFFICE_ATTACHMENT_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "POST_OFFICE_ATTACHMENT_TR" 
  BEFORE INSERT ON "POST_OFFICE_ATTACHMENT"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "POST_OFFICE_ATTACHMENT_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "POST_OFFICE_ATTACHMENT_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger POST_OFFICE_EMAILTEMPLATE_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "POST_OFFICE_EMAILTEMPLATE_TR" 
  BEFORE INSERT ON "POST_OFFICE_EMAILTEMPLATE"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "POST_OFFICE_EMAILTEMPLATE_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "POST_OFFICE_EMAILTEMPLATE_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger POST_OFFICE_EMAIL_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "POST_OFFICE_EMAIL_TR" 
  BEFORE INSERT ON "POST_OFFICE_EMAIL"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "POST_OFFICE_EMAIL_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "POST_OFFICE_EMAIL_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger POST_OFFICE_LOG_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "POST_OFFICE_LOG_TR" 
  BEFORE INSERT ON "POST_OFFICE_LOG"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "POST_OFFICE_LOG_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "POST_OFFICE_LOG_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger PROFILE_DETAILEDPROFILE_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "PROFILE_DETAILEDPROFILE_TR" 
  BEFORE INSERT ON "PROFILE_DETAILEDPROFILE"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "PROFILE_DETAILEDPROFILE_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "PROFILE_DETAILEDPROFILE_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger PROFILE_PROFILE_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "PROFILE_PROFILE_TR" 
  BEFORE INSERT ON "PROFILE_PROFILE"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "PROFILE_PROFILE_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "PROFILE_PROFILE_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger REGISTRATION_REGISTRATI2179_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "REGISTRATION_REGISTRATI2179_TR" 
  BEFORE INSERT ON "REGISTRATION_REGISTRATIONP238A"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "REGISTRATION_REGISTRATI2179_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "REGISTRATION_REGISTRATI2179_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger SHARE_ANONYMOUSSHARE_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "SHARE_ANONYMOUSSHARE_TR" 
  BEFORE INSERT ON "SHARE_ANONYMOUSSHARE"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "SHARE_ANONYMOUSSHARE_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "SHARE_ANONYMOUSSHARE_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger SHARE_FILESHARE_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "SHARE_FILESHARE_TR" 
  BEFORE INSERT ON "SHARE_FILESHARE"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "SHARE_FILESHARE_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "SHARE_FILESHARE_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger SHARE_ORGFILESHARE_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "SHARE_ORGFILESHARE_TR" 
  BEFORE INSERT ON "SHARE_ORGFILESHARE"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "SHARE_ORGFILESHARE_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "SHARE_ORGFILESHARE_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger SHARE_PRIVATEFILEDIRSHARE_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "SHARE_PRIVATEFILEDIRSHARE_TR" 
  BEFORE INSERT ON "SHARE_PRIVATEFILEDIRSHARE"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "SHARE_PRIVATEFILEDIRSHARE_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "SHARE_PRIVATEFILEDIRSHARE_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger SHARE_UPLOADLINKSHARE_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "SHARE_UPLOADLINKSHARE_TR" 
  BEFORE INSERT ON "SHARE_UPLOADLINKSHARE"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "SHARE_UPLOADLINKSHARE_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "SHARE_UPLOADLINKSHARE_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger SYSADMIN_EXTRA_USERLOGINLOG_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "SYSADMIN_EXTRA_USERLOGINLOG_TR" 
  BEFORE INSERT ON "SYSADMIN_EXTRA_USERLOGINLOG"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "SYSADMIN_EXTRA_USERLOGINLOG_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "SYSADMIN_EXTRA_USERLOGINLOG_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger TERMSANDCONDITIONS_TERM6123_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "TERMSANDCONDITIONS_TERM6123_TR" 
  BEFORE INSERT ON "TERMSANDCONDITIONS_TERMSAN0233"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "TERMSANDCONDITIONS_TERM6123_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "TERMSANDCONDITIONS_TERM6123_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger TERMSANDCONDITIONS_USERCF1A_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "TERMSANDCONDITIONS_USERCF1A_TR" 
  BEFORE INSERT ON "TERMSANDCONDITIONS_USERTERF56C"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "TERMSANDCONDITIONS_USERCF1A_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "TERMSANDCONDITIONS_USERCF1A_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger TWO_FACTOR_PHONEDEVICE_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "TWO_FACTOR_PHONEDEVICE_TR" 
  BEFORE INSERT ON "TWO_FACTOR_PHONEDEVICE"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "TWO_FACTOR_PHONEDEVICE_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "TWO_FACTOR_PHONEDEVICE_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger TWO_FACTOR_STATICDEVICE_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "TWO_FACTOR_STATICDEVICE_TR" 
  BEFORE INSERT ON "TWO_FACTOR_STATICDEVICE"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "TWO_FACTOR_STATICDEVICE_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "TWO_FACTOR_STATICDEVICE_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger TWO_FACTOR_STATICTOKEN_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "TWO_FACTOR_STATICTOKEN_TR" 
  BEFORE INSERT ON "TWO_FACTOR_STATICTOKEN"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "TWO_FACTOR_STATICTOKEN_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "TWO_FACTOR_STATICTOKEN_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger TWO_FACTOR_TOTPDEVICE_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "TWO_FACTOR_TOTPDEVICE_TR" 
  BEFORE INSERT ON "TWO_FACTOR_TOTPDEVICE"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "TWO_FACTOR_TOTPDEVICE_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "TWO_FACTOR_TOTPDEVICE_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger WIKI_GROUPWIKI_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "WIKI_GROUPWIKI_TR" 
  BEFORE INSERT ON "WIKI_GROUPWIKI"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "WIKI_GROUPWIKI_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "WIKI_GROUPWIKI_TR" ENABLE;
  --------------------------------------------------------
  --  DDL for Trigger WIKI_PERSONALWIKI_TR
  --------------------------------------------------------
  
    CREATE OR REPLACE TRIGGER "WIKI_PERSONALWIKI_TR" 
  BEFORE INSERT ON "WIKI_PERSONALWIKI"
  FOR EACH ROW
   WHEN (new."ID" IS NULL) BEGIN
          SELECT "WIKI_PERSONALWIKI_SQ".nextval
          INTO :new."ID" FROM dual;
      END;
  
  /
  ALTER TRIGGER "WIKI_PERSONALWIKI_TR" ENABLE;
  --------------------------------------------------------
  --  Constraints for Table INSTITUTIONS_INSTITUTION
  --------------------------------------------------------
  
    ALTER TABLE "INSTITUTIONS_INSTITUTION" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "INSTITUTIONS_INSTITUTION" MODIFY ("CREATE_TIME" NOT NULL ENABLE);
    ALTER TABLE "INSTITUTIONS_INSTITUTION" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table POST_OFFICE_LOG
  --------------------------------------------------------
  
    ALTER TABLE "POST_OFFICE_LOG" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "POST_OFFICE_LOG" ADD CHECK ("STATUS" >= 0) ENABLE;
    ALTER TABLE "POST_OFFICE_LOG" MODIFY ("EMAIL_ID" NOT NULL ENABLE);
    ALTER TABLE "POST_OFFICE_LOG" MODIFY ("STATUS" NOT NULL ENABLE);
    ALTER TABLE "POST_OFFICE_LOG" MODIFY ("DATE" NOT NULL ENABLE);
    ALTER TABLE "POST_OFFICE_LOG" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table TWO_FACTOR_TOTPDEVICE
  --------------------------------------------------------
  
    ALTER TABLE "TWO_FACTOR_TOTPDEVICE" ADD UNIQUE ("USER") ENABLE;
    ALTER TABLE "TWO_FACTOR_TOTPDEVICE" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "TWO_FACTOR_TOTPDEVICE" ADD CHECK ("TOLERANCE" >= 0) ENABLE;
    ALTER TABLE "TWO_FACTOR_TOTPDEVICE" ADD CHECK ("DIGITS" >= 0) ENABLE;
    ALTER TABLE "TWO_FACTOR_TOTPDEVICE" ADD CHECK ("STEP" >= 0) ENABLE;
    ALTER TABLE "TWO_FACTOR_TOTPDEVICE" ADD CHECK ("CONFIRMED" IN (0,1)) ENABLE;
    ALTER TABLE "TWO_FACTOR_TOTPDEVICE" MODIFY ("LAST_T" NOT NULL ENABLE);
    ALTER TABLE "TWO_FACTOR_TOTPDEVICE" MODIFY ("DRIFT" NOT NULL ENABLE);
    ALTER TABLE "TWO_FACTOR_TOTPDEVICE" MODIFY ("TOLERANCE" NOT NULL ENABLE);
    ALTER TABLE "TWO_FACTOR_TOTPDEVICE" MODIFY ("DIGITS" NOT NULL ENABLE);
    ALTER TABLE "TWO_FACTOR_TOTPDEVICE" MODIFY ("T0" NOT NULL ENABLE);
    ALTER TABLE "TWO_FACTOR_TOTPDEVICE" MODIFY ("STEP" NOT NULL ENABLE);
    ALTER TABLE "TWO_FACTOR_TOTPDEVICE" MODIFY ("CONFIRMED" NOT NULL ENABLE);
    ALTER TABLE "TWO_FACTOR_TOTPDEVICE" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table API2_TOKEN
  --------------------------------------------------------
  
    ALTER TABLE "API2_TOKEN" ADD UNIQUE ("USER") ENABLE;
    ALTER TABLE "API2_TOKEN" ADD PRIMARY KEY ("KEY") ENABLE;
    ALTER TABLE "API2_TOKEN" MODIFY ("CREATED" NOT NULL ENABLE);
    ALTER TABLE "API2_TOKEN" MODIFY ("KEY" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table OPTIONS_USEROPTIONS
  --------------------------------------------------------
  
    ALTER TABLE "OPTIONS_USEROPTIONS" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "OPTIONS_USEROPTIONS" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table AVATAR_AVATAR
  --------------------------------------------------------
  
    ALTER TABLE "AVATAR_AVATAR" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "AVATAR_AVATAR" ADD CHECK ("PRIMARY" IN (0,1)) ENABLE;
    ALTER TABLE "AVATAR_AVATAR" MODIFY ("DATE_UPLOADED" NOT NULL ENABLE);
    ALTER TABLE "AVATAR_AVATAR" MODIFY ("PRIMARY" NOT NULL ENABLE);
    ALTER TABLE "AVATAR_AVATAR" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table POST_OFFICE_ATTACHMENT_EMAILS
  --------------------------------------------------------
  
    ALTER TABLE "POST_OFFICE_ATTACHMENT_EMAILS" ADD UNIQUE ("ATTACHMENT_ID", "EMAIL_ID") ENABLE;
    ALTER TABLE "POST_OFFICE_ATTACHMENT_EMAILS" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "POST_OFFICE_ATTACHMENT_EMAILS" MODIFY ("EMAIL_ID" NOT NULL ENABLE);
    ALTER TABLE "POST_OFFICE_ATTACHMENT_EMAILS" MODIFY ("ATTACHMENT_ID" NOT NULL ENABLE);
    ALTER TABLE "POST_OFFICE_ATTACHMENT_EMAILS" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table TERMSANDCONDITIONS_USERTERF56C
  --------------------------------------------------------
  
    ALTER TABLE "TERMSANDCONDITIONS_USERTERF56C" ADD CONSTRAINT "FA265FB080B978BD0FE0BF3E4B445B" UNIQUE ("USERNAME", "TERMS_ID") ENABLE;
    ALTER TABLE "TERMSANDCONDITIONS_USERTERF56C" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "TERMSANDCONDITIONS_USERTERF56C" MODIFY ("TERMS_ID" NOT NULL ENABLE);
    ALTER TABLE "TERMSANDCONDITIONS_USERTERF56C" MODIFY ("DATE_ACCEPTED" NOT NULL ENABLE);
    ALTER TABLE "TERMSANDCONDITIONS_USERTERF56C" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table BASE_FILECOMMENT
  --------------------------------------------------------
  
    ALTER TABLE "BASE_FILECOMMENT" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "BASE_FILECOMMENT" MODIFY ("UPDATED_AT" NOT NULL ENABLE);
    ALTER TABLE "BASE_FILECOMMENT" MODIFY ("CREATED_AT" NOT NULL ENABLE);
    ALTER TABLE "BASE_FILECOMMENT" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table MESSAGE_USERMSGLASTCHECK
  --------------------------------------------------------
  
    ALTER TABLE "MESSAGE_USERMSGLASTCHECK" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "MESSAGE_USERMSGLASTCHECK" MODIFY ("CHECK_TIME" NOT NULL ENABLE);
    ALTER TABLE "MESSAGE_USERMSGLASTCHECK" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table BASE_USERSTARREDFILES
  --------------------------------------------------------
  
    ALTER TABLE "BASE_USERSTARREDFILES" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "BASE_USERSTARREDFILES" ADD CHECK ("IS_DIR" IN (0,1)) ENABLE;
    ALTER TABLE "BASE_USERSTARREDFILES" MODIFY ("IS_DIR" NOT NULL ENABLE);
    ALTER TABLE "BASE_USERSTARREDFILES" MODIFY ("ORG_ID" NOT NULL ENABLE);
    ALTER TABLE "BASE_USERSTARREDFILES" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table CAPTCHA_CAPTCHASTORE
  --------------------------------------------------------
  
    ALTER TABLE "CAPTCHA_CAPTCHASTORE" ADD UNIQUE ("HASHKEY") ENABLE;
    ALTER TABLE "CAPTCHA_CAPTCHASTORE" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "CAPTCHA_CAPTCHASTORE" MODIFY ("EXPIRATION" NOT NULL ENABLE);
    ALTER TABLE "CAPTCHA_CAPTCHASTORE" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table TWO_FACTOR_STATICTOKEN
  --------------------------------------------------------
  
    ALTER TABLE "TWO_FACTOR_STATICTOKEN" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "TWO_FACTOR_STATICTOKEN" MODIFY ("DEVICE_ID" NOT NULL ENABLE);
    ALTER TABLE "TWO_FACTOR_STATICTOKEN" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table SHARE_ORGFILESHARE
  --------------------------------------------------------
  
    ALTER TABLE "SHARE_ORGFILESHARE" ADD UNIQUE ("FILE_SHARE_ID") ENABLE;
    ALTER TABLE "SHARE_ORGFILESHARE" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "SHARE_ORGFILESHARE" MODIFY ("FILE_SHARE_ID" NOT NULL ENABLE);
    ALTER TABLE "SHARE_ORGFILESHARE" MODIFY ("ORG_ID" NOT NULL ENABLE);
    ALTER TABLE "SHARE_ORGFILESHARE" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table GROUP_MESSAGEATTACHMENT
  --------------------------------------------------------
  
    ALTER TABLE "GROUP_MESSAGEATTACHMENT" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "GROUP_MESSAGEATTACHMENT" MODIFY ("GROUP_MESSAGE_ID" NOT NULL ENABLE);
    ALTER TABLE "GROUP_MESSAGEATTACHMENT" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table SHARE_FILESHARE
  --------------------------------------------------------
  
    ALTER TABLE "SHARE_FILESHARE" ADD UNIQUE ("TOKEN") ENABLE;
    ALTER TABLE "SHARE_FILESHARE" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "SHARE_FILESHARE" MODIFY ("VIEW_CNT" NOT NULL ENABLE);
    ALTER TABLE "SHARE_FILESHARE" MODIFY ("CTIME" NOT NULL ENABLE);
    ALTER TABLE "SHARE_FILESHARE" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table WIKI_GROUPWIKI
  --------------------------------------------------------
  
    ALTER TABLE "WIKI_GROUPWIKI" ADD UNIQUE ("GROUP_ID") ENABLE;
    ALTER TABLE "WIKI_GROUPWIKI" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "WIKI_GROUPWIKI" MODIFY ("GROUP_ID" NOT NULL ENABLE);
    ALTER TABLE "WIKI_GROUPWIKI" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table POST_OFFICE_EMAIL
  --------------------------------------------------------
  
    ALTER TABLE "POST_OFFICE_EMAIL" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "POST_OFFICE_EMAIL" ADD CHECK ("PRIORITY" >= 0) ENABLE;
    ALTER TABLE "POST_OFFICE_EMAIL" ADD CHECK ("STATUS" >= 0) ENABLE;
    ALTER TABLE "POST_OFFICE_EMAIL" MODIFY ("LAST_UPDATED" NOT NULL ENABLE);
    ALTER TABLE "POST_OFFICE_EMAIL" MODIFY ("CREATED" NOT NULL ENABLE);
    ALTER TABLE "POST_OFFICE_EMAIL" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table GROUP_MESSAGEREPLY
  --------------------------------------------------------
  
    ALTER TABLE "GROUP_MESSAGEREPLY" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "GROUP_MESSAGEREPLY" MODIFY ("TIMESTAMP" NOT NULL ENABLE);
    ALTER TABLE "GROUP_MESSAGEREPLY" MODIFY ("REPLY_TO_ID" NOT NULL ENABLE);
    ALTER TABLE "GROUP_MESSAGEREPLY" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table CONSTANCE_CONFIG
  --------------------------------------------------------
  
    ALTER TABLE "CONSTANCE_CONFIG" ADD UNIQUE ("KEY") ENABLE;
    ALTER TABLE "CONSTANCE_CONFIG" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "CONSTANCE_CONFIG" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table SHARE_UPLOADLINKSHARE
  --------------------------------------------------------
  
    ALTER TABLE "SHARE_UPLOADLINKSHARE" ADD UNIQUE ("TOKEN") ENABLE;
    ALTER TABLE "SHARE_UPLOADLINKSHARE" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "SHARE_UPLOADLINKSHARE" MODIFY ("VIEW_CNT" NOT NULL ENABLE);
    ALTER TABLE "SHARE_UPLOADLINKSHARE" MODIFY ("CTIME" NOT NULL ENABLE);
    ALTER TABLE "SHARE_UPLOADLINKSHARE" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table PROFILE_DETAILEDPROFILE
  --------------------------------------------------------
  
    ALTER TABLE "PROFILE_DETAILEDPROFILE" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "PROFILE_DETAILEDPROFILE" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table NOTIFICATIONS_NOTIFICATION
  --------------------------------------------------------
  
    ALTER TABLE "NOTIFICATIONS_NOTIFICATION" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "NOTIFICATIONS_NOTIFICATION" ADD CHECK ("PRIMARY" IN (0,1)) ENABLE;
    ALTER TABLE "NOTIFICATIONS_NOTIFICATION" MODIFY ("PRIMARY" NOT NULL ENABLE);
    ALTER TABLE "NOTIFICATIONS_NOTIFICATION" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table DJANGO_CONTENT_TYPE
  --------------------------------------------------------
  
    ALTER TABLE "DJANGO_CONTENT_TYPE" ADD CONSTRAINT "D85D5DBB541FAB8F1DF26BA8B130BE" UNIQUE ("APP_LABEL", "MODEL") ENABLE;
    ALTER TABLE "DJANGO_CONTENT_TYPE" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "DJANGO_CONTENT_TYPE" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table ORGANIZATIONS_ORGMEMBERQUOTA
  --------------------------------------------------------
  
    ALTER TABLE "ORGANIZATIONS_ORGMEMBERQUOTA" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "ORGANIZATIONS_ORGMEMBERQUOTA" MODIFY ("QUOTA" NOT NULL ENABLE);
    ALTER TABLE "ORGANIZATIONS_ORGMEMBERQUOTA" MODIFY ("ORG_ID" NOT NULL ENABLE);
    ALTER TABLE "ORGANIZATIONS_ORGMEMBERQUOTA" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table WIKI_PERSONALWIKI
  --------------------------------------------------------
  
    ALTER TABLE "WIKI_PERSONALWIKI" ADD UNIQUE ("USERNAME") ENABLE;
    ALTER TABLE "WIKI_PERSONALWIKI" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "WIKI_PERSONALWIKI" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table BASE_USERENABLEDMODULE
  --------------------------------------------------------
  
    ALTER TABLE "BASE_USERENABLEDMODULE" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "BASE_USERENABLEDMODULE" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table BASE_INNERPUBMSG
  --------------------------------------------------------
  
    ALTER TABLE "BASE_INNERPUBMSG" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "BASE_INNERPUBMSG" MODIFY ("TIMESTAMP" NOT NULL ENABLE);
    ALTER TABLE "BASE_INNERPUBMSG" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table INSTITUTIONS_INSTITUTIONADMIN
  --------------------------------------------------------
  
    ALTER TABLE "INSTITUTIONS_INSTITUTIONADMIN" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "INSTITUTIONS_INSTITUTIONADMIN" MODIFY ("INSTITUTION_ID" NOT NULL ENABLE);
    ALTER TABLE "INSTITUTIONS_INSTITUTIONADMIN" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table AVATAR_GROUPAVATAR
  --------------------------------------------------------
  
    ALTER TABLE "AVATAR_GROUPAVATAR" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "AVATAR_GROUPAVATAR" MODIFY ("DATE_UPLOADED" NOT NULL ENABLE);
    ALTER TABLE "AVATAR_GROUPAVATAR" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table REGISTRATION_REGISTRATIONP238A
  --------------------------------------------------------
  
    ALTER TABLE "REGISTRATION_REGISTRATIONP238A" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "REGISTRATION_REGISTRATIONP238A" MODIFY ("EMAILUSER_ID" NOT NULL ENABLE);
    ALTER TABLE "REGISTRATION_REGISTRATIONP238A" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table TERMSANDCONDITIONS_TERMSAN0233
  --------------------------------------------------------
  
    ALTER TABLE "TERMSANDCONDITIONS_TERMSAN0233" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "TERMSANDCONDITIONS_TERMSAN0233" MODIFY ("DATE_CREATED" NOT NULL ENABLE);
    ALTER TABLE "TERMSANDCONDITIONS_TERMSAN0233" MODIFY ("VERSION_NUMBER" NOT NULL ENABLE);
    ALTER TABLE "TERMSANDCONDITIONS_TERMSAN0233" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table BASE_FILEDISCUSS
  --------------------------------------------------------
  
    ALTER TABLE "BASE_FILEDISCUSS" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "BASE_FILEDISCUSS" MODIFY ("GROUP_MESSAGE_ID" NOT NULL ENABLE);
    ALTER TABLE "BASE_FILEDISCUSS" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table GROUP_PUBLICGROUP
  --------------------------------------------------------
  
    ALTER TABLE "GROUP_PUBLICGROUP" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "GROUP_PUBLICGROUP" MODIFY ("GROUP_ID" NOT NULL ENABLE);
    ALTER TABLE "GROUP_PUBLICGROUP" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table BASE_CLIENTLOGINTOKEN
  --------------------------------------------------------
  
    ALTER TABLE "BASE_CLIENTLOGINTOKEN" ADD PRIMARY KEY ("TOKEN") ENABLE;
    ALTER TABLE "BASE_CLIENTLOGINTOKEN" MODIFY ("TIMESTAMP" NOT NULL ENABLE);
    ALTER TABLE "BASE_CLIENTLOGINTOKEN" MODIFY ("TOKEN" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table DJANGO_SESSION
  --------------------------------------------------------
  
    ALTER TABLE "DJANGO_SESSION" ADD PRIMARY KEY ("SESSION_KEY") ENABLE;
    ALTER TABLE "DJANGO_SESSION" MODIFY ("EXPIRE_DATE" NOT NULL ENABLE);
    ALTER TABLE "DJANGO_SESSION" MODIFY ("SESSION_KEY" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table NOTIFICATIONS_USERNOTIFICATION
  --------------------------------------------------------
  
    ALTER TABLE "NOTIFICATIONS_USERNOTIFICATION" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "NOTIFICATIONS_USERNOTIFICATION" ADD CHECK ("SEEN" IN (0,1)) ENABLE;
    ALTER TABLE "NOTIFICATIONS_USERNOTIFICATION" MODIFY ("SEEN" NOT NULL ENABLE);
    ALTER TABLE "NOTIFICATIONS_USERNOTIFICATION" MODIFY ("TIMESTAMP" NOT NULL ENABLE);
    ALTER TABLE "NOTIFICATIONS_USERNOTIFICATION" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table BASE_GROUPENABLEDMODULE
  --------------------------------------------------------
  
    ALTER TABLE "BASE_GROUPENABLEDMODULE" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "BASE_GROUPENABLEDMODULE" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table BASE_DEVICETOKEN
  --------------------------------------------------------
  
    ALTER TABLE "BASE_DEVICETOKEN" ADD UNIQUE ("TOKEN", "USER") ENABLE;
    ALTER TABLE "BASE_DEVICETOKEN" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "BASE_DEVICETOKEN" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table TWO_FACTOR_STATICDEVICE
  --------------------------------------------------------
  
    ALTER TABLE "TWO_FACTOR_STATICDEVICE" ADD UNIQUE ("USER") ENABLE;
    ALTER TABLE "TWO_FACTOR_STATICDEVICE" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "TWO_FACTOR_STATICDEVICE" ADD CHECK ("CONFIRMED" IN (0,1)) ENABLE;
    ALTER TABLE "TWO_FACTOR_STATICDEVICE" MODIFY ("CONFIRMED" NOT NULL ENABLE);
    ALTER TABLE "TWO_FACTOR_STATICDEVICE" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table GROUP_GROUPMESSAGE
  --------------------------------------------------------
  
    ALTER TABLE "GROUP_GROUPMESSAGE" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "GROUP_GROUPMESSAGE" MODIFY ("TIMESTAMP" NOT NULL ENABLE);
    ALTER TABLE "GROUP_GROUPMESSAGE" MODIFY ("GROUP_ID" NOT NULL ENABLE);
    ALTER TABLE "GROUP_GROUPMESSAGE" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table TWO_FACTOR_PHONEDEVICE
  --------------------------------------------------------
  
    ALTER TABLE "TWO_FACTOR_PHONEDEVICE" ADD UNIQUE ("USER") ENABLE;
    ALTER TABLE "TWO_FACTOR_PHONEDEVICE" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "TWO_FACTOR_PHONEDEVICE" ADD CHECK ("CONFIRMED" IN (0,1)) ENABLE;
    ALTER TABLE "TWO_FACTOR_PHONEDEVICE" MODIFY ("CONFIRMED" NOT NULL ENABLE);
    ALTER TABLE "TWO_FACTOR_PHONEDEVICE" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table POST_OFFICE_ATTACHMENT
  --------------------------------------------------------
  
    ALTER TABLE "POST_OFFICE_ATTACHMENT" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "POST_OFFICE_ATTACHMENT" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table POST_OFFICE_EMAILTEMPLATE
  --------------------------------------------------------
  
    ALTER TABLE "POST_OFFICE_EMAILTEMPLATE" ADD CONSTRAINT "FF9556696FEEA12226069FE6564DB9" UNIQUE ("LANGUAGE", "DEFAULT_TEMPLATE_ID") ENABLE;
    ALTER TABLE "POST_OFFICE_EMAILTEMPLATE" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "POST_OFFICE_EMAILTEMPLATE" MODIFY ("LAST_UPDATED" NOT NULL ENABLE);
    ALTER TABLE "POST_OFFICE_EMAILTEMPLATE" MODIFY ("CREATED" NOT NULL ENABLE);
    ALTER TABLE "POST_OFFICE_EMAILTEMPLATE" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table MESSAGE_USERMESSAGE
  --------------------------------------------------------
  
    ALTER TABLE "MESSAGE_USERMESSAGE" ADD PRIMARY KEY ("MESSAGE_ID") ENABLE;
    ALTER TABLE "MESSAGE_USERMESSAGE" ADD CHECK ("IFREAD" IN (0,1)) ENABLE;
    ALTER TABLE "MESSAGE_USERMESSAGE" MODIFY ("IFREAD" NOT NULL ENABLE);
    ALTER TABLE "MESSAGE_USERMESSAGE" MODIFY ("TIMESTAMP" NOT NULL ENABLE);
    ALTER TABLE "MESSAGE_USERMESSAGE" MODIFY ("MESSAGE_ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table BASE_COMMANDSLASTCHECK
  --------------------------------------------------------
  
    ALTER TABLE "BASE_COMMANDSLASTCHECK" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "BASE_COMMANDSLASTCHECK" MODIFY ("LAST_CHECK" NOT NULL ENABLE);
    ALTER TABLE "BASE_COMMANDSLASTCHECK" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table CONTACTS_CONTACT
  --------------------------------------------------------
  
    ALTER TABLE "CONTACTS_CONTACT" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "CONTACTS_CONTACT" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table DJANGO_MIGRATIONS
  --------------------------------------------------------
  
    ALTER TABLE "DJANGO_MIGRATIONS" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "DJANGO_MIGRATIONS" MODIFY ("APPLIED" NOT NULL ENABLE);
    ALTER TABLE "DJANGO_MIGRATIONS" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table INVITATIONS_INVITATION
  --------------------------------------------------------
  
    ALTER TABLE "INVITATIONS_INVITATION" MODIFY ("EXPIRE_TIME" NOT NULL ENABLE);
    ALTER TABLE "INVITATIONS_INVITATION" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "INVITATIONS_INVITATION" MODIFY ("INVITE_TIME" NOT NULL ENABLE);
    ALTER TABLE "INVITATIONS_INVITATION" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table BASE_USERLASTLOGIN
  --------------------------------------------------------
  
    ALTER TABLE "BASE_USERLASTLOGIN" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "BASE_USERLASTLOGIN" MODIFY ("LAST_LOGIN" NOT NULL ENABLE);
    ALTER TABLE "BASE_USERLASTLOGIN" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table SHARE_PRIVATEFILEDIRSHARE
  --------------------------------------------------------
  
    ALTER TABLE "SHARE_PRIVATEFILEDIRSHARE" ADD UNIQUE ("TOKEN") ENABLE;
    ALTER TABLE "SHARE_PRIVATEFILEDIRSHARE" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "SHARE_PRIVATEFILEDIRSHARE" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table SYSADMIN_EXTRA_USERLOGINLOG
  --------------------------------------------------------
  
    ALTER TABLE "SYSADMIN_EXTRA_USERLOGINLOG" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "SYSADMIN_EXTRA_USERLOGINLOG" MODIFY ("LOGIN_DATE" NOT NULL ENABLE);
    ALTER TABLE "SYSADMIN_EXTRA_USERLOGINLOG" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table SHARE_ANONYMOUSSHARE
  --------------------------------------------------------
  
    ALTER TABLE "SHARE_ANONYMOUSSHARE" ADD UNIQUE ("TOKEN") ENABLE;
    ALTER TABLE "SHARE_ANONYMOUSSHARE" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "SHARE_ANONYMOUSSHARE" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table MESSAGE_USERMSGATTACHMENT
  --------------------------------------------------------
  
    ALTER TABLE "MESSAGE_USERMSGATTACHMENT" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "MESSAGE_USERMSGATTACHMENT" MODIFY ("USER_MSG_ID" NOT NULL ENABLE);
    ALTER TABLE "MESSAGE_USERMSGATTACHMENT" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table BASE_INNERPUBMSGREPLY
  --------------------------------------------------------
  
    ALTER TABLE "BASE_INNERPUBMSGREPLY" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "BASE_INNERPUBMSGREPLY" MODIFY ("TIMESTAMP" NOT NULL ENABLE);
    ALTER TABLE "BASE_INNERPUBMSGREPLY" MODIFY ("REPLY_TO_ID" NOT NULL ENABLE);
    ALTER TABLE "BASE_INNERPUBMSGREPLY" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table PROFILE_PROFILE
  --------------------------------------------------------
  
    ALTER TABLE "PROFILE_PROFILE" ADD UNIQUE ("LOGIN_ID") ENABLE;
    ALTER TABLE "PROFILE_PROFILE" ADD UNIQUE ("USER") ENABLE;
    ALTER TABLE "PROFILE_PROFILE" ADD PRIMARY KEY ("ID") ENABLE;
    ALTER TABLE "PROFILE_PROFILE" MODIFY ("ID" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Constraints for Table API2_TOKENV2
  --------------------------------------------------------
  
    ALTER TABLE "API2_TOKENV2" ADD UNIQUE ("USER", "PLATFORM", "DEVICE_ID") ENABLE;
    ALTER TABLE "API2_TOKENV2" ADD PRIMARY KEY ("KEY") ENABLE;
    ALTER TABLE "API2_TOKENV2" MODIFY ("CREATED_AT" NOT NULL ENABLE);
    ALTER TABLE "API2_TOKENV2" MODIFY ("LAST_ACCESSED" NOT NULL ENABLE);
    ALTER TABLE "API2_TOKENV2" MODIFY ("KEY" NOT NULL ENABLE);
  --------------------------------------------------------
  --  Ref Constraints for Table BASE_FILEDISCUSS
  --------------------------------------------------------
  
    ALTER TABLE "BASE_FILEDISCUSS" ADD CONSTRAINT "D362E9BF714D64DD429DF16FAB60CB" FOREIGN KEY ("GROUP_MESSAGE_ID")
  	  REFERENCES "GROUP_GROUPMESSAGE" ("ID") DEFERRABLE INITIALLY DEFERRED ENABLE;
  --------------------------------------------------------
  --  Ref Constraints for Table BASE_INNERPUBMSGREPLY
  --------------------------------------------------------
  
    ALTER TABLE "BASE_INNERPUBMSGREPLY" ADD CONSTRAINT "D6FA27AB5E9198C8D9323B6EB8493E" FOREIGN KEY ("REPLY_TO_ID")
  	  REFERENCES "BASE_INNERPUBMSG" ("ID") DEFERRABLE INITIALLY DEFERRED ENABLE;
  --------------------------------------------------------
  --  Ref Constraints for Table GROUP_MESSAGEATTACHMENT
  --------------------------------------------------------
  
    ALTER TABLE "GROUP_MESSAGEATTACHMENT" ADD CONSTRAINT "D36A3F4E152A1CF41CD8EC91E6577B" FOREIGN KEY ("GROUP_MESSAGE_ID")
  	  REFERENCES "GROUP_GROUPMESSAGE" ("ID") DEFERRABLE INITIALLY DEFERRED ENABLE;
  --------------------------------------------------------
  --  Ref Constraints for Table GROUP_MESSAGEREPLY
  --------------------------------------------------------
  
    ALTER TABLE "GROUP_MESSAGEREPLY" ADD CONSTRAINT "CBC9C076EAE2B5F98C3961684556C2" FOREIGN KEY ("REPLY_TO_ID")
  	  REFERENCES "GROUP_GROUPMESSAGE" ("ID") DEFERRABLE INITIALLY DEFERRED ENABLE;
  --------------------------------------------------------
  --  Ref Constraints for Table INSTITUTIONS_INSTITUTIONADMIN
  --------------------------------------------------------
  
    ALTER TABLE "INSTITUTIONS_INSTITUTIONADMIN" ADD CONSTRAINT "D30B7110A400F3BC4A87B3F55C4224" FOREIGN KEY ("INSTITUTION_ID")
  	  REFERENCES "INSTITUTIONS_INSTITUTION" ("ID") DEFERRABLE INITIALLY DEFERRED ENABLE;
  --------------------------------------------------------
  --  Ref Constraints for Table MESSAGE_USERMSGATTACHMENT
  --------------------------------------------------------
  
    ALTER TABLE "MESSAGE_USERMSGATTACHMENT" ADD CONSTRAINT "D264DEBB373EBBE8EA66D911FB06D5" FOREIGN KEY ("USER_MSG_ID")
  	  REFERENCES "MESSAGE_USERMESSAGE" ("MESSAGE_ID") DEFERRABLE INITIALLY DEFERRED ENABLE;
    ALTER TABLE "MESSAGE_USERMSGATTACHMENT" ADD CONSTRAINT "D7660A1DD0C70FC07F97FD114B48D4" FOREIGN KEY ("PRIV_FILE_DIR_SHARE_ID")
  	  REFERENCES "SHARE_PRIVATEFILEDIRSHARE" ("ID") DEFERRABLE INITIALLY DEFERRED ENABLE;
  --------------------------------------------------------
  --  Ref Constraints for Table POST_OFFICE_ATTACHMENT_EMAILS
  --------------------------------------------------------
  
    ALTER TABLE "POST_OFFICE_ATTACHMENT_EMAILS" ADD CONSTRAINT "BDE40FCCED42FB8741DF331449A015" FOREIGN KEY ("EMAIL_ID")
  	  REFERENCES "POST_OFFICE_EMAIL" ("ID") DEFERRABLE INITIALLY DEFERRED ENABLE;
    ALTER TABLE "POST_OFFICE_ATTACHMENT_EMAILS" ADD CONSTRAINT "D3937EF63F9E2AFED0117BD2B2B64B" FOREIGN KEY ("ATTACHMENT_ID")
  	  REFERENCES "POST_OFFICE_ATTACHMENT" ("ID") DEFERRABLE INITIALLY DEFERRED ENABLE;
  --------------------------------------------------------
  --  Ref Constraints for Table POST_OFFICE_EMAIL
  --------------------------------------------------------
  
    ALTER TABLE "POST_OFFICE_EMAIL" ADD CONSTRAINT "D1ACABD4A4C9D137C464A3757D5C0D" FOREIGN KEY ("TEMPLATE_ID")
  	  REFERENCES "POST_OFFICE_EMAILTEMPLATE" ("ID") DEFERRABLE INITIALLY DEFERRED ENABLE;
  --------------------------------------------------------
  --  Ref Constraints for Table POST_OFFICE_EMAILTEMPLATE
  --------------------------------------------------------
  
    ALTER TABLE "POST_OFFICE_EMAILTEMPLATE" ADD CONSTRAINT "A89EFC0CAC9BCF61E78054A3CF6C99" FOREIGN KEY ("DEFAULT_TEMPLATE_ID")
  	  REFERENCES "POST_OFFICE_EMAILTEMPLATE" ("ID") DEFERRABLE INITIALLY DEFERRED ENABLE;
  --------------------------------------------------------
  --  Ref Constraints for Table POST_OFFICE_LOG
  --------------------------------------------------------
  
    ALTER TABLE "POST_OFFICE_LOG" ADD CONSTRAINT "D8ECEA069FFDCFAB2262016E237771" FOREIGN KEY ("EMAIL_ID")
  	  REFERENCES "POST_OFFICE_EMAIL" ("ID") DEFERRABLE INITIALLY DEFERRED ENABLE;
  --------------------------------------------------------
  --  Ref Constraints for Table SHARE_ORGFILESHARE
  --------------------------------------------------------
  
    ALTER TABLE "SHARE_ORGFILESHARE" ADD CONSTRAINT "D6FEC6D55701908211F0BB25A7B212" FOREIGN KEY ("FILE_SHARE_ID")
  	  REFERENCES "SHARE_FILESHARE" ("ID") DEFERRABLE INITIALLY DEFERRED ENABLE;
  --------------------------------------------------------
  --  Ref Constraints for Table TERMSANDCONDITIONS_USERTERF56C
  --------------------------------------------------------
  
    ALTER TABLE "TERMSANDCONDITIONS_USERTERF56C" ADD CONSTRAINT "D2272A698BFB055DBD76C7326B360B" FOREIGN KEY ("TERMS_ID")
  	  REFERENCES "TERMSANDCONDITIONS_TERMSAN0233" ("ID") DEFERRABLE INITIALLY DEFERRED ENABLE;
  --------------------------------------------------------
  --  Ref Constraints for Table TWO_FACTOR_STATICTOKEN
  --------------------------------------------------------
  
    ALTER TABLE "TWO_FACTOR_STATICTOKEN" ADD CONSTRAINT "D972B9A8ABECC9BD2550E36848B483" FOREIGN KEY ("DEVICE_ID")
  	  REFERENCES "TWO_FACTOR_STATICDEVICE" ("ID") DEFERRABLE INITIALLY DEFERRED ENABLE;
  