--
-- Host: rpi5db.louchepastiche.com    Database: users
-- ------------------------------------------------------


--
-- Current Database: `users`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `users` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;

USE `users`;

--
-- Table structure for table `accounts_page`
--

CREATE TABLE `accounts_page` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `slug` varchar(50) NOT NULL,
  `category` varchar(50) NOT NULL,
  `label` varchar(100) NOT NULL,
  `url` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `accounts_page`
--

INSERT INTO `accounts_page` VALUES (1,'dashboard','Admin','Dashboard',''),(2,'access-control','Admin','',NULL),(3,'admin-dashboard','admin-dashboard','Admin Dashboard',''),(4,'password_change','Admin','Change Password',''),(5,'options','Options','Options',NULL),(6,'chain','Options','Options Chain',NULL),(8,'useradmin','Admin','User Admin',''),(9,'spread-builder','Options','Spread Builder',''),(10,'profile','Admin','Profile',''),(11,'generate-app','Admin','Generate New App',''),(12,'delete-app','Admin','Delete App',''),(13,'deletion-log','Admin','Deletion Log',''),(14,'generate-page','Admin','Create New Page','/admin-tools/generate-page/'),(15,'delete-page','Admin','Delete Page','/admin-tools/delete-page/'),(16,'custom-spread-selector','Options','Custom Spread Selector',NULL);

--
-- Table structure for table `accounts_pageaccess`
--

CREATE TABLE `accounts_pageaccess` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `page_id` bigint(20) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `accounts_pageaccess_user_id_page_id_e3d22204_uniq` (`user_id`,`page_id`),
  KEY `accounts_pageaccess_page_id_e517567f_fk_accounts_page_id` (`page_id`),
  CONSTRAINT `accounts_pageaccess_page_id_e517567f_fk_accounts_page_id` FOREIGN KEY (`page_id`) REFERENCES `accounts_page` (`id`),
  CONSTRAINT `accounts_pageaccess_user_id_11da626e_fk_profile_user_id` FOREIGN KEY (`user_id`) REFERENCES `profile` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `accounts_pageaccess`
--

INSERT INTO `accounts_pageaccess` VALUES (4,1,1),(5,2,1),(3,3,1),(7,4,1),(9,5,1),(11,6,1),(14,8,1),(15,9,1),(42,10,1),(48,11,1),(49,12,1),(50,13,1),(51,14,1),(52,15,1),(53,16,1),(6,1,19),(31,3,19),(8,4,19),(10,5,19),(12,6,19),(16,9,19),(43,10,19),(17,1,20),(32,3,20),(18,4,20),(19,5,20),(20,6,20),(21,9,20),(44,10,20),(58,16,20),(22,1,21),(33,3,21),(23,4,21),(24,5,21),(25,6,21),(26,9,21),(45,10,21),(27,1,22),(34,3,22),(28,4,22),(29,5,22),(30,6,22),(41,9,22),(46,10,22),(35,1,23),(40,3,23),(36,4,23),(47,10,23);

--
-- Table structure for table `auth_group`
--

CREATE TABLE `auth_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `auth_group`
--


--
-- Table structure for table `auth_group_permissions`
--

CREATE TABLE `auth_group_permissions` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) 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_general_ci;

--
-- Dumping data for table `auth_group_permissions`
--


--
-- Table structure for table `auth_permission`
--

CREATE TABLE `auth_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) 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=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `auth_permission`
--

INSERT INTO `auth_permission` VALUES (1,'Can add custom user',1,'add_customuser'),(2,'Can change custom user',1,'change_customuser'),(3,'Can delete custom user',1,'delete_customuser'),(4,'Can view custom user',1,'view_customuser'),(5,'Can add log entry',2,'add_logentry'),(6,'Can change log entry',2,'change_logentry'),(7,'Can delete log entry',2,'delete_logentry'),(8,'Can view log entry',2,'view_logentry'),(9,'Can add permission',3,'add_permission'),(10,'Can change permission',3,'change_permission'),(11,'Can delete permission',3,'delete_permission'),(12,'Can view permission',3,'view_permission'),(13,'Can add group',4,'add_group'),(14,'Can change group',4,'change_group'),(15,'Can delete group',4,'delete_group'),(16,'Can view group',4,'view_group'),(17,'Can add content type',5,'add_contenttype'),(18,'Can change content type',5,'change_contenttype'),(19,'Can delete content type',5,'delete_contenttype'),(20,'Can view content type',5,'view_contenttype'),(21,'Can add session',6,'add_session'),(22,'Can change session',6,'change_session'),(23,'Can delete session',6,'delete_session'),(24,'Can view session',6,'view_session'),(25,'Can add page access',7,'add_pageaccess'),(26,'Can change page access',7,'change_pageaccess'),(27,'Can delete page access',7,'delete_pageaccess'),(28,'Can view page access',7,'view_pageaccess'),(29,'Can add page',8,'add_page'),(30,'Can change page',8,'change_page'),(31,'Can delete page',8,'delete_page'),(32,'Can view page',8,'view_page');

--
-- Table structure for table `django_admin_log`
--

CREATE TABLE `django_admin_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext DEFAULT NULL,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint(5) unsigned NOT NULL CHECK (`action_flag` >= 0),
  `change_message` longtext NOT NULL,
  `content_type_id` int(11) DEFAULT NULL,
  `user_id` int(11) 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_profile_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_profile_user_id` FOREIGN KEY (`user_id`) REFERENCES `profile` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `django_admin_log`
--

