create database training;

create database training;

use training;

#create dabase tables

# Database: train
# Table: 'product'
#
create table product(
     id integer AUTO_INCREMENT primary key,
     name varchar(30),
     retailprice  decimal(10,2),
     wholesaleprice decimal(10,2),
     description   varchar(50),
     quantity    integer
);

# Host: localhost
# Database: train
# Table: user_account
#
create table user_account(
    user_id varchar(20) not null primary key,
    password varchar(20) not null
);

insert into user_account values("admin","admin");
insert into user_account values("customer","customer");