/*
SQLyog Community v13.3.0 (64 bit)
MySQL - 8.0.42-0ubuntu0.20.04.1 : Database - webrtc
*********************************************************************
*/



CREATE DATABASE /*!32312 IF NOT EXISTS*/`webrtc` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `webrtc`;

/*Table structure for table `hotel_tables` */


CREATE TABLE `hotel_tables` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hotel_id` int NOT NULL,
  `table_number` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `hotel_id` (`hotel_id`),
  CONSTRAINT `hotel_tables_ibfk_1` FOREIGN KEY (`hotel_id`) REFERENCES `hotels` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `hotel_tables` */

insert  into `hotel_tables`(`id`,`hotel_id`,`table_number`) values 
(1,2,1),
(2,3,1),
(3,3,2),
(4,4,1);

