USE [db] GO /****** 对象: Table [dbo].[FolderInfo] 脚本日期: 07/23/2015 10:27:49 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO create table [dbo].[FolderInfo]( [OrderID] [varchar](50) NOT NULL, --订单号 [FolderNames] [varchar](50) NULL, --文件夹名集合如:(;1;2;3;) [Photos] [varchar](max) NULL, --文件夹里的相片(;文件夹1>文件1;文件夹1>文件2;文件夹2>文件1;) [DelPhotos] [varchar](max) NULL --删除的文件名集如:(;文件夹1>文件1;文件夹1>文件2;文件夹2>文件1;) CONSTRAINT [PK_FolderInfo] PRIMARY KEY CLUSTERED ( [OrderID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) on [primary] GO SET ANSI_PADDING OFF