sql.txt

简单邮电信息管理

create database ComDB
 on primary
( name=ComDB_data1,
filename='E:\sql_data\ComDB_data1.mdf',
size=1mb,
maxsize=unlimited,
filegrowth=10%)
log on
(name='ComDB_log1',
filename='E:\sql_data\ComDB_log1.ldf',
size=1mb,
maxsize=25mb,
filegrowth=10%)

create table Cust_Info(
ID int not null primary key,
Name varchar null,
Id_code varchar null,
Xb varchar null,
Birth_Date datetime null,
Zip varchar null,
Age int null,
Address varchar null,
Tel varchar null,
Source varchar null,
PurNum int null,
C_Date datetime null,
C_money money null,
Memo varchar null
)

create table Order_Info(
ID int null,
Cust_Name varchar null,
O_Date datetime null,
Order_M money null,
Post_price money null,
Should_M char(10) null,
Diff money null,
Finish varchar null,
Memo ntext null
)

create table Order_M(
Order_ID int null,
Stor_ID varchar null,
S_Size varchar null,
Num int null,
Post_ID varchar null,
Postprice money null,
Send_Date datetime null,
Pri_O money null,
Flag varchar null,
Memo varchar null
)

create table Shop_Info(
ID varchar null,
S_Size varchar null,
Num int null,
S_Date datetime null,
Ghf varchar null
)

create table Stor_Info(
ID varchar null,
S_Size varchar null,
Quantity int null,
Memo varchar null
)

create table Out_Info(
Stor_ID varchar not null primary key,
S_Size varchar null,
Num int null,
O_Date datetime null,
Memo varchar null
)

create table Price_Info(
Stor_ID varchar not null primary key,
M_Price money null,
Cost money null,
P_Date datetime null,
Memo varchar(200) null
)

create table User_Info(
User_ID int not null primary key,
User_Name  varchar null,
User_Pswd varchar null,
User_Limit varchar null,
User_Time datetime null
)