Changeset d36701a for npl/mailserver

Timestamp:

06/13/18 16:04:12 (7 years ago)

Author:

Edwin Eefting <edwin@datux.nl>

Branches:

gcc484, master, perl-5.22

Children:

28afc38

Parents:

20eb816

Message:

fix myisam syntax for initial db creation with newer mysql versions

Location:

npl/mailserver/dspam

Files:

• dspam.SlackBuild.log.gz (modified) (previous)
• dspam.build (modified) (1 diff)
• dspam.md5 (modified) (1 diff)
• dspam.pkg (modified) (previous)
• dspam_webui.build (modified) (1 diff)
• dspam_webui.pkg (modified) (previous)
• initdb.sql (modified) (5 diffs)

npl/mailserver/dspam/dspam.build

@@ -1 @@
-6540
+6541

npl/mailserver/dspam/dspam.md5

@@ -387 +387 @@
 d48b067b991ae2012862d109d21ebda3  ./dspam_clean.cron
 582b859928225701665e9bb8a1e897eb  ./dspam.conf
-cb736215da817654490524f9a1b3947a  ./dspam.pkg
+7b1e0e00192de8bfc02758d9338b6942  ./dspam.pkg
 0ac2b4b6380f0f6ebb937bfdc15f33c0  ./dspam.SlackBuild
-2dc712f32aa37def29df79c8bf746857  ./dspam.SlackBuild.log.gz
-c9badd49fcf25a18fab35b7e2fd7d8af  ./dspam_webui.pkg
+55425d5814ba9c4bfef258554b2a79ac  ./dspam.SlackBuild.log.gz
+801607ddf4293972af2610436546c2d0  ./dspam_webui.pkg
 d2aabf5ebfac3a5995171b98ac23845f  ./global.sql.gz
 f648885d1dac1916b6d9cc88536db3c7  ./group
 b3b686e10af71dd4c928b9d62c547f9e  ./htaccess
-f65b1fabc27074a9ef31d57431e08e96  ./initdb.sql
+9434b7a4713793dcc8d5dc458f3042a5  ./initdb.sql
 95cbc61d450e2904be264cb11d94431a  ./post.dspam
 1b2edfe1130eec64752c7fd65cde1a42  ./run

npl/mailserver/dspam/dspam_webui.build

@@ -1 @@
-6540
+6541

npl/mailserver/dspam/initdb.sql

@@ -9 +9 @@
   innocent_hits int not null,
   last_hit date not null
-) type=MyISAM PACK_KEYS=1;
+) ENGINE=MyISAM PACK_KEYS=1;
 
 create unique index id_token_data_01 on dspam_token_data(uid,token);
@@ -19 +19 @@
   length smallint not null,
   created_on date not null
-) type=MyISAM max_rows=2500000 avg_row_length=8096;
+) ENGINE=MyISAM max_rows=2500000 avg_row_length=8096;
 
 create unique index id_signature_data_01 on dspam_signature_data(uid,signature);
@@ -34 +34 @@
   spam_classified int not null,
   innocent_classified int not null
-) type=MyISAM;
+) ENGINE=MyISAM;
 
 create table dspam_preferences (
@@ -40 +40 @@
   preference varchar(32) not null,
   value varchar(64) not null
-) type=MyISAM;
+) ENGINE=MyISAM;
 
 create unique index id_preferences_01 on dspam_preferences(uid, preference);
@@ -49 +49 @@
   uid smallint unsigned primary key AUTO_INCREMENT,
   username varchar(128)
-) type=MyISAM;
+) ENGINE=MyISAM;
 
 create unique index id_virtual_uids_01 on dspam_virtual_uids(username);