//접속
mysql -uroot -pmysql
CREATE DATABASE PCROOM_DB
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
use PCROOM_DB;
//USER 테이블 생성
CREATE TABLE USER(
num INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
id VARCHAR(20) NOT NULL UNIQUE KEY,
pwd VARCHAR(20) ,
name VARCHAR(40),
age INT(11),
phone VARCHAR(20),
mileage INT(11),
indate TIMESTAMP
);
//USER 데이터 입력
INSERT INTO USER (id,pwd,name,age,phone,mileage) VALUES
('admin','1234','관리자','26','111-11111','0'),
('hong','1234','홍길동','27','1234-5678','1000'),
('kim','1234','김철수','35','0000-0000','2500');
//PRODUCT 테이블 생성
CREATE TABLE PRODUCT(
num INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(40) NOT NULL UNIQUE KEY,
price INT(11),
amount INT(11),
indate TIMESTAMP
);
//PRODUCT 데이터 입력
INSERT INTO PRODUCT (name,price,amount) VALUES
('라면','1500','20'),
('빵','1500','30'),
('음료','1000','50');
//SALES 테이블 생성
CREATE TABLE SALES(
num INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
seat INT(11),
indate TIMESTAMP,
sales INT(11),
total_sales INT(11)
);
//SALES 초기값 입력
INSERT INTO SALES (seat,sales,total_sales) VALUES
('0','0','0');