Attachment 6662 Details for Bug 31860 – Патч для create_mysql.sql

[patch] Патч для create_mysql.sql

create_mysql.sql.diff (text/plain), 2.42 KB, created by Стас on 2016-03-06 13:57:04 MSK

(hide)

Description:

Filename:

MIME Type:

Creator: Стас

Created: 2016-03-06 13:57:04 MSK

Size: 2.42 KB

patch

obsolete

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

Actions: View | Diff

Attachments on bug 31860: 6662 | 6663