Advertisement
Guest User

Untitled

a guest
May 20th, 2024
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Ruby 1.07 KB | None | 0 0
  1. def db__setup__create_tables()
  2.   DB.create_table :domains do
  3.     primary_key :id
  4.     String :name
  5.   end
  6.   DB.create_table :locus do
  7.     primary_key :id
  8.     String :name
  9.   end
  10.   DB.create_table :lifecycle_stages do
  11.     primary_key :id
  12.     String :name
  13.   end
  14.   DB.create_table :environments do
  15.     primary_key :id
  16.     String :name
  17.   end
  18.   DB.create_table :service_types do
  19.     primary_key :id
  20.     String :name
  21.   end
  22.   DB.create_table :servers_services do
  23.     primary_key :id
  24.     foreign_key :servers_id, :servers # FKEY to servers.id
  25.     foreign_key :services_id, :services # FKEY to services.id
  26.   end
  27.   DB.create_table :services do
  28.     primary_key :id
  29.     String :name
  30.     foreign_key :service_types_id, :service_types # FKEY to service_types.id
  31.   end
  32.   DB.create_table :servers do
  33.     primary_key :id
  34.     foreign_key :domains_id, :domains # FKEY to domains.id
  35.     foreign_key :environments_id, :environment # FKEY to environment.id
  36.     foreign_key :lifecycles_id, :lifecycle # FKEY to lifecycle.id
  37.     foreign_key :locus_id, :locus # FKEY to locus.id
  38.   end
  39. end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement