XF 2.1 What type to specify in addon's Entity class when storing only date value?

[asprin]

Looking at the Entity class (XF\Mvc\Entity), there doesn't seem to a value to specify a date column



In that case, how can specify a column of type "Date" in the Entity class as well as Setup file?

 

[Lukas W.]

XenForo stores dates as unix timestamps and thus uses the UINT type for them in the entity.

 

[asprin]

XenForo stores dates as unix timestamps and thus uses the UINT type for them in the entity.

That's understandable but wondering if that means there's no way one can specify in an addon's Setup.php file that a column is to be created of type "DATE"?

 

[asprin]

Just to add to the above, is there a way to specify that I need a column to be mediumint unsigned?

 

[digitalpoint]

mediumint is a valid column type when using the schema manager in a Setup.php file (and is unsigned by default).

$table->addColumn('your_column', 'mediumint');

If you wanted it to be signed, it would be this:

$table->addColumn('your_column', 'mediumint')->unsigned(false);

 

[asprin]

mediumint is a valid column type when using the schema manager in a Setup.php

Yes, but this requires me to specify this manually. What I was looking for to have this incorporated via the generate-schema command from the Entity's class file.

 

[digitalpoint]

No idea on that, but my guess is you are going to be more limited if you are trying to auto-generate the code for your Sstup file.