diff options
| author | Ladar Levison <ladar@lavabit.com> | 2020-11-10 23:09:48 +0300 |
|---|---|---|
| committer | Ladar Levison <ladar@lavabit.com> | 2020-11-10 23:09:48 +0300 |
| commit | 6842ef51dca48668d48133672d4fbce42a3e98c7 (patch) | |
| tree | 3f0e57e0fe029fe6b668b9b66f186411fd4917ab | |
| parent | 323cdbe6784e8dfe359a59ed3fcb7519d081415f (diff) | |
Create the default plans when initializing a new schema.
| -rwxr-xr-x | dev/scripts/database/schema.init.sh | 2 | ||||
| -rw-r--r-- | res/sql/Limits.sql | 11 |
2 files changed, 13 insertions, 0 deletions
diff --git a/dev/scripts/database/schema.init.sh b/dev/scripts/database/schema.init.sh index 41e177b1..a7e6738a 100755 --- a/dev/scripts/database/schema.init.sh +++ b/dev/scripts/database/schema.init.sh @@ -115,6 +115,7 @@ cat $MAGMA_RES_SQL/Start.sql \ $MAGMA_RES_SQL/Schema.sql \ $MAGMA_RES_SQL/Migration.sql \ $MAGMA_RES_SQL/Hostname.sql \ + $MAGMA_RES_SQL/Limits.sql \ $MAGMA_RES_SQL/Version.sql \ $MAGMA_RES_SQL/Finish.sql \ | mysql --batch --user="${MYSQL_USER}" --password="${MYSQL_PASSWORD}" &> /dev/null @@ -126,6 +127,7 @@ if [ $? != 0 ]; then $MAGMA_RES_SQL/Schema.sql \ $MAGMA_RES_SQL/Migration.sql \ $MAGMA_RES_SQL/Hostname.sql \ + $MAGMA_RES_SQL/Limits.sql \ $MAGMA_RES_SQL/Version.sql \ $MAGMA_RES_SQL/Finish.sql \ | mysql --verbose --user="${MYSQL_USER}" --password="${MYSQL_PASSWORD}" | tail -4 diff --git a/res/sql/Limits.sql b/res/sql/Limits.sql new file mode 100644 index 00000000..f8f97289 --- /dev/null +++ b/res/sql/Limits.sql @@ -0,0 +1,11 @@ + +-- +-- Dumping data for table `Limits` +-- +-- ORDER BY: `plan` + +/*!40000 ALTER TABLE `Limits` DISABLE KEYS */; +INSERT INTO `Limits` (`plan`, `description`, `corporate`, `paid`, `secure`, `forwarded`, `rollout`, `bounces`, `greylist`, `greytime_min`, `greytime_max`, `filters`, `rbl`, `rblaction_list`, `spf`, `spfaction_list`, `dkim`, `dkimaction_list`, `spam`, `spamaction_list`, `virus`, `virusaction_list`, `phish`, `phishaction_list`, `wormaction_list`, `autoreply`, `send_size_limit`, `send_size_limit_min`, `send_size_limit_max`, `recv_size_limit`, `recv_size_limit_min`, `recv_size_limit_max`, `daily_send_limit`, `daily_send_limit_min`, `daily_send_limit_max`, `daily_recv_limit`, `daily_recv_limit_min`, `daily_recv_limit_max`, `daily_recv_limit_ip`, `daily_recv_limit_ip_min`, `daily_recv_limit_ip_max`, `quota`, `tls`, `password`) VALUES ('BASIC','The basic account plan.',0,0,0,0,1,1,1,1,30,1,1,'REJECT,DELETE,MARK',1,'REJECT,DELETE,MARK',1,'DELETE,MARK',0,'DELETE,MARK',1,'DELETE,MARK',1,'DELETE,MARK','DELETE',0,1,1048576,33554432,1,1048576,33554432,1,8,256,1,8,1024,1,8,1024,134217728,1,1),('ENHANCED','The enhanced account plan.',0,0,1,1,1,1,1,1,30,1,1,'REJECT,DELETE,MARK',1,'REJECT,DELETE,MARK',1,'DELETE,MARK',1,'DELETE,MARK',1,'DELETE,MARK',1,'DELETE,MARK','DELETE',1,1,1048576,67108864,1,1048576,67108864,1,8,512,1,8,1024,1,8,1024,1073741824,1,1),('PERSONAL','The personal account plan.',0,0,0,1,1,1,1,1,30,1,1,'REJECT,DELETE,MARK',1,'REJECT,DELETE,MARK',1,'DELETE,MARK',0,'DELETE,MARK',1,'DELETE,MARK',1,'DELETE,MARK','DELETE',1,1,1048576,67108864,1,1048576,67108864,1,8,256,1,8,1024,1,8,1024,1073741824,1,1),('PREMIER','The premier account plan.',0,1,1,1,1,1,1,1,30,1,1,'REJECT,DELETE,MARK',1,'REJECT,DELETE,MARK',1,'DELETE,MARK',0,'MARK',1,'DELETE,MARK',1,'DELETE,MARK','DELETE',1,1,1048576,134217728,1,1048576,134217728,1,8,128,1,8,8192,1,8,8192,21474836480,1,1),('PREMIUM','The premium account plan.',0,0,1,1,1,1,1,1,30,1,1,'REJECT,DELETE,MARK',1,'REJECT,DELETE,MARK',1,'DELETE,MARK',1,'DELETE,MARK',1,'DELETE,MARK',1,'DELETE,MARK','DELETE',1,1,1048576,134217728,1,1048576,134217728,1,8,768,1,8,8196,1,8,8196,8589934592,1,1),('STANDARD','The standard account plan.',0,1,1,1,1,1,1,1,30,1,1,'REJECT,DELETE,MARK',1,'REJECT,DELETE,MARK',1,'DELETE,MARK',0,'MARK',1,'DELETE,MARK',1,'DELETE,MARK','DELETE',1,1,1048576,67108864,1,1048576,67108864,1,8,128,1,8,8192,1,8,8192,5368709120,1,1); +/*!40000 ALTER TABLE `Limits` ENABLE KEYS */; + +-- |