CREATE TABLE `NewTable` (
`LineSF_ID`  bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID' ,
`LineID`  bigint(255) NOT NULL COMMENT '线路ID' ,
`LineSF_Fee`  varchar(4096) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '经停费' ,
`LineSF_EffBeginDay`  datetime NULL DEFAULT NULL COMMENT '有效起始日期' ,
`LineSF_EffEndDay`  datetime NULL DEFAULT NULL COMMENT '有效结束日期' ,
`LineSF_BeginTime`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出发时间' ,
`LineSF_IsActive`  smallint(255) NULL DEFAULT NULL COMMENT '是否激活' ,
`LineSF_CreaterID`  bigint(255) NOT NULL DEFAULT 1 COMMENT '创建者ID' ,
`LineSF_DateTime`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`LineSF_Currency_Type`  varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '(0第一币种，1第二币种)' ,
PRIMARY KEY (`LineSF_ID`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=93
ROW_FORMAT=COMPACT
;

DELETE FROM NewTable WHERE NewTable.linesf_id > 88