 CREATE TABLE `utilities` (
   `UtilityID` int(11) NOT NULL,
   `AccountID` int(11) NOT NULL,
-  `Utility` varchar(30) DEFAULT NULL,
-  `Value` varchar(30) DEFAULT NULL,
-  `BillingCycle` varchar(30) DEFAULT NULL,
-  `DateAdded` varchar(30) DEFAULT NULL
+  `Utility` varchar(30) NOT NULL,
+  `Value` varchar(30) NOT NULL,
+  `BillingCycle` varchar(30) NOT NULL,
+  `DateAdded` varchar(30) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 --


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

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

INSERT INTO `accounts` (`AccountID`, `Password`, `Forename`, `Surname`, `Email`, `Income`) VALUES
(4545, 'aaa', 'Alex', 'Morrison', 'asmorrison@hotmail.co.uk', '10000.0'),
(4646, 'aaa', 'Alex', 'Test', 'test@gmail.com', '');

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



INSERT INTO `utilities` (`UtilityID`, `AccountID`, `Utility`, `Value`, `BillingCycle`, `DateAdded`) VALUES
(1, 4545, 'Gas', '75.76', '3 Month', '12-Apr-2017'),
(2, 4545, 'Water', '45.26', '1 Month', '09-Apr-2017'),
(3, 4545, 'Electric', '74.22', '4 Month', '12-Apr-2017'),
(4, 4646, 'Council Tax', '121.34', '1 Month', '12-Apr-2017');

--
-- Indexes for dumped tables
