Re: [Dspace-tech] [Dspace-devel] How can I create a new table in dspace's database?

2014-01-27 Thread helix84 
On Mon, Jan 27, 2014 at 1:46 PM, Teo Tokis teoto...@gmail.com wrote:
 How can I create a new table in dspace's database? Is it possible to add
 this table to file database_schema.sql in source and then execute ant update
 or I need to do something else?

Hi Teo,

this question is really not specific to DSpace. If you add a new
table, DSpace won't really care about it unless you modify the DSpace
source code. If you want to add a new table anyway, just talk directly
to the database as you normally would (psql for Postgres or sqlplus
for Oracle or any of the numerous DB client programs). Then to create
the table, just use a SQL command like CREATE TABLE yourtablename;.
There are also GUI DB clients. Use the db.username and db.password to
authenticate.


Regards,
~~helix84

Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

--
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments  Everything In Between.
Get a Quote or Start a Free Trial Today. 
http://pubads.g.doubleclick.net/gampad/clk?id=119420431iu=/4140/ostg.clktrk
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Re: [Dspace-tech] [Dspace-devel] How can I create a new table in dspace's database?

2014-01-27 Thread helix84 
On Mon, Jan 27, 2014 at 3:30 PM, Teo Tokis teoto...@gmail.com wrote:
 Actually i want to modify the dspace source and add some new forms when i
 submitt a new item and also to add some new columns in dspace user table.
 Do i have to modify some of the xml files of source code? Or just create new
 tables and columns in my database?

To add new columns in the eperson table, you'll also need to modify
the EPerson class:

https://github.com/DSpace/DSpace/blob/master/dspace-api/src/main/java/org/dspace/eperson/EPerson.java

If you're using XMLUI, you'll probably want to modify the EditProfile form:

https://github.com/DSpace/DSpace/blob/master/dspace-xmlui/src/main/java/org/dspace/app/xmlui/aspect/eperson/EditProfile.java

Depending on what exactly you want to do, you may or may not need to
modify .xsl files that render the HTML pages.


Is what you're doing something that other users might also find
useful? If so, it's advisable to write up a draft of your feature
(requirements, use cases, how you intend to implement it) and send it
to dspace-devel. You might find out that others are interested in the
same feature and willing to either help or at least pint out how you
can improve your design - before you start writing code.


Regards,
~~helix84

Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

--
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments  Everything In Between.
Get a Quote or Start a Free Trial Today. 
http://pubads.g.doubleclick.net/gampad/clk?id=119420431iu=/4140/ostg.clktrk
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette