[Xerte-dev] Re: Preparation for 1.8 Release

[Pat Lockley]

i've always deleted manually (as drop rights aren't available from web
hosts at UoN).

I could see a case that if reinstalling over the top / again then drop
makes sense, but perhaps there needs some logic - a sort of if table
exists prompt?

On Thu, Jul 12, 2012 at 12:44 PM, David Goodwin <david at palepurple.co.uk> wrote:
>
> On 12 Jul 2012, at 12:32, Pat Lockley wrote:
>
>> I think this is a use case though
>>
>> Install once, delete setup (or cripple setup).
>>
>
> Yes.
>
>> Installing a second time = upgrade and therefore a different process now?
>
> Yes - hence 'upgrade.php'
>
>
>
> And when someone decides they wish to trash their XOT installation / start again, they MAY not know how to clear out MySQL - so (in my mind) it makes sense to do a "drop table if exists" in the DB creation stuff.
>
> If you don't do a drop table thing, you would have either had the case that people end up with duplicate row(s) (which I suspect would cause problem), or your code already deleted/overwrote any records that already existed?
>
>
> David.
>
>
> Pale Purple Ltd.  (Company No: 5580814)
> 'Business Web Application Development and Training in PHP'
>
> http://www.palepurple.co.uk
> Office: 0845 0046746     Mobile: 07792380669
>
> Follow us on Twitter: @PalePurpleLtd
>
>
> _______________________________________________
> Xerte-dev mailing list
> Xerte-dev at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>
> This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it.   Please do not use, copy or disclose the information contained in this message or in any attachment.  Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.
>
> This message has been checked for viruses but the contents of an attachment
> may still contain software viruses which could damage your computer system:
> you are advised to perform your own checks. Email communications with the
> University of Nottingham may be monitored as permitted by UK legislation.
>