connect (master,127.0.0.1,root,,test,$MASTER_MYPORT,);
connect (master1,127.0.0.1,root,,test,$MASTER_MYPORT,);
connect (slave,127.0.0.1,root,,test,$SLAVE_MYPORT,);
connect (slave1,127.0.0.1,root,,test,$SLAVE_MYPORT,);

--let $MASTER_MYPORT = 9306
--connection master
set global binlog_format = 'mixed';
--connection slave
set global binlog_format = 'mixed';
stop slave;
change master to master_port=9306, master_host='127.0.0.1', master_user='root', master_connect_retry=1;
start slave;

#--connection master

DROP DATABASE IF EXISTS tpcb;
CREATE DATABASE tpcb;

CREATE TABLE tpcb.account (id INT, bid INT, balance DECIMAL(10,2), 
                           filler CHAR(255), PRIMARY KEY(id)) ENGINE= Falcon;

CREATE TABLE tpcb.branch (bid INT, balance DECIMAL(10,2), filler VARCHAR(255), 
                          PRIMARY KEY(bid))ENGINE = Falcon;

CREATE TABLE tpcb.teller (tid INT, balance DECIMAL(10,2), filler VARCHAR(255), 
                          PRIMARY KEY(tid))ENGINE = Falcon;

CREATE TABLE tpcb.history (id MEDIUMINT NOT NULL AUTO_INCREMENT,aid INT, 
                           tid INT, bid INT,  amount DECIMAL(10,2), 
                           tdate DATETIME, teller CHAR(20), uuidf LONGBLOB,
                           filler CHAR(80),PRIMARY KEY (id))ENGINE = Falcon;

delimiter |;
CREATE PROCEDURE tpcb.load()
BEGIN
  DECLARE acct INT DEFAULT 100000;
  DECLARE brch INT DEFAULT 1000;
  DECLARE tell INT DEFAULT 10000;
  DECLARE tmp INT DEFAULT 100;
  WHILE brch > 0 DO
    SET tmp = 100;
    WHILE tmp > 0 DO
     INSERT INTO tpcb.account VALUES (acct, brch, 0.0, "FRESH ACCOUNT");
     SET acct = acct - 1;
     SET tmp = tmp -1;
    END WHILE;
    INSERT INTO tpcb.branch VALUES (brch, 0.0, "FRESH BRANCH");
    SET brch = brch - 1;
   END WHILE;
  WHILE tell > 0 DO
   INSERT INTO tpcb.teller VALUES (tell, 0.0, "FRESH TELLER");
   SET tell = tell - 1;
  END WHILE;
END|

delimiter ;|

############ Finish Setup Section ###################
USE tpcb;

SET AUTOCOMMIT=0;
CALL tpcb.load();
SET AUTOCOMMIT=1;