create_table.sql

use lesson1

drop table if exists users;
create table users(
id varchar(20) ,
token varchar(20),
name varchar(20),
primary key(id)
);

insert into users(id,token,name)values("sampleid1","sampletoken1","samplename1"),("sampleid2","sampletoken2","samplename2");

drop table if exists characters;
create table characters(
       characterid varchar(20),
       name varchar(20),
       primary key(characterid));

insert into characters (characterid,name) values ('chara1','a'),('chara2','b'),('chara3','c');

drop table if exists gachatable;
create table gachatable(
       characterid varchar(20),
       rate float unsigned,
       primary key(characterid)
       );

insert into gachatable (characterid,rate) values ('chara1',0.5),('chara2',0.3),('chara3',0.2);

drop table if exists usercharacter;
create table usercharacter(
       usercharacterid varchar(20),
       characterid varchar(20),
       userid varchar(20),
       primary key(usercharacterid)
       );

insert into usercharacter (usercharacterid,characterid,userid) values ('1','chara1','sampleid1'),(2,'chara1','sampleid1'),(3,'chara1','sampleid1'),(4,'chara2','sampleid1'),(5,'chara2','sampleid2'),(6,'chara3','sampleid3');