db.sql

来自「一个公司管理系统,用简单的htmlt要servlet做的,有增.查.改功能.适合」· SQL 代码 · 共 30 行

create database tarena;

use tarena;

drop table users;


create table users (
userid int auto_increment primary key,
username varchar(50),
password varchar(50),
role varchar(20)
);


drop table company;

create table company (
id int auto_increment primary key,
name varchar(50),
city varchar(20),
address varchar(100),
scale varchar(10),
requiretech varchar(20),
kind varchar(2),
email varchar(70),
description varchar(255)
);