Dtcms4表結構示例sql · 旺財.Net企業信息化快速開發平臺

``` /****** Object: Table [dbo].[dt_blogroll] Script Date: 10/09/2017 16:43:18 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[dt_blogroll]( [id] [int] IDENTITY(1,1) NOT NULL, [site_path] [nvarchar](100) NULL, [title] [nvarchar](255) NULL, [user_id] [int] NULL, [user_name] [nvarchar](100) NULL, [user_tel] [nvarchar](20) NULL, [email] [nvarchar](50) NULL, [site_url] [nvarchar](255) NULL, [img_url] [nvarchar](255) NULL, [is_image] [int] NOT NULL, [sort_id] [int] NOT NULL, [click] [int] NOT NULL, [status] [tinyint] NOT NULL, [is_msg] [tinyint] NOT NULL, [is_top] [tinyint] NOT NULL, [is_red] [tinyint] NOT NULL, [is_hot] [tinyint] NOT NULL, [is_slide] [tinyint] NOT NULL, [is_lock] [tinyint] NOT NULL, [add_time] [datetime] NOT NULL, [add_ip] [nvarchar](50) NULL, [add_area] [nvarchar](100) NULL, [update_time] [datetime] NULL, [update_ip] [nvarchar](50) NULL, [update_area] [nvarchar](100) NULL, CONSTRAINT [PK_dt_blogroll] PRIMARY KEY CLUSTERED ( [id] 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 EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'編號' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'站點' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'site_path' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'標題' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'title' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用戶ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'user_id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用戶名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'user_name' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用戶電話' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'user_tel' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'郵件地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'email' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'網站鏈接' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'site_url' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'網站Logo地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'img_url' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否圖片鏈接' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'is_image' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'sort_id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'瀏覽次數' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'click' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'狀態(0正常1未審核2鎖定)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'status' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否允許評論' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'is_msg' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否置頂' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'is_top' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否推薦' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'is_red' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否熱門' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'is_hot' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否幻燈片' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'is_slide' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否鎖定' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'is_lock' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'創建時間' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'add_time' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'創建IP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'add_ip' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'創建區域' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'add_area' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改時間' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'update_time' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新IP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'update_ip' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新區域' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll', @level2type=N'COLUMN',@level2name=N'update_area' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'友情鏈接' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'dt_blogroll' GO ALTER TABLE [dbo].[dt_blogroll] ADD CONSTRAINT [DF_dt_blogroll_is_image] DEFAULT ((0)) FOR [is_image] GO ALTER TABLE [dbo].[dt_blogroll] ADD CONSTRAINT [DF_dt_blogroll_sort_id] DEFAULT ((99)) FOR [sort_id] GO ALTER TABLE [dbo].[dt_blogroll] ADD CONSTRAINT [DF_dt_blogroll_click] DEFAULT ((0)) FOR [click] GO ALTER TABLE [dbo].[dt_blogroll] ADD CONSTRAINT [DF_dt_blogroll_status] DEFAULT ((0)) FOR [status] GO ALTER TABLE [dbo].[dt_blogroll] ADD CONSTRAINT [DF_dt_blogroll_is_msg] DEFAULT ((0)) FOR [is_msg] GO ALTER TABLE [dbo].[dt_blogroll] ADD CONSTRAINT [DF_dt_blogroll_is_top] DEFAULT ((0)) FOR [is_top] GO ALTER TABLE [dbo].[dt_blogroll] ADD CONSTRAINT [DF_dt_blogroll_is_red] DEFAULT ((0)) FOR [is_red] GO ALTER TABLE [dbo].[dt_blogroll] ADD CONSTRAINT [DF_dt_blogroll_is_hot] DEFAULT ((0)) FOR [is_hot] GO ALTER TABLE [dbo].[dt_blogroll] ADD CONSTRAINT [DF_dt_blogroll_is_slide] DEFAULT ((0)) FOR [is_slide] GO ALTER TABLE [dbo].[dt_blogroll] ADD CONSTRAINT [DF_dt_blogroll_is_lock] DEFAULT ((0)) FOR [is_lock] GO ALTER TABLE [dbo].[dt_blogroll] ADD CONSTRAINT [DF_dt_blogroll_add_time] DEFAULT (getdate()) FOR [add_time] GO ```