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

START TRANSACTION;



--
-- Database: `hostku8374_rekapin`
--

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

--
-- Table structure for table `budgets`
--

CREATE TABLE `budgets` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `category` varchar(100) NOT NULL,
  `amount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `period` enum('monthly','weekly','yearly') DEFAULT 'monthly',
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `budgets`
--

INSERT INTO `budgets` (`id`, `user_id`, `category`, `amount`, `period`, `created_at`) VALUES
(2, 24, 'Belanja Bulanan', 50000.00, 'monthly', '2026-05-07 15:57:02');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `type` enum('income','expense') NOT NULL,
  `icon` varchar(50) DEFAULT '?',
  `color` varchar(20) DEFAULT '#6366F1',
  `is_default` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `user_id`, `name`, `type`, `icon`, `color`, `is_default`, `created_at`) VALUES
(1, 24, 'Makanan & Minuman', 'expense', '🍔', '#F43F5E', 1, '2026-05-06 16:42:47'),
(2, 24, 'Transportasi', 'expense', '🚗', '#3B82F6', 1, '2026-05-06 16:42:47'),
(3, 24, 'Tagihan', 'expense', '📄', '#F59E0B', 1, '2026-05-06 16:42:47'),
(4, 24, 'Belanja Bulanan', 'expense', '🛒', '#8B5CF6', 1, '2026-05-06 16:42:47'),
(5, 24, 'Hobi & Hiburan', 'expense', '🎮', '#EC4899', 1, '2026-05-06 16:42:47'),
(6, 24, 'Kesehatan', 'expense', '💊', '#10B981', 1, '2026-05-06 16:42:47'),
(7, 24, 'Lainnya', 'expense', '📦', '#64748B', 1, '2026-05-06 16:42:47'),
(8, 24, 'Gaji', 'income', '💰', '#10B981', 1, '2026-05-06 16:42:47'),
(9, 24, 'Freelance', 'income', '💻', '#3B82F6', 1, '2026-05-06 16:42:47'),
(10, 24, 'Investasi', 'income', '📈', '#8B5CF6', 1, '2026-05-06 16:42:47'),
(11, 24, 'Hadiah', 'income', '🎁', '#EC4899', 1, '2026-05-06 16:42:47'),
(12, 24, 'Bonus', 'income', '⭐', '#F59E0B', 1, '2026-05-06 16:42:47'),
(13, 24, 'Lainnya', 'income', '📦', '#64748B', 1, '2026-05-06 16:42:47'),
(27, 24, 'Shopping', 'expense', '🛍️', '#6366f1', 0, '2026-05-06 17:01:18'),
(28, 24, 'Gift', 'expense', '🎁', '#6366f1', 0, '2026-05-06 17:06:42');

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

--
-- Table structure for table `collaborators`
--

CREATE TABLE `collaborators` (
  `id` int(11) NOT NULL,
  `owner_user_id` int(11) NOT NULL,
  `collaborator_chat_id` varchar(50) NOT NULL,
  `collaborator_name` varchar(100) DEFAULT 'Kolaborator',
  `status` enum('active','inactive') DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `debts`
--

CREATE TABLE `debts` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `type` enum('hutang','piutang') NOT NULL,
  `person_name` varchar(100) NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `paid_amount` decimal(15,2) DEFAULT 0.00,
  `description` text DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `status` enum('active','paid','overdue') DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `debts`
--

INSERT INTO `debts` (`id`, `user_id`, `type`, `person_name`, `amount`, `paid_amount`, `description`, `due_date`, `status`, `created_at`, `updated_at`) VALUES
(2, 24, 'piutang', 'Delvi', 500000.00, 0.00, '', '2026-06-13', 'active', '2026-05-06 17:13:25', '2026-05-06 17:13:25'),
(3, 24, 'piutang', 'Maulana', 3100000.00, 0.00, '', '2027-05-01', 'active', '2026-05-09 02:32:45', '2026-05-09 02:32:45');

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

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `id` int(11) NOT NULL,
  `msgid` int(11) NOT NULL,
  `chatid` varchar(255) NOT NULL,
  `text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `logs`
--

