Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Schema::create('telegram_users', function (Blueprint $table) {
- $table->bigInteger('id'); // мне не нужен автоинкремент
- $table->primary('id');
- $table->string('name')->nullable();
- $table->timestamps();
- });
- Schema::create('telegram_bots', function (Blueprint $table) {
- $table->bigInteger('id'); // мне не нужен автоинкремент
- $table->primary('id');
- $table->string('name');
- $table->string('token');
- });
- Schema::create('telegram_user-bot', function (Blueprint $table) {
- $table->unsignedBigInteger('user_id');
- $table->unsignedBigInteger('bot_id');
- $table->foreign('user_id')
- ->references('id')->on('telegram_users')
- ->onDelete('cascade');
- $table->foreign('bot_id')
- ->references('id')->on('telegram_bots')
- ->onDelete('cascade');
- $table->primary(['user_id', 'bot_id']);
- });
- 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