Commits

Zhang Huangbin committed 430ed72

Add comments in SQL template file.

Comments (0)

Files changed (2)

iRedMail/samples/iredmail.mysql

     lastloginipv4 INT(4) UNSIGNED NOT NULL DEFAULT 0,
     lastloginprotocol CHAR(255) NOT NULL DEFAULT '',
     disclaimer TEXT,
+    -- Allow emails sent from certain users
+    allowedsenders TEXT,
+    -- Reject emails sent from certain users
+    rejectedsenders TEXT,
+    -- Allow to sent email to certain users
+    allowedrecipients TEXT,
+    -- Reject to sent email to certain users
+    rejectedrecipients TEXT,
     passwordlastchange DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
-    allowedsenders TEXT,
-    rejectedsenders TEXT,
-    allowedrecipients TEXT,
-    rejectedrecipients TEXT,
     created DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
     modified DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
     expired DATETIME NOT NULL DEFAULT '9999-12-31 00:00:00',

iRedMail/samples/iredmail.pgsql

     lastloginipv4 INET NOT NULL DEFAULT '0.0.0.0',
     lastloginprotocol CHAR(255) NOT NULL DEFAULT '',
     disclaimer TEXT NOT NULL DEFAULT '',
+    -- Allow emails sent from certain users
     allowedsenders TEXT NOT NULL DEFAULT '',
+    -- Reject emails sent from certain users
     rejectedsenders TEXT NOT NULL DEFAULT '',
+    -- Allow to sent email to certain users
     allowedrecipients TEXT NOT NULL DEFAULT '',
+    -- Reject to sent email to certain users
     rejectedrecipients TEXT NOT NULL DEFAULT '',
     passwordlastchange TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT '1970-01-01 00:00:00',
     created TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT '1970-01-01 00:00:00',
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.