<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16674" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=421225123-26062008><FONT face=Arial
size=2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=421225123-26062008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=421225123-26062008><FONT face=Arial size=2>I'm trying to
restore a database backup of opencms however I'm not sure what version of
opencms my export is from.</FONT></SPAN></DIV>
<DIV><SPAN class=421225123-26062008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=421225123-26062008><FONT face=Arial size=2>As an exmaple the
columns in cms_users in the backup are:</FONT></SPAN></DIV>
<DIV><SPAN class=421225123-26062008><FONT face=Arial
size=2></FONT></SPAN> </DIV><SPAN class=421225123-26062008>
<DIV>
<TABLE style="WIDTH: 104pt; BORDER-COLLAPSE: collapse" cellSpacing=0
cellPadding=0 width=138 border=0 x:str>
<COLGROUP>
<COL style="WIDTH: 104pt; mso-width-source: userset; mso-width-alt: 5046"
width=138>
<TBODY>
<TR style="HEIGHT: 12.75pt" height=17>
<TD
style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 104pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent"
width=138 height=17><FONT face=Arial size=2>USER_ID</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD
style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent"
height=17><FONT face=Arial size=2>USER_NAME</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD
style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent"
height=17><FONT face=Arial size=2>USER_PASSWORD</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD
style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent"
height=17><FONT face=Arial size=2>USER_DESCRIPTION</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD
style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent"
height=17><FONT face=Arial size=2>USER_FIRSTNAME</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD
style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent"
height=17><FONT face=Arial size=2>USER_LASTNAME</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD
style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent"
height=17><FONT face=Arial size=2>USER_EMAIL</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD
style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent"
height=17><FONT face=Arial size=2>USER_LASTLOGIN</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD
style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent"
height=17><FONT face=Arial size=2>USER_FLAGS</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD
style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent"
height=17><FONT face=Arial size=2>USER_INFO</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD
style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent"
height=17><FONT face=Arial size=2>USER_ADDRESS</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD
style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent"
height=17><FONT face=Arial
size=2>USER_TYPE</FONT></TD></TR></TBODY></TABLE></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=421225123-26062008><FONT face=Arial size=2>However elsewhere I
have a cms_users table (which is from OpenCms 7.0.1) which has these
columns:</FONT></SPAN></DIV>
<DIV><SPAN class=421225123-26062008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=421225123-26062008><FONT face=Arial size=2>USER_ID
<BR>USER_NAME <BR>USER_PASSWORD <BR>USER_FIRSTNAME <BR>USER_LASTNAME
<BR>USER_EMAIL <BR>USER_LASTLOGIN <BR>USER_FLAGS <BR>USER_OU
<BR>USER_DATECREATED <BR></FONT></SPAN></DIV>
<DIV><SPAN class=421225123-26062008><FONT face=Arial size=2>Is anyone able to
tell me if the the first one likely to be from 6.x?</FONT></SPAN></DIV>
<DIV><SPAN class=421225123-26062008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=421225123-26062008><FONT face=Arial size=2>Many
Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=421225123-26062008><FONT face=Arial
size=2>Andrew.</DIV></FONT></SPAN></SPAN>
<DIV><SPAN class=421225123-26062008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=421225123-26062008><FONT face=Arial
size=2></FONT></SPAN> </DIV><br><br><table bgcolor=white style="color:black"><tr><td><br><br>
----------------------------------------------------------------------------------------------------------------------------<br>
Disclaimer: <br>
This e-mail including any attachments may contain confidential information and is subject to copyright. <br>
Its contents may not be quoted or republished in any form without Harness Racing Victoria's written permission, except in the case of HRV authorised media releases. <br>
If you are not the intended recipient, you should not copy, distribute or take any action in reliance on it. <br>
If you believe you received this email in error, please delete and destroy all copies and immediately notify the sender by return e-mail. <br>
Harness Racing Victoria respects your privacy. Our privacy policy can be accessed from our web site: www.harness.org.au/vic <br>
</td></tr></table></BODY></HTML>