gistfile1.sql

CREATE TABLE "aeropuertos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "descripcion" varchar(255) DEFAULT NULL NULL, "country_id" integer DEFAULT NULL NULL, "province_id" integer DEFAULT NULL NULL, "city_id" integer DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL);
CREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255) DEFAULT NULL NULL, "province_id" integer DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL);

CREATE TABLE "countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255) DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL);

CREATE TABLE "planes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "codigo" varchar(255) DEFAULT NULL NULL, "cant_tripulacion" integer DEFAULT NULL NULL, "cant_asientos_turista" integer DEFAULT NULL NULL, "cant_asientos_business" integer DEFAULT NULL NULL, "cant_asientos_primera" integer DEFAULT NULL NULL, "fabricante" varchar(255) DEFAULT NULL NULL, "modelo" varchar(255) DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL);

CREATE TABLE "provinces" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255) DEFAULT NULL NULL, "country_id" integer DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL);

CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL);
CREATE TABLE "tipos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255) DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL);
CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar(40) DEFAULT NULL NULL, "name" varchar(100) DEFAULT '' NULL, "email" varchar(100) DEFAULT NULL NULL, "crypted_password" varchar(40) DEFAULT NULL NULL, "salt" varchar(40) DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL, "remember_token" varchar(40) DEFAULT NULL NULL, "remember_token_expires_at" datetime DEFAULT NULL NULL);
CREATE TABLE "vuelo_details" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "vuelo_id" integer DEFAULT NULL NULL, "asiento" integer DEFAULT NULL NULL, "pasajero_nombre" varchar(255) DEFAULT NULL NULL, "pasajero_apellido" varchar(255) DEFAULT NULL NULL, "pasajero_documento" varchar(255) DEFAULT NULL NULL, "observaciones" text DEFAULT NULL NULL, "reserve_type" integer DEFAULT NULL NULL, "user_id" integer DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL);
CREATE TABLE "vuelo_statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255) DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL);
CREATE TABLE "vuelos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "codigo" varchar(255) DEFAULT NULL NULL, "plane_id" integer DEFAULT NULL NULL, "aeropuerto_origen_id" integer DEFAULT NULL NULL, "aeropuerto_destino_id" integer DEFAULT NULL NULL, "fecha_salida" date DEFAULT NULL NULL, "fecha_llegada" date DEFAULT NULL NULL, "status_id" integer DEFAULT NULL NULL, "tipo_id" integer DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL);
CREATE UNIQUE INDEX "index_users_on_login" ON "users" ("login");
CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version");