-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `feedback`
--

-- --------------------------------------------------------

--
-- Table structure for table `branches`
--

CREATE TABLE IF NOT EXISTS `branches` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `active` int NOT NULL,
  `deleted` int NOT NULL,
  `feed_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `feed_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `feed_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `feed_4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `feed_5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `about` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `branches`
--

INSERT INTO `branches` (`id`, `name`, `created_at`, `active`, `deleted`, `feed_1`, `feed_2`, `feed_3`, `feed_4`, `feed_5`, `location`, `logo`, `title`, `about`) VALUES
(1, 'Coffee Castle Murree Cant', '2026-03-11 19:56:51', 1, 0, 'Food Quality', 'Service Quality', ' Cleanliness', 'Ambience', ' Value for Money', 'uploads/', '17788452170.png', 'Coffee Castle', ''),
(2, 'test', '2026-03-11 20:12:05', 1, 1, 'Food Quality', 'Service Quality', ' Cleanliness', 'Ambience', ' Value for Money', 'uploads/', '', 'test', '');

-- --------------------------------------------------------

--
-- Table structure for table `company`
--

CREATE TABLE IF NOT EXISTS `company` (
  `id` int NOT NULL AUTO_INCREMENT,
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `feedbacks`
--

CREATE TABLE IF NOT EXISTS `feedbacks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dob` varchar(220) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `FoodQualityrating` int NOT NULL,
  `FoodPresentationrating` int NOT NULL,
  `Atmosphererating` int NOT NULL,
  `Ambiancerating` int NOT NULL,
  `Servicerating` int NOT NULL,
  `message` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `branch_id` int NOT NULL,
  `feed_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `feed_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `feed_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `feed_4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `feed_5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feedbacks`
--

INSERT INTO `feedbacks` (`id`, `name`, `email`, `number`, `dob`, `FoodQualityrating`, `FoodPresentationrating`, `Atmosphererating`, `Ambiancerating`, `Servicerating`, `message`, `branch_id`, `feed_1`, `feed_2`, `feed_3`, `feed_4`, `feed_5`, `deleted`, `created_date`) VALUES
(1, 'gdfg', '', '32156456', '', 3, 4, 4, 3, 3, 'sdfg  sfgd s gf', 1, '', '', '', '', '', 1, '2026-03-11 20:17:49'),
(2, 'Kitchen KOT Printer', '', '132156', '0', 3, 5, 2, 4, 4, 'fg  sdf adsf a', 1, '', '', '', '', '', 1, '2026-03-11 20:23:09'),
(3, 'test', '', '132156', '0', 4, 2, 4, 3, 4, 'afd a dfa adfa', 1, '', '', '', '', '', 1, '2026-03-11 20:36:55'),
(4, 'drive thorgh', '', '132156', '0', 2, 3, 4, 5, 5, 'gds  sfgs sfg', 1, '', '', '', '', '', 1, '2026-03-11 20:38:29'),
(5, 'Kitchen KOT Printer', '', '132156', '0', 3, 3, 3, 5, 4, 'f asdf adsfasddafsd', 1, '', '', '', '', '', 1, '2026-03-11 20:38:44'),
(6, 'fsaf', '', '132156', '0', 3, 4, 5, 4, 5, 'af dasfasfdasfasf asd fdasf as', 1, '', '', '', '', '', 1, '2026-03-11 20:39:24'),
(7, 'Muneeb', '', '13212465', '0', 5, 4, 4, 5, 5, 'fsad asdf ads adfasd', 1, '', '', '', '', '', 1, '2026-03-11 22:33:37'),
(8, 'ITResources', '', '03113917777', '0', 5, 5, 5, 5, 5, 'This Is Test FeedBack', 1, '', '', '', '', '', 0, '2026-05-15 16:42:43');
COMMIT;

