 -- AUTO_INCREMENT for table `expenses`
 --
 ALTER TABLE `expenses`
-  MODIFY `ExpenseID` int(11) NOT NULL AUTO_INCREMENT;
+  MODIFY `ExpenseID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
 --
 -- AUTO_INCREMENT for table `utilities`
 --
 ALTER TABLE `utilities`
-  MODIFY `UtilityID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
---
--- Constraints for dumped tables
---
-
---
--- Constraints for table `expenses`
---
-ALTER TABLE `expenses`
-  ADD CONSTRAINT `FK_Expenses_Accounts` FOREIGN KEY (`AccountID`) REFERENCES `accounts` (`AccountID`);
-
---
--- Constraints for table `utilities`
---
-ALTER TABLE `utilities`
-  ADD CONSTRAINT `FK_Utility_Accounts` FOREIGN KEY (`AccountID`) REFERENCES `accounts` (`AccountID`);
-
+  MODIFY `UtilityID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
 /*!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 */;

CREATE TABLE `expenses` (
  `ExpenseID` int(11) NOT NULL,
  `AccountID` int(11) NOT NULL,
  `Expense` varchar(30) DEFAULT NULL,
  `Value` varchar(30) DEFAULT NULL,
  `DateAdded` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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



CREATE TABLE `accounts` (
  `AccountID` int(11) NOT NULL,
  `Password` varchar(60) NOT NULL,
  `Forename` varchar(30) DEFAULT '',
  `Surname` varchar(30) DEFAULT '',
  `Email` varchar(40) DEFAULT '',
  `Income` varchar(20) DEFAULT '',
  `TaxFree` varchar(20) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`AccountID`, `Password`, `Forename`, `Surname`, `Email`, `Income`, `TaxFree`) VALUES
(2525, '$2a$10$VBSuMODXI6p/iIrRz05.ae.LrCATq9TwUslxi/bnx.7WaPQmgP1J.', '', '', '', '', ''),
(4343, '$2a$10$hVwkAlGP1quVHWJdTYPlGerF.XZ1ZluBA.RbT7M6jz7tI.WPGsaOK', 'Alex', 'Test', 'test@gmail.com', '10000.0', ''),
(4444, '$2a$10$MRhYIAxc4C7CaWjKd.EWye5H5vYF35bhW1eOL/3/LDLwUu13hCMfW', '', '', '', '', ''),
(4545, '$2a$10$nhAyVU7F2QBWMFMqUamu5epEvlfOPDAb6LJM6nkYdb6zzMhtmz1tO', 'Alex', 'Morrison', 'asmorrison@hotmail.co.uk', '16000.0', '11500.0'),
(5555, '$2a$12$VLGhtf1zxkskOT3PEzU6ie4FqlWucMsRdP8lGronBkvev0BBrlmAa', 'Alex', 'Morrison', 'Test@gmail.com', '14000.0', '11500.0'),
(7777, '$2a$12$fngptem0NU64qLhrXCbileqisVehYF31tXkti9IVS0vbMNnHR6TEu', '', '', '', '', '');

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

