React Native 서버 구현 1

MariaDB

실행 명령어

• MariaDB 서버 실행
  brew services start mariadb
  
• MariaDB 서버 중지
  brew services stop mariadb
  
• MariaDB 서버 재시작
  brew services restart mariadb
  
• MariaDB 서버 실행 확인
  brew services list

HeidiSQL - MariaDB 내부를 편하게 볼 수 있는, SQL을 도와주는 툴

HeidiSQL
기본 틀 만들기

CREATE USER 'taxi'@'%' IDENTIFIED BY 'taxi';
GRANT ALL PRIVILEGES ON taxi.* TO 'taxi'@'%' IDENTIFIED BY 'taxi';
FLUSH PRIVILEGES;

유저 테이블

CREATE TABLE tb_user (
user_id VARCHAR(10) NOT NULL,
user_pw VARCHAR(10) NOT NULL,
fmc_token VARCHAR(255),
PRIMARY KEY (user_id)
);

기사 테이블

CREATE TABLE tb_driver (
driver_id VARCHAR(10) NOT NULL,
driver_pw VARCHAR(10) NOT NULL,
fmc_token VARCHAR(255),
PRIMARY KEY (driver_id)
);

콜 테이블

CREATE TABLE tb_call (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id VARCHAR(10) NOT NULL,
start_lat VARCHAR(100) NOT NULL,
start_lng VARCHAR(100) NOT NULL,
start_addr VARCHAR(255) NOT NULL,
end_lat VARCHAR(100) NOT NULL,
end_lng VARCHAR(100) NOT NULL,
end_addr VARCHAR(255) NOT NULL,
call_state VARCHAR(10) NOT NULL,
driver_id VARCHAR(10)
);