-- phpMyAdmin SQL Dump
-- version 2.11.9.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 06, 2010 at 09:18 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.11

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `bakery`
--

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

--
-- Table structure for table `cpl`
--

CREATE TABLE IF NOT EXISTS `cpl` (
  `cpl_id` int(10) NOT NULL auto_increment,
  `cpl_code` varchar(10) character set utf8 collate utf8_bin NOT NULL,
  `cpl_description` varchar(30) character set latin1 NOT NULL default '',
  `cpl_remark` varchar(30) character set latin1 NOT NULL default '',
  `cpl_prn` char(1) character set latin1 NOT NULL default '',
  `cpl_valid` char(1) character set latin1 NOT NULL default '',
  `cpl_subtot` float NOT NULL default '0',
  `cpl_creusr` varchar(10) character set latin1 NOT NULL default '',
  `cpl_creda` datetime NOT NULL default '0000-00-00 00:00:00',
  `cpl_updusr` varchar(10) character set latin1 NOT NULL default '',
  `cpl_updda` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`cpl_id`),
  UNIQUE KEY `cpl_id` (`cpl_id`,`cpl_code`),
  UNIQUE KEY `cpl_code` (`cpl_code`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='costplace' AUTO_INCREMENT=15 ;

--
-- Dumping data for table `cpl`
--

INSERT INTO `cpl` (`cpl_id`, `cpl_code`, `cpl_description`, `cpl_remark`, `cpl_prn`, `cpl_valid`, `cpl_subtot`, `cpl_creusr`, `cpl_creda`, `cpl_updusr`, `cpl_updda`) VALUES
(6, 'bread', 'Basic bread products', '', '', 'T', 0, 'wig', '2008-09-23 23:50:10', '', '0000-00-00 00:00:00'),
(7, 'pastry', 'pies, tarts, croissant', '', '', 'T', 0, 'wig', '2008-09-23 23:51:25', '', '0000-00-00 00:00:00'),
(8, 'light', 'colorypoor products', '', '', 'T', 0, 'wig', '2008-09-23 23:54:18', '', '0000-00-00 00:00:00'),
(9, 'distro', 'sale of external products', '', '', 'T', 0, 'wig', '2008-09-23 23:54:34', '', '0000-00-00 00:00:00'),
(10, 'tmpEnergy', 'Energy to divide', '', '', 'T', 0, 'wig', '2008-09-23 23:55:00', '', '0000-00-00 00:00:00'),
(11, 'tmpGas', 'Energy to divide', '', '', 'T', 0, 'wig', '2008-09-23 23:55:13', '', '0000-00-00 00:00:00'),
(12, 'tmpGeneral', 'General costs', '', '', 'T', 0, 'wig', '2008-09-23 23:55:53', '', '0000-00-00 00:00:00'),
(13, 'shop', 'Sale cost', '', '', 'T', 0, 'wig', '2008-09-23 23:56:20', '', '0000-00-00 00:00:00'),
(14, 'tmpBakery', 'Production cost', '', '', 'T', 0, 'wig', '2008-09-23 23:57:48', '', '0000-00-00 00:00:00');

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

--
-- Table structure for table `inv`
--

CREATE TABLE IF NOT EXISTS `inv` (
  `inv_id` bigint(20) unsigned NOT NULL auto_increment,
  `sup_id` int(11) NOT NULL default '0',
  `inv_description` varchar(30) collate utf8_unicode_ci default NULL,
  `inv_amount` double NOT NULL default '0',
  `inv_currency` varchar(5) collate utf8_unicode_ci default NULL,
  `inv_bkamount` double NOT NULL default '0',
  `inv_decr` varchar(1) collate utf8_unicode_ci default NULL,
  `inv_docseq` varchar(10) collate utf8_unicode_ci default NULL,
  `inv_docdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `inv_remark` varchar(10) collate utf8_unicode_ci default NULL,
  `inv_number` bigint(20) NOT NULL,
  `inv_prn` varchar(1) collate utf8_unicode_ci default NULL,
  `inv_creusr` varchar(10) collate utf8_unicode_ci default NULL,
  `inv_creda` datetime NOT NULL default '0000-00-00 00:00:00',
  `inv_updusr` varchar(10) collate utf8_unicode_ci default NULL,
  `inv_updda` datetime NOT NULL default '0000-00-00 00:00:00',
  `inv_ok` varchar(1) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`inv_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=53 ;

--
-- Dumping data for table `inv`
--

INSERT INTO `inv` (`inv_id`, `sup_id`, `inv_description`, `inv_amount`, `inv_currency`, `inv_bkamount`, `inv_decr`, `inv_docseq`, `inv_docdate`, `inv_remark`, `inv_number`, `inv_prn`, `inv_creusr`, `inv_creda`, `inv_updusr`, `inv_updda`, `inv_ok`) VALUES
(1, 9, 'rent january', 2000, 'EUR', 2000, 'D', '00001', '2008-01-29 00:00:00', '', 0, '', 'wig', '2008-09-23 23:19:53', 'wig', '2008-11-24 17:25:47', ''),
(2, 1, 'Heating jan', 366, 'EUR', 366, 'D', '00002', '2008-01-29 00:00:00', '', 0, '', 'wig', '2008-09-24 16:36:14', 'wig', '2008-11-24 17:09:30', ''),
(4, 2, 'electricity Dec 07', 1200, 'EUR', 1200, 'D', '00003', '2008-01-29 00:00:00', '', 0, '', 'wig', '2008-10-09 00:26:26', 'wig', '2008-11-24 17:09:15', ''),
(5, 5, 'opening account', 200, 'EUR', 200, 'D', '00004', '2008-01-30 00:00:00', '', 0, '', 'wig', '2008-10-10 00:40:57', 'wig', '2008-11-24 17:09:53', ''),
(6, 3, 'Oven ', 44900, 'EUR', 44900, 'D', '00005', '2008-01-30 00:00:00', '', 0, '', 'wig', '2008-10-10 00:48:28', 'wig', '2008-11-24 17:12:22', ''),
(7, 6, 'Airco Model 22 incl inst', 3325, 'EUR', 3325, 'D', '00006', '2008-01-30 00:00:00', '', 0, '', 'wig', '2008-10-10 01:09:27', 'wig', '2008-11-24 17:12:41', ''),
(8, 7, '80 kg flour', 60, 'EUR', 60, 'D', '00007', '2008-01-30 00:00:00', '', 0, '', 'wig', '2008-10-10 01:19:56', 'wig', '2008-11-24 17:13:10', ''),
(9, 8, 'advance water 2008', 250, 'EUR', 250, 'D', '00008', '2008-01-30 00:00:00', '', 0, '', 'wig', '2008-10-10 01:25:02', 'wig', '2008-11-24 17:08:43', ''),
(10, 4, 'leasing car jan', 860, 'EUR', 860, 'D', '00009', '2008-01-30 00:00:00', '', 0, '', 'wig', '2008-10-10 01:27:31', 'wig', '2008-11-24 17:08:04', ''),
(11, 5, 'bookkeeping month jan', 360, 'EUR', 360, 'D', '00010', '2008-01-30 00:00:00', '', 0, '', 'wig', '2008-10-10 01:29:56', '', '0000-00-00 00:00:00', ''),
(12, 10, 'milk 100 l', 54, 'EUR', 54, 'D', '00011', '2008-01-30 00:00:00', '', 0, '', 'wig', '2008-10-10 01:36:04', '', '0000-00-00 00:00:00', ''),
(13, 7, 'sugar 100 kg', 36, 'EUR', 36, 'D', '00012', '2008-01-30 00:00:00', '', 0, '', 'wig', '2008-10-10 01:42:27', '', '0000-00-00 00:00:00', ''),
(14, 10, 'butter 20 kg', 100, 'EUR', 100, 'D', '00013', '2008-01-30 00:00:00', '', 0, '', 'wig', '2008-10-10 01:45:30', '', '0000-00-00 00:00:00', ''),
(15, 11, 'yeast 2x.5 kg ', 8.4, 'EUR', 8.4, 'D', '00014', '2008-01-30 00:00:00', '', 0, '', 'wig', '2008-10-10 01:55:43', '', '0000-00-00 00:00:00', ''),
(16, 11, 'extra yeast .5 kg', 4.5, 'EUR', 4.5, 'D', '00015', '2008-01-30 00:00:00', '', 0, '', 'wig', '2008-10-10 01:57:29', '', '0000-00-00 00:00:00', ''),
(17, 12, 'eggs 100 pc', 216, 'EUR', 216, 'D', '00016', '2008-01-30 00:00:00', '', 0, '', 'wig', '2008-10-10 02:02:13', '', '0000-00-00 00:00:00', ''),
(19, 7, '80 kg flour', 60, 'EUR', 60, 'D', '00017', '2008-01-28 00:00:00', '', 0, '', 'wig', '2008-12-18 15:07:40', 'wig', '2008-12-19 10:57:44', ''),
(20, 3, 'Oven repair', 122, 'EUR', 122, 'D', '00018', '2008-01-28 00:00:00', '', 0, '', 'wig', '2008-12-18 15:10:14', 'wig', '2008-12-19 10:58:04', ''),
(21, 8, 'Install new main connection', 200, 'EUR', 200, 'D', '00019', '2008-01-28 00:00:00', '', 0, '', 'wig', '2008-12-18 15:12:45', 'wig', '2008-12-19 10:58:19', ''),
(22, 1, 'initial connection', 150, 'EUR', 150, 'D', '00020', '2008-01-28 00:00:00', '', 0, '', 'wig', '2008-12-18 15:13:23', 'wig', '2008-12-19 10:58:29', ''),
(23, 2, 'initial connection', 150, 'EUR', 100, 'D', '00021', '2008-01-28 00:00:00', '', 0, '', 'wig', '2008-12-18 15:14:10', 'wig', '2008-12-19 10:58:40', ''),
(24, 15, 'Casio Counter EUR-5', 1450, 'EUR', 1450, 'D', '00022', '2008-02-29 00:00:00', '', 0, '', 'wig', '2008-12-25 14:36:03', 'wig', '2008-12-28 13:53:57', ''),
(25, 11, 'extra yeast 5 kg', 8.4, 'EUR', 8.4, 'D', '00023', '2008-02-28 00:00:00', '', 0, '', 'wig', '2008-12-28 20:33:32', 'wig', '2008-12-28 20:39:03', ''),
(26, 10, 'milk', 43, 'EUR', 43, 'D', '00024', '2008-02-28 00:00:00', '', 0, '', 'wig', '2008-12-28 20:34:02', 'wig', '2008-12-28 20:39:18', ''),
(27, 12, 'eggs', 210, 'EUR', 210, 'D', '00025', '2008-02-28 00:00:00', '', 0, '', 'wig', '2008-12-28 20:34:19', 'wig', '2008-12-28 20:39:26', ''),
(28, 1, 'Heating febr', 366, 'EUR', 366, 'D', '00026', '2008-02-28 00:00:00', '', 0, '', 'wig', '2008-12-28 20:34:41', 'wig', '2008-12-28 20:39:34', ''),
(29, 4, 'leasing feb', 366, 'EUR', 366, 'D', '00027', '2008-02-28 00:00:00', '', 0, '', 'wig', '2008-12-28 20:34:54', 'wig', '2008-12-28 20:39:42', ''),
(30, 9, 'rent  february', 2000, 'EUR', 2000, 'D', '00028', '2008-02-28 00:00:00', '', 0, '', 'wig', '2008-12-28 20:37:09', 'wig', '2008-12-28 20:39:51', ''),
(31, 6, 'maintenance', 100, 'EUR', 100, 'D', '00029', '2008-02-28 00:00:00', '', 0, '', 'wig', '2008-12-28 20:38:16', 'wig', '2008-12-28 20:40:00', ''),
(32, 7, 'delivery flour', 50, 'EUR', 50, 'D', '00030', '2008-02-28 00:00:00', '', 0, '', 'wig', '2008-12-28 20:41:01', 'wig', '2008-12-28 21:03:51', ''),
(33, 2, 'electricity january', 1500, 'EUR', 1500, 'D', '00031', '2008-02-28 00:00:00', '', 0, '', 'wig', '2008-12-28 21:04:33', 'wig', '2008-12-28 22:40:11', ''),
(34, 7, 'delivery ', 0, 'EUR', 0, 'D', '00032', '2008-02-29 00:00:00', '', 0, '', 'wig', '2008-12-30 20:02:53', '', '0000-00-00 00:00:00', ''),
(35, 16, 'ordered abroad', 20, 'USD', 15, 'D', '00033', '2008-02-28 00:00:00', '', 0, '', 'wig', '2008-12-31 00:57:50', '', '0000-00-00 00:00:00', ''),
(36, 17, 'QC meter', 26, 'SFR', 40, 'D', '00034', '2008-02-29 00:00:00', '', 0, '', 'wig', '2008-12-31 01:01:04', '', '0000-00-00 00:00:00', ''),
(38, 8, 'water jan feb ma', 23, 'EUR', 23, 'D', '00035', '2009-03-14 00:00:00', '', 0, '', 'wig', '2009-06-14 23:45:34', '', '0000-00-00 00:00:00', ''),
(39, 8, 'water ', 134, 'EUR', 134, 'D', '00036', '2009-06-30 00:00:00', '', 0, '', 'wig', '2009-07-10 18:05:50', 'wig', '2009-07-28 14:22:43', ''),
(40, 8, 'water ', 34, 'EUR', 34, 'D', '00037', '2009-06-30 00:00:00', '', 0, '', 'wig', '2009-07-10 18:07:36', '', '0000-00-00 00:00:00', ''),
(42, 2, 'electr mnth: march, counter:', 244, 'EUR', 244, 'D', '00038', '2009-03-20 00:00:00', '', 0, '', 'wig', '2009-07-20 11:54:35', '', '0000-00-00 00:00:00', ''),
(43, 7, 'delivery kg:', 251, 'EUR', 251, 'D', '00039', '2009-04-20 00:00:00', '', 210, '', 'wig', '2009-07-20 13:12:18', 'wig', '2009-07-20 13:43:21', ''),
(44, 1, 'months: feb', 788, 'EUR', 788, 'D', '00040', '2009-03-30 00:00:00', '', 123456, '', 'wig', '2009-07-20 13:19:18', 'wig', '2009-07-20 13:22:40', ''),
(45, 6, 'maintenance, repair', 298, 'EUR', 298, 'D', '00041', '2009-03-30 00:00:00', '', 0, '', 'wig', '2009-07-28 14:37:37', 'wig', '2009-07-28 14:41:06', ''),
(47, 1, 'months: ', 100, 'EUR', 100, 'D', '00043', '2009-09-30 00:00:00', '', 0, '', 'wig', '2009-10-23 15:58:38', '', '0000-00-00 00:00:00', ''),
(48, 8, 'water ', 23, 'EUR', 23, 'D', '00044', '2009-09-30 00:00:00', '', 0, '', 'wig', '2009-10-23 16:01:12', '', '0000-00-00 00:00:00', ''),
(49, 1, 'months: ', 344, 'EUR', 344, 'D', '00045', '2009-09-30 00:00:00', '', 0, '', 'wig', '2009-10-23 16:01:30', '', '0000-00-00 00:00:00', ''),
(50, 2, 'electr mnth:', 22, 'EUR', 22, 'D', '00046', '2009-09-30 00:00:00', '', 0, '', 'wig', '2009-10-23 16:02:35', '', '0000-00-00 00:00:00', ''),
(51, 7, 'delivery22', 123, 'EUR', 123, 'D', '00047', '2009-09-30 00:00:00', 'NotToBeRep', 0, '', 'wig', '2009-10-23 16:49:12', 'wig', '2009-10-23 17:24:54', ''),
(52, 11, 'test remark', 12, 'EUR', 12, 'D', '00048', '2009-09-30 00:00:00', '', 0, '', 'wig', '2009-10-23 17:25:14', '', '0000-00-00 00:00:00', '');

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

--
-- Table structure for table `ixc`
--

CREATE TABLE IF NOT EXISTS `ixc` (
  `ixc_id` int(11) NOT NULL auto_increment,
  `inv_id` int(11) NOT NULL default '0',
  `ixc_year` varchar(4) character set latin1 NOT NULL default '',
  `ixc_amount` float(16,4) NOT NULL default '0.0000',
  `cpl_code` varchar(10) character set latin1 NOT NULL default '',
  `ixc_remark` varchar(80) character set latin1 NOT NULL default '',
  `ixc_creusr` varchar(10) character set latin1 NOT NULL default '',
  `ixc_creda` datetime NOT NULL default '0000-00-00 00:00:00',
  `ixc_updusr` varchar(10) character set latin1 NOT NULL default '',
  `ixc_updda` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ixc_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='invoiceamount assigned to costcenter' AUTO_INCREMENT=56 ;

--
-- Dumping data for table `ixc`
--

INSERT INTO `ixc` (`ixc_id`, `inv_id`, `ixc_year`, `ixc_amount`, `cpl_code`, `ixc_remark`, `ixc_creusr`, `ixc_creda`, `ixc_updusr`, `ixc_updda`) VALUES
(2, 1, '2008', 2000.0000, 'tmpBakery', 'rent jan', 'wig', '2008-09-24 11:21:45', 'wig', '2008-10-08 23:59:41'),
(4, 2, '2008', 366.0000, 'tmpGas', '', 'wig', '2008-10-09 00:06:56', '', '0000-00-00 00:00:00'),
(7, 4, '2008', 1200.0000, 'tmpEnergy', '', 'wig', '2008-10-10 00:39:42', '', '0000-00-00 00:00:00'),
(8, 5, '2008', 200.0000, 'tmpGeneral', '', 'wig', '2008-10-10 00:41:33', '', '0000-00-00 00:00:00'),
(25, 6, '2008', 6416.0000, 'bread', '1/7 oven', 'wig', '2008-10-10 01:06:55', '', '0000-00-00 00:00:00'),
(26, 7, '2009', 475.0000, 'shop', '7/7 airco', 'wig', '2008-10-10 01:10:17', '', '0000-00-00 00:00:00'),
(24, 6, '2014', 6414.0000, 'bread', '2/7 oven', 'wig', '2008-10-10 01:06:55', '', '0000-00-00 00:00:00'),
(22, 6, '2012', 6414.0000, 'bread', '4/7 oven', 'wig', '2008-10-10 01:06:55', '', '0000-00-00 00:00:00'),
(23, 6, '2013', 6414.0000, 'bread', '3/7 oven', 'wig', '2008-10-10 01:06:55', '', '0000-00-00 00:00:00'),
(21, 6, '2011', 6414.0000, 'bread', '5/7 oven', 'wig', '2008-10-10 01:06:55', '', '0000-00-00 00:00:00'),
(19, 6, '2009', 6414.0000, 'bread', '7/7 oven', 'wig', '2008-10-10 01:06:55', '', '0000-00-00 00:00:00'),
(20, 6, '2010', 6414.0000, 'bread', '6/7 oven', 'wig', '2008-10-10 01:06:55', '', '0000-00-00 00:00:00'),
(27, 7, '2010', 475.0000, 'shop', '6/7 airco', 'wig', '2008-10-10 01:10:17', '', '0000-00-00 00:00:00'),
(28, 7, '2011', 475.0000, 'shop', '5/7 airco', 'wig', '2008-10-10 01:10:17', '', '0000-00-00 00:00:00'),
(29, 7, '2012', 475.0000, 'shop', '4/7 airco', 'wig', '2008-10-10 01:10:17', '', '0000-00-00 00:00:00'),
(30, 7, '2013', 475.0000, 'shop', '3/7 airco', 'wig', '2008-10-10 01:10:17', '', '0000-00-00 00:00:00'),
(31, 7, '2014', 475.0000, 'shop', '2/7 airco', 'wig', '2008-10-10 01:10:17', '', '0000-00-00 00:00:00'),
(32, 7, '2008', 475.0000, 'shop', '1/7 airco', 'wig', '2008-10-10 01:10:17', '', '0000-00-00 00:00:00'),
(33, 8, '2008', 54.0000, 'bread', '', 'wig', '2008-10-10 01:20:44', '', '0000-00-00 00:00:00'),
(34, 8, '2008', 6.0000, 'pastry', '', 'wig', '2008-10-10 01:20:52', '', '0000-00-00 00:00:00'),
(35, 9, '2008', 250.0000, 'tmpGeneral', '', 'wig', '2008-10-10 01:25:21', '', '0000-00-00 00:00:00'),
(36, 10, '2008', 860.0000, 'tmpGeneral', '', 'wig', '2008-10-10 01:27:47', '', '0000-00-00 00:00:00'),
(37, 12, '2008', 27.0000, 'bread', '', 'wig', '2008-10-10 01:36:48', 'wig', '2008-10-10 01:37:24'),
(38, 12, '2008', 27.0000, 'pastry', '', 'wig', '2008-10-10 01:36:59', 'wig', '2008-10-10 01:37:12'),
(39, 13, '2008', 36.0000, 'pastry', '', 'wig', '2008-10-10 01:43:11', '', '0000-00-00 00:00:00'),
(40, 14, '2008', 100.0000, 'pastry', '', 'wig', '2008-10-10 01:45:37', '', '0000-00-00 00:00:00'),
(41, 15, '2008', 8.4000, 'bread', '', 'wig', '2008-10-10 01:56:54', '', '0000-00-00 00:00:00'),
(42, 16, '2008', 4.5000, 'pastry', '', 'wig', '2008-10-10 01:57:36', '', '0000-00-00 00:00:00'),
(43, 17, '2008', 172.0000, 'pastry', '', 'wig', '2008-10-10 02:02:45', '', '0000-00-00 00:00:00'),
(44, 17, '2008', 44.0000, 'bread', '', 'wig', '2008-10-10 02:02:50', '', '0000-00-00 00:00:00'),
(45, 18, '2008', 2200.0000, 'tmpBakery', '', 'wig', '2008-10-10 02:06:45', '', '0000-00-00 00:00:00'),
(46, 18, '2008', 1400.0000, 'shop', '', 'wig', '2008-10-10 02:09:27', '', '0000-00-00 00:00:00'),
(47, 11, '2008', 360.0000, 'tmpGeneral', '', 'wig', '2008-12-21 18:08:09', '', '0000-00-00 00:00:00'),
(48, 19, '2008', 10.0000, 'pastry', '', 'wig', '2008-12-21 18:09:49', '', '0000-00-00 00:00:00'),
(49, 19, '2008', 50.0000, 'bread', '', 'wig', '2008-12-21 18:09:54', '', '0000-00-00 00:00:00'),
(50, 20, '2008', 122.0000, 'bread', '', 'wig', '2008-12-21 18:10:19', '', '0000-00-00 00:00:00'),
(51, 21, '2008', 200.0000, 'tmpGeneral', '', 'wig', '2008-12-21 18:10:34', '', '0000-00-00 00:00:00'),
(52, 22, '2008', 150.0000, 'tmpGeneral', '', 'wig', '2008-12-21 18:11:04', '', '0000-00-00 00:00:00'),
(53, 23, '2008', 100.0000, 'tmpGeneral', '', 'wig', '2008-12-21 18:11:10', '', '0000-00-00 00:00:00'),
(54, 38, '2008', 23.0000, 'tmpGeneral', '', 'wig', '2009-06-14 23:45:54', '', '0000-00-00 00:00:00'),
(55, 50, '2008', 22.0000, 'tmpEnergy', '', 'wig', '2009-10-23 16:02:49', '', '0000-00-00 00:00:00');

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

--
-- Table structure for table `sup`
--

CREATE TABLE IF NOT EXISTS `sup` (
  `sup_id` int(10) NOT NULL auto_increment,
  `sup_name` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `sup_description` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `sup_lastcurrency` varchar(5) collate utf8_unicode_ci NOT NULL,
  `sup_subcount` int(10) NOT NULL default '0',
  `adr_id` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  `sup_extid` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  `sup_lastcpl` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  `sup_mostcpl` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  `sup_invdescription` varchar(30) collate utf8_unicode_ci NOT NULL,
  `sup_creusr` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  `sup_creda` datetime NOT NULL default '0000-00-00 00:00:00',
  `sup_updusr` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  `sup_updda` datetime NOT NULL default '0000-00-00 00:00:00',
  `sup_prn` char(1) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`sup_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Supplier Invoice data' AUTO_INCREMENT=23 ;

--
-- Dumping data for table `sup`
--

INSERT INTO `sup` (`sup_id`, `sup_name`, `sup_description`, `sup_lastcurrency`, `sup_subcount`, `adr_id`, `sup_extid`, `sup_lastcpl`, `sup_mostcpl`, `sup_invdescription`, `sup_creusr`, `sup_creda`, `sup_updusr`, `sup_updda`, `sup_prn`) VALUES
(1, 'GasCompany', 'Heating', 'EUR', 6, '', '', '', 'tmpGas', 'months: ', 'wig', '2008-09-23 23:03:18', 'wig', '2009-10-23 15:55:40', ''),
(2, 'ElectricityCompany', 'electricity ', 'EUR', 5, '', '', 'tmpEnergy', 'tmpEnergy', 'electr mnth:', 'wig', '2008-09-23 23:04:57', 'wig', '2009-06-14 21:18:27', ''),
(3, 'OvenBuilder', 'Oven', 'EUR', 2, '', '', '', '', 'Oven', 'wig', '2008-09-23 23:05:24', '', '0000-00-00 00:00:00', ''),
(4, 'CarCompany', 'leasing ', 'EUR', 2, '', '', '', '', 'month ', 'wig', '2008-09-23 23:09:34', 'wig', '2009-06-14 21:18:52', ''),
(5, 'Accountant', 'bookkeeping ', 'EUR', 2, '', '', '', '', 'bookkeeping ', 'wig', '2008-09-23 23:11:59', '', '0000-00-00 00:00:00', ''),
(6, 'AircoCompany', 'airco shop', 'EUR', 3, '', '', '', '', 'maintenance', 'wig', '2008-09-23 23:13:46', 'wig', '2009-07-10 17:36:40', ''),
(7, 'MillsCompany', 'flour etc', 'EUR', 7, '', ' ', '', '', 'delivery', 'wig', '2008-09-23 23:15:15', 'wig', '2009-06-14 21:20:29', ''),
(8, 'WaterCompany', 'water ', 'EUR', 6, '', '', 'tmpGeneral', 'tmpGeneral', 'water ', 'wig', '2008-09-23 23:15:29', 'wig', '2009-07-10 18:05:26', ''),
(9, 'RealEstateManagement', 'rent ', 'EUR', 1, '', '', '', '', 'month: ', 'wig', '2008-09-23 23:18:32', 'wig', '2009-06-14 21:19:56', ''),
(10, 'TwoCows', 'milk', 'EUR', 3, '', '', '', '', 'milk', 'wig', '2008-10-10 01:33:10', '', '0000-00-00 00:00:00', ''),
(11, 'BSupplies', '', 'EUR', 5, '', '', '', '', '', 'wig', '2008-10-10 01:53:31', '', '0000-00-00 00:00:00', ''),
(12, 'Chickenfarm', 'eggs', 'EUR', 2, '', '', '', '', 'eggs', 'wig', '2008-10-10 01:59:28', '', '0000-00-00 00:00:00', ''),
(14, 'CarWash', '', '', 0, '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', ''),
(15, 'DigiCom', 'telephone', 'EUR', 1, '', '', '', '', 'month: ', 'wig', '2008-12-21 18:14:02', 'wig', '2009-06-10 23:05:44', ''),
(16, 'FarawayBooks', '', 'USD', 1, '', '', '', '', '', 'wig', '2008-12-31 00:56:50', '', '0000-00-00 00:00:00', ''),
(17, 'PreciseParts', '', 'SFR', 1, '', '', '', '', '', 'wig', '2008-12-31 00:59:43', '', '0000-00-00 00:00:00', ''),
(21, 'testtest', '', 'EUR', 0, '', '', '', '', '', 'wig', '2009-07-10 12:36:06', '', '0000-00-00 00:00:00', ''),
(22, 'test', '', 'EUR', 1, '', '', '', '', '', 'wig', '2009-07-10 12:41:31', '', '0000-00-00 00:00:00', '');
