CREATE DEFINER=`root`@`localhost` TRIGGER `insert_file` BEFORE INSERT ON `file` FOR EACH ROW BEGIN
   DECLARE next_id INT;
   SET next_id = (SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='file');
   SET NEW.order_num=next_id;   
END;