This is the CREATE table query from the installation script
PHP Code:
$query = "CREATE TABLE ".$prefix."adoptables (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, type varchar(40), description varchar(300), eggimage varchar(120), whenisavail varchar(50), promocode varchar(50), freqcond varchar(50), number INT, datecond varchar(50), date varchar(20), adoptscond varchar(20), moreless varchar(20), morelessnum INT, levelgrle varchar(25), grlelevel INT, alternates varchar(10), altoutlevel INT, altchance INT, pricestatus varchar(10), pricevalue INT)";
The pricestatus field's type is varchar with length of 10
the pricevalue field's type is int