mysql表结构转postsql_MySQL5.1内表转到MS SQL，表结构应如何设置？

# MySQL-Front 5.1  (Build 4.2)

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;

/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;

/*!40103 SET SQL_NOTES='ON' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;

/*!40014 SET FOREIGN_KEY_CHECKS=0 */;

# Host: localhost    Database: scanmaster

# ------------------------------------------------------

# Server version 5.1.46-community

#

# Source for table tabapp

#

DROP TABLE IF EXISTS `tabapp`;

CREATE TABLE `tabapp` (

`appid` int(4) NOT NULL AUTO_INCREMENT,

`appname` varchar(32) NOT NULL DEFAULT '',

`apppath` varchar(255) CHARACTER SET gbk COLLATE gbk_bin NOT NULL DEFAULT '',

`outputpath` varchar(255) CHARACTER SET gbk COLLATE gbk_bin NOT NULL DEFAULT '',

`indexed` int(4) NOT NULL DEFAULT '0',

`key1` varchar(64) DEFAULT NULL,

`key2` varchar(64) DEFAULT NULL,

PRIMARY KEY (`appid`),

UNIQUE KEY `appname` (`appname`)

) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=gbk;

#

# Dumping data for table tabapp

#

LOCK TABLES `tabapp` WRITE;

/*!40000 ALTER TABLE `tabapp` DISABLE KEYS */;

INSERT INTO `tabapp` VALUES (4,'FDCdoc1','\\\\aqlcserver\\in$\\FDCdoc1','\\\\aqlcserver\\out$\\FDCdoc1',1,'批次号','盒内序号');

/*!40000 ALTER TABLE `tabapp` ENABLE KEYS */;

UNLOCK TABLES;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

以上是MySQL导出表的SQL,若在MS SQL中建立相同的表，红色字体部分在MS SQL中如何设置？