sql.sql

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

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

/****** Object:  Database [mall]    Script Date: 04/25/2012 16:10:22 ******/
CREATE DATABASE [mall] ON  PRIMARY 
( NAME = N'mall', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mall.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'mall_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mall_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO

USE [mall]
GO

CREATE TABLE [dbo].[mall_admin](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[username] [nvarchar](50) NULL,
	[password] [nvarchar](50) NULL,
	[role] [nvarchar](50) NULL,
	[isopen] [nvarchar](50) NULL,
	[name] [nvarchar](50) NULL,
	[sex] [nvarchar](10) NULL,
	[age] [nvarchar](50) NULL,
	[address] [nvarchar](200) NULL,
	[remark] [ntext] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

INSERT INTO [mall].[dbo].[mall_admin]
           ([username]
           ,[password]
           ,[role]
           ,[isopen]
           ,[name]
           ,[sex]
           ,[age]
           ,[address]
           ,[remark])
     VALUES
           ('admin'
           ,'21232F297A57A5A743894A0E4A801FC3'
           ,'管理员'
           ,'yes'
           ,'管理员'
           ,'男'
           ,'30'
           ,'奇岩'
           ,'高达德')







CREATE TABLE [dbo].[mall_kucun](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[pid] [nvarchar](50) NULL,
	[quantity] [int] NULL
) ON [PRIMARY]


CREATE TABLE [dbo].[mall_member](
	[id] [int] IDENTITY(1,1) NOT NULL,