INSERT INTO `logs` (`id`, `msgid`, `chatid`, `text`) VALUES
(1, 465, '6310843350', 'bantuan_menu'),
(2, 467, '6310843350', ''),
(3, 470, '6310843350', ''),
(4, 471, '6310843350', 'laporan_menu'),
(5, 479, '6310843350', ''),
(6, 483, '6495353594', 'laporan_menu'),
(7, 484, '6310843350', ''),
(8, 495, '6310843350', ''),
(9, 500, '6310843350', 'laporan_menu'),
(10, 501, '6310843350', 'bantuan_menu');

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

--
-- Table structure for table `members`
--

CREATE TABLE `members` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `avatar_color` varchar(20) DEFAULT '#6366F1',
  `telegram_chat_id` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `members`
--

INSERT INTO `members` (`id`, `user_id`, `name`, `avatar_color`, `telegram_chat_id`, `created_at`) VALUES
(1, 24, 'Vinz', '#0af587', NULL, '2026-04-27 04:31:24'),
(2, 24, 'Intan', '#14b8a6', NULL, '2026-05-06 16:24:03'),
(3, 24, 'Maulana', '#6366f1', NULL, '2026-05-06 16:24:46'),
(4, 24, 'Delvi', '#8b5cf6', NULL, '2026-05-06 16:56:33');

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

--
-- Table structure for table `recurring_transactions`
--