INSERT INTO `django_admin_log` VALUES (1,'2025-03-28 20:33:46.332278','2','access-control',2,'[{\"changed\": {\"fields\": [\"Category\"]}}]',8,1),(2,'2025-03-28 20:33:54.939423','1','dashboard',2,'[{\"changed\": {\"fields\": [\"Category\"]}}]',8,1),(3,'2025-03-28 20:40:21.308543','2','PageAccess object (2)',2,'[]',7,1),(4,'2025-03-28 20:40:28.151396','1','PageAccess object (1)',2,'[]',7,1),(5,'2025-03-28 20:59:17.270747','3','admin',1,'[{\"added\": {}}]',8,1),(6,'2025-03-28 20:59:48.177103','3','admin',2,'[]',8,1),(7,'2025-03-29 01:43:32.395595','4','password_change',1,'[{\"added\": {}}]',8,1),(8,'2025-03-29 02:11:52.971022','4','password_change',2,'[{\"changed\": {\"fields\": [\"Label\"]}}]',8,1),(9,'2025-03-29 02:12:27.026252','4','password_change',2,'[]',8,1),(10,'2025-03-29 02:17:30.494693','4','password_change',2,'[{\"changed\": {\"fields\": [\"Label\"]}}]',8,1),(11,'2025-03-30 02:18:35.583437','5','options',1,'[{\"added\": {}}]',8,1),(12,'2025-03-30 03:34:22.157819','6','chain',1,'[{\"added\": {}}]',8,1),(13,'2025-03-30 06:15:52.026916','3','admin',2,'[{\"changed\": {\"fields\": [\"Label\", \"Url\"]}}]',8,1),(14,'2025-03-30 06:43:49.355492','4','Page object (4)',2,'[{\"changed\": {\"fields\": [\"Url\"]}}]',8,1),(15,'2025-03-30 06:47:18.676997','4','Page object (4)',2,'[{\"changed\": {\"fields\": [\"Url\"]}}]',8,1),(16,'2025-03-30 06:47:56.951030','4','Page object (4)',2,'[{\"changed\": {\"fields\": [\"Url\"]}}]',8,1),(17,'2025-03-30 07:07:27.268067','4','Page object (4)',2,'[{\"changed\": {\"fields\": [\"Url\"]}}]',8,1),(18,'2025-03-30 07:07:44.205214','3','Page object (3)',2,'[{\"changed\": {\"fields\": [\"Url\"]}}]',8,1),(19,'2025-03-30 07:12:25.593065','3','Admin Dashboard',2,'[{\"changed\": {\"fields\": [\"Slug\"]}}]',8,1),(20,'2025-03-30 07:12:42.651469','7','Admin',1,'[{\"added\": {}}]',8,1),(21,'2025-03-30 07:20:53.334833','7','Admin',3,'',8,1),(22,'2025-03-30 07:21:13.913238','3','Admin Dashboard',2,'[{\"changed\": {\"fields\": [\"Url\"]}}]',8,1),(23,'2025-03-30 07:28:51.363110','3','Admin Dashboard',2,'[{\"changed\": {\"fields\": [\"Category\"]}}]',8,1),(24,'2025-03-30 20:49:48.076156','8','User Admin',1,'[{\"added\": {}}]',8,1),(25,'2025-04-07 06:32:09.295180','9','Spread Builder',1,'[{\"added\": {}}]',8,1),(26,'2025-04-17 19:39:06.708269','10','Profile',1,'[{\"added\": {}}]',8,1),(27,'2025-04-17 21:28:33.786461','10','Profile',2,'[{\"changed\": {\"fields\": [\"Label\"]}}]',8,1),(28,'2025-04-17 21:28:38.400424','10','Profile',2,'[]',8,1),(29,'2025-04-17 21:28:46.546866','4','Change Password',2,'[]',8,1),(30,'2025-04-18 20:58:08.704958','1','Dashboard',2,'[{\"changed\": {\"fields\": [\"Label\"]}}]',8,1),(31,'2025-04-20 04:21:41.612780','11','Generate New App',1,'[{\"added\": {}}]',8,1),(32,'2025-04-20 04:22:11.643592','12','Delete App',1,'[{\"added\": {}}]',8,1),(33,'2025-04-20 04:22:37.273865','13','Deletion Log',1,'[{\"added\": {}}]',8,1),(34,'2025-04-20 05:20:24.689558','14','Create New Page',1,'[{\"added\": {}}]',8,1),(35,'2025-04-20 05:20:48.153468','15','Delete Page',1,'[{\"added\": {}}]',8,1),(36,'2025-04-20 05:30:10.305222','14','Create New Page',2,'[{\"changed\": {\"fields\": [\"Url\"]}}]',8,1),(37,'2025-04-20 05:30:23.419339','15','Delete Page',2,'[{\"changed\": {\"fields\": [\"Url\"]}}]',8,1),(38,'2025-04-21 05:56:15.645345','18','Test Page 6',3,'',8,1);

--
-- Table structure for table `django_content_type`
--

