-- MySQL dump 10.13 Distrib 8.4.9, for Win64 (x86_64) -- -- Host: 127.0.0.1 Database: campus_coin -- ------------------------------------------------------ -- Server version 8.4.9 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `campus_coin` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `campus_coin` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */ /*!80016 DEFAULT ENCRYPTION='N' */; USE `campus_coin`; -- -- Table structure for table `accounts_user` -- DROP TABLE IF EXISTS `accounts_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `accounts_user` ( `id` bigint NOT NULL AUTO_INCREMENT, `password` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, `last_login` datetime(6) DEFAULT NULL, `is_superuser` tinyint(1) NOT NULL, `username` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `first_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `last_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL, `is_staff` tinyint(1) NOT NULL, `is_active` tinyint(1) NOT NULL, `date_joined` datetime(6) NOT NULL, `academic_year` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `monthly_allowance_baseline` decimal(12,2) NOT NULL, `monthly_savings_goal` decimal(12,2) NOT NULL, `is_admin` tinyint(1) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `accounts_user` -- LOCK TABLES `accounts_user` WRITE; /*!40000 ALTER TABLE `accounts_user` DISABLE KEYS */; INSERT INTO `accounts_user` VALUES (1,'pbkdf2_sha256$1500000$wA6SQnez6QLXZYsSLUM6E4$to7vEVHO0JmfDBYej9lRQxLizsN/S18Dyf/xrN+4bz8=',NULL,1,'admin','','','admin@campuscoin.local',1,1,'2026-09-24 15:21:54.773084',NULL,0.00,0.00,0),(2,'pbkdf2_sha256$1500000$TEuUjiRbqUYPfZYgxqCEeJ$bhJqGshNF7HO6WrbopUSG11w5gFudIRA6CWh9B45J1A=',NULL,0,'Abo','Daniel','Abo','abodaniel435@gmail.com',0,1,'2026-09-24 15:24:45.518952','300 level',120000.00,20000.00,0); /*!40000 ALTER TABLE `accounts_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accounts_user_groups` -- DROP TABLE IF EXISTS `accounts_user_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `accounts_user_groups` ( `id` bigint NOT NULL AUTO_INCREMENT, `user_id` bigint NOT NULL, `group_id` int NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `accounts_user_groups_user_id_group_id_59c0b32f_uniq` (`user_id`,`group_id`), KEY `accounts_user_groups_group_id_bd11a704_fk_auth_group_id` (`group_id`), CONSTRAINT `accounts_user_groups_group_id_bd11a704_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`), CONSTRAINT `accounts_user_groups_user_id_52b62117_fk_accounts_user_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `accounts_user_groups` -- LOCK TABLES `accounts_user_groups` WRITE; /*!40000 ALTER TABLE `accounts_user_groups` DISABLE KEYS */; /*!40000 ALTER TABLE `accounts_user_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accounts_user_user_permissions` -- DROP TABLE IF EXISTS `accounts_user_user_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `accounts_user_user_permissions` ( `id` bigint NOT NULL AUTO_INCREMENT, `user_id` bigint NOT NULL, `permission_id` int NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `accounts_user_user_permi_user_id_permission_id_2ab516c2_uniq` (`user_id`,`permission_id`), KEY `accounts_user_user_p_permission_id_113bb443_fk_auth_perm` (`permission_id`), CONSTRAINT `accounts_user_user_p_permission_id_113bb443_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`), CONSTRAINT `accounts_user_user_p_user_id_e4f0a161_fk_accounts_` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `accounts_user_user_permissions` -- LOCK TABLES `accounts_user_user_permissions` WRITE; /*!40000 ALTER TABLE `accounts_user_user_permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `accounts_user_user_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_group` -- DROP TABLE IF EXISTS `auth_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_group` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_group` -- LOCK TABLES `auth_group` WRITE; /*!40000 ALTER TABLE `auth_group` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_group_permissions` -- DROP TABLE IF EXISTS `auth_group_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_group_permissions` ( `id` bigint NOT NULL AUTO_INCREMENT, `group_id` int NOT NULL, `permission_id` int NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`), KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`), CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`), CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_group_permissions` -- LOCK TABLES `auth_group_permissions` WRITE; /*!40000 ALTER TABLE `auth_group_permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_group_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_permission` -- DROP TABLE IF EXISTS `auth_permission`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_permission` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `content_type_id` int NOT NULL, `codename` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`), CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_permission` -- LOCK TABLES `auth_permission` WRITE; /*!40000 ALTER TABLE `auth_permission` DISABLE KEYS */; INSERT INTO `auth_permission` VALUES (1,'Can add log entry',1,'add_logentry'),(2,'Can change log entry',1,'change_logentry'),(3,'Can delete log entry',1,'delete_logentry'),(4,'Can view log entry',1,'view_logentry'),(5,'Can add permission',3,'add_permission'),(6,'Can change permission',3,'change_permission'),(7,'Can delete permission',3,'delete_permission'),(8,'Can view permission',3,'view_permission'),(9,'Can add group',2,'add_group'),(10,'Can change group',2,'change_group'),(11,'Can delete group',2,'delete_group'),(12,'Can view group',2,'view_group'),(13,'Can add content type',4,'add_contenttype'),(14,'Can change content type',4,'change_contenttype'),(15,'Can delete content type',4,'delete_contenttype'),(16,'Can view content type',4,'view_contenttype'),(17,'Can add session',5,'add_session'),(18,'Can change session',5,'change_session'),(19,'Can delete session',5,'delete_session'),(20,'Can view session',5,'view_session'),(21,'Can add Token',6,'add_token'),(22,'Can change Token',6,'change_token'),(23,'Can delete Token',6,'delete_token'),(24,'Can view Token',6,'view_token'),(25,'Can add Token',7,'add_tokenproxy'),(26,'Can change Token',7,'change_tokenproxy'),(27,'Can delete Token',7,'delete_tokenproxy'),(28,'Can view Token',7,'view_tokenproxy'),(29,'Can add user',8,'add_user'),(30,'Can change user',8,'change_user'),(31,'Can delete user',8,'delete_user'),(32,'Can view user',8,'view_user'),(33,'Can add announcement',9,'add_announcement'),(34,'Can change announcement',9,'change_announcement'),(35,'Can delete announcement',9,'delete_announcement'),(36,'Can view announcement',9,'view_announcement'),(37,'Can add category',11,'add_category'),(38,'Can change category',11,'change_category'),(39,'Can delete category',11,'delete_category'),(40,'Can view category',11,'view_category'),(41,'Can add insight',12,'add_insight'),(42,'Can change insight',12,'change_insight'),(43,'Can delete insight',12,'delete_insight'),(44,'Can view insight',12,'view_insight'),(45,'Can add transaction',13,'add_transaction'),(46,'Can change transaction',13,'change_transaction'),(47,'Can delete transaction',13,'delete_transaction'),(48,'Can view transaction',13,'view_transaction'),(49,'Can add budget',10,'add_budget'),(50,'Can change budget',10,'change_budget'),(51,'Can delete budget',10,'delete_budget'),(52,'Can view budget',10,'view_budget'); /*!40000 ALTER TABLE `auth_permission` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `authtoken_token` -- DROP TABLE IF EXISTS `authtoken_token`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `authtoken_token` ( `key` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL, `created` datetime(6) NOT NULL, `user_id` bigint NOT NULL, PRIMARY KEY (`key`), UNIQUE KEY `user_id` (`user_id`), CONSTRAINT `authtoken_token_user_id_35299eff_fk_accounts_user_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `authtoken_token` -- LOCK TABLES `authtoken_token` WRITE; /*!40000 ALTER TABLE `authtoken_token` DISABLE KEYS */; /*!40000 ALTER TABLE `authtoken_token` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `core_announcement` -- DROP TABLE IF EXISTS `core_announcement`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `core_announcement` ( `id` bigint NOT NULL AUTO_INCREMENT, `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(1) NOT NULL, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `core_announcement` -- LOCK TABLES `core_announcement` WRITE; /*!40000 ALTER TABLE `core_announcement` DISABLE KEYS */; /*!40000 ALTER TABLE `core_announcement` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `core_budget` -- DROP TABLE IF EXISTS `core_budget`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `core_budget` ( `id` bigint NOT NULL AUTO_INCREMENT, `month` date NOT NULL, `limit_amount` decimal(12,2) NOT NULL, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, `user_id` bigint NOT NULL, `category_id` bigint NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `core_budget_user_id_category_id_month_055b1664_uniq` (`user_id`,`category_id`,`month`), KEY `core_budget_category_id_779c79ff_fk_core_category_id` (`category_id`), CONSTRAINT `core_budget_category_id_779c79ff_fk_core_category_id` FOREIGN KEY (`category_id`) REFERENCES `core_category` (`id`), CONSTRAINT `core_budget_user_id_5c344614_fk_accounts_user_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `core_budget` -- LOCK TABLES `core_budget` WRITE; /*!40000 ALTER TABLE `core_budget` DISABLE KEYS */; INSERT INTO `core_budget` VALUES (1,'2026-09-01',49999.95,'2026-09-24 15:28:34.183831','2026-09-24 15:28:34.183896',2,6),(2,'2026-09-01',18000.00,'2026-09-24 19:09:29.474405','2026-09-24 19:09:29.474488',2,11); /*!40000 ALTER TABLE `core_budget` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `core_category` -- DROP TABLE IF EXISTS `core_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `core_category` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `is_default` tinyint(1) NOT NULL, `created_at` datetime(6) NOT NULL, `user_id` bigint DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `core_category_user_id_name_type_de0c61bc_uniq` (`user_id`,`name`,`type`), CONSTRAINT `core_category_user_id_d4f5e86c_fk_accounts_user_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `core_category` -- LOCK TABLES `core_category` WRITE; /*!40000 ALTER TABLE `core_category` DISABLE KEYS */; INSERT INTO `core_category` VALUES (1,'Allowance','income',1,'2026-09-24 15:21:09.773250',NULL),(2,'Part-time Job','income',1,'2026-09-24 15:21:09.777726',NULL),(3,'Scholarship','income',1,'2026-09-24 15:21:09.781045',NULL),(4,'Gift','income',1,'2026-09-24 15:21:09.783743',NULL),(5,'Other Income','income',1,'2026-09-24 15:21:09.786993',NULL),(6,'Food','expense',1,'2026-09-24 15:21:09.790128',NULL),(7,'Transport','expense',1,'2026-09-24 15:21:09.792799',NULL),(8,'Hostel/Rent','expense',1,'2026-09-24 15:21:09.796293',NULL),(9,'Academics','expense',1,'2026-09-24 15:21:09.799641',NULL),(10,'Subscriptions','expense',1,'2026-09-24 15:21:09.802434',NULL),(11,'Entertainment','expense',1,'2026-09-24 15:21:09.805805',NULL),(12,'Miscellaneous','expense',1,'2026-09-24 15:21:09.808591',NULL); /*!40000 ALTER TABLE `core_category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `core_insight` -- DROP TABLE IF EXISTS `core_insight`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `core_insight` ( `id` bigint NOT NULL AUTO_INCREMENT, `month` date DEFAULT NULL, `summary_text` longtext COLLATE utf8mb4_unicode_ci, `tip_text` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `source` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `is_bookmarked` tinyint(1) NOT NULL, `is_dismissed` tinyint(1) NOT NULL, `generated_at` datetime(6) NOT NULL, `user_id` bigint NOT NULL, PRIMARY KEY (`id`), KEY `core_insight_user_id_809a9633_fk_accounts_user_id` (`user_id`), CONSTRAINT `core_insight_user_id_809a9633_fk_accounts_user_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `core_insight` -- LOCK TABLES `core_insight` WRITE; /*!40000 ALTER TABLE `core_insight` DISABLE KEYS */; INSERT INTO `core_insight` VALUES (1,'2026-09-01','Your highest spending category this month is Food.','Set a weekly limit for Food to reduce your monthly spending.','rule',0,0,'2026-09-24 19:08:41.317054',2); /*!40000 ALTER TABLE `core_insight` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `core_transaction` -- DROP TABLE IF EXISTS `core_transaction`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `core_transaction` ( `id` bigint NOT NULL AUTO_INCREMENT, `amount` decimal(12,2) NOT NULL, `type` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `transaction_date` date NOT NULL, `is_recurring` tinyint(1) NOT NULL, `recurrence_rule` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_deleted` tinyint(1) NOT NULL, `created_at` datetime(6) NOT NULL, `updated_at` datetime(6) NOT NULL, `category_id` bigint NOT NULL, `user_id` bigint NOT NULL, PRIMARY KEY (`id`), KEY `core_transaction_category_id_45ccacc9_fk_core_category_id` (`category_id`), KEY `core_transaction_user_id_9d7207a3_fk_accounts_user_id` (`user_id`), CONSTRAINT `core_transaction_category_id_45ccacc9_fk_core_category_id` FOREIGN KEY (`category_id`) REFERENCES `core_category` (`id`), CONSTRAINT `core_transaction_user_id_9d7207a3_fk_accounts_user_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `core_transaction` -- LOCK TABLES `core_transaction` WRITE; /*!40000 ALTER TABLE `core_transaction` DISABLE KEYS */; INSERT INTO `core_transaction` VALUES (1,5000.00,'expense','','2026-09-24',0,NULL,1,'2026-09-24 15:25:45.595042','2026-09-24 15:26:09.045814',7,2),(2,100000.00,'income','monthly allowance','2026-09-24',0,NULL,0,'2026-09-24 15:29:28.867932','2026-09-24 15:29:28.867993',1,2),(3,20000.00,'expense','','2026-09-24',0,NULL,0,'2026-09-24 18:54:05.071546','2026-09-24 18:54:05.071813',6,2),(4,5000.00,'expense','','2026-09-24',0,NULL,0,'2026-09-24 19:10:57.904063','2026-09-24 19:10:57.904134',11,2),(5,2000.00,'expense','','2026-09-25',0,NULL,0,'2026-09-25 20:58:02.245230','2026-09-25 20:58:02.245273',6,2),(6,2000.00,'expense','','2026-09-25',0,NULL,0,'2026-09-25 20:59:06.750775','2026-09-25 20:59:06.750801',12,2); /*!40000 ALTER TABLE `core_transaction` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `django_admin_log` -- DROP TABLE IF EXISTS `django_admin_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `django_admin_log` ( `id` int NOT NULL AUTO_INCREMENT, `action_time` datetime(6) NOT NULL, `object_id` longtext COLLATE utf8mb4_unicode_ci, `object_repr` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `action_flag` smallint unsigned NOT NULL, `change_message` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `content_type_id` int DEFAULT NULL, `user_id` bigint NOT NULL, PRIMARY KEY (`id`), KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`), KEY `django_admin_log_user_id_c564eba6_fk_accounts_user_id` (`user_id`), CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`), CONSTRAINT `django_admin_log_user_id_c564eba6_fk_accounts_user_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`), CONSTRAINT `django_admin_log_chk_1` CHECK ((`action_flag` >= 0)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `django_admin_log` -- LOCK TABLES `django_admin_log` WRITE; /*!40000 ALTER TABLE `django_admin_log` DISABLE KEYS */; /*!40000 ALTER TABLE `django_admin_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `django_content_type` -- DROP TABLE IF EXISTS `django_content_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `django_content_type` ( `id` int NOT NULL AUTO_INCREMENT, `app_label` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `model` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `django_content_type` -- LOCK TABLES `django_content_type` WRITE; /*!40000 ALTER TABLE `django_content_type` DISABLE KEYS */; INSERT INTO `django_content_type` VALUES (8,'accounts','user'),(1,'admin','logentry'),(2,'auth','group'),(3,'auth','permission'),(6,'authtoken','token'),(7,'authtoken','tokenproxy'),(4,'contenttypes','contenttype'),(9,'core','announcement'),(10,'core','budget'),(11,'core','category'),(12,'core','insight'),(13,'core','transaction'),(5,'sessions','session'); /*!40000 ALTER TABLE `django_content_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `django_migrations` -- DROP TABLE IF EXISTS `django_migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `django_migrations` ( `id` bigint NOT NULL AUTO_INCREMENT, `app` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `applied` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `django_migrations` -- LOCK TABLES `django_migrations` WRITE; /*!40000 ALTER TABLE `django_migrations` DISABLE KEYS */; INSERT INTO `django_migrations` VALUES (1,'contenttypes','0001_initial','2026-09-24 15:21:07.204946'),(2,'contenttypes','0002_remove_content_type_name','2026-09-24 15:21:07.275403'),(3,'auth','0001_initial','2026-09-24 15:21:07.512804'),(4,'auth','0002_alter_permission_name_max_length','2026-09-24 15:21:07.567331'),(5,'auth','0003_alter_user_email_max_length','2026-09-24 15:21:07.576768'),(6,'auth','0004_alter_user_username_opts','2026-09-24 15:21:07.583368'),(7,'auth','0005_alter_user_last_login_null','2026-09-24 15:21:07.589928'),(8,'auth','0006_require_contenttypes_0002','2026-09-24 15:21:07.592131'),(9,'auth','0007_alter_validators_add_error_messages','2026-09-24 15:21:07.598675'),(10,'auth','0008_alter_user_username_max_length','2026-09-24 15:21:07.605711'),(11,'auth','0009_alter_user_last_name_max_length','2026-09-24 15:21:07.610833'),(12,'auth','0010_alter_group_name_max_length','2026-09-24 15:21:07.626147'),(13,'auth','0011_update_proxy_permissions','2026-09-24 15:21:07.633194'),(14,'auth','0012_alter_user_first_name_max_length','2026-09-24 15:21:07.641568'),(15,'accounts','0001_initial','2026-09-24 15:21:07.929910'),(16,'admin','0001_initial','2026-09-24 15:21:08.062139'),(17,'admin','0002_logentry_remove_auto_add','2026-09-24 15:21:08.070314'),(18,'admin','0003_logentry_add_action_flag_choices','2026-09-24 15:21:08.078740'),(19,'authtoken','0001_initial','2026-09-24 15:21:08.204741'),(20,'authtoken','0002_auto_20160226_1747','2026-09-24 15:21:08.232091'),(21,'authtoken','0003_tokenproxy','2026-09-24 15:21:08.234860'),(22,'authtoken','0004_alter_tokenproxy_options','2026-09-24 15:21:08.240820'),(23,'core','0001_initial','2026-09-24 15:21:08.701778'),(24,'sessions','0001_initial','2026-09-24 15:21:08.737007'); /*!40000 ALTER TABLE `django_migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `django_session` -- DROP TABLE IF EXISTS `django_session`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `django_session` ( `session_key` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL, `session_data` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `expire_date` datetime(6) NOT NULL, PRIMARY KEY (`session_key`), KEY `django_session_expire_date_a5c62663` (`expire_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `django_session` -- LOCK TABLES `django_session` WRITE; /*!40000 ALTER TABLE `django_session` DISABLE KEYS */; /*!40000 ALTER TABLE `django_session` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-09-25 22:04:10