CREATE?TABLE?[dbo].[Zz_AccessIP]( ????[IP]?[nvarchar](50)?NOT?NULL, ????[FirstDateTime]?[datetime]?NOT?NULL, ????[LastDateTime]?[datetime]?NOT?NULL, ????[Times]?[int]?NOT?NULL, ?CONSTRAINT?[PK_Zz_AccessIP]?PRIMARY?KEY?CLUSTERED? ( ????[IP]?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 ? ALTER?TABLE?[dbo].[Zz_AccessIP]?ADD??CONSTRAINT?[DF_Zz_AccessIP_FirstDateTime]??default?(getdate())?FOR?[FirstDateTime] GO ? ALTER?TABLE?[dbo].[Zz_AccessIP]?ADD??CONSTRAINT?[DF_Zz_AccessIP_LastDateTime]??DEFAULT?(getdate())?FOR?[LastDateTime] GO ? ALTER?TABLE?[dbo].[Zz_AccessIP]?ADD??CONSTRAINT?[DF_Zz_AccessIP_Times]??DEFAULT?((0))?FOR?[Times] GO
? 版權聲明
文章版權歸作者所有,未經允許請勿轉載。
THE END