DB Dumb with data
All data are test data and doesnot match real data. Database should be created by self.
Details
-- phpMyAdmin SQL Dump
-- version 2.8.0.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 09, 2007 at 08:03 PM
-- Server version: 5.0.20
-- PHP Version: 5.1.2
--
-- Database: `veenas`
--
-- --------------------------------------------------------
--
-- Table structure for table `AccessLog`
--
CREATE TABLE `AccessLog` (
`id` int(10) unsigned NOT NULL auto_increment,
`employee_id` int(10) unsigned NOT NULL default '0',
`checkin` datetime NOT NULL default '0000-00-00 00:00:00',
`checkout` datetime default NULL,
`description` text,
PRIMARY KEY (`id`),
KEY `employee_id` (`employee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `AccessLog`
--
-- --------------------------------------------------------
--
-- Table structure for table `ActiveCustomers`
--
CREATE TABLE `ActiveCustomers` (
`id` int(10) unsigned NOT NULL default '0',
`name` varchar(128) default NULL,
`checkin` datetime default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ActiveCustomers`
--
-- --------------------------------------------------------
--
-- Table structure for table `ActualSales`
--
CREATE TABLE `ActualSales` (
`id` int(10) unsigned NOT NULL auto_increment,
`budget_id` int(10) unsigned NOT NULL default '0',
`service_sales` double NOT NULL default '0',
`product_sales` double NOT NULL default '0',
`labour` double NOT NULL default '0',
`rent` double NOT NULL default '0',
`electricity` double NOT NULL default '0',
`reinvestement` double NOT NULL default '0',
`tax` double NOT NULL default '0',
`remarks` text NOT NULL,
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `budget_id` (`budget_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores the Actual Sales of the company' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ActualSales`
--
-- --------------------------------------------------------
--
-- Table structure for table `Addresses`
--
CREATE TABLE `Addresses` (
`id` int(10) unsigned NOT NULL auto_increment,
`line1` text,
`line2` text,
`line3` text,
`city` varchar(64) default NULL,
`country` varchar(64) default NULL,
`homephone` varchar(64) default NULL,
`workphone` varchar(64) default NULL,
`mobile` varchar(64) default NULL,
`email` varchar(64) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `Addresses`
--
INSERT INTO `Addresses` (`id`, `line1`, `line2`, `line3`, `city`, `country`, `homephone`, `workphone`, `mobile`, `email`) VALUES (2, NULL, NULL, NULL, 'Sankhu', 'Nepal', NULL, NULL, NULL, NULL),
(3, 'Patan', 'test2', 'test3', NULL, 'Nepal', NULL, NULL, NULL, NULL),
(4, 'Patan', NULL, NULL, NULL, 'Nepal', NULL, NULL, NULL, NULL),
(5, 'ad1', 'ad2', 'ad3', 'city1', 'country1', 'homep', 'officep', 'mobp', 'email'),
(6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `Attendance`
--
CREATE TABLE `Attendance` (
`id` int(10) unsigned NOT NULL auto_increment,
`employee_id` int(10) unsigned NOT NULL default '0',
`checkin` datetime NOT NULL default '0000-00-00 00:00:00',
`remark` varchar(32) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `employee_id` (`employee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `Attendance`
--
-- --------------------------------------------------------
--
-- Table structure for table `Budget`
--
CREATE TABLE `Budget` (
`id` int(10) unsigned NOT NULL auto_increment,
`startdate` datetime NOT NULL default '0000-00-00 00:00:00',
`enddate` datetime NOT NULL default '0000-00-00 00:00:00',
`service_sales` double NOT NULL default '0',
`product_sales` double NOT NULL default '0',
`labour` double NOT NULL default '0',
`rent` double NOT NULL default '0',
`electricity` double NOT NULL default '0',
`reinvestement` double NOT NULL default '0',
`tax` double NOT NULL default '0',
`remarks` text NOT NULL,
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='To store the budget of the company' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `Budget`
--
-- --------------------------------------------------------
--
-- Table structure for table `CustomerServices`
--
CREATE TABLE `CustomerServices` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(64) default NULL,
`unitprice` double default NULL,
`description` text,
`remarks` text,
`discontinued` tinyint(1) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `CustomerServices`
--
INSERT INTO `CustomerServices` (`id`, `name`, `unitprice`, `description`, `remarks`, `discontinued`) VALUES (1, 'Hair Massage 2', 124, 'Hair Massage', NULL, 0),
(2, 'Hari Massage 3', 1000, 'hair massage', 'test', 0),
(3, 'Hari Massage 4', 1400, 'hair massage', 'test 4', 0),
(4, 'Hair Massage 1', 1400, '100', 'asdf', 0),
(5, 'Hair Massage 3', 1548, 'test', 'test', 0),
(6, 'Foot massage', 1400, 'fm', 'rm', 0);
-- --------------------------------------------------------
--
-- Table structure for table `CustomerVisitDetails`
--
CREATE TABLE `CustomerVisitDetails` (
`id` int(10) unsigned NOT NULL auto_increment,
`customervisit_id` int(10) unsigned NOT NULL default '0',
`specialist_id` int(10) unsigned default NULL,
`item_id` int(10) unsigned default NULL,
`customerservice_id` int(10) unsigned default NULL,
`transaction_id` int(10) unsigned default NULL,
`quantity` int(10) unsigned default NULL,
`remarks` text,
`realdate` datetime default NULL,
`created` datetime default NULL,
`modified` datetime default NULL,
PRIMARY KEY (`id`),
KEY `CustomerVisitDetails_FKIndex1` (`customervisit_id`),
KEY `CustomerVisitDetails_FKIndex2` (`customerservice_id`),
KEY `CustomerVisitDetails_FKIndex3` (`transaction_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
--
-- Dumping data for table `CustomerVisitDetails`
--
INSERT INTO `CustomerVisitDetails` (`id`, `customervisit_id`, `specialist_id`, `item_id`, `customerservice_id`, `transaction_id`, `quantity`, `remarks`, `realdate`, `created`, `modified`) VALUES (1, 1, 1, NULL, 6, 5, 1, NULL, '2007-05-28 11:05:11', '2007-05-28 11:05:11', '2007-05-28 11:05:11'),
(2, 2, 2, NULL, 6, 10, 1, NULL, '2007-05-28 11:32:54', '2007-05-28 11:32:54', '2007-05-28 11:32:54'),
(3, 3, 3, NULL, 2, 15, 1, NULL, '2007-05-28 14:37:50', '2007-05-28 14:37:50', '2007-05-28 14:37:50'),
(4, 4, 1, NULL, 6, 20, 1, NULL, '2007-05-29 11:21:43', '2007-05-29 11:21:43', '2007-05-29 11:21:43'),
(5, 5, 1, NULL, 6, 25, 1, NULL, '2007-05-29 11:26:57', '2007-05-29 11:26:57', '2007-05-29 11:26:57'),
(6, 6, 2, NULL, 6, 30, 1, '123456879', '2007-05-29 11:32:27', '2007-05-29 11:32:27', '2007-05-29 11:32:27'),
(7, 7, 2, NULL, 6, 35, 1, '123456879', '2007-05-29 11:39:15', '2007-05-29 11:39:15', '2007-05-29 11:39:15'),
(8, 8, 2, NULL, 4, 40, 1, '987654321', '2007-05-29 11:40:13', '2007-05-29 11:40:13', '2007-05-29 11:40:13'),
(9, 9, 3, NULL, 6, 45, 1, '879546213', '2007-05-29 11:54:58', '2007-05-29 11:54:58', '2007-05-29 11:54:58'),
(10, 10, 1, NULL, 1, 50, 1, 'Use a soft shampoo next time', '2007-05-30 12:15:48', '2007-05-30 12:15:48', '2007-05-30 12:15:48'),
(11, 11, 1, NULL, 1, 55, 1, 'use little soft clothes', '2007-05-30 13:01:04', '2007-05-30 13:01:04', '2007-05-30 13:01:04'),
(12, 11, 2, NULL, 3, 56, 1, NULL, '2007-05-30 13:01:04', '2007-05-30 13:01:04', '2007-05-30 13:01:04'),
(13, 12, 2, NULL, 6, 61, 1, 'test', '2007-06-09 07:40:29', '2007-06-09 07:40:29', '2007-06-09 07:40:29');
-- --------------------------------------------------------
--
-- Table structure for table `CustomerVisits`
--
CREATE TABLE `CustomerVisits` (
`id` int(10) unsigned NOT NULL auto_increment,
`customer_id` int(10) unsigned default NULL,
`receiver_id` int(10) unsigned default NULL,
`voucher_id` int(10) unsigned default NULL,
`costtotal` double default NULL,
`discount` double default NULL,
`tax` double default NULL,
`grandtotal` double default NULL,
`amount_paid` double default NULL,
`previous_due` double default NULL,
`realdate` datetime default NULL,
`created` datetime default NULL,
`modified` datetime default NULL,
PRIMARY KEY (`id`),
KEY `CustomerVisits_FKIndex1` (`customer_id`),
KEY `CustomerVisits_FKIndex2` (`voucher_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `CustomerVisits`
--
INSERT INTO `CustomerVisits` (`id`, `customer_id`, `receiver_id`, `voucher_id`, `costtotal`, `discount`, `tax`, `grandtotal`, `amount_paid`, `previous_due`, `realdate`, `created`, `modified`) VALUES (1, 1, 1, 1, 1400, 140, 0, 1260, 1500, NULL, '2007-05-28 11:05:10', '2007-05-28 11:05:11', '2007-05-28 11:05:11'),
(2, 1, 1, 2, 1400, 140, 176.4, 1196.4, 0, NULL, '2007-05-28 11:32:53', '2007-05-28 11:32:53', '2007-05-28 11:32:53'),
(3, 1, 1, 3, 1000, 50, 133, 2039.4, 2000, NULL, '2007-05-28 14:37:50', '2007-05-28 14:37:50', '2007-05-28 14:37:50'),
(4, 1, 1, 4, 1400, 0, 0, 2395.8, 2395.8, NULL, '2007-05-29 11:21:42', '2007-05-29 11:21:42', '2007-05-29 11:21:42'),
(5, 1, 1, 5, 1400, 0, 0, 2395.8, 2395.8, NULL, '2007-05-29 11:26:57', '2007-05-29 11:26:57', '2007-05-29 11:26:57'),
(6, 1, 1, 6, 1400, 0, 0, 2395.8, 2395.8, NULL, '2007-05-29 11:32:27', '2007-05-29 11:32:27', '2007-05-29 11:32:27'),
(7, 1, 1, 7, 1400, 0, 0, 2395.8, 2395.8, NULL, '2007-05-29 11:39:15', '2007-05-29 11:39:15', '2007-05-29 11:39:15'),
(8, 1, 1, 8, 1400, 0, 0, 2395.8, 2395.8, NULL, '2007-05-29 11:40:13', '2007-05-29 11:40:13', '2007-05-29 11:40:13'),
(9, 1, 1, 9, 1400, 0, 0, 2395.8, 2395.8, NULL, '2007-05-29 11:54:58', '2007-05-29 11:54:58', '2007-05-29 11:54:58'),
(10, 2, 1, 10, 124, 0, 17.36, 141.36, 141.36, NULL, '2007-05-30 12:15:48', '2007-05-30 12:15:48', '2007-05-30 12:15:48'),
(11, 2, 1, 11, 1524, 0, 213.36, 1737.36, 1707.36, NULL, '2007-05-30 13:01:04', '2007-05-30 13:01:04', '2007-05-30 13:01:04'),
(12, 1, 1, 12, 1400, 56, 188.16, 1532.16, 1532.16, NULL, '2007-06-09 07:40:29', '2007-06-09 07:40:29', '2007-06-09 07:40:29');
-- --------------------------------------------------------
--
-- Table structure for table `Customers`
--
CREATE TABLE `Customers` (
`id` int(10) unsigned NOT NULL auto_increment,
`address_id` int(10) unsigned default NULL,
`balancedue` double default NULL,
`firstname` varchar(64) default NULL,
`lastname` varchar(64) default NULL,
`dob` date default NULL,
`profession` varchar(64) default NULL,
`pictureurl` text,
`realdate` datetime default NULL,
`created` datetime default NULL,
`modified` datetime default NULL,
PRIMARY KEY (`id`),
KEY `Customers_FKIndex1` (`address_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `Customers`
--
INSERT INTO `Customers` (`id`, `address_id`, `balancedue`, `firstname`, `lastname`, `dob`, `profession`, `pictureurl`, `realdate`, `created`, `modified`) VALUES (1, 2, 0, 'Ramita', 'Shrestha', '1980-05-01', 'Student', NULL, '2007-05-26 07:25:45', '2007-05-26 07:25:45', '2007-05-26 07:32:19'),
(2, 6, 30.0000000000002, 'Sonia', 'Sharma', NULL, NULL, NULL, '2007-05-30 12:14:04', '2007-05-30 12:14:04', '2007-05-30 12:14:04');
-- --------------------------------------------------------
--
-- Table structure for table `EmployeeReviews`
--
CREATE TABLE `EmployeeReviews` (
`id` int(10) unsigned NOT NULL auto_increment,
`employee_id` int(10) unsigned NOT NULL default '0',
`effectivefrom` datetime NOT NULL default '0000-00-00 00:00:00',
`salaryold` int(10) unsigned default NULL,
`salarynew` int(10) unsigned default NULL,
`description` text,
`created` datetime default NULL,
PRIMARY KEY (`id`),
KEY `employee_id` (`employee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `EmployeeReviews`
--
-- --------------------------------------------------------
--
-- Table structure for table `EmployeeSkillRatings`
--
CREATE TABLE `EmployeeSkillRatings` (
`id` int(10) unsigned NOT NULL auto_increment,
`employee_id` int(10) unsigned NOT NULL default '0',
`employeeskill_id` int(10) unsigned NOT NULL default '0',
`rating` int(10) unsigned default NULL,
`created` datetime default NULL,
PRIMARY KEY (`id`),
KEY `EmployeeSkillRatings_FKIndex1` (`employee_id`),
KEY `EmployeeSkillRatings_FKIndex2` (`employeeskill_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `EmployeeSkillRatings`
--
-- --------------------------------------------------------
--
-- Table structure for table `EmployeeSkills`
--
CREATE TABLE `EmployeeSkills` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(64) default NULL,
`description` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `EmployeeSkills`
--
INSERT INTO `EmployeeSkills` (`id`, `title`, `description`) VALUES (1, 'Massage', 'Massage of head,body,legs,etc'),
(2, 'Haircut', 'Haircut - general,new styles, etc'),
(3, 'Facial', 'Facial');
-- --------------------------------------------------------
--
-- Table structure for table `EmployeeVisitDetails`
--
CREATE TABLE `EmployeeVisitDetails` (
`id` int(10) unsigned NOT NULL auto_increment,
`employeevisit_id` int(10) unsigned NOT NULL default '0',
`transaction_id` int(10) unsigned NOT NULL default '0',
`employeevisitdetail_type` int(2) NOT NULL default '0',
`startdate` datetime default NULL,
`enddate` datetime default NULL,
`absentdays` int(2) NOT NULL default '0',
`remarks` text NOT NULL,
`created` datetime default NULL,
`modified` datetime default NULL,
PRIMARY KEY (`id`),
KEY `employeevisit_id` (`employeevisit_id`),
KEY `transaction_id` (`transaction_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Keeps Track of the Details in each Employee''s Visit' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `EmployeeVisitDetails`
--
-- --------------------------------------------------------
--
-- Table structure for table `EmployeeVisits`
--
CREATE TABLE `EmployeeVisits` (
`id` int(10) unsigned NOT NULL auto_increment,
`receiver_id` int(10) unsigned default NULL,
`employee_id` int(10) unsigned default NULL,
`voucher_id` int(10) unsigned default NULL,
`cashtotal` double default NULL,
`tax` double default NULL,
`remarks` text,
`realdate` datetime default NULL,
`created` datetime default NULL,
`modified` datetime default NULL,
PRIMARY KEY (`id`),
KEY `receiver_id` (`receiver_id`),
KEY `employee_id` (`employee_id`),
KEY `voucher_id` (`voucher_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Keeps track of employee''s Visit for cash transactions' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `EmployeeVisits`
--
-- --------------------------------------------------------
--
-- Table structure for table `Employees`
--
CREATE TABLE `Employees` (
`id` int(10) unsigned NOT NULL auto_increment,
`address_id` int(10) unsigned default NULL,
`firstname` varchar(64) default NULL,
`lastname` varchar(64) default NULL,
`datejoined` datetime default NULL,
`dateleft` datetime default NULL,
`orientationdate` datetime default NULL,
`salary` int(10) unsigned default NULL,
`education` text,
`isactive` tinyint(1) default NULL,
`pictureurl` text,
`remark` text,
`realdate` datetime default NULL,
`created` datetime default NULL,
`modified` datetime default NULL,
PRIMARY KEY (`id`),
KEY `Employees_FKIndex1` (`address_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `Employees`
--
INSERT INTO `Employees` (`id`, `address_id`, `firstname`, `lastname`, `datejoined`, `dateleft`, `orientationdate`, `salary`, `education`, `isactive`, `pictureurl`, `remark`, `realdate`, `created`, `modified`) VALUES (1, 3, 'Surendra', 'Maharjan', '2007-05-01 00:00:00', '2007-05-03 00:00:00', '2007-05-02 00:00:00', 10000, NULL, 1, NULL, NULL, '2007-05-26 12:57:47', '2007-05-26 12:57:47', '2007-05-26 19:24:40'),
(2, 4, 'Narad', 'Budhathoki', '2007-05-02 00:00:00', '2007-05-04 00:00:00', '2007-05-03 00:00:00', 10000, NULL, 1, NULL, NULL, '2007-05-26 12:58:06', '2007-05-26 12:58:06', '2007-05-26 19:23:35'),
(3, 5, 'Ramesh', 'Upreti', '2007-05-01 00:00:00', '2007-05-03 00:00:00', '2007-05-02 00:00:00', 1200, 'bachelors', 1, '/a/b/c', 'test', '2007-05-26 18:53:12', '2007-05-26 18:53:12', '2007-05-26 18:53:12');
-- --------------------------------------------------------
--
-- Table structure for table `Groups`
--
CREATE TABLE `Groups` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(32) NOT NULL default '',
`description` text,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `Groups`
--
INSERT INTO `Groups` (`id`, `name`, `description`) VALUES (1, 'MANAGER', ''),
(2, 'NORMALUSER', '');
-- --------------------------------------------------------
--
-- Table structure for table `ItemBrands`
--
CREATE TABLE `ItemBrands` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(64) default NULL,
`remarks` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ItemBrands`
--
-- --------------------------------------------------------
--
-- Table structure for table `ItemCategories`
--
CREATE TABLE `ItemCategories` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(64) default NULL,
`remarks` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ItemCategories`
--
-- --------------------------------------------------------
--
-- Table structure for table `ItemSalesProjection`
--
CREATE TABLE `ItemSalesProjection` (
`id` int(10) unsigned NOT NULL auto_increment,
`startdate` datetime default NULL,
`enddate` datetime default NULL,
`item_id` int(10) unsigned default NULL,
`projectionType` char(1) default NULL,
`actualSalesAmount` double default NULL,
`projectedSalesAmount` double default NULL,
PRIMARY KEY (`id`),
KEY `item_id` (`item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ItemSalesProjection`
--
-- --------------------------------------------------------
--
-- Table structure for table `ItemSuppliers`
--
CREATE TABLE `ItemSuppliers` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(64) default NULL,
`address_id` int(10) unsigned default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ItemSuppliers`
--
-- --------------------------------------------------------
--
-- Table structure for table `ItemTransactions`
--
CREATE TABLE `ItemTransactions` (
`id` int(10) unsigned NOT NULL auto_increment,
`item_id` int(10) unsigned default NULL,
`transaction_id` int(10) unsigned default NULL,
`itemsupplier_id` int(10) unsigned default NULL,
`date` datetime default NULL,
`quantity` int(10) unsigned default NULL,
`stockcurrent` int(10) unsigned default NULL,
`stockprevious` int(10) unsigned default NULL,
`created` datetime default NULL,
`modified` datetime default NULL,
`transactiontype` int(10) unsigned default NULL,
PRIMARY KEY (`id`),
KEY `ItemTransactions_FKIndex1` (`item_id`),
KEY `ItemTransactions_FKIndex2` (`itemsupplier_id`),
KEY `ItemTransactions_FKIndex3` (`transaction_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ItemTransactions`
--
-- --------------------------------------------------------
--
-- Table structure for table `Items`
--
CREATE TABLE `Items` (
`id` int(10) unsigned NOT NULL auto_increment,
`itemcategory_id` int(10) unsigned default NULL,
`itembrand_id` int(10) unsigned default NULL,
`name` varchar(64) default NULL,
`unitsinstock` int(10) unsigned default NULL,
`quantityperunit` int(10) unsigned default NULL,
`unitprice` double unsigned default NULL,
`discontinued` tinyint(1) default NULL,
`realdate` datetime NOT NULL default '0000-00-00 00:00:00',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `Items_FKIndex1` (`itembrand_id`),
KEY `Items_FKIndex2` (`itemcategory_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `Items`
--
-- --------------------------------------------------------
--
-- Table structure for table `ProjectedSales`
--
CREATE TABLE `ProjectedSales` (
`id` int(10) unsigned NOT NULL auto_increment,
`budget_id` int(10) unsigned NOT NULL default '0',
`service_sales` double NOT NULL default '0',
`product_sales` double NOT NULL default '0',
`labour` double NOT NULL default '0',
`rent` double NOT NULL default '0',
`electricity` double NOT NULL default '0',
`reinvestement` double NOT NULL default '0',
`tax` double NOT NULL default '0',
`remarks` text,
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `budget_id` (`budget_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores the projection for future sales of the company' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ProjectedSales`
--
-- --------------------------------------------------------
--
-- Table structure for table `TransactionAccounts`
--
CREATE TABLE `TransactionAccounts` (
`id` int(10) unsigned NOT NULL auto_increment,
`Name` varchar(64) default NULL,
`accounttype` int(10) unsigned default NULL,
`description` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `TransactionAccounts`
--
INSERT INTO `TransactionAccounts` (`id`, `Name`, `accounttype`, `description`) VALUES (1, 'Customer Transaction', 1, 'Transactions related to Customers'),
(2, 'Item Transaction', 2, 'Transactions related to Items'),
(3, 'Employee Transaction', 3, 'Transactions related to Employees'),
(4, 'Other Transaction', 4, 'Transactions related to aspects other than the Employee,Item and Customers');
-- --------------------------------------------------------
--
-- Table structure for table `Transactions`
--
CREATE TABLE `Transactions` (
`id` int(10) unsigned NOT NULL auto_increment,
`voucher_id` int(10) unsigned default NULL,
`accountdebit` int(10) unsigned default NULL,
`accountcredit` int(10) unsigned default NULL,
`amountdebit` double unsigned default NULL,
`amountcredit` double unsigned default NULL,
`date` datetime default NULL,
`description` text,
`created` datetime default NULL,
`modified` datetime default NULL,
PRIMARY KEY (`id`),
KEY `Vouchers_FKIndex1` (`voucher_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=62 ;
--
-- Dumping data for table `Transactions`
--
INSERT INTO `Transactions` (`id`, `voucher_id`, `accountdebit`, `accountcredit`, `amountdebit`, `amountcredit`, `date`, `description`, `created`, `modified`) VALUES (1, 1, 23, NULL, 140, 0, '2007-05-28 11:05:11', 'Discount Given', '2007-05-28 11:05:11', '2007-05-28 11:05:11'),
(2, 1, NULL, 26, 0, 0, '2007-05-28 11:05:11', 'No Tax', '2007-05-28 11:05:11', '2007-05-28 11:05:11'),
(3, 1, 1, NULL, 1500, 0, '2007-05-28 11:05:11', 'Amount Paid Remarks', '2007-05-28 11:05:11', '2007-05-28 11:05:11'),
(4, 1, NULL, 22, 0, 1640, '2007-05-28 11:05:11', 'Bills of the amount in credit are payable to the customers', '2007-05-28 11:05:11', '2007-05-28 11:05:11'),
(5, 1, NULL, 25, 0, 1400, '2007-05-28 11:05:11', NULL, '2007-05-28 11:05:11', '2007-05-28 11:05:11'),
(6, 2, 23, NULL, 140, 0, '2007-05-28 11:32:54', 'Discount Given', '2007-05-28 11:32:54', '2007-05-28 11:32:54'),
(7, 2, NULL, 26, 0, 176.4, '2007-05-28 11:32:54', 'Tax Taken', '2007-05-28 11:32:54', '2007-05-28 11:32:54'),
(8, 2, 1, NULL, 0, 0, '2007-05-28 11:32:54', 'Amount Paid Remarks', '2007-05-28 11:32:54', '2007-05-28 11:32:54'),
(9, 2, 21, NULL, 36.4, 0, '2007-05-28 11:32:54', 'Bills Receivable from Customer so Debited', '2007-05-28 11:32:54', '2007-05-28 11:32:54'),
(10, 2, NULL, 25, 0, 1400, '2007-05-28 11:32:54', NULL, '2007-05-28 11:32:54', '2007-05-28 11:32:54'),
(11, 3, 23, NULL, 50, 0, '2007-05-28 14:37:50', 'Discount Given', '2007-05-28 14:37:50', '2007-05-28 14:37:50'),
(12, 3, NULL, 26, 0, 133, '2007-05-28 14:37:50', 'Tax Taken', '2007-05-28 14:37:50', '2007-05-28 14:37:50'),
(13, 3, 1, NULL, 2000, 0, '2007-05-28 14:37:50', 'Amount Paid Remarks', '2007-05-28 14:37:50', '2007-05-28 14:37:50'),
(14, 3, NULL, 22, 0, 1917, '2007-05-28 14:37:50', 'Bills of the amount in credit are payable to the customers', '2007-05-28 14:37:50', '2007-05-28 14:37:50'),
(15, 3, NULL, 25, 0, 1000, '2007-05-28 14:37:50', NULL, '2007-05-28 14:37:50', '2007-05-28 14:37:50'),
(16, 4, 23, NULL, 0, 0, '2007-05-29 11:21:42', 'No Discount', '2007-05-29 11:21:42', '2007-05-29 11:21:42'),
(17, 4, NULL, 26, 0, 0, '2007-05-29 11:21:42', 'No Tax', '2007-05-29 11:21:42', '2007-05-29 11:21:42'),
(18, 4, 1, NULL, 2395.8, 0, '2007-05-29 11:21:42', 'Amount Paid Remarks', '2007-05-29 11:21:42', '2007-05-29 11:21:42'),
(19, 4, NULL, 22, 0, 2395.8, '2007-05-29 11:21:42', 'Bills of the amount in credit are payable to the customers', '2007-05-29 11:21:42', '2007-05-29 11:21:42'),
(20, 4, NULL, 25, 0, 1400, '2007-05-29 11:21:43', NULL, '2007-05-29 11:21:43', '2007-05-29 11:21:43'),
(21, 5, 23, NULL, 0, 0, '2007-05-29 11:26:57', 'No Discount', '2007-05-29 11:26:57', '2007-05-29 11:26:57'),
(22, 5, NULL, 26, 0, 0, '2007-05-29 11:26:57', 'No Tax', '2007-05-29 11:26:57', '2007-05-29 11:26:57'),
(23, 5, 1, NULL, 2395.8, 0, '2007-05-29 11:26:57', 'Amount Paid Remarks', '2007-05-29 11:26:57', '2007-05-29 11:26:57'),
(24, 5, NULL, 22, 0, 2395.8, '2007-05-29 11:26:57', 'Bills of the amount in credit are payable to the customers', '2007-05-29 11:26:57', '2007-05-29 11:26:57'),
(25, 5, NULL, 25, 0, 1400, '2007-05-29 11:26:57', NULL, '2007-05-29 11:26:57', '2007-05-29 11:26:57'),
(26, 6, 23, NULL, 0, 0, '2007-05-29 11:32:27', 'No Discount', '2007-05-29 11:32:27', '2007-05-29 11:32:27'),
(27, 6, NULL, 26, 0, 0, '2007-05-29 11:32:27', 'No Tax', '2007-05-29 11:32:27', '2007-05-29 11:32:27'),
(28, 6, 1, NULL, 2395.8, 0, '2007-05-29 11:32:27', 'Amount Paid Remarks', '2007-05-29 11:32:27', '2007-05-29 11:32:27'),
(29, 6, NULL, 22, 0, 2395.8, '2007-05-29 11:32:27', 'Bills of the amount in credit are payable to the customers', '2007-05-29 11:32:27', '2007-05-29 11:32:27'),
(30, 6, NULL, 25, 0, 1400, '2007-05-29 11:32:27', '123456879', '2007-05-29 11:32:27', '2007-05-29 11:32:27'),
(31, 7, 23, NULL, 0, 0, '2007-05-29 11:39:15', 'No Discount', '2007-05-29 11:39:15', '2007-05-29 11:39:15'),
(32, 7, NULL, 26, 0, 0, '2007-05-29 11:39:15', 'No Tax', '2007-05-29 11:39:15', '2007-05-29 11:39:15'),
(33, 7, 1, NULL, 2395.8, 0, '2007-05-29 11:39:15', 'Amount Paid Remarks', '2007-05-29 11:39:15', '2007-05-29 11:39:15'),
(34, 7, NULL, 22, 0, 2395.8, '2007-05-29 11:39:15', 'Bills of the amount in credit are payable to the customers', '2007-05-29 11:39:15', '2007-05-29 11:39:15'),
(35, 7, NULL, 25, 0, 1400, '2007-05-29 11:39:15', '123456879', '2007-05-29 11:39:15', '2007-05-29 11:39:15'),
(36, 8, 23, NULL, 0, 0, '2007-05-29 11:40:13', 'No Discount', '2007-05-29 11:40:13', '2007-05-29 11:40:13'),
(37, 8, NULL, 26, 0, 0, '2007-05-29 11:40:13', 'No Tax', '2007-05-29 11:40:13', '2007-05-29 11:40:13'),
(38, 8, 1, NULL, 2395.8, 0, '2007-05-29 11:40:13', 'Amount Paid Remarks', '2007-05-29 11:40:13', '2007-05-29 11:40:13'),
(39, 8, NULL, 22, 0, 2395.8, '2007-05-29 11:40:13', 'Bills of the amount in credit are payable to the customers', '2007-05-29 11:40:13', '2007-05-29 11:40:13'),
(40, 8, NULL, 25, 0, 1400, '2007-05-29 11:40:13', '987654321', '2007-05-29 11:40:13', '2007-05-29 11:40:13'),
(41, 9, 23, NULL, 0, 0, '2007-05-29 11:54:58', 'No Discount', '2007-05-29 11:54:58', '2007-05-29 11:54:58'),
(42, 9, NULL, 26, 0, 0, '2007-05-29 11:54:58', 'No Tax', '2007-05-29 11:54:58', '2007-05-29 11:54:58'),
(43, 9, 1, NULL, 2395.8, 0, '2007-05-29 11:54:58', 'Amount Paid Remarks', '2007-05-29 11:54:58', '2007-05-29 11:54:58'),
(44, 9, NULL, 22, 0, 2395.8, '2007-05-29 11:54:58', 'Bills of the amount in credit are payable to the customers', '2007-05-29 11:54:58', '2007-05-29 11:54:58'),
(45, 9, NULL, 25, 0, 1400, '2007-05-29 11:54:58', '879546213', '2007-05-29 11:54:58', '2007-05-29 11:54:58'),
(46, 10, 23, NULL, 0, 0, '2007-05-30 12:15:48', 'No Discount', '2007-05-30 12:15:48', '2007-05-30 12:15:48'),
(47, 10, NULL, 26, 0, 17.36, '2007-05-30 12:15:48', 'Tax Taken', '2007-05-30 12:15:48', '2007-05-30 12:15:48'),
(48, 10, 1, NULL, 141.36, 0, '2007-05-30 12:15:48', 'Amount Paid Remarks', '2007-05-30 12:15:48', '2007-05-30 12:15:48'),
(49, 10, NULL, 22, 0, 124, '2007-05-30 12:15:48', 'Bills of the amount in credit are payable to the customers', '2007-05-30 12:15:48', '2007-05-30 12:15:48'),
(50, 10, NULL, 25, 0, 124, '2007-05-30 12:15:48', 'Use a soft shampoo next time', '2007-05-30 12:15:48', '2007-05-30 12:15:48'),
(51, 11, 23, NULL, 0, 0, '2007-05-30 13:01:04', 'No Discount', '2007-05-30 13:01:04', '2007-05-30 13:01:04'),
(52, 11, NULL, 26, 0, 213.36, '2007-05-30 13:01:04', 'Tax Taken', '2007-05-30 13:01:04', '2007-05-30 13:01:04'),
(53, 11, 1, NULL, 1707.36, 0, '2007-05-30 13:01:04', 'Amount Paid Remarks', '2007-05-30 13:01:04', '2007-05-30 13:01:04'),
(54, 11, NULL, 22, 0, 1494, '2007-05-30 13:01:04', 'Bills of the amount in credit are payable to the customers', '2007-05-30 13:01:04', '2007-05-30 13:01:04'),
(55, 11, NULL, 25, 0, 124, '2007-05-30 13:01:04', 'use little soft clothes', '2007-05-30 13:01:04', '2007-05-30 13:01:04'),
(56, 11, NULL, 25, 0, 1400, '2007-05-30 13:01:04', NULL, '2007-05-30 13:01:04', '2007-05-30 13:01:04'),
(57, 12, 23, NULL, 56, 0, '2007-06-09 07:40:29', 'Discount Given', '2007-06-09 07:40:29', '2007-06-09 07:40:29'),
(58, 12, NULL, 26, 0, 188.16, '2007-06-09 07:40:29', 'Tax Taken', '2007-06-09 07:40:29', '2007-06-09 07:40:29'),
(59, 12, 1, NULL, 1532.16, 0, '2007-06-09 07:40:29', 'Amount Paid Remarks', '2007-06-09 07:40:29', '2007-06-09 07:40:29'),
(60, 12, NULL, 22, 0, 1400, '2007-06-09 07:40:29', 'Bills of the amount in credit are payable to the customers', '2007-06-09 07:40:29', '2007-06-09 07:40:29'),
(61, 12, NULL, 25, 0, 1400, '2007-06-09 07:40:29', 'test', '2007-06-09 07:40:29', '2007-06-09 07:40:29');
-- --------------------------------------------------------
--
-- Table structure for table `Users`
--
CREATE TABLE `Users` (
`id` int(10) unsigned NOT NULL auto_increment,
`employee_id` int(10) unsigned NOT NULL default '0',
`group_id` int(10) unsigned NOT NULL default '0',
`username` varchar(32) default NULL,
`password` varchar(40) default NULL,
`isactive` tinyint(1) NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
KEY `employee_id` (`employee_id`),
KEY `group_id` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `Users`
--
INSERT INTO `Users` (`id`, `employee_id`, `group_id`, `username`, `password`, `isactive`, `created`, `modified`) VALUES (2, 1, 1, 'mukesh', '256d23ebdfeb388c10a3019a2c223ca5c90edfcc', 1, '2007-04-21 13:10:54', '2007-04-21 13:10:54');
-- --------------------------------------------------------
--
-- Table structure for table `Vouchers`
--
CREATE TABLE `Vouchers` (
`id` int(10) unsigned NOT NULL auto_increment,
`type_id` int(10) unsigned default NULL,
`date` datetime default NULL,
`modified` datetime default NULL,
`created` datetime default NULL,
PRIMARY KEY (`id`),
KEY `TransactionAccounts_FKIndex1` (`type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `Vouchers`
--
INSERT INTO `Vouchers` (`id`, `type_id`, `date`, `modified`, `created`) VALUES (1, 1, '2007-05-28 11:05:10', '2007-05-28 11:05:10', '2007-05-28 11:05:10'),
(2, 1, '2007-05-28 11:32:53', '2007-05-28 11:32:53', '2007-05-28 11:32:53'),
(3, 1, '2007-05-28 14:37:50', '2007-05-28 14:37:50', '2007-05-28 14:37:50'),
(4, 1, '2007-05-29 11:21:42', '2007-05-29 11:21:42', '2007-05-29 11:21:42'),
(5, 1, '2007-05-29 11:26:57', '2007-05-29 11:26:57', '2007-05-29 11:26:57'),
(6, 1, '2007-05-29 11:32:27', '2007-05-29 11:32:27', '2007-05-29 11:32:27'),
(7, 1, '2007-05-29 11:39:15', '2007-05-29 11:39:15', '2007-05-29 11:39:15'),
(8, 1, '2007-05-29 11:40:13', '2007-05-29 11:40:13', '2007-05-29 11:40:13'),
(9, 1, '2007-05-29 11:54:58', '2007-05-29 11:54:58', '2007-05-29 11:54:58'),
(10, 1, '2007-05-30 12:15:48', '2007-05-30 12:15:48', '2007-05-30 12:15:48'),
(11, 1, '2007-05-30 13:01:04', '2007-05-30 13:01:04', '2007-05-30 13:01:04'),
(12, 1, '2007-06-09 07:40:29', '2007-06-09 07:40:29', '2007-06-09 07:40:29');