--
-- Host: localhost    Database: bank
-- ------------------------------------------------------


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

CREATE TABLE `transactions` (
  `uuid` varchar(36) NOT NULL,
  `amount` decimal(10,0) NOT NULL,
  `date` varchar(255) NOT NULL DEFAULT '',
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  `status` enum('DECLINED','PENDING','ACEPTED') NOT NULL DEFAULT 'PENDING',
  `type` enum('SEND','RECEIVE') NOT NULL DEFAULT 'RECEIVE',
  `from` varchar(255) NOT NULL,
  `to` varchar(255) NOT NULL,
  `userUuid` varchar(36) NOT NULL,
  PRIMARY KEY (`uuid`),
  KEY `FK_88653dbe9b078bbd43b3534d44d` (`userUuid`),
  CONSTRAINT `FK_88653dbe9b078bbd43b3534d44d` FOREIGN KEY (`userUuid`) REFERENCES `users` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `uuid` varchar(36) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` enum('ADMIN','USER') NOT NULL DEFAULT 'USER',
  `firstName` varchar(255) NOT NULL DEFAULT '',
  `lastName` varchar(255) NOT NULL DEFAULT '',
  `address` varchar(255) NOT NULL DEFAULT '',
  `formLocation` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`uuid`),
  KEY `IDX_97672ac88f789774dd47f7c8be` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES ('0e3d1429-3310-416b-8d0d-6e549fd612c3','admin@bank.com','$2a$12$FONBqDEP2q3wW.yCuZuhS.5hLGCQQhlMJ0mMSfYiktIbuE2HiAk2u','ADMIN','Super','Admin','','');


