 ('home/addupdateasset', 1),
 ('home/getnetassets', 1),
 ('home/getotherinfo', 1),
+('home/removeeasset', 1),
 ('login', 999),
 ('otheruserupdate', 0),
 ('user', 1),

  `ppu` double NOT NULL COMMENT 'priceperunit',
  `cppu` double DEFAULT NULL,
  `unitform` varchar(20) NOT NULL,
  `color` int(11) DEFAULT NULL,
  PRIMARY KEY (`assetid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `assets`
--

INSERT INTO `assets` (`assetid`, `userid`, `date`, `subcategoryid`, `assetname`, `assetdescription`, `units`, `ppu`, `cppu`, `unitform`, `color`) VALUES
(1, 0, '2014-04-17', 1, 'HDFC 2000', 'Equity mutual fund\nthis is it', 46, 20, 32, '', 0),
(2, 0, '2014-05-23', 1, 'asd', '', 23, 1, 2, 'ad', 0),
(3, 0, '2014-05-06', 1, 'lkajsdkl', 'llkas;;lad', 56, 1111, 876, 'kgs', 0);

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


  `categoryid` int(11) NOT NULL AUTO_INCREMENT,
  `categoryname` varchar(30) NOT NULL,
  `color` int(11) DEFAULT NULL,
  PRIMARY KEY (`categoryid`),
  UNIQUE KEY `categoryname` (`categoryname`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
