2.sql

具备用户登录校验、数据库中相关数据表中数据的添加、修改、删除、检索、统计分析等有关功能

create table users(
uid char(10) primary key,
pwd char(10),
jb  bit
);

CREATE TABLE customers (
no char(10) , 
name char(10), 
sex char(1) , id char(10), 
address varchar(100) , 
phone char(11) , 
e_mail char(30),
producttype char(1),
PRIMARY KEY(no,name)
);
create table workers(
id char(10),
name char(10),
address varchar(100),
phone char(11),
salary char(10),
zhiwu char(10),
primary key (id,name)
);