Page MenuHomeDevCentral
Paste P350

dump.sql of vimbadmin
ActivePublic

Authored by DorianWinty on Jun 2 2024, 12:25.
Tags
Referenced Files
F3033683: dump.sql
Jun 2 2024, 12:25
Subscribers
Deprecated: Using ${var} in strings is deprecated, use {$var} instead in /var/wwwroot/default/vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/PostgreSqlPlatform.php on line 874
Deprecated: Doctrine\ORM\Id\SequenceGenerator implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in /var/wwwroot/default/vendor/doctrine/orm/lib/Doctrine/ORM/Id/SequenceGenerator.php on line 32
The following SQL statements will be executed:
CREATE TABLE admin (id BIGINT NOT NULL, username VARCHAR(255) DEFAULT NULL, password VARCHAR(255) NOT NULL, super BOOLEAN DEFAULT 'false' NOT NULL, active BOOLEAN DEFAULT 'true' NOT NULL, created TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, modified TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id));
CREATE UNIQUE INDEX IX_Username_1 ON admin (username);
CREATE TABLE domain_admins (Admin_id BIGINT NOT NULL, Domain_id BIGINT NOT NULL, PRIMARY KEY(Admin_id, Domain_id));
CREATE INDEX IDX_CD8319C69D5DE046 ON domain_admins (Admin_id);
CREATE INDEX IDX_CD8319C693AE8C46 ON domain_admins (Domain_id);
CREATE TABLE admin_pref (id BIGINT NOT NULL, attribute VARCHAR(255) NOT NULL, ix INT DEFAULT 0 NOT NULL, op VARCHAR(2) DEFAULT ':=' NOT NULL, value TEXT NOT NULL, expire BIGINT DEFAULT 0 NOT NULL, Admin_id BIGINT DEFAULT NULL, PRIMARY KEY(id));
CREATE INDEX IDX_814C1AD19D5DE046 ON admin_pref (Admin_id);
CREATE UNIQUE INDEX IX_AdminPreference_1 ON admin_pref (Admin_id, attribute, ix);
CREATE TABLE alias (id BIGINT NOT NULL, address VARCHAR(255) NOT NULL, goto TEXT NOT NULL, active BOOLEAN DEFAULT 'true' NOT NULL, created TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, modified TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, Domain_id BIGINT DEFAULT NULL, PRIMARY KEY(id));
CREATE INDEX IDX_E16C6B9493AE8C46 ON alias (Domain_id);
CREATE UNIQUE INDEX IX_Address_1 ON alias (address);
CREATE TABLE alias_pref (id BIGINT NOT NULL, attribute VARCHAR(255) NOT NULL, ix INT DEFAULT 0 NOT NULL, op VARCHAR(2) DEFAULT ':=' NOT NULL, value TEXT NOT NULL, expire BIGINT DEFAULT 0 NOT NULL, Alias_id BIGINT DEFAULT NULL, PRIMARY KEY(id));
CREATE INDEX IDX_3279E911A72028B4 ON alias_pref (Alias_id);
CREATE INDEX IX_AliasPreference_1 ON alias_pref (Alias_id, attribute, ix);
CREATE TABLE archive (id BIGINT NOT NULL, username VARCHAR(255) NOT NULL, status VARCHAR(255) NOT NULL, archived_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, status_changed_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, homedir_server VARCHAR(255) DEFAULT NULL, homedir_file VARCHAR(255) DEFAULT NULL, homedir_orig_size BIGINT DEFAULT NULL, homedir_size BIGINT DEFAULT NULL, maildir_server VARCHAR(255) DEFAULT NULL, maildir_file VARCHAR(255) DEFAULT NULL, maildir_orig_size BIGINT DEFAULT NULL, maildir_size BIGINT DEFAULT NULL, data TEXT NOT NULL, Domain_id BIGINT DEFAULT NULL, Admin_id BIGINT DEFAULT NULL, PRIMARY KEY(id));
CREATE UNIQUE INDEX UNIQ_D5FC5D9CF85E0677 ON archive (username);
CREATE INDEX IDX_D5FC5D9C93AE8C46 ON archive (Domain_id);
CREATE INDEX IDX_D5FC5D9C9D5DE046 ON archive (Admin_id);
CREATE TABLE dbversion (id INT NOT NULL, version INT NOT NULL, name VARCHAR(255) NOT NULL, applied_on TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PRIMARY KEY(id));
CREATE TABLE directory_entry (id BIGINT NOT NULL, mailbox_id BIGINT NOT NULL, businessCategory VARCHAR(255) DEFAULT NULL, carLicense VARCHAR(255) DEFAULT NULL, departmentNumber VARCHAR(255) DEFAULT NULL, displayName VARCHAR(255) DEFAULT NULL, employeeNumber VARCHAR(255) DEFAULT NULL, employeeType VARCHAR(255) DEFAULT NULL, homePhone VARCHAR(255) DEFAULT NULL, homePostalAddress TEXT DEFAULT NULL, initials VARCHAR(10) DEFAULT NULL, jpegPhoto TEXT DEFAULT NULL, labeledURI TEXT DEFAULT NULL, mail VARCHAR(255) DEFAULT NULL, manager VARCHAR(255) DEFAULT NULL, mobile VARCHAR(255) DEFAULT NULL, o VARCHAR(255) DEFAULT NULL, pager VARCHAR(255) DEFAULT NULL, preferredLanguage VARCHAR(255) DEFAULT NULL, roomNumber VARCHAR(255) DEFAULT NULL, secretary VARCHAR(255) DEFAULT NULL, personalTitle VARCHAR(255) DEFAULT NULL, sn VARCHAR(255) DEFAULT NULL, ou VARCHAR(255) DEFAULT NULL, title VARCHAR(255) DEFAULT NULL, facsimileTelephoneNumber VARCHAR(255) DEFAULT NULL, givenName VARCHAR(255) DEFAULT NULL, telephoneNumber VARCHAR(255) DEFAULT NULL, vimb_created TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, vimb_update TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PRIMARY KEY(id));
CREATE UNIQUE INDEX UNIQ_6553C92D66EC35CC ON directory_entry (mailbox_id);
COMMENT ON COLUMN directory_entry.jpegPhoto IS '(DC2Type:object)';
CREATE TABLE domain (id BIGINT NOT NULL, domain VARCHAR(255) NOT NULL, description VARCHAR(255) DEFAULT NULL, max_aliases INT DEFAULT 0 NOT NULL, alias_count BIGINT DEFAULT 0 NOT NULL, max_mailboxes INT DEFAULT 0 NOT NULL, mailbox_count BIGINT DEFAULT 0 NOT NULL, max_quota BIGINT DEFAULT 0 NOT NULL, quota BIGINT DEFAULT 0 NOT NULL, transport VARCHAR(255) DEFAULT 'virtual' NOT NULL, backupmx BOOLEAN DEFAULT 'false' NOT NULL, active BOOLEAN DEFAULT 'true' NOT NULL, homedir VARCHAR(255) DEFAULT NULL, maildir VARCHAR(255) DEFAULT NULL, uid INT DEFAULT NULL, gid INT DEFAULT NULL, created TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, modified TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id));
CREATE UNIQUE INDEX IX_Domain_1 ON domain (domain);
CREATE TABLE domain_pref (id BIGINT NOT NULL, attribute VARCHAR(255) NOT NULL, ix INT DEFAULT 0 NOT NULL, op VARCHAR(2) DEFAULT ':=' NOT NULL, value TEXT NOT NULL, expire BIGINT DEFAULT 0 NOT NULL, Domain_id BIGINT DEFAULT NULL, PRIMARY KEY(id));
CREATE INDEX IDX_C89B55693AE8C46 ON domain_pref (Domain_id);
CREATE INDEX IX_DomainPreference_1 ON domain_pref (Domain_id, attribute, ix);
CREATE TABLE log (id BIGINT NOT NULL, action VARCHAR(100) NOT NULL, data TEXT DEFAULT NULL, timestamp TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, Admin_id BIGINT DEFAULT NULL, Domain_id BIGINT DEFAULT NULL, PRIMARY KEY(id));
CREATE INDEX IDX_8F3F68C59D5DE046 ON log (Admin_id);
CREATE INDEX IDX_8F3F68C593AE8C46 ON log (Domain_id);
CREATE TABLE mailbox (id BIGINT NOT NULL, username VARCHAR(255) NOT NULL, password VARCHAR(255) NOT NULL, name VARCHAR(255) DEFAULT NULL, alt_email VARCHAR(255) DEFAULT NULL, quota BIGINT DEFAULT 0 NOT NULL, local_part VARCHAR(255) NOT NULL, active BOOLEAN DEFAULT 'false' NOT NULL, access_restriction VARCHAR(100) DEFAULT 'ALL' NOT NULL, homedir VARCHAR(255) DEFAULT NULL, maildir VARCHAR(255) DEFAULT NULL, uid BIGINT DEFAULT NULL, gid BIGINT DEFAULT NULL, homedir_size BIGINT DEFAULT NULL, maildir_size BIGINT DEFAULT NULL, size_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, delete_pending BOOLEAN DEFAULT 'false', created TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, modified TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, Domain_id BIGINT DEFAULT NULL, PRIMARY KEY(id));
CREATE INDEX IDX_A69FE20B93AE8C46 ON mailbox (Domain_id);
CREATE UNIQUE INDEX IX_Username_1 ON mailbox (username);
CREATE TABLE mailbox_pref (id BIGINT NOT NULL, attribute VARCHAR(255) NOT NULL, ix INT DEFAULT 0 NOT NULL, op VARCHAR(2) DEFAULT ':=' NOT NULL, value TEXT NOT NULL, expire BIGINT DEFAULT 0 NOT NULL, Mailbox_id BIGINT DEFAULT NULL, PRIMARY KEY(id));
CREATE INDEX IDX_F9C4B42A29B1361C ON mailbox_pref (Mailbox_id);
CREATE INDEX IX_MailboxPreference_1 ON mailbox_pref (Mailbox_id, attribute, ix);
CREATE TABLE remember_me (id BIGINT NOT NULL, userhash VARCHAR(40) NOT NULL, ckey VARCHAR(40) NOT NULL, original_ip VARCHAR(40) NOT NULL, expires TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, last_used TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, created TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, Admin_id BIGINT DEFAULT NULL, PRIMARY KEY(id));
CREATE INDEX IDX_7AF2A7289D5DE046 ON remember_me (Admin_id);
CREATE SEQUENCE admin_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
CREATE SEQUENCE admin_pref_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
CREATE SEQUENCE alias_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
CREATE SEQUENCE alias_pref_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
CREATE SEQUENCE archive_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
CREATE SEQUENCE dbversion_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
CREATE SEQUENCE directory_entry_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
CREATE SEQUENCE domain_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
CREATE SEQUENCE domain_pref_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
CREATE SEQUENCE log_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
CREATE SEQUENCE mailbox_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
CREATE SEQUENCE mailbox_pref_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
CREATE SEQUENCE remember_me_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
ALTER TABLE domain_admins ADD CONSTRAINT FK_CD8319C69D5DE046 FOREIGN KEY (Admin_id) REFERENCES admin (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE domain_admins ADD CONSTRAINT FK_CD8319C693AE8C46 FOREIGN KEY (Domain_id) REFERENCES domain (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE admin_pref ADD CONSTRAINT FK_814C1AD19D5DE046 FOREIGN KEY (Admin_id) REFERENCES admin (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE alias ADD CONSTRAINT FK_E16C6B9493AE8C46 FOREIGN KEY (Domain_id) REFERENCES domain (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE alias_pref ADD CONSTRAINT FK_3279E911A72028B4 FOREIGN KEY (Alias_id) REFERENCES alias (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE archive ADD CONSTRAINT FK_D5FC5D9C93AE8C46 FOREIGN KEY (Domain_id) REFERENCES domain (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE archive ADD CONSTRAINT FK_D5FC5D9C9D5DE046 FOREIGN KEY (Admin_id) REFERENCES admin (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE directory_entry ADD CONSTRAINT FK_6553C92D66EC35CC FOREIGN KEY (mailbox_id) REFERENCES mailbox (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE domain_pref ADD CONSTRAINT FK_C89B55693AE8C46 FOREIGN KEY (Domain_id) REFERENCES domain (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE log ADD CONSTRAINT FK_8F3F68C59D5DE046 FOREIGN KEY (Admin_id) REFERENCES admin (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE log ADD CONSTRAINT FK_8F3F68C593AE8C46 FOREIGN KEY (Domain_id) REFERENCES domain (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE mailbox ADD CONSTRAINT FK_A69FE20B93AE8C46 FOREIGN KEY (Domain_id) REFERENCES domain (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE mailbox_pref ADD CONSTRAINT FK_F9C4B42A29B1361C FOREIGN KEY (Mailbox_id) REFERENCES mailbox (id) NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE remember_me ADD CONSTRAINT FK_7AF2A7289D5DE046 FOREIGN KEY (Admin_id) REFERENCES admin (id) NOT DEFERRABLE INITIALLY IMMEDIATE;

Event Timeline

DorianWinty changed the title of this paste from dump.sql to dump.sql of vimbadmin.Jun 2 2024, 12:26
DorianWinty added a project: Mail.
DorianWinty added a subscriber: DorianWinty.