About four fields auto-added by OFBiz

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Reply | Threaded
Open this post in threaded view
|

Re: About four fields auto-added by OFBiz

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-----
Reply | Threaded
Open this post in threaded view
|

Re: About four fields auto-added by OFBiz

Jacques Le Roux
Administrator
In reply to this post by Jack Liu-2
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



Reply | Threaded
Open this post in threaded view
|

Re: About four fields auto-added by OFBiz

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-----