Create transcript.sql

This file contains the sql schema and have also inserted some test data.