DB 구축

//접속

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');