From 70059b0d00de150a6ba749ac28ef373b86408982 Mon Sep 17 00:00:00 2001
From: Pjotr Prins
Date: Wed, 24 Apr 2024 19:18:16 -0500
Subject: Layout

---
 issues/systems/mariadb/move-to-innodb.gmi | 53 ++++++++++++++++---------------
 1 file changed, 28 insertions(+), 25 deletions(-)

(limited to 'issues/systems')

diff --git a/issues/systems/mariadb/move-to-innodb.gmi b/issues/systems/mariadb/move-to-innodb.gmi
index c6b52c7..924a203 100644
--- a/issues/systems/mariadb/move-to-innodb.gmi
+++ b/issues/systems/mariadb/move-to-innodb.gmi
@@ -664,6 +664,7 @@ CREATE TABLE 'ProbeSetFreeze' (
 
 There is a primary key. Good.
 
+```
 ALTER TABLE ProbeSetSE
   ADD PRIMARY KEY(DataId,StrainId);
 Query OK, 688744613 rows affected (15 min 13.830 sec)
@@ -920,12 +921,14 @@ Or
 
 ```
 SHOW CREATE TABLE ProbeSet;
+```
 
 E.g.
 
-  FULLTEXT KEY `SEARCH_GENE_IDX` (`Symbol`,`alias`),
-  FULLTEXT KEY `SEARCH_FULL_IDX` (`Name`,`description`,`Symbol`,`alias`,`GenbankId`,`UniGeneId`,`Probe_Target_Description`),
-  FULLTEXT KEY `RefSeq_FULL_IDX` (`RefSeq_TranscriptId`)
+```
+FULLTEXT KEY 'SEARCH_GENE_IDX' ('Symbol','alias'),
+  FULLTEXT KEY 'SEARCH_FULL_IDX' ('Name','description','Symbol','alias','GenbankId','UniGeneId','Probe_Target_Description'),
+  FULLTEXT KEY 'RefSeq_FULL_IDX' ('RefSeq_TranscriptId')
 ```
 
 To see all:
@@ -995,10 +998,10 @@ CREATE FULLTEXT INDEX ft_ProbeSet_Symbol ON ProbeSet(Symbol);
 Now we have
 
 ```
-FULLTEXT KEY `SEARCH_GENE_IDX` (`Symbol`,`alias`),
-FULLTEXT KEY `SEARCH_FULL_IDX` (`Name`,`description`,`Symbol`,`alias`,`GenbankId`,`UniGeneId`,`Probe_Target_Description`),
-FULLTEXT KEY `RefSeq_FULL_IDX` (`RefSeq_TranscriptId`),
-FULLTEXT KEY `ft_ProbeSet_Symbol` (`Symbol`)
+FULLTEXT KEY 'SEARCH_GENE_IDX' ('Symbol','alias'),
+FULLTEXT KEY 'SEARCH_FULL_IDX' ('Name','description','Symbol','alias','GenbankId','UniGeneId','Probe_Target_Description'),
+FULLTEXT KEY 'RefSeq_FULL_IDX' ('RefSeq_TranscriptId'),
+FULLTEXT KEY 'ft_ProbeSet_Symbol' ('Symbol')
 ```
 
 and the query works.
@@ -1061,24 +1064,24 @@ select count(*) from ProbeSetFreeze limit 2;
 |      931 |
 +----------+
 SHOW CREATE TABLE ProbeSetFreeze;
-CREATE TABLE `ProbeSetFreeze` (
-  `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
-  `ProbeFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0,
-  `AvgID` smallint(5) unsigned NOT NULL DEFAULT 0,
-  `Name` varchar(40) DEFAULT NULL,
-  `Name2` varchar(100) NOT NULL DEFAULT '',
-  `FullName` varchar(100) NOT NULL DEFAULT '',
-  `ShortName` varchar(100) NOT NULL DEFAULT '',
-  `CreateTime` date NOT NULL DEFAULT '0000-00-00',
-  `OrderList` int(5) DEFAULT NULL,
-  `public` tinyint(4) NOT NULL DEFAULT 0,
-  `confidentiality` tinyint(4) NOT NULL DEFAULT 0,
-  `AuthorisedUsers` varchar(300) NOT NULL,
-  `DataScale` varchar(20) NOT NULL DEFAULT 'log2',
-  PRIMARY KEY (`Id`),
-  UNIQUE KEY `FullName` (`FullName`),
-  UNIQUE KEY `Name` (`Name`),
-  KEY `NameIndex` (`Name2`)
+CREATE TABLE 'ProbeSetFreeze' (
+  'Id' smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+  'ProbeFreezeId' smallint(5) unsigned NOT NULL DEFAULT 0,
+  'AvgID' smallint(5) unsigned NOT NULL DEFAULT 0,
+  'Name' varchar(40) DEFAULT NULL,
+  'Name2' varchar(100) NOT NULL DEFAULT '',
+  'FullName' varchar(100) NOT NULL DEFAULT '',
+  'ShortName' varchar(100) NOT NULL DEFAULT '',
+  'CreateTime' date NOT NULL DEFAULT '0000-00-00',
+  'OrderList' int(5) DEFAULT NULL,
+  'public' tinyint(4) NOT NULL DEFAULT 0,
+  'confidentiality' tinyint(4) NOT NULL DEFAULT 0,
+  'AuthorisedUsers' varchar(300) NOT NULL,
+  'DataScale' varchar(20) NOT NULL DEFAULT 'log2',
+  PRIMARY KEY ('Id'),
+  UNIQUE KEY 'FullName' ('FullName'),
+  UNIQUE KEY 'Name' ('Name'),
+  KEY 'NameIndex' ('Name2')
 ) ENGINE=MyISAM AUTO_INCREMENT=1054 DEFAULT CHARSET=latin1
 ```
 
-- 
cgit v1.2.3