Changeset d36701a for npl/mailserver/dspam/initdb.sql

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

File:

• npl/mailserver/dspam/initdb.sql (modified) (5 diffs)

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);