DB_51aspx/Car.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

USE [ek_zuche]
GO
/****** Object:  User [zuche]    Script Date: 2015/1/27 12:28:25 ******/
CREATE USER [zuche] FOR LOGIN [zuche] WITH DEFAULT_SCHEMA=[zuche]
GO
sys.sp_addrolemember @rolename = N'db_owner', @membername = N'zuche'
GO
/****** Object:  Schema [zuche]    Script Date: 2015/1/27 12:28:25 ******/
CREATE SCHEMA [zuche]
GO
/****** Object:  Table [dbo].[ek_amount_log]    Script Date: 2015/1/27 12:28:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ek_amount_log](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[user_id] [int] NULL,
	[user_name] [nvarchar](100) NULL,
	[type] [nvarchar](50) NULL,
	[order_no] [nvarchar](100) NULL,
	[payment_id] [int] NULL,
	[value] [decimal](9, 2) NULL,
	[remark] [nvarchar](500) NULL,
	[status] [tinyint] NULL,
	[add_time] [datetime] NULL,
	[complete_time] [datetime] NULL,
 CONSTRAINT [PK_DT_AMOUNT_LOG] 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
/****** Object:  Table [dbo].[ek_article]    Script Date: 2015/1/27 12:28:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ek_article](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[channel_id] [int] NULL,
	[category_id] [int] NULL,
	[title] [nvarchar](100) NULL,
	[link_url] [nvarchar](500) NULL,
	[img_url] [nvarchar](500) NULL,
	[seo_title] [nvarchar](255) NULL,
	[seo_keywords] [nvarchar](255) NULL,
	[seo_description] [nvarchar](255) NULL,
	[new_author] [nvarchar](500) NULL,
	[new_from] [nvarchar](500) NULL,
	[new_desc] [nvarchar](500) NULL,
	[good_goods_no] [nvarchar](100) NULL,
	[good_stock_quantity] [int] NULL,
	[good_market_price] [decimal](9, 2) NULL,
	[good_sell_price] [decimal](9, 2) NULL,
	[good_reall_price] [decimal](9, 2) NULL,
	[good_score] [int] NULL,
	[content] [ntext] NULL,
	[sort_id] [int] NULL,