| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154 |
- -- phpMyAdmin SQL Dump
- -- version 2.6.2-pl1
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Erstellungszeit: 09. Dezember 2005 um 09:19
- -- Server Version: 4.1.12
- -- PHP-Version: 4.3.11
- --
- -- Datenbank: `faursprung`
- --
- -- --------------------------------------------------------
- --
- -- Tabellenstruktur für Tabelle `bill`
- --
- CREATE TABLE `bill` (
- `bill_id` int(11) NOT NULL default '0',
- `customer_id` int(11) NOT NULL default '0',
- `tour_id` int(11) NOT NULL default '0',
- `date` date NOT NULL default '0000-00-00'
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Tabellenstruktur für Tabelle `bill_product`
- --
- CREATE TABLE `bill_product` (
- `bill_product_id` int(11) NOT NULL default '0',
- `bill_id` int(11) NOT NULL default '0',
- `product_id` int(11) NOT NULL default '0',
- `amount` float NOT NULL default '0',
- `details` varchar(64) NOT NULL default ''
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Tabellenstruktur für Tabelle `category`
- --
- CREATE TABLE `category` (
- `category_id` int(11) NOT NULL default '0',
- `name` varchar(32) NOT NULL default '',
- `details` varchar(64) NOT NULL default '',
- UNIQUE KEY `category_id` (`category_id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Tabellenstruktur für Tabelle `customer`
- --
- CREATE TABLE `customer` (
- `customer_id` int(11) NOT NULL default '0',
- `password` varchar(32) NOT NULL default '',
- `prename` varchar(32) NOT NULL default '',
- `postname` varchar(32) NOT NULL default '',
- `street` varchar(32) NOT NULL default '',
- `streetnumber` varchar(5) NOT NULL default '',
- `plz` int(5) NOT NULL default '0',
- `city` varchar(32) NOT NULL default '',
- `telephone` varchar(32) NOT NULL default '',
- `telefax` varchar(32) NOT NULL default '',
- `email` varchar(32) NOT NULL default '',
- `pricelist_id` int(11) NOT NULL default '0',
- UNIQUE KEY `customer_id` (`customer_id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Tabellenstruktur für Tabelle `global`
- --
- CREATE TABLE `global` (
- `store` varchar(32) NOT NULL default '',
- `store_details` varchar(64) NOT NULL default '',
- `owner` varchar(64) NOT NULL default '',
- `street` varchar(32) NOT NULL default '',
- `streetnumber` varchar(16) NOT NULL default '',
- `plz` int(11) NOT NULL default '0',
- `city` varchar(32) NOT NULL default '',
- `telephone` varchar(32) NOT NULL default '',
- `telefax` varchar(32) NOT NULL default ''
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Tabellenstruktur für Tabelle `price`
- --
- CREATE TABLE `price` (
- `price_id` int(11) NOT NULL default '0',
- `priceset_id` int(11) NOT NULL default '0',
- `product_id` int(11) NOT NULL default '0',
- `price` float NOT NULL default '0'
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Tabellenstruktur für Tabelle `priceset`
- --
- CREATE TABLE `priceset` (
- `priceset_id` int(11) NOT NULL default '0',
- `name` varchar(32) NOT NULL default ''
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Tabellenstruktur für Tabelle `product`
- --
- CREATE TABLE `product` (
- `product_id` int(11) NOT NULL default '0',
- `name` varchar(32) NOT NULL default '',
- `details` varchar(64) NOT NULL default '',
- `category_id` int(11) NOT NULL default '0',
- `tax_id` int(11) NOT NULL default '0',
- UNIQUE KEY `product_id` (`product_id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Tabellenstruktur für Tabelle `tax`
- --
- CREATE TABLE `tax` (
- `tax_id` int(11) NOT NULL default '0',
- `name` varchar(32) NOT NULL default '',
- `tax_rate` float NOT NULL default '0',
- UNIQUE KEY `tax_id` (`tax_id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Tabellenstruktur für Tabelle `tour`
- --
- CREATE TABLE `tour` (
- `tour_id` int(11) NOT NULL default '0',
- `name` varchar(32) NOT NULL default ''
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|