《灵泉之悍妇当家》百度网盘txt最新全集下载:
链接:https://pan.baidu.com/s/1rq6JdWf0GmjES_ZXYDBuEA
?pwd=fz8f 提取码:fz8f简介:
得了灵泉以为末世要来的女医师崔乐蓉从大城市隐居到了小乡村,可惜末世一直没来,一不留神却穿越到了古代。古代不可怕,最怕有人渣!父母亲厚,却是家徒四壁,上有极品偏心奶奶死要钱,下有奇葩亲戚不开眼。奇葩婶婶看上了亲事坏了名声生生要将人逼死,奶奶拉偏架不管不问只管伸手要钱。崔乐蓉冷笑一声,吃了我的给我吐出来,拿了我的给我还回来。我倒霉了谁也别想好过。婶婶坏我亲事想要自嫁女,那就让堂妹也跟着一起坏了名声当老姑婆。奶奶死要钱从此计算分明一分钱也别想多拿!大姑小姑上门打秋风统统赶出去!本想靠着医术和灵泉带着一家子发家致富走上小康之路,却不想父母给定了秀才亲。骗婚?夺嫁妆?三从四德?当牛做马?恶妇狰狞一笑,敢算计欺负老娘,不搅得你们家鸡飞狗跳老娘就不姓崔!
直接给你代码,你在查询语句里执行一次就可以了use master
go
----查询是否存在bbsDB数据库,有的话删除----
if exists (select * from sysdatabases where name='bbsDB')
drop database bbsDB
go
----创建bbsDB数据库----
create database bbsDB
on primary
(
name='bbsDB_data',
filename='D:\BBS数据库zxy\bbsDB_data.mdf',
size=10MB,
filegrowth=20%
)
log on
(
name='bbsDB_log',
filename='D:\BBS数据库zxy\bbsDB_log.ldf',
size=3MB,
maxsize=20MB,
filegrowth=10%
)
go
use bbsDB
go
----创建表----
--是否已经存在bbsUsers表(用户表),存在就删除
if exists (select * from sysobjects where name='bbsUsers')
drop table bbsUsers
--创建bbsUsers表
create table bbsUsers
(
UID int identity(1,1) not null,
Uname varchar(15) not null,
Upassword varchar(10),
Ubirthday datetime not null,
Uemail varchar(20),
Usex bit not null,
Uclass int not null,
Uremark varchar(20),
UregDate datetime not null,
Ustate int ,
Upoint int
)
go
--为bbsUsers表添加约束
alter table bbsUsers
add constraint PK_UID
primary key (UID)
alter table bbsUsers
add constraint DF_Upassword
default(888888)for Upassword
alter table bbsUsers
add constraint CK_Upassword
check (len(Upassword)>=6)
alter table bbsUsers
add constraint CK_Uemail
check(Uemail like '%@%')
alter table bbsUsers
add constraint DF_Usex
default (1) for Usex
alter table bbsUsers
add constraint DF_Uclass
default (1) for Uclass
alter table bbsUsers
add constraint DF_UregDate
default(getdate())for UregDate
alter table bbsUsers
add constraint DF_Ustate
default (0)for Ustate
alter table bbsUsers
add constraint DF_Upoint
default (20)for Upoint
go
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)