CREATE TABLE `recurring_transactions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `store` varchar(255) NOT NULL,
  `total` decimal(15,2) NOT NULL,
  `items` text DEFAULT NULL,
  `category` varchar(50) NOT NULL,
  `type` enum('Pemasukan','Pengeluaran') NOT NULL,
  `wallet_id` int(11) DEFAULT NULL,
  `member_id` int(11) DEFAULT NULL,
  `frequency` enum('daily','weekly','monthly','yearly') NOT NULL DEFAULT 'monthly',
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `savings_goals`
--

CREATE TABLE `savings_goals` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `target_amount` decimal(15,2) NOT NULL,
  `current_amount` decimal(15,2) DEFAULT 0.00,
  `icon` varchar(50) DEFAULT '?',
  `color` varchar(20) DEFAULT '#10B981',
  `deadline` date DEFAULT NULL,
  `status` enum('active','completed','cancelled') DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `savings_goals`
--

INSERT INTO `savings_goals` (`id`, `user_id`, `name`, `target_amount`, `current_amount`, `icon`, `color`, `deadline`, `status`, `created_at`, `updated_at`) VALUES
(1, 24, 'Nikah', 1000000.00, 101000.00, '🎯', '#10b981', '2028-05-13', 'active', '2026-05-06 17:50:18', '2026-05-07 17:31:16');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `uid` char(36) NOT NULL,
  `user_id` int(11) NOT NULL,
  `member_id` int(11) DEFAULT NULL,
  `wallet_id` int(11) DEFAULT NULL,
  `store` varchar(255) NOT NULL DEFAULT 'Manual Input',
  `total` decimal(15,2) NOT NULL CHECK (`total` > 0),
  `items` text DEFAULT NULL,
  `note` text DEFAULT NULL,
  `category` varchar(50) DEFAULT NULL,
  `type` enum('Pemasukan','Pengeluaran') NOT NULL,
  `receipt_date` date NOT NULL,
  `input_date` date NOT NULL DEFAULT current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `uid`, `user_id`, `member_id`, `wallet_id`, `store`, `total`, `items`, `note`, `category`, `type`, `receipt_date`, `input_date`, `created_at`, `updated_at`) VALUES
(83, '972ddb16-5c20-46c9-bd17-b5acb48126e1', 24, 1, 1, 'Gajian', 9500000.00, '', '', 'Gaji', 'Pemasukan', '2026-05-01', '2026-05-08', '2026-05-08 02:07:14', '2026-05-09 02:48:01'),
(84, 'mom93474-2wdb9w6', 24, 2, 1, 'FLIP', 15560.00, 'DOKU', 'FLIP-DOKU', 'Lainnya', 'Pengeluaran', '2026-05-01', '2026-05-08', '2026-05-08 02:07:35', '2026-05-08 04:02:44'),
(85, 'mop8l89s-2wdb9w6', 24, NULL, 1, 'Transfer ke BCA Virtual Account', 405800.00, '-', 'Transfer ke BCA Virtual Account--', 'Lainnya', 'Pengeluaran', '2026-05-03', '2026-05-08', '2026-05-08 02:07:35', '2026-05-08 04:02:42'),
(86, 'mopzfyqo-2wdb9w6', 24, NULL, 1, 'HASMITA', 650000.00, '1980219093', 'HASMITA-1980219093', 'Lainnya', 'Pengeluaran', '2026-05-03', '2026-05-08', '2026-05-08 02:07:35', '2026-05-08 04:02:42'),
(87, 'movdif34-2wdb9w6', 24, NULL, 1, 'Transfer ke BCA Virtual Account', 301000.00, '-', 'Transfer ke BCA Virtual Account--', 'Lainnya', 'Pengeluaran', '2026-05-07', '2026-05-08', '2026-05-08 02:07:35', '2026-05-08 04:02:44'),
(88, 'mow0u9nk-2wdb9w6', 24, NULL, 1, 'SITI YUNITA SARI', 20000.00, '5785374841', 'SITI YUNITA SARI-5785374841', 'Lainnya', 'Pengeluaran', '2026-05-07', '2026-05-08', '2026-05-08 02:07:36', '2026-05-08 04:02:44'),
(89, 'mondznrs-2wdb9w6', 24, 1, 1, 'FLIPTECH LENTERA IP PT', 912825.00, '5465389289', 'FLIPTECH LENTERA IP PT-5465389289', 'Lainnya', 'Pengeluaran', '2026-05-01', '2026-05-08', '2026-05-08 02:07:36', '2026-05-08 04:02:44'),
(90, 'moq82pgw-2wdb9w6', 24, NULL, 1, 'MAULANA SYUFI IKBAL', 25000.00, '7560466841', 'MAULANA SYUFI IKBAL-7560466841', 'Lainnya', 'Pengeluaran', '2026-05-03', '2026-05-08', '2026-05-08 02:07:36', '2026-05-08 04:02:43'),
(91, 'mor3jrlc-2wdb9w6', 24, 4, 1, 'FLIPTECH LENTERA IP PT', 500348.00, '5465389289', 'FLIPTECH LENTERA IP PT-5465389289', 'Lainnya', 'Pengeluaran', '2026-05-04', '2026-05-08', '2026-05-08 02:07:36', '2026-05-08 04:02:42'),
(92, 'mosn056w-2wdb9w6', 24, 1, 1, 'Transfer ke BCA Virtual Account', 3241100.00, '-', 'Transfer ke BCA Virtual Account--', 'Lainnya', 'Pengeluaran', '2026-05-05', '2026-05-08', '2026-05-08 02:07:37', '2026-05-08 04:02:43'),
(93, 'mouhbokw-2wdb9w6', 24, 1, 1, 'IDM INDOMARET D', 52200.00, 'BCA', 'IDM INDOMARET D-BCA', 'Lainnya', 'Pengeluaran', '2026-05-06', '2026-05-08', '2026-05-08 02:07:37', '2026-05-08 04:02:43'),
(94, 'mouguop4-2wdb9w6', 24, NULL, 1, 'IOH', 55000.00, 'OTTOCASH', 'IOH-OTTOCASH', 'Lainnya', 'Pengeluaran', '2026-05-06', '2026-05-08', '2026-05-08 02:07:37', '2026-05-08 04:02:43'),
(95, 'mon16748-2wdb9w6', 24, NULL, 1, 'GALAXY RELOAD', 1501.00, 'DANA', 'GALAXY RELOAD-DANA', 'Lainnya', 'Pengeluaran', '2026-05-01', '2026-05-08', '2026-05-08 02:07:37', '2026-05-08 04:02:42'),
(96, 'morh8fpc-2wdb9w6', 24, 1, 2, 'SeaBank Bayar Instan', 11500.00, '-', 'SeaBank Bayar Instan--', 'Lainnya', 'Pengeluaran', '2026-05-04', '2026-05-08', '2026-05-08 02:07:38', '2026-05-08 04:02:46'),
(98, 'tfr-in-1778206308445', 24, NULL, 2, 'Transfer ← BCA', 405800.00, 'Transfer Masuk', '', '', 'Pemasukan', '2026-05-03', '2026-05-08', '2026-05-08 02:11:48', '2026-05-08 02:12:31'),
(100, 'tfr-in-1778206698544', 24, NULL, 3, 'Transfer ← BCA', 301000.00, 'Transfer Masuk', '', 'Transfer', 'Pemasukan', '2026-05-08', '2026-05-08', '2026-05-08 02:18:18', '2026-05-08 02:18:18'),
(101, '5b2235b1-7b93-48b1-a55f-e9a2582f8f70', 24, 1, 2, 'Jagoan Hosting', 100000.00, 'VPS', '', 'Belanja Bulanan', 'Pengeluaran', '2026-05-04', '2026-05-08', '2026-05-08 02:19:48', '2026-05-08 02:20:16'),
(102, '6385e600-d1d8-4e94-b842-bc5c8c4d2b0a', 24, 2, 1, 'Bayar Hutang Intan', 15000.00, '', '', 'Freelance', 'Pemasukan', '2026-05-08', '2026-05-08', '2026-05-08 02:40:17', '2026-05-08 02:40:17'),
(103, '36b11fbb-8a5f-4d38-93c8-e7bfce37236d', 24, 1, 1, 'Dispenser', 300000.00, 'Patungan Beli Dispenser', '', 'Freelance', 'Pemasukan', '2026-05-08', '2026-05-08', '2026-05-08 02:41:29', '2026-05-08 02:41:29'),
(104, 'ddbf058a-9fc5-49d1-845e-2fdd6cf0e3a9', 24, 1, 1, 'Freelance', 451500.00, '', '', 'Freelance', 'Pemasukan', '2026-05-08', '2026-05-08', '2026-05-08 02:43:48', '2026-05-08 02:43:48'),
(105, 'c7629eb8-d8b2-4fad-b79e-b75b6680555c', 24, 1, 1, 'Freelance', 750000.00, '', '', 'Freelance', 'Pemasukan', '2026-05-08', '2026-05-08', '2026-05-08 02:44:17', '2026-05-08 02:44:17'),
(106, 'mownx45c-2wdb9w6', 24, 1, 2, 'SeaBank Bayar Instan', 20469.00, '-', 'SeaBank Bayar Instan--', 'Lainnya', 'Pengeluaran', '2026-05-08', '2026-05-08', '2026-05-08 04:02:46', '2026-05-08 13:02:48'),
(107, 'moworz9c-2wdb9w6', 24, 1, 2, 'SeaBank Bayar Instan', 21000.00, '-', 'SeaBank Bayar Instan--', 'Lainnya', 'Pengeluaran', '2026-05-08', '2026-05-08', '2026-05-08 04:02:46', '2026-05-08 13:02:48'),
(108, 'mox57new-2wdb9w6', 24, 1, 1, 'MARIA KIRANA', 50000.00, '7570311691', 'MARIA KIRANA-7570311691', 'Lainnya', 'Pengeluaran', '2026-05-08', '2026-05-08', '2026-05-08 10:02:43', '2026-05-08 13:02:45'),
(109, '3f5c8b76-0f02-4364-b88b-409cc152be87', 24, 1, 1, 'Topup Koin Tiktok', 40001.00, 'Intan', '', 'Bonus', 'Pemasukan', '2026-05-08', '2026-05-08', '2026-05-08 12:14:40', '2026-05-08 12:14:40'),
(110, 'moxadfoo-2wdb9w6', 24, 1, 1, 'ALFIN HILMY NURMAKHLUFI', 200000.00, '8035113564', 'ALFIN HILMY NURMAKHLUFI-8035113564', 'Lainnya', 'Pengeluaran', '2026-05-08', '2026-05-08', '2026-05-08 12:15:46', '2026-05-08 13:02:44'),
(111, 'ed6afe09-8b84-4f46-b19f-4d5779df8edb', 24, 1, 3, 'Makan Dinda', 110500.00, '', '', 'Belanja Bulanan', 'Pengeluaran', '2026-05-07', '2026-05-08', '2026-05-08 12:19:05', '2026-05-08 12:19:05'),
(112, '301d4d0c-59df-4803-90fc-9dabdafda685', 24, 1, 3, 'Makan Dinda', 34600.00, '', '', 'Makanan & Minuman', 'Pengeluaran', '2026-05-08', '2026-05-08', '2026-05-08 12:19:59', '2026-05-08 12:19:59'),
(113, 'moxmcecg-2wdb9w6', 24, 1, 1, 'FLIPTECH LENTERA IP PT', 2098325.00, '5465128965', '', 'Lainnya', 'Pengeluaran', '2026-05-09', '2026-05-08', '2026-05-08 19:02:45', '2026-05-09 04:02:45'),
(114, 'moy5yv7s-2wdb9w6', 24, NULL, 1, 'Patungin', 150000.00, 'BANK MANDIRI', NULL, 'Lainnya', 'Pengeluaran', '2026-05-09', '2026-05-09', '2026-05-09 04:02:45', '2026-05-09 04:02:45');

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

--
-- Table structure for table `wallets`
--

CREATE TABLE `wallets` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `icon` varchar(50) DEFAULT 'wallet',
  `color` varchar(20) DEFAULT '#3B82F6',
  `balance` decimal(15,2) DEFAULT 0.00,
  `type` enum('cash','bank','ewallet','investment','savings') DEFAULT 'cash',
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wallets`
--

