create database board;
use board;

create table topic(
board_idx int(11) PRIMARY KEY AUTO_INCREMENT,
title varchar(45),
description text,
price varchar(50),
created datetime,
image varchar(100),
author_name varchar(20)
);

INSERT INTO topic(board_idx,title,description,price,created,image,author_name) VALUES (1,'애플워치 팔아요','미개봉입니다','150\,000',now(),'1.PNG','김작성');
INSERT INTO topic(board_idx,title,description,price,created,image,author_name) VALUES (2,'애플워치 팔아요','미개봉입니다','150\,000',now(),'2.PNG','김작성');
INSERT INTO topic(board_idx,title,description,price,created,image,author_name) VALUES (3,'애플워치 팔아요','미개봉입니다','150\,000',now(),'3.PNG','김작성');
INSERT INTO topic(board_idx,title,description,price,created,image,author_name) VALUES (4,'애플워치 팔아요','미개봉입니다','150\,000',now(),'4.PNG','김작성');

    
    INSERT INTO topic
    (image, title, description, price, author_name, created)
    VALUES(
        '애플워치.PNG',
        '애플워치 팔아요.',
        '미개볼입니다.',
        '250000',
        '홍성표',
        NOW()
    )

    CREATE TABLE `member_data` (
  `token_idx` int(11) NOT NULL,
  `tokenID` varchar(255) NOT NULL,
  `created` datetime NOT NULL
)