CREATE TABLE g2_items (
    itemID bigint(20) unsigned not null auto_increment,
    name varchar(25) not null,
    units varchar(25) not null,
    price varchar(25) not null,
    min bigint(20) unsigned,
    max bigint(20) unsigned,
    maxTotal bigint(20) unsigned,
    userID bigint(20) not null,
    primary key (itemID)
);

CREATE TABLE g2_monthly (
    month varchar(25) not null,
    itemID bigint(20) not null,
    pickup varchar(255),
    primary key (month)
);

CREATE TABLE g2_users (
    userID bigint(20) unsigned not null auto_increment,
    name varchar(25) not null,
    email varchar(50),
    password varchar(25),
    type varchar(25) not null,
    address varchar(100),
    phone varchar(12),
    primary key (userID)
);

CREATE TABLE g2_orders (
    orderID bigint(20) unsigned not null auto_increment,
    userID bigint(20) not null,
    itemID bigint(20) not null,
    quantity bigint(20) not null,
    pickup varchar(50) not null,
    paid varchar(4) not null,
    month varchar(25) not null,
    primary key (orderID)
);

CREATE TABLE g2_farmers (
    farmerID bigint(20) unsigned not null auto_increment,
    name varchar(25) not null,
    email varchar(25),
    address varchar(100),
    phone varchar(12),
    farm_description varchar(1000),
    primary key (farmerID)
);

Questions for Coop:

What information about the farmers needs to be stored?
    -Phone? Address?

Can an order be placed for multiple items from different farmers?

Clarify ability to confirm order.