CREATE TABLE `django_content_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `django_content_type`
--

INSERT INTO `django_content_type` VALUES (1,'accounts','customuser'),(8,'accounts','page'),(7,'accounts','pageaccess'),(2,'admin','logentry'),(4,'auth','group'),(3,'auth','permission'),(5,'contenttypes','contenttype'),(6,'sessions','session');

--
-- Table structure for table `django_migrations`
--

CREATE TABLE `django_migrations` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `app` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `django_migrations`
--

INSERT INTO `django_migrations` VALUES (1,'accounts','0001_initial','2025-03-26 20:55:55.898425'),(2,'contenttypes','0001_initial','2025-03-26 20:55:55.923952'),(3,'admin','0001_initial','2025-03-26 20:55:55.969985'),(4,'admin','0002_logentry_remove_auto_add','2025-03-26 20:55:55.984565'),(5,'admin','0003_logentry_add_action_flag_choices','2025-03-26 20:55:55.996926'),(6,'contenttypes','0002_remove_content_type_name','2025-03-26 20:55:56.041256'),(7,'auth','0001_initial','2025-03-26 20:55:56.149945'),(8,'auth','0002_alter_permission_name_max_length','2025-03-26 20:55:56.177835'),(9,'auth','0003_alter_user_email_max_length','2025-03-26 20:55:56.195631'),(10,'auth','0004_alter_user_username_opts','2025-03-26 20:55:56.208905'),(11,'auth','0005_alter_user_last_login_null','2025-03-26 20:55:56.223278'),(12,'auth','0006_require_contenttypes_0002','2025-03-26 20:55:56.226126'),(13,'auth','0007_alter_validators_add_error_messages','2025-03-26 20:55:56.240677'),(14,'auth','0008_alter_user_username_max_length','2025-03-26 20:55:56.254616'),(15,'auth','0009_alter_user_last_name_max_length','2025-03-26 20:55:56.268174'),(16,'auth','0010_alter_group_name_max_length','2025-03-26 20:55:56.289833'),(17,'auth','0011_update_proxy_permissions','2025-03-26 20:55:56.309212'),(18,'auth','0012_alter_user_first_name_max_length','2025-03-26 20:55:56.323358'),(19,'sessions','0001_initial','2025-03-26 20:55:56.342311'),(20,'accounts','0002_page_pageaccess','2025-03-28 01:36:35.982649'),(21,'accounts','0003_page_category','2025-03-28 20:17:52.589508'),(22,'accounts','0004_alter_pageaccess_options_page_label','2025-03-29 02:11:00.034179'),(23,'accounts','0005_page_url','2025-03-30 06:09:09.800860');

--
-- Table structure for table `django_session`
--

CREATE TABLE `django_session` (
  `session_key` varchar(40) NOT NULL,
  `session_data` longtext 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_general_ci;

--
-- Dumping data for table `django_session`
--

INSERT INTO `django_session` VALUES ('1njfzwyovtbix7dmz6i43ex2f6jhghg6','.eJxVjEEOwiAQRe_C2hAIMAWX7j0DGQZGqgaS0q6Md9cmXej2v_f-S0Tc1hq3UZY4Z3EWWpx-t4T0KG0H-Y7t1iX1ti5zkrsiDzrktefyvBzu30HFUb_1xA5VIh-AFZmpsCcNHtFkAI3ogME6IKWMCgrI5ZRTYk1s0NrgvXh_APF7ODI:1u8qJw:PnlptDg1h6P3w7P2aPCGmOCTIjV_GEUBMIVEHjmE1gs','2025-05-11 00:56:36.890302'),('29a8qtyo9d3b44ev1xflii389qyiwflw','.eJxVjEEOwiAQRe_C2hCGoQVcuvcMZICpVA0kpV0Z765NutDtf-_9lwi0rSVsnZcwZ3EWIE6_W6T04LqDfKd6azK1ui5zlLsiD9rltWV-Xg7376BQL9_aD0oNbMkzsCPjk0NDemIeQdlErIEgJowjsjbOojZApJzNCTXmyYr3B94TN8A:1u1wnL:__qnmgUADipdd6yeaw2ERbCOJIe96RhGkZxnX0qMCyA','2025-04-22 00:26:27.768158'),('2bc81bpeuwtg87v4z93bq7l37nmicfcz','.eJxVjEEOwiAQRe_C2hAIMAWX7j0DGQZGqgaS0q6Md9cmXej2v_f-S0Tc1hq3UZY4Z3EWWpx-t4T0KG0H-Y7t1iX1ti5zkrsiDzrktefyvBzu30HFUb_1xA5VIh-AFZmpsCcNHtFkAI3ogME6IKWMCgrI5ZRTYk1s0NrgvXh_APF7ODI:1u3V36:umz0ErYbgy5KNJx64fkcUYJATHbRfx1a__efvktPuko','2025-04-26 07:13:08.761133'),('4v5rg53acmu43tu6tq93fkw5n7ow0n5w','.eJxVjEEOwiAQRe_C2hAIMAWX7j0DGQZGqgaS0q6Md9cmXej2v_f-S0Tc1hq3UZY4Z3EWWpx-t4T0KG0H-Y7t1iX1ti5zkrsiDzrktefyvBzu30HFUb_1xA5VIh-AFZmpsCcNHtFkAI3ogME6IKWMCgrI5ZRTYk1s0NrgvXh_APF7ODI:1uBcVA:8G-zZ9dQgV99q5XC2-HNJnvU-IFcrH5UHh9eDsihTAY','2025-05-18 16:47:40.156690'),('5jrqt87fxnldl8oqweaaq9d9mtmfs70q','.eJxVjEEOwiAQRe_C2hAIMAWX7j0DGQZGqgaS0q6Md9cmXej2v_f-S0Tc1hq3UZY4Z3EWWpx-t4T0KG0H-Y7t1iX1ti5zkrsiDzrktefyvBzu30HFUb_1xA5VIh-AFZmpsCcNHtFkAI3ogME6IKWMCgrI5ZRTYk1s0NrgvXh_APF7ODI:1u8l7J:y9e8etvxjVN_zFvAMfC6hUplOhJsl00LDq1vNaNq9Jk','2025-05-10 19:23:13.385598'),('6dblt4hlflzr0kqu1jjcyknbtd537seb','.eJxVjEEOwiAQRe_C2hAIMAWX7j0DGQZGqgaS0q6Md9cmXej2v_f-S0Tc1hq3UZY4Z3EWWpx-t4T0KG0H-Y7t1iX1ti5zkrsiDzrktefyvBzu30HFUb_1xA5VIh-AFZmpsCcNHtFkAI3ogME6IKWMCgrI5ZRTYk1s0NrgvXh_APF7ODI:1uIYiQ:qC6DTBItL7VODEzXAw2f9i71R1X9kcQ8526MEQpdvC0','2025-06-06 20:10:02.902668'),('8cwqhnht1eu4cxp4oi3mnq6pm8qqv0o1','.eJxVjMsOwiAQRf-FtSE8Zgi4dO83kAGmUjWQlHZl_Hdt0oVu7znnvkSkba1xG7zEuYiz0EGcfsdE-cFtJ-VO7dZl7m1d5iR3RR50yGsv_Lwc7t9BpVG_dcglYEKdGNAlsqTRG_KEhiaTOcBkNGTlEdlhUZ4d6AKgLLvsLHvx_gAPODfZ:1u1x6s:OLb6prlf2gqbbMEkY3Jik_dyQdCR_6Tm_sWqCMVWiZk','2025-04-22 00:46:38.636068'),('8f9kxhjvg9wd58nhjooqqg9xathd0iz6','.eJxVjEEOwiAQRe_C2hAIMAWX7j0DGQZGqgaS0q6Md9cmXej2v_f-S0Tc1hq3UZY4Z3EWWpx-t4T0KG0H-Y7t1iX1ti5zkrsiDzrktefyvBzu30HFUb_1xA5VIh-AFZmpsCcNHtFkAI3ogME6IKWMCgrI5ZRTYk1s0NrgvXh_APF7ODI:1u5bc2:-WKQTkXtpARAxFckcvhMd8aN5-x7xmhNfstAt5xi6mA','2025-05-02 02:37:54.619491'),('8hl3lbju8shu5w8z5108gxk6pa3vwjwy','.eJxVjEEOwiAQRe_C2hCGoQVcuvcMZICpVA0kpV0Z765NutDtf-_9lwi0rSVsnZcwZ3EWIE6_W6T04LqDfKd6azK1ui5zlLsiD9rltWV-Xg7376BQL9_aD0oNbMkzsCPjk0NDemIeQdlErIEgJowjsjbOojZApJzNCTXmyYr3B94TN8A:1u1QnZ:MFV6IC3Mw1ivUWNWVgeIZCZiO2X-esSYFgqbdF-R9cg','2025-04-20 14:16:33.870296'),('9hqkveen13znn8eye8fvim5o4p6o8ntu','e30:1txXpy:wHMj4Ydh87EDZ4ETji8zV898Nqkk2VZo89gn4aU9rsk','2025-04-09 20:58:58.944494'),('ay2ihh9fos8ekq26lqzq8gstvpvr35x4','.eJxVjEEOwiAQRe_C2hAIMAWX7j0DGQZGqgaS0q6Md9cmXej2v_f-S0Tc1hq3UZY4Z3EWWpx-t4T0KG0H-Y7t1iX1ti5zkrsiDzrktefyvBzu30HFUb_1xA5VIh-AFZmpsCcNHtFkAI3ogME6IKWMCgrI5ZRTYk1s0NrgvXh_APF7ODI:1uCmLT:yZu4USgJdMouVM1ULZcT9FYeLMGoJXgjLP859AfzvFY','2025-05-21 21:30:27.685923'),('b3nuogeg30k48teao78sm945goy3ib5h','.eJxVjEEOwiAQRe_C2hAIMAWX7j0DGQZGqgaS0q6Md9cmXej2v_f-S0Tc1hq3UZY4Z3EWWpx-t4T0KG0H-Y7t1iX1ti5zkrsiDzrktefyvBzu30HFUb_1xA5VIh-AFZmpsCcNHtFkAI3ogME6IKWMCgrI5ZRTYk1s0NrgvXh_APF7ODI:1u5HTQ:1OZGH37AZhRAxldTkQuAjUjp-wViXf_eI6YeOtUMsJw','2025-05-01 05:07:40.066281'),('bdcnbokvcnymadxxws16pz905holt6yz','.eJxVjEEOwiAQRe_C2hAIMAWX7j0DGQZGqgaS0q6Md9cmXej2v_f-S0Tc1hq3UZY4Z3EWWpx-t4T0KG0H-Y7t1iX1ti5zkrsiDzrktefyvBzu30HFUb_1xA5VIh-AFZmpsCcNHtFkAI3ogME6IKWMCgrI5ZRTYk1s0NrgvXh_APF7ODI:1uAaqs:x5QxOqYSBalQTx7pDDhtUmgoA6kRqIZaLD9ddC3blTs','2025-05-15 20:49:50.136405'),('bejzstzji9k9it4qhc56widzzggxmley','.eJxVjMsOwiAQRf-FtSE8Zgi4dO83kAGmUjWQlHZl_Hdt0oVu7znnvkSkba1xG7zEuYiz0EGcfsdE-cFtJ-VO7dZl7m1d5iR3RR50yGsv_Lwc7t9BpVG_dcglYEKdGNAlsqTRG_KEhiaTOcBkNGTlEdlhUZ4d6AKgLLvsLHvx_gAPODfZ:1uAVyM:-ohC_189zgPrk02oUq7HVx6QO_u9IasKIJ5FFP1YNCY','2025-05-15 15:37:14.551643'),('bp8jmob0s5jl084nw073e94jfxr236y2','.eJxVjEEOwiAQRe_C2hAIMAWX7j0DGQZGqgaS0q6Md9cmXej2v_f-S0Tc1hq3UZY4Z3EWWpx-t4T0KG0H-Y7t1iX1ti5zkrsiDzrktefyvBzu30HFUb_1xA5VIh-AFZmpsCcNHtFkAI3ogME6IKWMCgrI5ZRTYk1s0NrgvXh_APF7ODI:1uB2ks:C3n9rdsTgVpDZFUAC1yuehVVEmlbQr4IsBK3jlENeNo','2025-05-17 02:37:30.155789'),('drgwn23ixman0cw1p2l5wckr9tkri7ee','.eJxVjMsOwiAQRf-FtSE8Zgi4dO83kAGmUjWQlHZl_Hdt0oVu7znnvkSkba1xG7zEuYiz0EGcfsdE-cFtJ-VO7dZl7m1d5iR3RR50yGsv_Lwc7t9BpVG_dcglYEKdGNAlsqTRG_KEhiaTOcBkNGTlEdlhUZ4d6AKgLLvsLHvx_gAPODfZ:1tyLTf:nlUAHzIubZOAN_Hb0ZIj43yIsz98dWsPU1aDdFEJ_XE','2025-04-12 01:59:15.982455'),('fyxd200obwurrlpw4314bayt8r6dic2t','.eJxVjEEOwiAQRe_C2hAIMAWX7j0DGQZGqgaS0q6Md9cmXej2v_f-S0Tc1hq3UZY4Z3EWWpx-t4T0KG0H-Y7t1iX1ti5zkrsiDzrktefyvBzu30HFUb_1xA5VIh-AFZmpsCcNHtFkAI3ogME6IKWMCgrI5ZRTYk1s0NrgvXh_APF7ODI:1u3UVR:l33eWA26Y3T4c2fdV9C0gDeB2M5IGc5TpO7Vk4dft-o','2025-04-26 06:38:21.519743'),('j1e415hv4zgwr3g5pkj919g1htsn4o8h','.eJxVjEEOwiAQRe_C2hCGoQVcuvcMZICpVA0kpV0Z765NutDtf-_9lwi0rSVsnZcwZ3EWIE6_W6T04LqDfKd6azK1ui5zlLsiD9rltWV-Xg7376BQL9_aD0oNbMkzsCPjk0NDemIeQdlErIEgJowjsjbOojZApJzNCTXmyYr3B94TN8A:1tyiGD:ZW1H5mltSAxmC46AXoAg_-MoNmBpuCakZuNxoV5OKhI','2025-04-13 02:18:53.437374'),('k6edldqt480iyz4l9qmafsr48vu1mvno','.eJxVjEEOwiAQRe_C2hAIMAWX7j0DGQZGqgaS0q6Md9cmXej2v_f-S0Tc1hq3UZY4Z3EWWpx-t4T0KG0H-Y7t1iX1ti5zkrsiDzrktefyvBzu30HFUb_1xA5VIh-AFZmpsCcNHtFkAI3ogME6IKWMCgrI5ZRTYk1s0NrgvXh_APF7ODI:1u3fbt:jEkTqp0X-lZZ6gtKW4Tb58XcbKzgba0f9P6OiSgy0zs','2025-04-26 18:29:45.807583'),('nrcu5lk8ncyidb3o5f0j9dekf2sgt9kh','.eJxVjMsOwiAQRf-FtSGUCS-X7v0GMgyMVA0kpV0Z_12bdKHbe865LxFxW2vcRlninMVZaCVOv2NCepS2k3zHduuSeluXOcldkQcd8tpzeV4O9--g4qjfunhUBi1q4Mkap3KwFBJYVyA48EQ6AHJ2rJi9VhMjZOMMJ4Oggifx_gAB8zgS:1u29DD:MzOw8Fbtx2ZylCwxlZG_2zW5wlsuc5UOjO7_s_RypCo','2025-04-22 13:41:59.997301'),('qs8ixphyzxsbjkv9wqbvdf55nq2o6x9k','.eJxVjEEOwiAQRe_C2hAIMAWX7j0DGQZGqgaS0q6Md9cmXej2v_f-S0Tc1hq3UZY4Z3EWWpx-t4T0KG0H-Y7t1iX1ti5zkrsiDzrktefyvBzu30HFUb_1xA5VIh-AFZmpsCcNHtFkAI3ogME6IKWMCgrI5ZRTYk1s0NrgvXh_APF7ODI:1u6k3a:XSM5rqWd1OePrpH5UiFnmufEDkJCkkuKJmelJlvhtYg','2025-05-05 05:51:02.335444'),('r3bo1e5tyzo688p9gu34aorg1u9vhnws','.eJxVjEEOwiAQRe_C2hAIMAWX7j0DGQZGqgaS0q6Md9cmXej2v_f-S0Tc1hq3UZY4Z3EWWpx-t4T0KG0H-Y7t1iX1ti5zkrsiDzrktefyvBzu30HFUb_1xA5VIh-AFZmpsCcNHtFkAI3ogME6IKWMCgrI5ZRTYk1s0NrgvXh_APF7ODI:1u8lW3:d0LxSpBMi-BlmizjweaMFXvH3CD3KYfKGpJl4kspUag','2025-05-10 19:48:47.243770'),('ujeks9pckywzbi9hv5q95vtpps8vb3d8','.eJxVjDsOwjAQBe_iGln-G1PS5wzWrneNAyiR4qRC3B0ipYD2zcx7iQzb2vLWeckjiYswWpx-R4Ty4GkndIfpNssyT-syotwVedAuh5n4eT3cv4MGvX1rjCkmAEpnZ4zD4NGnmjSUgOipggtVkdWEbG0MXilniSNH43RgRhbvDw9kOGs:1u8T94:CsjLF9HBWe-Yb5OKvlyZoIpCIMBMxQYJP-HtdzeEtnw','2025-05-10 00:11:50.761571'),('wczd5mdobs9em0n2dr101ee8986xpd87','.eJxVjEEOwiAQRe_C2hAIMAWX7j0DGQZGqgaS0q6Md9cmXej2v_f-S0Tc1hq3UZY4Z3EWWpx-t4T0KG0H-Y7t1iX1ti5zkrsiDzrktefyvBzu30HFUb_1xA5VIh-AFZmpsCcNHtFkAI3ogME6IKWMCgrI5ZRTYk1s0NrgvXh_APF7ODI:1uH8ct:WIlTYjZbpVpblWSQyCM12-sL1dbBRBiZDqAJAP_MHJ4','2025-06-02 22:06:27.533016'),('zormhs6996fmhrxlfpty6fhjpepzi86v','.eJxVjEEOwiAQRe_C2hAIMAWX7j0DGQZGqgaS0q6Md9cmXej2v_f-S0Tc1hq3UZY4Z3EWWpx-t4T0KG0H-Y7t1iX1ti5zkrsiDzrktefyvBzu30HFUb_1xA5VIh-AFZmpsCcNHtFkAI3ogME6IKWMCgrI5ZRTYk1s0NrgvXh_APF7ODI:1u3bOa:jjLgChPK1VHzpsVoWOQYl7EYZTcR_wCgURkMrHdpqfY','2025-04-26 13:59:44.505196');

--
-- Table structure for table `profile`
--

CREATE TABLE `profile` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(128) DEFAULT NULL,
  `firstname` varchar(128) DEFAULT NULL,
  `lastname` varchar(128) DEFAULT NULL,
  `password` varchar(128) DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `is_superuser` tinyint(1) DEFAULT 0,
  `is_staff` tinyint(1) DEFAULT 0,
  `is_active` tinyint(1) DEFAULT 1,
  `date_joined` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `profile`
--

INSERT INTO `profile` VALUES (1,'jmanecke@umich.edu','Drew','Manecke','pbkdf2_sha256$600000$pNuVUdgifHmrmjtCqnu7LP$aULP2VOm2ETpECVW8PIQFeT3pV34Y2IjDKCCKLXocDk=','2025-05-23 20:10:02',1,1,1,'2025-03-26 15:00:31'),(19,'emailjvasek@gmail.com','John','Vasek','pbkdf2_sha256$600000$RH5Nrebd9XqDeSDGFW1pnm$JZr9tdLtM4cTOoa78w66aKeL3kb3RgjzwLcUfEhh6gg=','2025-04-30 20:30:43',0,0,1,'2025-03-28 22:21:39'),(20,'rezoanshuvro@gmail.com','Rezoan','Ahmed','pbkdf2_sha256$600000$0iJgpaJzJRPqALAbql7A1v$7GCVmrMdNVA7l/An/yJ5PKKVOqLZHe9gWoLi3ooU/sM=','2025-04-08 13:39:42',0,0,1,'2025-04-07 19:27:04'),(21,'cologlu@udel.edu','Ziya','Cologlu','pbkdf2_sha256$600000$8bWXhXn2PFjtNz9uKWNetp$5C/p1vxhnGc+YqKftgM6TJq7XTKBCGeVdVxhAUzm0E8=','2025-04-12 18:09:24',0,0,1,'2025-04-10 14:56:54'),(22,'themietelskis@gmail.com','Josh','Mietelski','pbkdf2_sha256$600000$Qdc8GGU4ctnpzuZqwuDkgw$C1ZIMHYzPe6MHkxG25bW7HuXU1JEimqBTOjgIgHi3Us=',NULL,0,0,1,'2025-04-12 18:34:21'),(23,'dummy@dummyusername.com','Dummy','Username','pbkdf2_sha256$600000$IrZ5IK4umE0dlFCC6v7q9v$nkjL7dwV5ZTWb5qrLeoRYFC4Rsi8uiF7U2EvE6LWyDc=','2025-04-17 21:21:50',0,0,1,'2025-04-17 03:53:51');

--
-- Table structure for table `resetdata`
--

CREATE TABLE `resetdata` (
  `reset_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `token` varchar(255) NOT NULL,
  `expiry` datetime NOT NULL,
  PRIMARY KEY (`reset_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `fkuserid` FOREIGN KEY (`user_id`) REFERENCES `profile` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `resetdata`
--


--
-- Current Database: `django_db`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `django_db` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;

USE `django_db`;

--
-- Current Database: `creds`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `creds` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;

USE `creds`;

--
-- Table structure for table `credentials`
--

CREATE TABLE `credentials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `service_name` varchar(255) NOT NULL,
  `key_name` varchar(255) NOT NULL,
  `encrypted_value` text NOT NULL,
  `last_updated` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_user_service_key` (`user_id`,`service_name`,`key_name`),
  KEY `idx_credentials_user_id` (`user_id`),
  CONSTRAINT `fk_credentials_user_2` FOREIGN KEY (`user_id`) REFERENCES `users`.`profile` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1939 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `credentials`
--

INSERT INTO `credentials` VALUES (1,'ERCOTAPI','SUBSCRIPTION_KEY','s+g8ybvS139mCkXUzpdI2q+VlOQ2pUV3i2BanS8mD1k9DQOcQmSPjshn3TfEUaHBHJw9Agcwkrf4LQW2','2025-04-17 20:57:50',1),(2,'ERCOTAPI','ACCESS_TOKEN','/hXdtViNq1GzqponxKrc/2XXwxW4W22Jzjx9EmsZ3J90+3cjnukJAGk0CFzzjCrb7qH/+5h7Jsht/D6qaFjCvMIPdR3jf5nUK52MSfEtHaTiAFtMB4KRrpORLa6+KHQK54RAI2tZlyDDGUDolEWcRiFvukQ4eyFVboCxOQ6v83nb8rJHX/D6EjiQFAT4GOESHcMoW5VGiJ4Xwz+nxzj8V4Bm94bt+FsPHeDfgzh5lJMa4AMuhEOvRdhdo2AwzpWBTt5TkFbMymsCOIQo/rUzHLjQJKy4CeBMyLx/neCxNwvt/3uMJlppfeUG5KFhnbhdIxMm2FoeO3xr3MzlVtW/llYOC66L+gofobnhYqw3L97NFI2n9pcLPEyry4aY+eWqGX6Q7Xje+1d3Cc7MRpVxntGfs3DFlGMC0e6P/cFEW5p/l7FbCyF48RE+Bmzc0mn9kB+gLWSp+3kqV5+HVOhJ4RgBGeoxNQn+n97gpBeG0rC47DNQtFzwKJTtk4ZdnUy3aXO+sVUjbjveTjdPthuxnsQvEbtfT48qOLyciIcMwPfPNp1r2l4PKEKi8cjj/JRJD1Ao2EstRWvKROYpYybB/xbihlQhjQmClfaCTl08kGn385PV4x0TuGkRrOiQqQWWF4UiFPaOhZfdUUx4ZSQ1v8W5bXIBVK7VwO+y/SghJueTvsUnfB18fYwyYAZ22IwPZtjRL7OMpQuCMhoO3wcFoJp0vAoRm4wNCZULgMum0JLG1ux/pmZMqOBi9OGPxh1xDHf0VxGqiaiZsJS1QU57LKmRgw+DcMV/KGf9V8v/pB6u3AN0M4x8iB8QHmM27c8kDQWPHxBsXdG4VkHznlvKz5VKIjH8nQtGVh51bRfp46xlmjHl5XveqkxjtHWJAENwV4PNdlG6K5w46C2sW046OyK7FCRfIrl059EmsLdwXWGqapJa9bOLr4RDRHrpD12IVT523q4uv47tj5JHo2sdNiL87SySnSrJAkrTaC2eC2lNF9xoEv/2h/sS1BdeCHdwdG4Cb/J/RjbfsCqcnQhqqMX+/UcYeJzqY237ISXG7cJLKksS+jwM1j9DNwbpn4Z7VeYxZUMbtE5KU+bfOyQPQy8zoa+t4HJaV0B9a4tjM3wF9nz9RgNIn+3zpHCCkibiCu96amCbC48Igk3IWdlLCc2uqn8/SdJGibeLnx/1fImVTYwxW2VF9zQYzuueboJJKRJvRxEkPhuJJ8+lQ+OIoqWgeE1dxGbavjpD14FyiRtJj+2Ar7rmoxp8B48eZj1nARvGCIAeC7/Uq2W7MteD/WEb9MQMgJXwWRPo7ngg3alVYOzEUvjJiARQgEENfIgvPYV1UJk00NseBqXcjD/WBMcv+zh7O0QRMo9Ju+35ORAv5o3jVhuFteQafB33G9p9HpCCmrr7MV0KtoTMwZUCe2ikfmmUTEafyaQ=','2025-05-25 05:15:03',1),(3,'ERCOTAPI','TOKEN_EXPIRY','2025-05-25 01:15:03','2025-05-25 05:15:03',1),(4,'ERCOTAPI','USERNAME','K9HVWirDduQRqbqAM8lilnJ5ymoZEfrZukgTks2x73ex3kAzfAr17+/2VkL9cQ==','2025-04-17 20:57:50',1),(5,'ERCOTAPI','PASSWORD','VST0Lgh/FOQKbHXoG1CWk78JBMKYS8GIhzHPJ5Sk+3bu7tbPbg==','2025-04-17 20:57:50',1),(6,'SCHWABAPI','APP_KEY','JrXP9OCE7mzAYZVGjhixoVdlYsPzjOpDtErb7A6oPLCkKMaE1j97V7e1CZzBN1s/zEsXe3Fkmf2q/ImK','2025-04-17 20:57:50',1),(7,'SCHWABAPI','SECRET','P2G2iRPqwuoPgA4CupIjMSc4OxLbREukYrbF3zdK8HqKldd7EgkXkINb3OE=','2025-04-17 20:57:50',1),(8,'SCHWABAPI','ACCESS_TOKEN','RwqgtCC1YigaK6DKylcha5MJkzCA53+T7cDOG6yD4fj9u4jFVGAeTiMe8ABO2f9h/BCS47/Zx2+n+byNm7yUgimU3o57FyBAWMqxHx+Tt/oLYxigYqARpBMe8AyFXbnU81i+Am/Vxrk=','2025-05-23 20:23:32',1),(9,'SCHWABAPI','REFRESH_TOKEN','wR2nX0EiTwjx2WG0x49TuXtZdQ6e6N1v503WLsN/Yas3i2aTP5v8LDASk1BDsUMP34skQtQ0fToNY0KUs9B5TY4RaGoEVI7ITRBfSizEnoetHLHUL0ze9NfZBYrPuEvTNlrcOPT4OZZ49fBKLrBRPFJdfgtmq7CwQjLXym7aOrqJYK65zEu7PYtirwFgOC780Vn/93aY63tIr4zNcFHBd2nA38hbL6Ma','2025-05-23 20:23:32',1),(10,'SCHWABAPI','TOKEN_EXPIRY','2025-05-23 15:53:32','2025-05-23 20:23:32',1),(11,'PYTHONDOCKER1','USER','Kof6a8DgkTdQKHIOPYPvdOdD0F/6qifPp7Wo4Tua6p7ubGAAwbpFZrsquPxnOA==','2025-04-17 20:57:50',1),(12,'PYTHONDOCKER1','PASS','cmbvypGIgThLeDTwPkcKrHcWEPLENJVf/wSGYjs7X5lcrhAzl/iy1Q==','2025-04-17 20:57:50',1),(13,'FREDAPI','API_KEY','cd2OATCGul5kzO3OSMaFHsfjllBkfkGU9SD7jAi/Dz8e22mvWWEPAoF22WuDhE2mAw3AIRtD4JfSRX4K','2025-05-21 22:01:16',1),(1931,'SCHWABAPI','ACCESS_TOKEN','pfXf4uRepgLu8XyTDH4fBLPRoollbIdlwBmNNzkWxD4O5Xs2Ycgtqtu1JD1LgXKeJeFaaZg6tBPeIVvbmvTw/Oa7ScD7c9BP72zU53YwB6a+h0qtLbiE9Gt02DBEl6Mdd/QzfJ3N0Ds=','2025-05-24 19:29:35',NULL),(1932,'SCHWABAPI','TOKEN_EXPIRY','2025-05-24 14:59:35','2025-05-24 19:29:35',NULL),(1933,'SCHWABAPI','ACCESS_TOKEN','tumEPjJTqBl3kvau0DPy7nx67QQlVFoqqgLc/lYKfUkgrk2lo88TkILXvIRIOKffy61ivMzLL34uiqj1uy92r+CA0+d3Ye8Cf30dytCDJniyznCjGhWjPddfhIo40sJKZkM/B9kKXlE=','2025-05-24 19:57:11',NULL),(1934,'SCHWABAPI','TOKEN_EXPIRY','2025-05-24 15:27:11','2025-05-24 19:57:11',NULL);

--
-- Table structure for table `credentials_backup`
--

CREATE TABLE `credentials_backup` (
  `id` int(11) NOT NULL DEFAULT 0,
  `service_name` varchar(255) NOT NULL,
  `key_name` varchar(255) NOT NULL,
  `encrypted_value` text NOT NULL,
  `last_updated` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `credentials_backup`
--

INSERT INTO `credentials_backup` VALUES (1,'ERCOTAPI','SUBSCRIPTION_KEY','s+g8ybvS139mCkXUzpdI2q+VlOQ2pUV3i2BanS8mD1k9DQOcQmSPjshn3TfEUaHBHJw9Agcwkrf4LQW2','2025-01-23 22:39:12'),(2,'ERCOTAPI','ACCESS_TOKEN','tn9YfemcNuG0H2fJFbMDzrMwFyDg3q5mr9hdDn1sF1gEvKVtfQgteCnAWOQkKHIYSwZ7lIqYgTAlLqz74pwGnFM50F35lX3FmtcorHoGLFntlL0fHX8tREsR3nHWkAfumlG0Wg3KiqPZCwzIq3RoMPgeRiMYA8UxOh40Nz3LuvQejA9RR/1Ha82zFVFsWfQFLekJNhQ1/BVOnUqar1DqopIPd1Y6/1zW+I2SsEY/6AF+JKFJEK2HEsQbNNw9GOOlW5LkResdWVk+8UceBlrlYMwE3Gy/4RK9IMFxWLxt8EWBeYmIJAyRFLOXsolYLg5BWa/FqEkxu274SUwKsLqlfx+/o98hK5oh8RoT7/Qgylw6MEOebLUZCSmbljHGvznq7+Mc86e0y9eC2Agfgws8muZDmSYgOLTl+7jOT6Ke1OrUwXd2/9kFzyVV4RRCiAeOReQk/Zgzq7hKxmSHSfOy6a2rPyA4/vFZp9HG4C9IDMBfLTKag2BBPezjG4DocbKkupSjebyPlTgcx1fgVmXqOZEN/GGAryQBI4wSAGu68/FMqlUzpEGPtA46tpl7tfBFk0WjJVJW2S4XGVPvITayX/cT9K3eb93f6bPFJIbgp8BfiPGZQHqjnjwbri88TWKRDj6jbHryhTa+IMDoOXufi/zJRE4JvkAdmIEvyLO2gbHVcz8jyybRuGoK/GD2eL/tXDztKQL4vFJonPTvWdglimmI/P1Zy3gFih5jj/QIeYufDJUro/E0SVmuxpOCAopqWm6e/gr6o/jMmYNW3ewIz/mBaTThljVWJxc9ct8OH/lL+Xj8BykNzYd8BN243EdTKLK5pWSWW6SeEhVEYETfMoB/ZgLZP04hGTAZBpZ2GYOSk87bNhnjTAktfhamRI2q5buIDQLyln7zZM091P63+MtDfoWkFnmLg3HUYoPewcJdzpl+YttiB/FLdYyJGmbk3rHDQLW6PGxSS3gzVrFmUiP7U6u0gVoaiMUWM9ae1YlkKJAp103RYd1HAiivT3SG06n5AzvAZQUu0yj+DySUiGfldnYUCwB6nNgaoJD4oEhSstyZNi1rknofqfpxAzsSsCIKZKJHKFkn5I6UpTkWytegMdbFEO5YRjbfnV/I3e4RsZ/IQnyPVs7Ctr5B6HWk8XWH3bIoO08tvAC2936w7gc0byWTcP9X8GlTkrDPDy9cK7l1K5qubB0f4U+ZA0HRk0yYPgeeLH3p0XQnt4z8cZGtLE/EnB+ySnCYouQH3BeNbWxEi22Sp3WpOzbGN8E424vrHWersl8R4ScfTAfsSUid9EDLduL2JR1c2WFWEoQ0gXt3s1pN7kduCcsUDURfVQDwdrnvn7QDZ1fRnR6AqJS6mRG9nmJ2r3ErsU3szPoYpB6A2ju3kpR5kTcEKikl11euLtFwZZiXDnrVqBxjL1GqsylL5PLrZFU=','2025-01-23 22:39:13'),(3,'ERCOTAPI','TOKEN_EXPIRY','2025-01-16 18:20:34.490242','2025-01-22 17:11:46'),(4,'SCHWABAPI','APP_KEY','JrXP9OCE7mzAYZVGjhixoVdlYsPzjOpDtErb7A6oPLCkKMaE1j97V7e1CZzBN1s/zEsXe3Fkmf2q/ImK','2025-01-23 22:39:13'),(5,'SCHWABAPI','SECRET','P2G2iRPqwuoPgA4CupIjMSc4OxLbREukYrbF3zdK8HqKldd7EgkXkINb3OE=','2025-01-23 22:39:13'),(6,'SCHWABAPI','ACCESS_TOKEN','PvnYKmtJj4k1lwnok1IOkSe6T4sfHw2tmEi4d7E36bRmutbvj/kIHQ7Y83Z4p3uoIg+9EM5l/Hb2JsmpBRAHn+C5TyaJfyitjaBMCiZYqmTVIXsav6V/MAabBRrfBCRFakprG2R4aTE=','2025-01-31 18:29:27'),(7,'SCHWABAPI','REFRESH_TOKEN','0Sm0BYES8OsnbljTXpPrn588wvGYDEleCIbRGicp70oTWXZRuTjvmpkxC3HJKnLhPswH4lyKkUEjL60XMnL350hsEp5TL4aqjPD/GdC9JeUJvA8yGC5OBD8f2xiz4E8ftNVFBU5Xw9Y/VGdv8m83JUT+l/3DdjyTUU81wzrZI/JCpRLQ/WZ23eSZw1gwoKNqsH1HcZ6yzS1X2MBpcy+bYmI+TQYu52ZO','2025-01-28 16:49:16'),(8,'SCHWABAPI','TOKEN_EXPIRY','2025-01-31 12:59:27','2025-01-31 18:29:27');

--
-- Table structure for table `credentials_new`
--

CREATE TABLE `credentials_new` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `service_name` varchar(255) NOT NULL,
  `key_name` varchar(255) NOT NULL,
  `encrypted_value` text NOT NULL,
  `last_updated` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `service_name` (`service_name`,`key_name`),
  KEY `fk_credentials_user` (`user_id`),
  CONSTRAINT `fk_credentials_user` FOREIGN KEY (`user_id`) REFERENCES `users`.`profile` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `credentials_new`
--

INSERT INTO `credentials_new` VALUES (1,1,'ERCOTAPI','SUBSCRIPTION_KEY','s+g8ybvS139mCkXUzpdI2q+VlOQ2pUV3i2BanS8mD1k9DQOcQmSPjshn3TfEUaHBHJw9Agcwkrf4LQW2','2025-01-23 22:39:12'),(2,1,'ERCOTAPI','ACCESS_TOKEN','tn9YfemcNuG0H2fJFbMDzrMwFyDg3q5mr9hdDn1sF1gEvKVtfQgteCnAWOQkKHIYSwZ7lIqYgTAlLqz74pwGnFM50F35lX3FmtcorHoGLFntlL0fHX8tREsR3nHWkAfumlG0Wg3KiqPZCwzIq3RoMPgeRiMYA8UxOh40Nz3LuvQejA9RR/1Ha82zFVFsWfQFLekJNhQ1/BVOnUqar1DqopIPd1Y6/1zW+I2SsEY/6AF+JKFJEK2HEsQbNNw9GOOlW5LkResdWVk+8UceBlrlYMwE3Gy/4RK9IMFxWLxt8EWBeYmIJAyRFLOXsolYLg5BWa/FqEkxu274SUwKsLqlfx+/o98hK5oh8RoT7/Qgylw6MEOebLUZCSmbljHGvznq7+Mc86e0y9eC2Agfgws8muZDmSYgOLTl+7jOT6Ke1OrUwXd2/9kFzyVV4RRCiAeOReQk/Zgzq7hKxmSHSfOy6a2rPyA4/vFZp9HG4C9IDMBfLTKag2BBPezjG4DocbKkupSjebyPlTgcx1fgVmXqOZEN/GGAryQBI4wSAGu68/FMqlUzpEGPtA46tpl7tfBFk0WjJVJW2S4XGVPvITayX/cT9K3eb93f6bPFJIbgp8BfiPGZQHqjnjwbri88TWKRDj6jbHryhTa+IMDoOXufi/zJRE4JvkAdmIEvyLO2gbHVcz8jyybRuGoK/GD2eL/tXDztKQL4vFJonPTvWdglimmI/P1Zy3gFih5jj/QIeYufDJUro/E0SVmuxpOCAopqWm6e/gr6o/jMmYNW3ewIz/mBaTThljVWJxc9ct8OH/lL+Xj8BykNzYd8BN243EdTKLK5pWSWW6SeEhVEYETfMoB/ZgLZP04hGTAZBpZ2GYOSk87bNhnjTAktfhamRI2q5buIDQLyln7zZM091P63+MtDfoWkFnmLg3HUYoPewcJdzpl+YttiB/FLdYyJGmbk3rHDQLW6PGxSS3gzVrFmUiP7U6u0gVoaiMUWM9ae1YlkKJAp103RYd1HAiivT3SG06n5AzvAZQUu0yj+DySUiGfldnYUCwB6nNgaoJD4oEhSstyZNi1rknofqfpxAzsSsCIKZKJHKFkn5I6UpTkWytegMdbFEO5YRjbfnV/I3e4RsZ/IQnyPVs7Ctr5B6HWk8XWH3bIoO08tvAC2936w7gc0byWTcP9X8GlTkrDPDy9cK7l1K5qubB0f4U+ZA0HRk0yYPgeeLH3p0XQnt4z8cZGtLE/EnB+ySnCYouQH3BeNbWxEi22Sp3WpOzbGN8E424vrHWersl8R4ScfTAfsSUid9EDLduL2JR1c2WFWEoQ0gXt3s1pN7kduCcsUDURfVQDwdrnvn7QDZ1fRnR6AqJS6mRG9nmJ2r3ErsU3szPoYpB6A2ju3kpR5kTcEKikl11euLtFwZZiXDnrVqBxjL1GqsylL5PLrZFU=','2025-01-23 22:39:13'),(3,1,'ERCOTAPI','TOKEN_EXPIRY','2025-01-16 18:20:34.490242','2025-01-22 17:11:46'),(4,1,'SCHWABAPI','APP_KEY','JrXP9OCE7mzAYZVGjhixoVdlYsPzjOpDtErb7A6oPLCkKMaE1j97V7e1CZzBN1s/zEsXe3Fkmf2q/ImK','2025-01-23 22:39:13'),(5,1,'SCHWABAPI','SECRET','P2G2iRPqwuoPgA4CupIjMSc4OxLbREukYrbF3zdK8HqKldd7EgkXkINb3OE=','2025-01-23 22:39:13'),(6,1,'SCHWABAPI','ACCESS_TOKEN','PvnYKmtJj4k1lwnok1IOkSe6T4sfHw2tmEi4d7E36bRmutbvj/kIHQ7Y83Z4p3uoIg+9EM5l/Hb2JsmpBRAHn+C5TyaJfyitjaBMCiZYqmTVIXsav6V/MAabBRrfBCRFakprG2R4aTE=','2025-01-31 18:29:27'),(7,1,'SCHWABAPI','REFRESH_TOKEN','0Sm0BYES8OsnbljTXpPrn588wvGYDEleCIbRGicp70oTWXZRuTjvmpkxC3HJKnLhPswH4lyKkUEjL60XMnL350hsEp5TL4aqjPD/GdC9JeUJvA8yGC5OBD8f2xiz4E8ftNVFBU5Xw9Y/VGdv8m83JUT+l/3DdjyTUU81wzrZI/JCpRLQ/WZ23eSZw1gwoKNqsH1HcZ6yzS1X2MBpcy+bYmI+TQYu52ZO','2025-01-28 16:49:16'),(8,1,'SCHWABAPI','TOKEN_EXPIRY','2025-01-31 12:59:27','2025-01-31 18:29:27');


