## create a simple cardfile file# just in case it already exists, drop the table. If it doesn't# exist, this will produce an error...#drop table cardfile\gcreate table cardfile   (name    char(20),    address char(35),    city    char(20),    state   char(2),    zip     char(11),    country char(25),    phone   char(20),    id      int) \g   CREATE UNIQUE INDEX ix_id ON cardfile (id)\g