create database buyistic;
create table buyistic.accounts
(
    uuid     text not null,
    username text not null,
    password text not null
);
create table buyistic.items
(
    imgurl        text  not null,
    nowprice      float not null,
    rawprice      float not null,
    title         text  not null,
    detail        text  not null,
    id            int auto_increment primary key,
    categories    text  not null,
    type          int   not null,
    introductions text  not null
);
create table buyistic.orders
(
    orderid    text      not null,
    itemid     int       not null,
    createTime timestamp not null,
    status     int       not null,
    price      double    not null,
    userid     text      not null
);