cbrhex

<?php

if (! function_exists('dbd')) {
    /**
     * Showing all database queries.
     * Отображение всех запросов в базу.
     *
     * @param null|\Illuminate\Console\Command|\Psr\Log\LoggerInterface $channel
     */
    function dbd($channel = null)

cbrhex

// REGIONS
        Schema::create('regions', function (Blueprint $table) {
            $table->increments('id');
            $table->tinyInteger('code')->unique();
            $table->string('title', 25)->unique();
            $table->string('image');
            $table->string('description', 100);
            $table->timestamps();
        });

cbrhex

CREATE DEFINER=`root`@`root` PROCEDURE `procedure_name`()
BEGIN

  IF (SELECT count(*)
    FROM information_schema.TABLES
    WHERE 
      TABLE_SCHEMA = 'DB_NAME' -- Database name
      AND TABLE_NAME = 'TABLE_NAME' AND ...) = 0 THEN
      SELECT ...; -- not exists
        ELSE