INSERT INTO `wallets` (`id`, `user_id`, `name`, `icon`, `color`, `balance`, `type`, `created_at`) VALUES
(1, 24, 'BCA', 'wallet', '#3b82f6', 0.00, 'bank', '2026-04-27 04:32:27'),
(2, 24, 'Seabank', 'wallet', '#3b82f6', 0.00, 'bank', '2026-05-06 16:57:08'),
(3, 24, 'GoPay', 'wallet', '#3b82f6', 0.00, 'ewallet', '2026-05-07 17:44:12');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `budgets`
--
ALTER TABLE `budgets`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_budget` (`user_id`,`category`,`period`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_cat` (`user_id`,`name`,`type`),
  ADD KEY `idx_categories_user` (`user_id`,`type`);

--
-- Indexes for table `collaborators`
--
ALTER TABLE `collaborators`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_collab` (`owner_user_id`,`collaborator_chat_id`);

--
-- Indexes for table `debts`
--
ALTER TABLE `debts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_debts_user` (`user_id`,`status`);

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

--
-- Indexes for table `members`
--
ALTER TABLE `members`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `recurring_transactions`
--
ALTER TABLE `recurring_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_recurring_user` (`user_id`,`is_active`);

--
-- Indexes for table `savings_goals`
--
ALTER TABLE `savings_goals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_savings_user` (`user_id`,`status`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_date` (`user_id`,`receipt_date`),
  ADD KEY `idx_type` (`type`),
  ADD KEY `idx_transactions_user_date` (`user_id`,`receipt_date`),
  ADD KEY `idx_transactions_member` (`member_id`),
  ADD KEY `idx_transactions_wallet` (`wallet_id`);

