greghelton

drop table if exists Sales;
drop table if exists SalesRep;
drop table if exists Product;
drop table if exists Category;
drop table if exists Manufacturer;
create table Manufacturer (
  id INT NOT NULL AUTO_INCREMENT
, name VARCHAR(50)
, PRIMARY KEY (id)
) ENGINE=INNODB;

greghelton

create database MovieEngagement;

connect MovieEngagement;

create table Theater  (
	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, 
	name VARCHAR(50) NOT NULL
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	
create table Screen  (

greghelton

-- start the server: $ mysqld --console
-- login:            $ mysql -u root --password=wxyz
-- run the script:   mysql> source /Users/javapro/dev/src/sql/Cookbook.sql
-- the script: 

drop database if exists Cookbook;

create database Cookbook; 

connect Cookbook; 

openback

#!/bin/bash
#===============================================================================
#
#          FILE:  iso2wbfs
#
#         USAGE:  ./iso2wbfs [option] FILE... [wbfs directory]
#
#   DESCRIPTION:  Uses wit to convert one or more  Wii ISO into a WBFS file
#                 properly named for use on non-WBFS partitions.
#