AccountPlus

--
-- Definition of table `expense_details`
--
CREATE TABLE `expense_details` (
  `Exp_Id` int(11) NOT NULL auto_increment,
  `Item_Id` int(11) default '0',
  `Exp_Desc` varchar(255) default NULL,
  `Exp_Amount` int(11) default '0',
  `Exp_By` int(11) default '0',
  `Exp_Date` datetime default NULL,
  `MonthYear` varchar(50) default NULL,
  `Finalized` int(11) default '0',
  `IsDeleted` int(11) default '0',
  PRIMARY KEY  (`Exp_Id`),
  KEY `Item_Id` (`Item_Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Definition of table `item_details`
--
DROP TABLE IF EXISTS `item_details`;
CREATE TABLE `item_details` (
  `Item_Id` int(11) NOT NULL auto_increment,
  `Item_Name` varchar(50) default NULL,
  `Item_Desc` varchar(250) default NULL,
  `Created_By` varchar(50) default NULL,
  `Entry_Date` datetime default NULL,
  `IsActive` int(11) default '0',
  PRIMARY KEY  (`Item_Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table 'item_Details'
--
INSERT INTO item_Details (Item_Name, Item_Desc, Created_By, IsActive)
VALUES('TestItem','Please edit this item details. Its simply added for test purpose.',1,1);


--
-- Definition of table `roledetails`
--

DROP TABLE IF EXISTS `roledetails`;
CREATE TABLE `roledetails` (
  `RoleId` int(11) NOT NULL auto_increment,
  `Role` varchar(255) default NULL,
  `Description` varchar(255) default NULL,
  PRIMARY KEY  (`RoleId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `roledetails`
--

INSERT INTO `roledetails` (`Role`,`Description`) VALUES 
 ('Admin','Super User'),
 ('User',NULL);



--
-- Definition of table `user_info`
--
CREATE TABLE `user_info` (
  `User_Id` int(11) NOT NULL auto_increment,
  `RoleId` int(11) default NULL,
  `User_Name` varchar(50) default NULL,
  `Pwd` varchar(50) default NULL,
  `First_Name` varchar(50) default NULL,
  `Last_Name` varchar(50) default NULL,
  `EMail` varchar(255) default NULL,
  `Mobile` varchar(255) default NULL,
  `Last_Login_Date` datetime default NULL,
  `Password_Change_Date` datetime default NULL,
  `IsActive` int(11) default '0',
  PRIMARY KEY  (`User_Id`),
  KEY `RoleId` (`RoleId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_info`
--
INSERT INTO `user_info` (`RoleId`,`User_Name`,`Pwd`,`First_Name`,`Last_Name`,`EMail`,`Mobile`,`Last_Login_Date`,`Password_Change_Date`,`IsActive`) VALUES 
 (1,'admin','a6jr0tclfyWJWKaPi9URIQ==','Admin','Admin','ak.tripathi@yahoo.com','9880946821','2009-08-24 00:00:00','2009-08-18 00:00:00',1);