February 23, 2013 at 9:44 am
I had some great help with the last questions I posted.
Thanks everyone for the help
Okay I have found out my old database was mysql converting it to sql for project. So I have been googling the heck of what to replace ENUM with so It will be recognized in SQL. Any Help will be great.
CREATE TABLE jos_acymailing_mail (
mailid int NOT NULL ,
subject varchar(250) NOT NULL,
body longtext NOT NULL,
altbody longtext NOT NULL,
published int default '1',
senddate int default NULL,
created int default NULL,
fromname varchar(250) NOT NULL,
fromemail varchar(250) NOT NULL,
replyname varchar(250) NOT NULL,
replyemail varchar(250) NOT NULL,
type enum(news , autonews , followup , unsub , welcome , notification) NOT NULL default 'news',
visible int NOT NULL default '1',
userid int default NULL,
alias varchar(250) default NULL,
attach text,
html int NOT NULL default '1',
tempid int NOT NULL default '0',
key varchar(200) default NULL,
frequency varchar(50) default NULL,
params text,
sentby int default NULL,
metakey text,
metadesc text,
filter text,
PRIMARY KEY ( mailid ),
February 23, 2013 at 10:01 am
There is no enum data type in SQL 2008. You would usually use a lookup table for something like that - maybe tinyint for the key & varchar for the desc.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply