# MySQL dump 8.13
#
# Host: localhost    Database: premiere
#--------------------------------------------------------
# Server version	3.23.36

#
# Table structure for table 'CUSTOMER'
#

DROP TABLE IF EXISTS CUSTOMER;
CREATE TABLE CUSTOMER (
  CUSTOMER_NUM char(3) NOT NULL default '',
  CUSTOMER_NAME char(35) NOT NULL default '',
  STREET char(15) default NULL,
  CITY char(15) default NULL,
  STATE char(2) default NULL,
  ZIP char(5) default NULL,
  BALANCE decimal(8,2) default NULL,
  CREDIT_LIMIT decimal(8,2) default NULL,
  REP_NUM char(2) default NULL,
  PRIMARY KEY  (CUSTOMER_NUM)
) TYPE=MyISAM;

#
# Dumping data for table 'CUSTOMER'
#

LOCK TABLES CUSTOMER WRITE;
INSERT INTO CUSTOMER VALUES ('148','Al\'s Appliance and Sport','2837 \nGreenway','Fillmore','FL','33336',6550.00,7500.00,'20'),('282','Brookings Direct','3827 \nDevon','Grove','FL','33321',431.50,10000.00,'35'),('356','Ferguson\'s','382 \nWildwood','Northfield','FL','33146',5785.00,7500.00,'65'),('408','The Everything Shop','1828 \nRaven','Crystal','FL','33503',5285.25,5000.00,'35'),('462','Bargains Galore','3829 \nCentral','Grove','FL','33321',3412.00,10000.00,'65'),('524','Kline\'s','838 \nRidgeland','Fillmore','FL','33336',12762.00,15000.00,'20'),('608','Johnson\'s Department Store','372 \nOxford','Sheldon','FL','33553',2106.00,10000.00,'65'),('687','Lee\'s Sport and Appliance','282 \nEvergreen','Altonville','FL','32543',2851.00,5000.00,'35'),('725','Deerfield\'s Four Seasons','282 \nColumbia','Sheldon','FL','33553',248.00,7500.00,'35'),('842','All Season','28 Lakeview','Grove','FL','33321',8221.00,7500.00,'20');
UNLOCK TABLES;

#
# Table structure for table 'ORDERS'
#

DROP TABLE IF EXISTS ORDERS;
CREATE TABLE ORDERS (
  ORDER_NUM char(5) NOT NULL default '',
  ORDER_DATE date default NULL,
  CUSTOMER_NUM char(3) default NULL,
  PRIMARY KEY  (ORDER_NUM)
) TYPE=MyISAM;

#
# Dumping data for table 'ORDERS'
#

LOCK TABLES ORDERS WRITE;
INSERT INTO ORDERS VALUES ('21608','0000-00-00','148'),('21610','0000-00-00','356'),('21613','0000-00-00','408'),('21614','0000-00-00','282'),('21617','0000-00-00','608'),('21619','0000-00-00','148'),('21623','0000-00-00','608');
UNLOCK TABLES;

#
# Table structure for table 'ORDER_LINE'
#

DROP TABLE IF EXISTS ORDER_LINE;
CREATE TABLE ORDER_LINE (
  ORDER_NUM char(5) NOT NULL default '',
  PART_NUM char(4) NOT NULL default '',
  NUM_ORDERED decimal(3,0) default NULL,
  QUOTED_PRICE decimal(6,2) default NULL,
  PRIMARY KEY  (ORDER_NUM,PART_NUM)
) TYPE=MyISAM;

#
# Dumping data for table 'ORDER_LINE'
#

LOCK TABLES ORDER_LINE WRITE;
INSERT INTO ORDER_LINE VALUES ('21608','AT94',11,21.95),('21610','DR93',1,495.00),('21610','DW11',1,399.99),('21613','KL62',4,329.95),('21614','KT03',2,595.00),('21617','BV06',2,794.95),('21617','CD52',4,150.00),('21619','DR93',1,495.00),('21623','KV29',2,1290.00);
UNLOCK TABLES;

#
# Table structure for table 'PART'
#

DROP TABLE IF EXISTS PART;
CREATE TABLE PART (
  PART_NUM char(4) NOT NULL default '',
  DESCRIPTION char(15) default NULL,
  ON_HAND decimal(4,0) default NULL,
  CLASS char(2) default NULL,
  WAREHOUSE char(1) default NULL,
  PRICE decimal(6,2) default NULL,
  PRIMARY KEY  (PART_NUM)
) TYPE=MyISAM;

#
# Dumping data for table 'PART'
#

LOCK TABLES PART WRITE;
INSERT INTO PART VALUES ('AT94','Iron',50,'HW','3',24.95),('BV06','Home Gym',45,'SG','2',794.95),('CD52','Microwave Oven',32,'AP','1',165.00),('DL71','Cordless Drill',21,'HW','3',129.95),('DR93','Gas Range',8,'AP','2',495.00),('DW11','Washer',12,'AP','3',399.99),('FD21','Stand Mixer',22,'HW','3',159.95),('KL62','Dryer',12,'AP','1',349.95),('KT03','Dishwasher',8,'AP','3',595.00),('KV29','Treadmill',9,'SG','2',1390.00);
UNLOCK TABLES;

#
# Table structure for table 'REP'
#

DROP TABLE IF EXISTS REP;
CREATE TABLE REP (
  REP_NUM char(2) NOT NULL default '',
  LAST_NAME char(15) default NULL,
  FIRST_NAME char(15) default NULL,
  STREET char(15) default NULL,
  CITY char(15) default NULL,
  STATE char(2) default NULL,
  ZIP char(5) default NULL,
  COMMISSION decimal(7,2) default NULL,
  RATE decimal(4,2) default NULL,
  PRIMARY KEY  (REP_NUM)
) TYPE=MyISAM;

#
# Dumping data for table 'REP'
#

LOCK TABLES REP WRITE;
INSERT INTO REP VALUES ('20','Kaiser','Valerie','624 Randall','Grove','FL','33321',20542.50,0.05),('35','Hull','Richard','532 Jackson','Sheldon','FL','33553',39216.00,0.07),('65','Perez','Juan','1626 Taylor','Fillmore','FL','33336',23487.00,0.05);
UNLOCK TABLES;