use raj

SET FOREIGN_KEY_CHECKS = 0;
drop table if exists SENATOR;
drop table if exists HREP;
SET FOREIGN_KEY_CHECKS = 1;

create table SENATOR (
  id       int not null auto_increment,
  lname    varchar(25),
  fname    varchar(25),
  birthday date,
  gender   char(1),
  state    char(2),
  party    varchar(20),
  url      varchar(50),
  twitter  varchar(50),
  facebook varchar(50),
  youtube  varchar(50),
  primary key (id)
);

create table HREP (
  id       int not null auto_increment,
  lname    varchar(25),
  fname    varchar(25),
  birthday date,
  gender   char(1),
  state    char(2),
  district int,
  party    varchar(20),
  url      varchar(50),
  twitter  varchar(50),
  facebook varchar(50),
  youtube  varchar(50),
  primary key (id)
);

source senators.sql
source hreps.sql
