Forum OpenACS Q&A: perl script to automatically create new object type sql/plpgsql
You write your create table sql, and this script will do the rest.
Full documentation (including sample output) is at : http://svn.pumptheory.com/cgi-bin/pod2html.cgi?path=openacs/scripts/oacs-create-type.pl
You can download the script at : http://svn.pumptheory.com/repos/trunk/openacs/scripts/oacs-create-type.pl
Don't look too carefully at the code, it's a little messy but it does the trick.
I also forgot to say that this is postgres specific. Writing an oracle version is an exercise left to the reader.
I want to add a new form, for that we have to mention the OBJECT_ID and OBJECT_TYPE
Please how to create a new one ,please help me in this