drop table if exists studios;
create table studios (
id int not null auto_increment,
title varchar(100) not null,
confirmed_listing tinyint(1) unsigned NOT NULL default '0',
confirmed_deletion tinyint(1) unsigned NOT NULL default '0',
description text not null,
image_url varchar(200) not null,
price decimal(10,2) not null,
latitude decimal(10,2) not null,
longitude decimal(10,2) not null,
date_available datetime not null,
email varchar(100) not null,
created_at datetime not null,
updated_at datetime not null,
primary key (id)
);
drop table if exists users;
  CREATE TABLE users (                                                                                           
    id int(11) NOT NULL auto_increment,                                                                          
    login varchar(80) default NULL,                                                                              
    password varchar(40) default NULL,                                                                           
    PRIMARY KEY  (id)                                                                                            
  );