About four fields auto-added by OFBiz

[Jack Liu-2]

Hi, all

OFBiz will add four fields below automatically when creating tables:

LAST_UPDATED_STAMP
LAST_UPDATED_TX_STAMP
CREATED_ STAMP
CREATED_TX_STAMP

If these fields are dropped, then OFBiz will not work properly.
Can we have these fields dropped while it will not affect OFBiz?

Thank you!

Jack Liu

[BJ Freeman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Yes it will break ofbiz
These are used by the tranactional code when updating the DB.
they should not be removed.

Jack Liu sent the following on 3/4/2009 1:58 AM:

> Hi, all
>
> OFBiz will add four fields below automatically when creating tables:
>
> LAST_UPDATED_STAMP
> LAST_UPDATED_TX_STAMP
> CREATED_ STAMP
> CREATED_TX_STAMP
>
> If these fields are dropped, then OFBiz will not work properly.
> Can we have these fields dropped while it will not affect OFBiz?
>
> Thank you!
>
> Jack Liu
>
>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJrlhrrP3NbaWWqE4RAuc/AJ9wb14U4dPqI72rGvyK3jFjMS8CngCfUAXg
wTV+6gNHTtFOwwFSdFoQJzA=
=6Q1h
-----END PGP SIGNATURE-----

[Jacques Le Roux]

You can remove these fields using no-auto-stamp in entities definitions. This means change that for all definitions. Note that there
are no entities using this attribute OOTB...

They are mostly use for entities synchronisation and maybe you will need them at a time. Of course you can imagine much more usages
for these fields (audit, etc.)... So I'd recommend to keep them unless it's really annoying for you

Jacques

From: "Jack Liu" <[hidden email]>
Hi, all

OFBiz will add four fields below automatically when creating tables:

LAST_UPDATED_STAMP
LAST_UPDATED_TX_STAMP
CREATED_ STAMP
CREATED_TX_STAMP

If these fields are dropped, then OFBiz will not work properly.
Can we have these fields dropped while it will not affect OFBiz?

Thank you!

Jack Liu

[BJ Freeman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

thanks. did not see that one
:D

Jacques Le Roux sent the following on 3/4/2009 2:39 AM:

> You can remove these fields using no-auto-stamp in entities definitions.
> This means change that for all definitions. Note that there
> are no entities using this attribute OOTB...
>
> They are mostly use for entities synchronisation and maybe you will need
> them at a time. Of course you can imagine much more usages for these
> fields (audit, etc.)... So I'd recommend to keep them unless it's really
> annoying for you
>
> Jacques
>
> From: "Jack Liu" <[hidden email]>
> Hi, all
>
> OFBiz will add four fields below automatically when creating tables:
>
> LAST_UPDATED_STAMP
> LAST_UPDATED_TX_STAMP
> CREATED_ STAMP
> CREATED_TX_STAMP
>
> If these fields are dropped, then OFBiz will not work properly.
> Can we have these fields dropped while it will not affect OFBiz?
>
> Thank you!
>
> Jack Liu
>
>
>
>
>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJrmNzrP3NbaWWqE4RAsSzAJ0dsYYiNGNYhe37G7d3JKkL+y6G4ACcCYMe
+kTkUrrHcTg/dnF+p3D3ARU=
=nC3w
-----END PGP SIGNATURE-----