When I create a table with one column of type ENUM and then generate
scaffolding for the model and controller the ENUM column isn’t shown as
a drop down in the edit view. It just shows the column name and that’s
it. Am I missing something?
Here’s the SQL for the table:
drop table if exists products;
CREATE TABLE products (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
sku varchar(6) NOT NULL,
price decimal(10,2) not null,
state ENUM (‘kansas’,‘georgia’, ‘new york’) NOT NULL,
date_available datetime not null
) CHARSET=utf8;
When I create a table with one column of type ENUM and then generate
scaffolding for the model and controller the ENUM column isn’t shown as
a drop down in the edit view. It just shows the column name and that’s
it. Am I missing something?
Here’s the SQL for the table:
drop table if exists products;
CREATE TABLE products (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
sku varchar(6) NOT NULL,
price decimal(10,2) not null,
state ENUM (‘kansas’,‘georgia’, ‘new york’) NOT NULL,
date_available datetime not null
) CHARSET=utf8;