SG Broadband Community

Code: Select all

drop table if exists _trips;

 
 
create table _trips (
 
tripID tinyint(3) unsigned auto_increment NOT NULL,
 
tripName char(40) NOT NULL,
 
tripDescription tinytext default null,
 
tripStartDate date NOT NULL,
 
tripEndDate date NOT NULL,
 
tripStartLoc tinyint(3) unsigned NOT NULL,
 
tripEndLoc tinyint(3) unsigned NOT NULL,
 
tripNotes tinytext default null,
 
tripContactInfo tinytext default null,
 
tripCreated datetime,
 
tripModified timestamp,
 
tripIsLeg tinyint(1) unsigned default 0,
 
extTripID tinyint(3) unsigned NOT NULL,
 
tripLegPosition tinyint(2) unsigned default null,
 
 
 
PRIMARY KEY (id, tripName),
 
INDEX (id, tripName, tripEndLoc, tripStartDate)
 
);

Code: Select all

"Last Name","First Name","Street","State","Zip","Home Phone","Work Phone","Cell Phone","Email Address","Estimate Date","Estimate Price","Job Start Date","Completion Date","Work Description","Referred By",'\n\r

Code: Select all

# phpMyAdmin MySQL-Dump
# version 2.2.3
# [url]http://phpwizard.net/phpMyAdmin/[/url]
# [url]http://phpmyadmin.sourceforge.net/[/url] (download page)
#
# Host: localhost
# Generation Time: May 19, 2004 at 10:01 AM
# Server version: 3.23.49
# PHP Version: 4.1.2
# Database : `email`
# --------------------------------------------------------

#
# Table structure for table `addresses`
#

CREATE TABLE addresses (
  Last Name text NOT NULL,
  E-Mail Address text NOT NULL,
  Full Name text NOT NULL,
  Company text NOT NULL,
  Address1 text NOT NULL,
  Address2 text NOT NULL,
  Address3 text NOT NULL,
  City text NOT NULL,
  State text NOT NULL,
  Zip Code text NOT NULL,
  Country text NOT NULL,
  Phone Number text NOT NULL,
  Fax Number text NOT NULL,
  Comments text NOT NULL,
  Cellular Numbar text NOT NULL,
  Other Number text NOT NULL,
  FULLTEXT KEY Alias (Last Name),
  FULLTEXT KEY E-Mail Address (E-Mail Address),
  FULLTEXT KEY Name (Full Name),
  FULLTEXT KEY Company (Company),
  FULLTEXT KEY Address1 (Address1),
  FULLTEXT KEY Address2 (Address2),
  FULLTEXT KEY Address3 (Address3),
  FULLTEXT KEY City (City),
  FULLTEXT KEY State (State),
  FULLTEXT KEY Zip Code (Zip Code),
  FULLTEXT KEY Country (Country),
  FULLTEXT KEY Phone Number (Phone Number),
  FULLTEXT KEY Country_2 (Country),
  FULLTEXT KEY Phone Number_2 (Phone Number),
  FULLTEXT KEY Fax Number (Fax Number),
  FULLTEXT KEY Comments (Comments),
  FULLTEXT KEY Cellular Numbar (Cellular Numbar),
  FULLTEXT KEY Cellular Numbar_2 (Cellular Numbar),
  FULLTEXT KEY Other Number (Other Number)
) TYPE=MyISAM;

Code: Select all

# phpMyAdmin MySQL-Dump
# version 2.2.3
# [url]http://phpwizard.net/phpMyAdmin/[/url]
# [url]http://phpmyadmin.sourceforge.net/[/url] (download page)
#
# Host: localhost
# Generation Time: May 20, 2004 at 10:06 AM
# Server version: 3.23.49
# PHP Version: 4.1.2
# Database : `atco`
# --------------------------------------------------------

#
# Table structure for table `customers`
#

CREATE TABLE customers (
  custID tinyint(4) unsigned NOT NULL auto_increment,
  nameF char(30) NOT NULL default '" "',
  nameL char(30) NOT NULL default '" "',
  street char(48) NOT NULL default '" "',
  city char(30) NOT NULL default '" "',
  state char(2) NOT NULL default '"',
  zip char(10) NOT NULL default '" "',
  phoneH char(13) NOT NULL default '" "',
  phoneW char(13) NOT NULL default '" "',
  phoneC char(13) NOT NULL default '" "',
  fax char(13) NOT NULL default '" "',
  eMail char(48) NOT NULL default '" "',
  PRIMARY KEY  (custID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `income`
#

CREATE TABLE income (
  incID tinyint(4) NOT NULL auto_increment,
  custID tinyint(4) NOT NULL default '0',
  jobID tinyint(4) NOT NULL default '0',
  labID tinyint(4) NOT NULL default '0',
  matID tinyint(4) NOT NULL default '0',
  grossInc decimal(9,0) NOT NULL default '0',
  netInc decimal(9,0) NOT NULL default '0',
  PRIMARY KEY  (incID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `jobs`
#

CREATE TABLE jobs (
  jobID tinyint(4) NOT NULL auto_increment,
  custID tinyint(4) NOT NULL default '0',
  dateEst date NOT NULL default '0000-00-00',
  dateStart date NOT NULL default '0000-00-00',
  dateComp date NOT NULL default '0000-00-00',
  refBy char(30) NOT NULL default '" "',
  jobDescript char(100) NOT NULL default '" "',
  PRIMARY KEY  (jobID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `labor`
#

CREATE TABLE labor (
  labID tinyint(4) NOT NULL auto_increment,
  custID tinyint(4) NOT NULL default '0',
  jobID tinyint(4) NOT NULL default '0',
  labDescript char(100) NOT NULL default '" "',
  labTotal decimal(8,0) NOT NULL default '0',
  PRIMARY KEY  (labID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `materials`
#

CREATE TABLE materials (
  matID tinyint(4) NOT NULL auto_increment,
  custID tinyint(4) NOT NULL default '0',
  jobID tinyint(4) NOT NULL default '0',
  labID tinyint(4) NOT NULL default '0',
  matDescript char(100) NOT NULL default '" "',
  matTotal decimal(8,0) NOT NULL default '0',
  PRIMARY KEY  (matID)
) TYPE=MyISAM;