gusucode.com > CRM源码带手机版ASP源码程序 > Data/Easycrm.txt
/****** 对象: Table [dbo].[NotDownload] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON SET ANSI_PADDING ON CREATE TABLE [dbo].[NotDownload]( [NotDown] [binary](1) NULL ) ON [PRIMARY] SET ANSI_PADDING OFF /****** 对象: Table [dbo].[AreaData] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[AreaData]( [aId] [int] IDENTITY(1,1) NOT NULL, [aFId] [nvarchar](50) NULL, [aName] [nvarchar](50) NULL, CONSTRAINT [PK_AreaData] PRIMARY KEY CLUSTERED ( [aId] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] /****** 对象: Table [dbo].[Calendar] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[Calendar]( [ID] [int] IDENTITY(1,1) NOT NULL, [calendarDate] [datetime] NULL, [calendarText] [ntext] NULL, [calendaruser] [nvarchar](50) NULL, CONSTRAINT [PK_Calendar] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[Client] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[Client]( [cId] [int] IDENTITY(1,1) NOT NULL, [cdate] [datetime] NULL, [cYn] [int] NULL, [cCompany] [nvarchar](255) NULL, [cArea] [nvarchar](50) NULL, [cSquare] [nvarchar](50) NULL, [cAddress] [nvarchar](255) NULL, [cLinkman] [nvarchar](50) NULL, [cZhiwei] [nvarchar](50) NULL, [cMobile] [nvarchar](50) NULL, [cZip] [nvarchar](50) NULL, [cTel] [nvarchar](50) NULL, [cFax] [nvarchar](50) NULL, [cHomepage] [nvarchar](255) NULL, [cEmail] [nvarchar](255) NULL, [cTrade] [nvarchar](50) NULL, [cStrade] [nvarchar](50) NULL, [cType] [nvarchar](50) NULL, [cStart] [nvarchar](50) NULL, [cSource] [nvarchar](50) NULL, [cInfo] [ntext] NULL, [cUser] [nvarchar](16) NULL, [cGroup] [int] NULL, [cBeizhu] [ntext] NULL, [cOldUser] [nvarchar](50) NULL, [cLastUpdated] [datetime] NULL, [cShare] [int] NULL, [cShareRange] [ntext] NULL, [cService] [nvarchar](50) NULL, [cRNextTime] [datetime] NULL, [cOEDate] [datetime] NULL, [cHEdate] [datetime] NULL, CONSTRAINT [PK_Client] PRIMARY KEY CLUSTERED ( [cId] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[CustomField] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[CustomField]( [id] [int] IDENTITY(1,1) NOT NULL, [cTable] [nvarchar](50) NULL, [cTitle] [nvarchar](50) NULL, [cName] [nvarchar](50) NULL, [cType] [nvarchar](50) NULL, [cWidth] [nvarchar](50) NULL, [cContent] [nvarchar](50) NULL, [cList] [int] NULL, [cYn] [int] NULL, CONSTRAINT [PK_CustomField] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] /****** 对象: Table [dbo].[CustomFieldContent] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[CustomFieldContent]( [id] [int] IDENTITY(1,1) NOT NULL, [cID] [int] NULL, [rID] [int] NULL, [oID] [int] NULL, [hID] [int] NULL, [sID] [int] NULL, [eID] [int] NULL, [cContent] [ntext] NULL, CONSTRAINT [PK_CustomFieldContent] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[Expense] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[Expense]( [eId] [int] IDENTITY(1,1) NOT NULL, [cId] [int] NULL, [eDate] [datetime] NULL, [eOutIn] [int] NULL, [eType] [nvarchar](50) NULL, [eMoney] [money] NULL, [eContent] [ntext] NULL, [eUser] [nvarchar](50) NULL, [eTime] [datetime] NULL, CONSTRAINT [PK_Expense] PRIMARY KEY CLUSTERED ( [eId] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[Field_Name] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[Field_Name]( [id] [int] IDENTITY(1,1) NOT NULL, [DataTable] [nvarchar](255) NULL, [Field] [nvarchar](255) NULL, [Name] [nvarchar](255) NULL, [Shows] [int] NULL, CONSTRAINT [PK_Field_Name] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] /****** 对象: Table [dbo].[File] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[File]( [fId] [int] IDENTITY(1,1) NOT NULL, [cId] [int] NULL, [fTitle] [nvarchar](255) NULL, [fFile] [nvarchar](255) NULL, [fContent] [ntext] NULL, [fUser] [nvarchar](50) NULL, [fTime] [datetime] NULL, CONSTRAINT [PK_File] PRIMARY KEY CLUSTERED ( [fId] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[Hetong] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[Hetong]( [hId] [int] IDENTITY(1,1) NOT NULL, [cId] [int] NULL, [oId] [int] NULL, [hNum] [nvarchar](50) NULL, [hSdate] [datetime] NULL, [hEdate] [datetime] NULL, [hType] [nvarchar](50) NULL, [hMoney] [money] NULL, [hRevenue] [money] NULL, [hOwed] [money] NULL, [hInvoice] [nvarchar](50) NULL, [hTax] [nvarchar](50) NULL, [hState] [nvarchar](50) NULL, [hContent] [ntext] NULL, [hAudit] [nvarchar](50) NULL, [hAuditTime] [datetime] NULL, [hAuditReasons] [ntext] NULL, [hUser] [nvarchar](50) NULL, [hTime] [datetime] NULL, CONSTRAINT [PK_Hetong] PRIMARY KEY CLUSTERED ( [hId] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[Hetong_Renew] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[Hetong_Renew]( [rid] [int] IDENTITY(1,1) NOT NULL, [hID] [int] NULL, [rMoney] [money] NULL, [rRevenue] [money] NULL, [rEdate] [datetime] NULL, [rState] [nvarchar](50) NULL, [rContent] [ntext] NULL, [rAudit] [nvarchar](50) NULL, [rAuditTime] [datetime] NULL, [rAuditReasons] [ntext] NULL, [rUser] [nvarchar](50) NULL, [rTime] [datetime] NULL, CONSTRAINT [PK_Hetong_Renew] PRIMARY KEY CLUSTERED ( [rid] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[Linkmans] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[Linkmans]( [lId] [int] IDENTITY(1,1) NOT NULL, [cId] [int] NULL, [lName] [nvarchar](50) NULL, [lSex] [nvarchar](255) NULL, [lZhiwei] [nvarchar](50) NULL, [lMobile] [nvarchar](50) NULL, [lQQ] [nvarchar](50) NULL, [lTel] [nvarchar](50) NULL, [lEmail] [nvarchar](255) NULL, [lMSN] [nvarchar](255) NULL, [lALWW] [nvarchar](50) NULL, [lBirthday] [datetime] NULL, [lContent] [ntext] NULL, [lUser] [nvarchar](50) NULL, [lTime] [datetime] NULL, CONSTRAINT [PK_Linkmans_1] PRIMARY KEY CLUSTERED ( [lId] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[Logfile] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[Logfile]( [lId] [int] IDENTITY(1,1) NOT NULL, [lcId] [int] NULL, [lClass] [nvarchar](50) NULL, [lAction] [nvarchar](50) NULL, [lReason] [ntext] NULL, [lUser] [nvarchar](50) NULL, [lTime] [datetime] NULL, CONSTRAINT [PK_Logfile] PRIMARY KEY CLUSTERED ( [lId] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[OA_mms_Receive] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[OA_mms_Receive]( [id] [int] IDENTITY(1,1) NOT NULL, [oReceiver] [nvarchar](255) NULL, [oSender] [nvarchar](50) NULL, [oTitle] [nvarchar](255) NULL, [oContent] [ntext] NULL, [oIsread] [int] NULL, [oAttime] [datetime] NULL, [oTime] [datetime] NULL, CONSTRAINT [PK_OA_mms_Receive] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[OA_mms_send] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[OA_mms_send]( [id] [int] IDENTITY(1,1) NOT NULL, [oReceiver] [nvarchar](255) NULL, [oSender] [nvarchar](50) NULL, [oTitle] [nvarchar](255) NULL, [oContent] [ntext] NULL, [oIsread] [int] NULL, [oTime] [datetime] NULL, CONSTRAINT [PK_OA_mms_send] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[OA_Notice] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[OA_Notice]( [oNid] [int] IDENTITY(1,1) NOT NULL, [oSendto] [nvarchar](255) NULL, [oNclass] [nvarchar](50) NULL, [oNStar] [int] NULL, [oNtitle] [nvarchar](255) NULL, [oNcontent] [ntext] NULL, [oNIsread] [int] NULL, [oNuser] [nvarchar](50) NULL, [oNedittime] [datetime] NULL, [oNaddtime] [datetime] NULL , CONSTRAINT [PK_OA_Notice] PRIMARY KEY CLUSTERED ( [oNid] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[OA_Report] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[OA_Report]( [id] [int] IDENTITY(1,1) NOT NULL, [oSendto] [nvarchar](255) NULL, [oClass] [nvarchar](50) NULL, [oTitle] [nvarchar](50) NULL, [oReport] [ntext] NULL, [oPlan] [ntext] NULL, [oReply] [ntext] NULL, [oUser] [nvarchar](50) NULL, [oIsread] [int] NULL, [oTime] [datetime] NULL, CONSTRAINT [PK_OA_Report] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[OA_soft] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[OA_soft]( [sId] [int] IDENTITY(1,1) NOT NULL, [s_class] [nvarchar](50) NULL, [s_title] [nvarchar](50) NULL, [s_file] [nvarchar](255) NULL, [s_user] [nvarchar](50) NULL, [s_share] [int] NULL, [s_time] [datetime] NULL, [s_content] [ntext] NULL, CONSTRAINT [PK_OA_soft] PRIMARY KEY CLUSTERED ( [sId] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[Order] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[Order]( [oid] [int] IDENTITY(1,1) NOT NULL, [cId] [int] NULL, [oCode] [nvarchar](50) NULL, [oLinkman] [nvarchar](50) NULL, [oSDate] [datetime] NULL, [oEDate] [datetime] NULL, [oDeposit] [money] NULL, [oMoney] [money] NULL, [oState] [int] NULL, [oContent] [ntext] NULL, [oUser] [nvarchar](50) NULL, [oTime] [datetime] NULL, [oAuditReasons] [nvarchar](255) NULL, CONSTRAINT [PK_Order] PRIMARY KEY CLUSTERED ( [oid] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[Order_Products] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[Order_Products]( [osId] [int] IDENTITY(1,1) NOT NULL, [oId] [int] NULL, [cId] [int] NULL, [ProId] [int] NULL, [oProNum] [int] NULL, [oDiscount] [money] NULL, [oMoney] [money] NULL, [oContent] [ntext] NULL, [oUser] [nvarchar](50) NULL, [oTime] [datetime] NULL, CONSTRAINT [PK_Order_Products] PRIMARY KEY CLUSTERED ( [osId] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[Plugin] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[Plugin]( [id] [int] IDENTITY(1,1) NOT NULL, [pSort] [int] NULL, [pTitle] [nvarchar](50) NULL, [pUrl] [nvarchar](255) NULL, [pAuthor] [nvarchar](50) NULL, [pVersion] [nvarchar](50) NULL, [pContent] [nvarchar](255) NULL, [pTime] [datetime] NULL, [pYn] [int] NULL, [QuickYN] [int] NULL, CONSTRAINT [PK_Plugin] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] /****** 对象: Table [dbo].[ProductClass] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[ProductClass]( [pClassId] [int] IDENTITY(1,1) NOT NULL, [pClassFid] [nvarchar](50) NULL, [pClassname] [nvarchar](50) NULL, CONSTRAINT [PK_ProductClass] PRIMARY KEY CLUSTERED ( [pClassId] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] /****** 对象: Table [dbo].[Products] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[Products]( [id] [int] IDENTITY(1,1) NOT NULL, [pBigClass] [nvarchar](255) NULL, [pSmallClass] [nvarchar](255) NULL, [pTitle] [nvarchar](255) NULL, [pItemA] [nvarchar](255) NULL, [pItemB] [nvarchar](255) NULL, [pItemC] [nvarchar](255) NULL, [pItemD] [nvarchar](255) NULL, [pItemE] [nvarchar](255) NULL, [pUprice] [money] NULL, CONSTRAINT [PK_Products] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] /****** 对象: Table [dbo].[QuickMenu] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[QuickMenu]( [id] [int] IDENTITY(1,1) NOT NULL, [Sort] [int] NULL, [Title] [nvarchar](50) NULL, [Url] [nvarchar](255) NULL, [QuickYN] [int] NULL, CONSTRAINT [PK_QuickMenu] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] /****** 对象: Table [dbo].[Records] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[Records]( [rId] [int] IDENTITY(1,1) NOT NULL, [cId] [int] NULL, [rType] [nvarchar](50) NULL, [rState] [nvarchar](50) NULL, [rLinkman] [nvarchar](50) NULL, [rNextTime] [datetime] NULL, [rRemind] [int] NULL, [rContent] [ntext] NULL, [rUser] [nvarchar](50) NULL, [rTime] [datetime] NULL, CONSTRAINT [PK_Records] PRIMARY KEY CLUSTERED ( [rId] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[SelectData] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[SelectData]( [SelectID] [int] IDENTITY(1,1) NOT NULL, [Select_Type] [nvarchar](50) NULL, [Select_Star] [nvarchar](50) NULL, [Select_Source] [nvarchar](50) NULL, [Select_Zhiwei] [nvarchar](50) NULL, [Select_Sex] [nvarchar](50) NULL, [Select_Records] [nvarchar](50) NULL, [Select_Hetong] [nvarchar](50) NULL, [Select_Service] [nvarchar](50) NULL, [Select_YN] [nvarchar](50) NULL, [Select_SoftClass] [nvarchar](50) NULL, [Select_NoticeClass] [nvarchar](50) NULL, [Select_ExpenseIN] [nvarchar](50) NULL, [Select_ExpenseOUT] [nvarchar](50) NULL, CONSTRAINT [PK_SelectData] PRIMARY KEY CLUSTERED ( [SelectID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] /****** 对象: Table [dbo].[Service] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[Service]( [sid] [int] IDENTITY(1,1) NOT NULL, [cId] [int] NULL, [ProId] [int] NULL, [sTitle] [nvarchar](255) NULL, [sLinkman] [nvarchar](50) NULL, [sType] [nvarchar](50) NULL, [sSDate] [datetime] NULL, [sEDate] [datetime] NULL, [sContent] [ntext] NULL, [sSolve] [int] NULL, [sInfo] [ntext] NULL, [sUser] [nvarchar](50) NULL, [sTime] [datetime] NULL, CONSTRAINT [PK_Service] PRIMARY KEY CLUSTERED ( [sid] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[system_group] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[system_group]( [gId] [tinyint] NULL , [gName] [nvarchar](24) NULL ) ON [PRIMARY] /****** 对象: Table [dbo].[system_level] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[system_level]( [lId] [tinyint] NULL, [lName] [nvarchar](16) NULL, [lQxfalg] [nvarchar](255) NULL ) ON [PRIMARY] /****** 对象: Table [dbo].[user] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[user]( [uId] [int] IDENTITY(1,1) NOT NULL, [uAccount] [nvarchar](16) NULL, [uPassword] [nvarchar](16) NULL, [uName] [nvarchar](16) NULL, [uGroup] [int] NULL, [uLevel] [int] NULL, [uQxflag] [nvarchar](255) NULL, [uMobile] [nvarchar](50) NULL, [uEmail] [nvarchar](255) NULL, [uAddress] [nvarchar](255) NULL, [uBirthday] [datetime] NULL, [uCard] [nvarchar](18) NULL, [uAddtime] [datetime] NULL, [uManagerange] [ntext] NULL, [uClientNum] [int] NULL, CONSTRAINT [PK_user] PRIMARY KEY CLUSTERED ( [uId] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] /****** 对象: Table [dbo].[userlog] ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[userlog]( [id] [int] IDENTITY(1,1) NOT NULL, [olname] [nvarchar](50) NULL, [olstarttime] [datetime] NULL, [olip] [nvarchar](50) NULL, CONSTRAINT [PK_userlog] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]