Source

iredmail / iRedMail / samples / iredmail.pgsql

Diff from to

iRedMail/samples/iredmail.pgsql

     department VARCHAR(255) NOT NULL DEFAULT '',
     rank VARCHAR(255) NOT NULL DEFAULT 'normal',
     employeeid VARCHAR(255) DEFAULT '',
+    isadmin INT2 NOT NULL DEFAULT 0,
+    isglobaladmin INT2 NOT NULL DEFAULT 0,
+    language VARCHAR(5) NOT NULL DEFAULT 'en_US',
     enablesmtp INT2 NOT NULL DEFAULT 1,
     enablesmtpsecured INT2 NOT NULL DEFAULT 1,
     enablepop3 INT2 NOT NULL DEFAULT 1,
 CREATE INDEX idx_mailbox_domain ON mailbox (domain);
 CREATE INDEX idx_mailbox_department ON mailbox (department);
 CREATE INDEX idx_mailbox_employeeid ON mailbox (employeeid);
+CREATE INDEX idx_mailbox_isadmin ON mailbox (isadmin);
 CREATE INDEX idx_mailbox_enablesmtp ON mailbox (enablesmtp);
 CREATE INDEX idx_mailbox_enablesmtpsecured ON mailbox (enablesmtpsecured);
 CREATE INDEX idx_mailbox_enablepop3 ON mailbox (enablepop3);