-- 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', '');