-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `expenses`
--

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

--
-- Table structure for table `budget`
--

CREATE TABLE IF NOT EXISTS `budget` (
  `budget_id` int NOT NULL,
  `amount` double NOT NULL,
  `startmonth` date NOT NULL,
  `endmonth` date NOT NULL,
  PRIMARY KEY (`budget_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `category`
--

CREATE TABLE IF NOT EXISTS `category` (
  `categoryid` int NOT NULL,
  `categoryname` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`categoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `expense`
--

CREATE TABLE IF NOT EXISTS `expense` (
  `expenseid` int NOT NULL,
  `categoryid` int NOT NULL,
  `item` varchar(255) NOT NULL,
  `price` double NOT NULL,
  `details` text NOT NULL,
  `added_on` date NOT NULL,
  PRIMARY KEY (`expenseid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
COMMIT;

