Question

Why replace .Index in migration file incorrect usage of spatial/fulltext/hash index and explicit index order

Answer 1

create table `Articles`  

(

`articleId` int not null  auto_increment ,

`title` longtext not null ,

`digest` longtext,

`content` longtext not null ,

`imgLink` longtext not null ,

`releaseDate` datetime,

`userId` int not null ,

 primary key ( `articleId`)

) engine=InnoDb auto_increment=0

 CREATE index  `IX_userId` on `Articles` (`userId` DESC) using HAS