We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 26537
    • 7 Posts
    Is for me my.mysql.schema.xml

    1 - How to define a field for money with 2 decimals?
    Like this?
    <field key="saldo" dbtype="decimal" precision="10,2" phptype="numeric" null="false" default="0" />


    2 - How to fill my table with UserID?
    Like this?
    <object class="UserID" extends="modUser">
                    <aggregate alias="Orden" class="Ordenativo" local="id" foreign="leido_x_userid" cardinality="many" owner="local" />
                    <aggregate alias="Venci" class="Vencimiento" local="id" foreign="se_terminaron_x_userid" cardinality="many" owner="local" />
                    <aggregate alias="CargaaSistema" class="Carga_a_Sistema" local="id" foreign="userid" cardinality="many" owner="local" />
                    <aggregate alias="RecargaAnulada" class="Recarga_Anulada" local="id" foreign="userid" cardinality="many" owner="local" />
            </object>

    no table (table="xxxx") is that correct?

    3 - How do I set the date and time fields to be entered manually?

    4 - I can view the date and time of the server to automate tasks?