text: # --- Created by Ebean DDL
  # To stop Ebean DDL generation, remove this comment and start using Evolutions
  
  # --- !Ups
  
  create table category (
    id                            integer auto_increment not null,
    name                          varchar(255),
    parent_id                     varchar(255),
    constraint pk_category primary key (id)
  );
  
  create table person (
    id                            integer auto_increment not null,
    name                          varchar(255),
    email                         varchar(255),
    password                      varchar(255),
    constraint pk_person primary key (id)
  );
  
  create table product (
    id                            bigint auto_increment not null,
    name                          varchar(255),
    price                         integer,
    location                      varchar(255),
    constraint pk_product primary key (id)
  );
  
  
  # --- !Downs
  
  drop table if exists category;
  
  drop table if exists person;
  
  drop table if exists product;
  
  