github.com/mmatczuk/gohan@v0.0.0-20170206152520-30e45d9bdb69/examples/db_migration/db/migrations/20151110132025_init_schema.sql (about)

     1  
     2  -- +goose Up
     3  -- SQL in section 'Up' is executed when this migration is applied
     4  create table `tests` (`id`varchar(255) primary key,`name`text null,`tenant_id`text null,`test5`text null,`description`text null);
     5  
     6  create table `networks` (`firewall_id`varchar(255) null,`id`varchar(255) primary key,`name`text not null,`tenant_id`text null,foreign key(`firewall_id`) REFERENCES `firewalls`(id) );
     7  
     8  create table `firewalls` (`id`varchar(255) primary key,`name`text not null,`tenant_id`text null);
     9  
    10  create table `firewall_rules` (`tenant_id`text null,`action`text not null,`destination_port`text not null,`firewall_id`varchar(255) not null,`id`varchar(255) primary key,`protocol`text not null,foreign key(`firewall_id`) REFERENCES `firewalls`(id) ,foreign key(`firewall_id`) REFERENCES `firewalls`(id) );
    11  
    12  create table `devices` (`id`varchar(255) primary key,`management_ip`text null,`name`text null,`status`text null,`tenant_id`text null);
    13  
    14  
    15  -- +goose Down
    16  -- SQL section 'Down' is executed when this migration is rolled back
    17  drop table networks;
    18  
    19  drop table firewalls;
    20  
    21  drop table firewall_rules;
    22  
    23  drop table devices;
    24  
    25  drop table tests;
    26