--- /usr/share/doc/web-cyradm-0.5.5e1/scripts/create_mysql.sql	2011-06-14 23:39:11.000000000 +0600
+++ create_mysql.sql	2016-03-06 15:50:53.702964969 +0500
@@ -24,7 +24,7 @@
   sieve int(10) NOT NULL default '1',
   smtpauth int(10) NOT NULL default '1',
   UNIQUE KEY username (username)
-) TYPE=MyISAM;
+) engine=MariaDB;
 # --------------------------------------------------------
 
 #
@@ -38,7 +38,7 @@
   SID varchar(255) NOT NULL default '',
   home varchar(255) NOT NULL default '',
   PRIMARY KEY  (username)
-) TYPE=MyISAM;
+) engine=MariaDB;
 # --------------------------------------------------------
 
 #
@@ -51,7 +51,7 @@
   `maxdisplay` int(4) NOT NULL default '15',
   `warnlevel` int(3) NOT NULL default '90',
   PRIMARY KEY  (username)
-) TYPE=MyISAM;
+) engine=MariaDB;
 # --------------------------------------------------------
 
 #
@@ -64,7 +64,7 @@
   username varchar(50) NOT NULL default '',
   status int(11) NOT NULL default '1',
   PRIMARY KEY  (alias)
-) TYPE=MyISAM;
+) engine=MariaDB;
 # --------------------------------------------------------
 
 #
@@ -83,7 +83,7 @@
   folders varchar(255) NOT NULL default '',
   PRIMARY KEY  (domain_name),
   UNIQUE KEY prefix (prefix)
-) TYPE=MyISAM;
+) engine=MariaDB;
 # --------------------------------------------------------
 
 #
@@ -93,7 +93,7 @@
 CREATE TABLE domainadmin (
   domain_name varchar(255) NOT NULL default '',
   adminuser varchar(255) NOT NULL default ''
-) TYPE=MyISAM;
+) engine=MariaDB;
 # --------------------------------------------------------
 
 #
@@ -104,10 +104,10 @@
   search_id varchar(255) NOT NULL default '',
   search_sql text NOT NULL,
   perpage int(11) NOT NULL default '0',
-  timestamp timestamp(14) NOT NULL,
-  PRIMARY KEY  (search_id),
+  timestamp timestamp,
+  PRIMARY KEY (search_id),
   KEY search_id (search_id)
-) TYPE=MyISAM;
+) engine=MariaDB;
 # --------------------------------------------------------
 
 #
@@ -120,7 +120,7 @@
   username varchar(50) NOT NULL default '',
   status int(11) NOT NULL default '1',
   KEY alias (alias)
-) TYPE=MyISAM;
+) engine=MariaDB;
 
 CREATE TABLE log (
   id int(11) NOT NULL auto_increment,
@@ -130,7 +130,7 @@
   time datetime NOT NULL default '2000-00-00 00:00:00',
   pid varchar(255) NOT NULL default '',
   PRIMARY KEY  (id)
-) TYPE=MyISAM;
+) engine=MariaDB;
 
 INSERT INTO adminuser (username, password) VALUES ('admin', ENCRYPT('test'));
 INSERT INTO domainadmin (domain_name,adminuser) VALUES ('*','admin');