Web Game 서버 제작 7일차

db 생성함.

use RS_Act;

drop table IF EXISTS user_info;

drop table IF EXISTS friends_list;

drop table IF EXISTS inventory;

drop table IF EXISTS item_list;

drop table IF EXISTS ui_log;

create table user_info (

user_id int unsigned not null auto_increment primary key,

nick_name char(30) not null,

password char(30) not null,

gold int unsigned,

potion int unsigned,

note int unsigned,

high_score int unsigned,

weekly_high_score int unsigned

);

create table friends_list (

owner_id int unsigned not null primary key,

friend_id int unsigned

);

create table inventory (

owner int unsigned not null primary key,

item_id int unsigned,

count int unsigned,

get_date timestamp,

start_date datetime default '0000-00-00 00:00:00',

valid_date datetime default '0000-00-00 00:00:00'

);

create table item_list (

item_id int unsigned not null primary key,

item_name char(30) not null,

item_type int unsigned,

valid_date datetime default '0000-00-00 00:00:00',

item_desc text not null

);

create table ui_log (

owner_id int unsigned not null primary key,

log_time timestamp not null,

log_type int unsigned,

log_text text

);