sql

DROP TABLE member;    /* remove this statement if you don't already have a member table created */
DROP TABLE ref_member_type; /* remove this statement if you don't already have a member table created */

CREATE TABLE member(
  mem_no INTEGER (5) PRIMARY KEY AUTO_INCREMENT,
  mem_fname VARCHAR (30),
  mem_mi CHAR (1),
  mem_lname VARCHAR (30),
  mem_duty_ph VARCHAR (15),
  mem_cell_number VARCHAR (15),
  mem_add_1 VARCHAR (50),
  mem_add_2 VARCHAR (50),
  mem_email VARCHAR (50),
  mem_installation VARCHAR (15),
  mem_category_cd CHAR (2),
  mem_type CHAR (1),
  mem_remarks VARCHAR (150),
  mem_position VARCHAR (20),
  mem_add_date_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  mem_last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
 );

/* this statement is to add data into table after its created */
INSERT INTO member (mem_fname, mem_mi, mem_lname, mem_duty_ph, mem_cell_number, mem_add_1, mem_add_2, mem_email, mem_installation, mem_category_cd, mem_type, mem_remarks, mem_position)
VALUES ('Jason', 'T', 'Kidder', '225-4225', '080-9158-6594', 'PSC 78 Box 146', 'APO, AP 96326', 'robin.kidder@yahoo.com', 'Yokota', 'AD', 'I', ' ', 'President');

CREATE TABLE ref_member_type (
    ref_mem_typ CHAR (1) PRIMARY KEY,
    ref_mem_typ_desc VARCHAR (15) NOT NULL
    );
    
INSERT INTO ref_member_type 
VALUES ('I', 'Individual');

INSERT INTO ref_member_type
VALUES ('F', 'Family');