Commits

Zhang Huangbin  committed 14a07ca

Don't show created time stamp.

  • Participants
  • Parent commits 0ff63a9

Comments (0)

Files changed (4)

File libs/mysql/admin.py

         try:
             result = self.conn.query(
                 """
-                SELECT name, username, language, created, active
+                SELECT name, username, language, active
                 FROM admin
                 ORDER BY username ASC
                 %s

File libs/mysql/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,
                 IFNULL(b.alias_count, 0) AS alias_count,
                 IFNULL(c.mailbox_count, 0) AS mailbox_count,
                 IFNULL(c.quota_count, 0) AS quota_count
                 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
                 ORDER BY domain.domain
                 LIMIT 1
                 ''',

File libs/pgsql/admin.py

         try:
             result = self.conn.query(
                 """
-                SELECT name, username, language, created, active
+                SELECT name, username, language, active
                 FROM admin
                 ORDER BY username ASC
                 %s

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,