[Phoneorder-commits] SF.net SVN: phoneorder: [47] trunk

[<hur...@us...>]

Revision: 47
          http://phoneorder.svn.sourceforge.net/phoneorder/?rev=47&view=rev
Author:   hurikhan
Date:     2007-08-04 10:49:40 -0700 (Sat, 04 Aug 2007)

Log Message:
-----------
Added MySQL schema for everyone's convenience

Added Paths:
-----------
    trunk/db/
    trunk/db/mysql-schema.sql

Added: trunk/db/mysql-schema.sql
===================================================================
--- trunk/db/mysql-schema.sql	                        (rev 0)
+++ trunk/db/mysql-schema.sql	2007-08-04 17:49:40 UTC (rev 47)
@@ -0,0 +1,146 @@
+-- MySQL dump 10.11
+--
+-- Host: terra    Database: phoneorder
+-- ------------------------------------------------------
+-- Server version	5.0.26
+
+/*!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 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Table structure for table `cities`
+--
+
+DROP TABLE IF EXISTS `cities`;
+CREATE TABLE `cities` (
+  `cityid` int(11) NOT NULL auto_increment,
+  `city` varchar(50) NOT NULL,
+  `mdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  `cdate` timestamp NOT NULL default '0000-00-00 00:00:00',
+  PRIMARY KEY  (`cityid`)
+) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='Cities Table';
+
+--
+-- Table structure for table `customers`
+--
+
+DROP TABLE IF EXISTS `customers`;
+CREATE TABLE `customers` (
+  `custid` int(11) NOT NULL auto_increment,
+  `name` varchar(100) NOT NULL,
+  `locid` int(11) NOT NULL default '0',
+  `number` varchar(10) default NULL,
+  `comments` text NOT NULL,
+  `phone` varchar(100) NOT NULL,
+  `custnum` varchar(8) NOT NULL,
+  `mdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  `cdate` timestamp NOT NULL default '0000-00-00 00:00:00',
+  PRIMARY KEY  (`custid`)
+) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='Customer Data';
+
+--
+-- Table structure for table `dishes`
+--
+
+DROP TABLE IF EXISTS `dishes`;
+CREATE TABLE `dishes` (
+  `dishid` int(11) NOT NULL auto_increment,
+  `dishnum` varchar(5) NOT NULL,
+  `dish` varchar(100) NOT NULL,
+  `mdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  `cdate` timestamp NOT NULL default '0000-00-00 00:00:00',
+  PRIMARY KEY  (`dishid`)
+) ENGINE=MyISAM AUTO_INCREMENT=126 DEFAULT CHARSET=utf8 COMMENT='Dish Names Table';
+
+--
+-- Table structure for table `dishprices`
+--
+
+DROP TABLE IF EXISTS `dishprices`;
+CREATE TABLE `dishprices` (
+  `dpid` int(11) NOT NULL auto_increment,
+  `dishid` int(11) NOT NULL default '0',
+  `groupid` int(11) NOT NULL default '0',
+  `price` float(6,2) NOT NULL default '0.00',
+  `mdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  `cdate` timestamp NOT NULL default '0000-00-00 00:00:00',
+  PRIMARY KEY  (`dpid`),
+  UNIQUE KEY `size` (`dishid`,`groupid`)
+) ENGINE=MyISAM AUTO_INCREMENT=262 DEFAULT CHARSET=utf8 COMMENT='Dish Prices Table';
+
+--
+-- Table structure for table `groups`
+--
+
+DROP TABLE IF EXISTS `groups`;
+CREATE TABLE `groups` (
+  `groupid` int(11) NOT NULL auto_increment,
+  `group` varchar(40) NOT NULL,
+  `mdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  `cdate` timestamp NOT NULL default '0000-00-00 00:00:00',
+  PRIMARY KEY  (`groupid`)
+) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COMMENT='Dish Groups Table';
+
+--
+-- Table structure for table `ingprices`
+--
+
+DROP TABLE IF EXISTS `ingprices`;
+CREATE TABLE `ingprices` (
+  `ipid` int(11) NOT NULL auto_increment,
+  `groupid` int(11) NOT NULL default '0',
+  `ingid` int(11) NOT NULL default '0',
+  `price` float(6,2) NOT NULL default '0.00',
+  `mdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  `cdate` timestamp NOT NULL default '0000-00-00 00:00:00',
+  PRIMARY KEY  (`ipid`),
+  UNIQUE KEY `amount` (`groupid`,`ingid`)
+) ENGINE=MyISAM AUTO_INCREMENT=179 DEFAULT CHARSET=utf8 COMMENT='Ingredient Prices Table';
+
+--
+-- Table structure for table `ingredients`
+--
+
+DROP TABLE IF EXISTS `ingredients`;
+CREATE TABLE `ingredients` (
+  `ingid` int(11) NOT NULL auto_increment,
+  `ingnum` varchar(5) NOT NULL,
+  `ingredient` varchar(50) NOT NULL,
+  `mdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  `cdate` timestamp NOT NULL default '0000-00-00 00:00:00',
+  PRIMARY KEY  (`ingid`)
+) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COMMENT='Ingredient Names Table';
+
+--
+-- Table structure for table `locations`
+--
+
+DROP TABLE IF EXISTS `locations`;
+CREATE TABLE `locations` (
+  `locid` int(11) NOT NULL auto_increment,
+  `cityid` int(11) NOT NULL default '0',
+  `street` varchar(100) NOT NULL,
+  `distance` int(11) default '0',
+  `mdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  `cdate` timestamp NOT NULL default '0000-00-00 00:00:00',
+  PRIMARY KEY  (`locid`)
+) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COMMENT='Locations Table';
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
+-- Dump completed on 2007-08-04 17:47:11


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.