# create Dyna database

DROP DATABASE IF EXISTS Dyna;
CREATE DATABASE Dyna;

# create Customer table

DROP TABLE IF EXISTS Customer;
CREATE TABLE Customer
(
  cMobileNo          char(11)    NOT NULL,
  vName              varchar(25) NOT NULL,
  vPassword          varchar(25) binary     NOT NULL,
  dDateOfBirth       date,
  vAddress           varchar(50) DEFAULT '' NOT NULL,
  vCity              varchar(25) DEFAULT '' NOT NULL,
  vEmail             varchar(20),
  fAmountOutstanding float(6,2)  DEFAULT '0.00',
  PRIMARY KEY (cMobileNo)
);

# insert startup data to Customer table

INSERT INTO Customer VALUES ('09104443230','Roberto Gomez','crug115',NULL,'2344 Roxas Boulevard','Manila City','rob@yeba.net',NULL);
INSERT INTO Customer VALUES ('09104443231','Ahmed Khalid','leif761',NULL,'7365 Riverside Avenue','Bali City','kham@ahlana.com',NULL);
INSERT INTO Customer VALUES ('09104443232','George Smith','sgyw298',NULL,'7465 Acacia Lane','Sunset City','smith@myemail.com',NULL);
INSERT INTO Customer VALUES ('09104443240','Anna Sirowski','djdii111',NULL,'8276 Ibaan Street','Al Bhatin City','anna@dungcorp.com',NULL);
INSERT INTO Customer VALUES ('09104443241','Alex Malitax','jofo399',NULL,'9386 New Orleans Road','Carbon City','alexm@caltron.com',NULL);
INSERT INTO Customer VALUES ('09104443250','Mayet Tamondong','matt818','1932-11-10 00:00:00','6353 Rumbarg Avenue','Sunshine City','matt@jh.com',NULL);
INSERT INTO Customer VALUES ('09104443251','Ricardo Sunico','riss837','1950-10-20 00:00:00','7464 Mahinhin Street','Ormoc City','riss@myemail.com',NULL);
INSERT INTO Customer VALUES ('09104443252','Toni Bilan','tani827','1966-06-20 00:00:00','7363 Sunset Avenue','Burham City','tani@cfh.com',NULL);