Source

iredadmin-ose / libs / pgsql / domain.py

Diff from to

File libs/pgsql/domain.py

             qr = self.conn.query(
                 '''
                 SELECT
-                    admin.username, admin.name, admin.language,
-                    admin.created, admin.active
+                    admin.username, admin.name, admin.language, admin.active
                 FROM admin
                 LEFT JOIN domain_admins ON (domain_admins.username=admin.username)
                 WHERE domain_admins.domain=$domain
         rawSQLOfRecords = """
             SELECT
                 a.domain, a.description, a.aliases, a.mailboxes, a.maxquota, a.quota,
-                a.transport, a.backupmx, a.created, a.active,
+                a.transport, a.backupmx, a.active,
                 NULLIF(b.alias_count, 0) AS alias_count,
                 NULLIF(c.mailbox_count, 0) AS mailbox_count,
                 NULLIF(c.quota_count, 0) AS quota_count
             %s
             GROUP BY
                 a.domain, a.description, a.aliases, a.mailboxes, a.maxquota, a.quota,
-                a.transport, a.backupmx, a.created, a.active,
+                a.transport, a.backupmx, a.active,
                 mailbox_count, alias_count, quota_count
             ORDER BY a.domain
             LIMIT %d
                 SELECT
                     domain.domain, domain.description, domain.aliases,
                     domain.mailboxes, domain.maxquota, domain.quota,
-                    domain.transport, domain.backupmx, domain.created,
-                    domain.active,
+                    domain.transport, domain.backupmx, domain.active,
                     domain.defaultuseraliases, domain.defaultuserquota,
                     domain.minpasswordlength, domain.maxpasswordlength,
                     sbcc.bcc_address AS sbcc_addr,
                 GROUP BY
                     domain.domain, domain.description, domain.aliases,
                     domain.mailboxes, domain.maxquota, domain.quota,
-                    domain.transport, domain.backupmx, domain.created,
-                    domain.active,
+                    domain.transport, domain.backupmx, domain.active,
                     domain.defaultuseraliases, domain.defaultuserquota,
                     domain.minpasswordlength, domain.maxpasswordlength,
                     sbcc.bcc_address, sbcc.active,