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

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