Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.31 KB | None | 0 0
  1.    
  2.     Schema::create('telegram_users', function (Blueprint $table) {
  3.             $table->bigInteger('id'); // мне не нужен автоинкремент
  4.             $table->primary('id');
  5.             $table->string('name')->nullable();
  6.             $table->timestamps();
  7.         });
  8.  
  9.    Schema::create('telegram_bots', function (Blueprint $table) {
  10.             $table->bigInteger('id'); // мне не нужен автоинкремент
  11.             $table->primary('id');
  12.             $table->string('name');
  13.             $table->string('token');
  14.         });
  15.  
  16.     Schema::create('telegram_user-bot', function (Blueprint $table) {
  17.             $table->unsignedBigInteger('user_id');
  18.             $table->unsignedBigInteger('bot_id');
  19.  
  20.             $table->foreign('user_id')
  21.                 ->references('id')->on('telegram_users')
  22.                 ->onDelete('cascade');
  23.  
  24.             $table->foreign('bot_id')
  25.                 ->references('id')->on('telegram_bots')
  26.                 ->onDelete('cascade');
  27.  
  28.  
  29.             $table->primary(['user_id', 'bot_id']);
  30.         });
  31.  
  32.  
  33.    SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL: alter table `telegram_user_bot` add constraint `telegram_user_bot_user_id_foreign` foreign key (`user_id`) references `telegram_users` (`id`) on delete cascade)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement