mysqlscripts.sql

struts+MySQL开发的简单客户关系管理系统

create database employees;

use employees;

create table employees
(
  username varchar(15) not null primary key,
  password varchar(15) not null,
  roleid integer not null,
  name varchar(30) not null,
  phone varchar(15) not null,
  email varchar(30) not null,
  depid integer not null
);

insert into employees values("abrickey", "$word", 1, "Art Brickey", "[phone]", "[e-mail]", 2);
insert into employees values("tharris", "ralph", 1, "Todd Harris", "[phone]", "[e-mail]", 2);
insert into employees values("sriley", "$mindy$", 2, "Sean Riley", "[phone]", "[e-mail]", 4);
insert into employees values("jgoodwill", "$pass$", 1, "James Goodwill", "[phone]", "[e-mail]", 3);
insert into employees values("tgray", "password", 2, "Tim Gray", "[phone]", "[e-mail]", 1);

create table roles
(
  roleid integer not null primary key,
  rolename varchar(30) not null
);

insert into roles values(1, "manager");
insert into roles values(2, "employee");


create table departments
(
  depid integer not null primary key,
  depname varchar(30) not null
);

insert into departments values(1, "Administration");
insert into departments values(2, "Network");
insert into departments values(3, "Sales");
insert into departments values(4, "Engineering");