When I try to create a table using:
create table cust
("email" varchar(127) not null primary key unique,
"lname" varchar(31) not null,
"fname" varchar(31) not null,
"address1" varchar(63),
"address2" varchar(63),
"city" varchar(31),
"state" char(2),
"zip" varchar(9),
"wphone" char(10),
"hphone" char(10),
"cphone" char(10),
"ophone" char(10),
"receive" bool(1) not null);
I get back:
failed : parser: parse error at or near "("
Can anybody tell me what I am missing/why it's getting stuck at the first (.
Thank you
create table cust
("email" varchar(127) not null primary key unique,
"lname" varchar(31) not null,
"fname" varchar(31) not null,
"address1" varchar(63),
"address2" varchar(63),
"city" varchar(31),
"state" char(2),
"zip" varchar(9),
"wphone" char(10),
"hphone" char(10),
"cphone" char(10),
"ophone" char(10),
"receive" bool(1) not null);
I get back:
failed : parser: parse error at or near "("
Can anybody tell me what I am missing/why it's getting stuck at the first (.
Thank you