Issue/16

db/migrations/1524235595755_add_table_agent.js

-/*
- * Copyright (C) 2018 Centro de Computacao Cientifica e Software Livre
- * Departamento de Informatica - Universidade Federal do Parana - C3SL/UFPR
- *
- * This file is part of pinsis
- *
- * pinsis is free software; you can redistribute it and/or
- * modify it under the terms of the GNU General Public License
- * as published by the Free Software Foundation; either version 2
- * of the License, or (at your option) any later version.
- *
- * This program is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- * GNU General Public License for more details.
- *
- * You should have received a copy of the GNU General Public License
- * along with this program; if not, write to the Free Software
- * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301,
- * USA.
-*/
-
-exports.shorthands = undefined;
-
-exports.up = (pgm) => {
-    
-    // Agent information
-    pgm.createTable("agent", {
-        id: {type: "BIGSERIAL", primaryKey: true},
-        hospital_name: { type: "VARCHAR(16)", notNull: true },
-        geo_long: { type: "FLOAT", notNull: true },
-        geo_lat: { type: "FLOAT", notNull: true },
-        countie: { type: "VARCHAR(64)", notNull: true },
-        state: { type: "VARCHAR(64)", notNull: true },
-        region: { type: "VARCHAR(64)", notNull: true },
-    });
-};
-
-exports.down = (pgm) => {
-    // Drop all created tables in this migrate
-    pgm.dropTable( "agent");
-};