# phpMyAdmin SQL Dump # version 2.5.3 # http://www.phpmyadmin.net # # Host: localhost # Generation Time: Apr 25, 2008 at 07:55 PM # Server version: 4.0.15 # PHP Version: 4.3.3 # # Database : `cosy` # # -------------------------------------------------------- # # Table structure for table `cpl` # # Creation: Mar 28, 2008 at 11:43 PM # Last update: Apr 10, 2008 at 06:46 PM # DROP TABLE IF EXISTS `cpl`; CREATE TABLE `cpl` ( `cpl_id` int(10) NOT NULL auto_increment, `cpl_code` varchar(10) NOT NULL default '', `cpl_description` varchar(30) NOT NULL default '', `cpl_remark` varchar(30) NOT NULL default '', `cpl_prn` char(1) NOT NULL default '', `cpl_valid` char(1) NOT NULL default '', `cpl_subtot` float NOT NULL default '0', `cpl_creusr` varchar(10) NOT NULL default '', `cpl_creda` datetime NOT NULL default '0000-00-00 00:00:00', `cpl_updusr` varchar(10) NOT NULL default '', `cpl_updda` datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `cpl_id` (`cpl_id`,`cpl_code`), UNIQUE KEY `cpl_code` (`cpl_code`) ) TYPE=MyISAM COMMENT='costplace' AUTO_INCREMENT=1 ; # -------------------------------------------------------- # # Table structure for table `inv` # # Creation: Apr 24, 2008 at 02:29 PM # Last update: Apr 25, 2008 at 11:53 AM # DROP TABLE IF EXISTS `inv`; CREATE TABLE `inv` ( `inv_id` int(10) NOT NULL auto_increment, `sup_id` int(11) NOT NULL default '0', `inv_description` varchar(30) NOT NULL default '', `inv_amount` float NOT NULL default '0', `inv_currency` varchar(5) NOT NULL default '', `inv_bkamount` float(16,4) NOT NULL default '0.0000', `inv_decr` char(1) NOT NULL default '', `inv_docseq` varchar(10) NOT NULL default '', `inv_docdate` date NOT NULL default '0000-00-00', `inv_remark` varchar(10) NOT NULL default '', `inv_prn` char(1) NOT NULL default '', `inv_creusr` varchar(10) NOT NULL default '', `inv_creda` datetime NOT NULL default '0000-00-00 00:00:00', `inv_updusr` varchar(10) NOT NULL default '', `inv_updda` datetime NOT NULL default '0000-00-00 00:00:00', `inv_ok` char(1) NOT NULL default '', UNIQUE KEY `inv_id` (`inv_id`) ) TYPE=MyISAM COMMENT='Incoming invoices' AUTO_INCREMENT=1 ; # -------------------------------------------------------- # # Table structure for table `ixc` # # Creation: Apr 25, 2008 at 02:45 PM # Last update: Apr 25, 2008 at 02:45 PM # DROP TABLE IF EXISTS `ixc`; CREATE TABLE `ixc` ( `ixc_id` int(11) NOT NULL auto_increment, `inv_id` int(11) NOT NULL default '0', `ixc_year` varchar(4) NOT NULL default '', `ixc_amount` float(16,4) NOT NULL default '0.0000', `cpl_code` varchar(10) NOT NULL default '', `ixc_remark` varchar(80) NOT NULL default '', `ixc_creusr` varchar(10) NOT NULL default '', `ixc_creda` datetime NOT NULL default '0000-00-00 00:00:00', `ixc_updusr` varchar(10) NOT NULL default '', `ixc_updda` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`ixc_id`) ) TYPE=MyISAM COMMENT='invoiceamount assigned to costcenter' AUTO_INCREMENT=1 ; # -------------------------------------------------------- # # Table structure for table `sup` # # Creation: Apr 01, 2008 at 11:34 PM # Last update: Apr 01, 2008 at 11:35 PM # DROP TABLE IF EXISTS `sup`; CREATE TABLE `sup` ( `sup_id` int(10) NOT NULL auto_increment, `sup_name` varchar(30) NOT NULL default '', `sup_description` varchar(30) NOT NULL default '', `sup_lastcurrency` varchar(5) NOT NULL default '', `sup_subcount` int(10) NOT NULL default '0', `adr_id` varchar(10) NOT NULL default '', `sup_extid` varchar(10) NOT NULL default '', `sup_lastcpl` varchar(10) NOT NULL default '', `sup_mostcpl` varchar(10) NOT NULL default '', `sup_creusr` varchar(10) NOT NULL default '', `sup_creda` datetime NOT NULL default '0000-00-00 00:00:00', `sup_updusr` varchar(10) NOT NULL default '', `sup_updda` datetime NOT NULL default '0000-00-00 00:00:00', `sup_prn` char(1) NOT NULL default '', UNIQUE KEY `sup_id` (`sup_id`) ) TYPE=MyISAM COMMENT='Supplier Invoice data' AUTO_INCREMENT=1 ;