START TRANSACTION;
SET time_zone = "+00:00";

--
-- Database: `iresidenz_iresidenz`
--

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

--
-- Table structure for table `badge_bill`
--

CREATE TABLE `badge_bill` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `bill_id` int(11) NOT NULL,
  `read_status` varchar(1) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


CREATE TABLE IF NOT EXISTS `badge_bill_csv` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `bill_id` int(11) NOT NULL,
  `read_status` varchar(1) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


--
-- Table structure for table `badge_booking`
--

CREATE TABLE `badge_booking` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `booking_id` int(11) NOT NULL,
  `read_status` varchar(1) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


--
-- Table structure for table `badge_global_file`
--

CREATE TABLE `badge_global_file` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `file_list_id` int(11) NOT NULL,
  `read_status` varchar(1) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


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

--
-- Table structure for table `badge_global_gallery`
--

CREATE TABLE `badge_global_gallery` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `gallery_image_id` int(11) NOT NULL,
  `read_status` varchar(1) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


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

--
-- Table structure for table `badge_global_notice`
--

CREATE TABLE `badge_global_notice` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `notice_id` int(11) NOT NULL,
  `read_status` varchar(1) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


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

--
-- Table structure for table `badge_payment`
--

CREATE TABLE `badge_payment` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `payment_id` int(11) NOT NULL,
  `read_status` varchar(1) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


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

--
-- Table structure for table `badge_renovation`
--

CREATE TABLE `badge_renovation` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `renovation_id` int(11) NOT NULL,
  `read_status` varchar(1) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


--
-- Indexes for dumped tables
--

--
-- Indexes for table `badge_bill`
--
ALTER TABLE `badge_bill`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `badge_booking`
--
ALTER TABLE `badge_booking`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `badge_global_file`
--
ALTER TABLE `badge_global_file`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `badge_global_gallery`
--
ALTER TABLE `badge_global_gallery`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `badge_global_notice`
--
ALTER TABLE `badge_global_notice`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `badge_payment`
--
ALTER TABLE `badge_payment`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `badge_renovation`
--
ALTER TABLE `badge_renovation`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `badge_bill`
--
ALTER TABLE `badge_bill`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `badge_booking`
--
ALTER TABLE `badge_booking`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `badge_global_file`
--
ALTER TABLE `badge_global_file`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `badge_global_gallery`
--
ALTER TABLE `badge_global_gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `badge_global_notice`
--
ALTER TABLE `badge_global_notice`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `badge_payment`
--
ALTER TABLE `badge_payment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `badge_renovation`
--
ALTER TABLE `badge_renovation`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;