So more like...
[sql]CREATE vb_session (
sessionhash CHAR(32) NOT NULL DEFAULT '',
userid INT CHAR(10) NOT NULL DEFAULT '',
host CHAR(15) NOT NULL DEFAULT '',
idhash CHAR(32) NOT NULL DEFAULT '',
lastactivity INT CHAR(10) NOT NULL DEFAULT '',
location CHAR(255) NOT NULL DEFAULT '',
useragent CHAR(100) NOT NULL DEFAULT '',
styleid SMALLINT CHAR(5) NOT NULL DEFAULT '',
languageid SMALLINT CHAR(5) NOT NULL DEFAULT '',
loggedin SMALLINT CHAR(5) NOT NULL DEFAULT '',
inforum SMALLINT CHAR(5) NOT NULL DEFAULT '',
inthread INT CHAR(10) NOT NULL DEFAULT '',
incalendar SMALLINT CHAR(5) NOT NULL DEFAULT '',
badlocation SMALLINT CHAR(5) NOT NULL DEFAULT '',
bypass TINYINT CHAR(4) NOT NULL DEFAULT '',
profileupdate SMALLINT CHAR(5) NOT NULL DEFAULT '',
PRIMARY KEY (sessionhash)
);[/sql]
Or do I need to specify INT, too?
--------------- Added [DATE]1381196910[/DATE] at [TIME]1381196910[/TIME] ---------------
I went ahead and tried both of these. But nothing happens. No tables are created. No errors are thrown up. I've been stuck on this one all day.
|