##################
# create database
##################

DROP DATABASE IF EXISTS BUFFERTEST;
CREATE DATABASE IF NOT EXISTS BUFFERTEST;
USE BUFFERTEST;

#######
# top
#######

CREATE TABLE A (
  c1 varchar(10000),
  c2 varchar(8)
);

CREATE TABLE B (
  c1 varchar(10000),
  c2 varchar(8)
);

load data local infile "testdata_a.csv" into table A fields terminated by ',';
load data local infile "testdata_b.csv" into table B fields terminated by ',';

GRANT ALL PRIVILEGES ON BUFFERTEST.* TO 'root'@'localhost';
GRANT ALL PRIVILEGES ON BUFFERTEST.* TO 'root'@'*';

COMMIT;
