-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 01, 2008 at 11:51 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `cosy`
--

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

--
-- 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 default '',
  `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_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 '',
  UNIQUE KEY `sup_id` (`sup_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Supplier Invoice data' AUTO_INCREMENT=6 ;

--
-- 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_creusr`, `sup_creda`, `sup_updusr`, `sup_updda`, `sup_prn`) VALUES
(1, 'Suse', 'openSuse and Suse Linux', 'EUR', 0, '', '', '', '', 'wig', '2008-05-29 00:00:00', '', '0000-00-00 00:00:00', ''),
(2, 'RedHat', 'Fedora Core en RH Linux', 'USD', 0, '', '', '', '', 'wig', '2008-05-29 00:00:00', '', '0000-00-00 00:00:00', ''),
(3, 'Knopper AG', 'Knoppix Linux Live distro', 'EUR', 0, '', '', '', '', 'wig', '2008-05-29 00:00:00', '', '0000-00-00 00:00:00', ''),
(4, 'Canonical', 'Ubuntu, Kubuntu', 'ZAR', 0, '', '', '', '', 'facs', '2008-05-29 00:46:39', '', '0000-00-00 00:00:00', ''),
(5, 'Future Publishing', 'Linux Format UK', 'GBP', 0, '', '', '', '', 'facs', '2008-06-01 10:26:07', '', '0000-00-00 00:00:00', '');
