--
-- Host: localhost    Database: norules_community
-- ------------------------------------------------------


--
-- Table structure for table `blacklist`
--

CREATE TABLE `blacklist` (
  `id` char(36) NOT NULL DEFAULT (uuid()),
  `nama` varchar(150) NOT NULL,
  `nickname` varchar(150) NOT NULL,
  `status` varchar(50) NOT NULL,
  `durasi` varchar(100) DEFAULT 'PERMANEN',
  `alasan` text,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `blacklist`
--


--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` char(36) NOT NULL DEFAULT (uuid()),
  `title` varchar(180) NOT NULL,
  `description` text,
  `event_date` date NOT NULL,
  `banner_url` longtext,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `events`
--


--
-- Table structure for table `feedback`
--

CREATE TABLE `feedback` (
  `id` char(36) NOT NULL DEFAULT (uuid()),
  `name` varchar(150) DEFAULT NULL,
  `category` varchar(50) NOT NULL,
  `message` text NOT NULL,
  `is_read` tinyint(1) DEFAULT '0',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `feedback`
--


--
-- Table structure for table `testers`
--

CREATE TABLE `testers` (
  `id` char(36) NOT NULL DEFAULT (uuid()),
  `nama` varchar(150) NOT NULL,
  `whatsapp` varchar(30) NOT NULL,
  `is_online` tinyint(1) DEFAULT '0',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `testers`
--



