youku项目离线表脚本

CREATE TABLE [dbo].[t_sys_offline] (
 [fguid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
 [issync] [int] NULL ,
 [fdate] [datetime] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[t_sys_offline] ADD
 CONSTRAINT [DF_t_sys_offline_issync] DEFAULT (0) FOR [issync],
 CONSTRAINT [DF_t_sys_offline_fdate] DEFAULT (getdate()) FOR [fdate],
 CONSTRAINT [PK_t_sys_offline] PRIMARY KEY  CLUSTERED
 (
  [fguid]
 )  ON [PRIMARY]
GO