MySQL Linux and Windows entity changes I have a trigger on an entity that copies the row and saves it in a different entity.

I also have 2 MySQL servers one on Linux and the other on Windows. It seems the order of the columns in the same table are different between the servers. Is there a way to make them the same order? Some configuration? 

I'm creating an audit table using this script:

CREATE TABLE xxx.AuditEntity (
  auditAction VARCHAR(45) NULL DEFAULT NULL COMMENT '',
  auditTime DATETIME NULL DEFAULT NULL COMMENT '',
  type VARCHAR(64)  NULL COMMENT '',
  id BIGINT(20) NOT NULL COMMENT '',
  modifiedBy BIGINT(20) NULL DEFAULT NULL COMMENT '',
  timeCreated DATETIME  NULL COMMENT '',
  currency VARCHAR(32)  NULL COMMENT '',
  nameVARCHAR(128) NULL DEFAULT NULL COMMENT '',
   INDEX auditTime (auditTime ASC)  COMMENT '',
  INDEX id (id ASC)  COMMENT '');


The trigger on the original entity:

CREATE DEFINER=`root`@`localhost` 
TRIGGER xxx.entity_AINS AFTER INSERT ON Entity FOR EACH ROW 
BEGIN INSERT INTO AuditEntity select 'AFTER_INSERT', now(), e.* 
    from Entity e where id = NEW.id; 
END


Because the columns in the 2 servers have a different order it doesn't work.

Our idea is not to explicitly write out the columns' names, is there a difference between how Linux and Windows save entities?
This is part of the table definition, you'll need to do something similar to this:

ALTER TABLE Table1 MODIFY COLUMN Column1 INT AFTER Column2;


This will move Column1 after Column2.

Alter Table Syntax