Tables

gistfile1.txt

CREATE TABLE TimeSlots (
  ID integer PRIMARY KEY NOT NULL,
  SessionNumber integer,
  SessionName text
);

# note- this table name is excel because it was originally imported from, well, excel.
#might be easier to think if this table as if it were named "Session"
CREATE TABLE excel (
  ID integer PRIMARY KEY NOT NULL,
  FirstName text(255,0),
  LastName text(255,0),
  SessionTimeSlot text(255,0),
  RoomNumber text(255,0),
  SessionTitle text(255,0),
  SpeakerStatus text(255,0),
  Phone text(255,0),
  Email text(255,0),
  SessionStatus text(255,0),
  MVP text(255,0),
  Contacted text(255,0),
  Blog text(255,0),
  Twitter text(255,0),
  SessionAbstract text(5000,0),
  Bio text(5000,0),
  Headshot text(255,0),
  ext1 text(255,0),
  ext2 text(255,0)
);