bsms_table.txt

来自「实现JSP开发的BBS源码」· 文本 代码 · 共 91 行

create database BSMS

drop table admintable;
create table admintable(
                        adminname char(16)
                        ,code char(8)
);

insert into adminTable values('Admin','12345678');
insert into adminTable values('yukechao','12345678');

drop table cardtable;

create table cardTable(
                       userCardNum char(19) primary key
                      ,balance char(8)
                      ,code char(8) not null
                   
                      
);


drop table userTable;


create table userTable(
                       userID char(8) primary key
                      ,userIDCard char(18) not null
                      ,userName char(16) not null
                      ,birthday char(10) 
                      ,sex char(6) not null
                      ,addr char(30) not null
                      ,tel char(11)
                      ,userCardNum char(19)
);

select * from admintable

select * from usertable;

select * from cardtable;



******************************************************************8
create database BSMS

backup database BSMS to disk='g:\BSMS\backup\BSMS.bak' with init;

drop table admintable;
create table admintable(
                        adminname char(16)
                        ,code char(8)
);

insert into adminTable values('Admin','12345678');
insert into adminTable values('yukechao','12345678');

drop table cardtable;

create table cardTable(
                       userCardNum char(19) primary key
                      ,balance char(8)
                      ,code char(8) not null
                   
                      
);


drop table userTable;


create table userTable(
                       userID char(8) primary key
                      ,userIDCard char(18) not null
                      ,userName char(16) not null
                      ,birthday char(10) 
                      ,sex char(6) not null
                      ,addr char(30) not null
                      ,tel char(11)
                      ,userCardNum char(19)
);

select * from admintable

select * from usertable;

select * from cardtable


backup log BSMS to disk='g:\BSMS\backup\logs\BSMS.logs' with init;