Breaking News: Grepper is joining You.com. Read the official announcement!

migrations

Innocent Iguana answered on July 22, 2022 Popularity 8/10 Helpfulness 1/10

answer migrations

related Migrations#

migrations

Comment

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateUsersTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->id();
            $table->string('name');
	      // Create other columns
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('users');
    }
}

Popularity 8/10 Helpfulness 1/10 Language whatever

Source: www.interviewbit.com

Tags: whatever

Link to this answer
Share Copy Link

Contributed on Jul 22 2022

Innocent Iguana

0 Answers Avg Quality 2/10

Closely Related Answers

Migrations#

Comment

The database layer should provide programmatic access to the database and also manage changes in the database. The latter is called migrations or evolutions. We will use Flyway as the tool to manage our database schema.

Flyway uses raw SQL scripts that have to be put into a certain location and follow certain naming conventions. This is the /db/migration (under the resources folder) in our case. The files also have to be named following the convention VXX__some_name.sql, where XX is the version number. Please note that there are two underscores between the version prefix and the rest of the name.

Because our database schema is straightforward, we get done quickly.

CREATE TABLE "products" (
  "id" UUID NOT NULL,
  CONSTRAINT "products_pk" PRIMARY KEY ("id")
);

COMMENT ON TABLE "products" IS 'This table holds all product keys.';
COMMENT ON COLUMN "products"."id" IS 'The unique product ID.';

CREATE TABLE "names" (
  "product_id" UUID       NOT NULL,
  "lang_code"  VARCHAR(2) NOT NULL,
  "name"       TEXT       NOT NULL,
  CONSTRAINT "names_pk" PRIMARY KEY ("product_id", "lang_code"),
  CONSTRAINT "names_product_id_fk" FOREIGN KEY ("product_id") REFERENCES "products" ("id") ON DELETE CASCADE ON UPDATE CASCADE
);

COMMENT ON TABLE "names" IS 'This table holds all translations for all products. Deletions and updates of products are cascaded.';
COMMENT ON COLUMN "names"."product_id" IS 'A foreign key on the product id.';
COMMENT ON COLUMN "names"."lang_code" IS 'A two letter ISO-639-1 language code.';
COMMENT ON COLUMN "names"."name" IS 'A localized product name.';

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on May 23 2023

Sumit Rawal

0 Answers Avg Quality 2/10

migrations

Contents

More Related Answers

migrations

Closely Related Answers

Migrations#

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.