--
-- Indexes for table `wallets`
--
ALTER TABLE `wallets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `budgets`
--
ALTER TABLE `budgets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

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

--
-- AUTO_INCREMENT for table `debts`
--
ALTER TABLE `debts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

--
-- AUTO_INCREMENT for table `members`
--
ALTER TABLE `members`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `recurring_transactions`
--
ALTER TABLE `recurring_transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `savings_goals`
--
ALTER TABLE `savings_goals`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=115;

--
-- AUTO_INCREMENT for table `wallets`
--
ALTER TABLE `wallets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `budgets`
--
ALTER TABLE `budgets`
  ADD CONSTRAINT `budgets_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE;

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `categories_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE;

--
-- Constraints for table `collaborators`
--
ALTER TABLE `collaborators`
  ADD CONSTRAINT `collaborators_ibfk_1` FOREIGN KEY (`owner_user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE;

--
-- Constraints for table `debts`
--
ALTER TABLE `debts`
  ADD CONSTRAINT `debts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE;

--
-- Constraints for table `members`
--
ALTER TABLE `members`
  ADD CONSTRAINT `members_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE;

--
-- Constraints for table `recurring_transactions`
--
ALTER TABLE `recurring_transactions`
  ADD CONSTRAINT `recurring_transactions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE;

--
-- Constraints for table `savings_goals`
--
ALTER TABLE `savings_goals`
  ADD CONSTRAINT `savings_goals_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE;

--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `fk_user_transaction` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE;

--
-- Constraints for table `wallets`
--
ALTER TABLE `wallets`
  ADD CONSTRAINT `wallets_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE;
COMMIT;

