lyfz_repos/经典版源码/document/数据库新版本脚本/文件夹信息表.sql

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