<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Monotype Corsiva";
panose-1:3 1 1 1 1 2 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msochpdefault, li.msochpdefault, div.msochpdefault
{mso-style-name:msochpdefault;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Calibri","sans-serif";}
span.emailstyle17
{mso-style-name:emailstyle17;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-GB link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Hi,<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>The table ‘eprint_divisions’ contains the divisions selected for an eprint.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>The table ‘subjects’ contains the data for all subject trees. Divisions is a ‘subject’ field – so it should be in there.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>When you save an eprint with one of your new divisions selected, you should then be able to see it in eprint_divisions.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Cheers,<br>John<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> eprints-tech-bounces@ecs.soton.ac.uk [mailto:eprints-tech-bounces@ecs.soton.ac.uk] <b>On Behalf Of </b>MOHD IZAMRI, ISMAIL<br><b>Sent:</b> 20 September 2013 04:37<br><b>To:</b> eprints-tech@ecs.soton.ac.uk<br><b>Subject:</b> [EP-tech] Database Relation<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal><span lang=EN-US>Hi All,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>I don’t know if this is too much to ask, but do you have eprints database documentations? I want to know the database relation.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>I check on MySQL database and see one of the tables there “eprint_divisions”. Check on the data inside and found out that it contains the old divisions ID.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>I already update my repository hierarchy (<a href="http://wiki.eprints.org/w/EPrints_3_Organisation_Hierarchy">http://wiki.eprints.org/w/EPrints_3_Organisation_Hierarchy</a>), but I cannot found the new divisions ID that I create.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Is this right or need to be corrected manually?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Thank you.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><b><span lang=EN-US style='font-size:13.5pt;font-family:"Monotype Corsiva";color:#0070C0'>Best Regards,</span></b><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><b><span lang=EN-US style='font-size:8.0pt;font-family:"Monotype Corsiva";color:#0070C0'> </span></b><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#0070C0'>Mohd <u>Izamri</u> Ismail (Izam)</span></b><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><b><span lang=EN-US style='font-size:8.0pt;font-family:"Tahoma","sans-serif";color:black'>Analyst Programmer</span></b><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:8.0pt;font-family:"Tahoma","sans-serif";color:black'>Management Information System (MIS)</span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:8.0pt;font-family:"Tahoma","sans-serif";color:black'>HELP University, BZ-2, Pusat Bdr Damansara (Main Block),</span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:8.0pt;font-family:"Tahoma","sans-serif";color:black'>50490 Kuala Lumpur, Malaysia.</span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:8.0pt;font-family:"Tahoma","sans-serif";color:black'>Mobile: +6019 6690190</span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='font-size:8.0pt;font-family:"Tahoma","sans-serif";color:black'>Email: <a href="mailto:izamri.ismail@help.edu.my">izamri.ismail@help.edu.my</a></span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><b><span lang=EN-US style='font-size:9.0pt;font-family:"Tahoma","sans-serif";color:#C00000'>“University Of Achievers”</span></b><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div><p class=MsoNormal><span lang=EN-US style='font-size:12.0pt;font-family:"Times New Roman","serif"'>DISCLAIMER: We value your online privacy. This email including any attachments may contain confidential & privileged information and is intended solely for the use of the recipient(s). If you have received it in error, please notify the sender and delete all the contents permanently from all kinds of storage devices. Unauthorized distribution or dissemination of this email is strictly prohibited. Please be informed that views or opinions found in this email are solely that of the author and do not necessarily represent HELP University Sdn Bhd. HELP University Sdn Bhd disclaims all warranties to the content of this email and shall not be liable for any loss or damage to the person and /or their property caused by this email. <o:p></o:p></span></p></div></body></html>