Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 error in 1 step of db setup active users 4.0.18		  New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

masterao
Senior Member

Sweden
1678 Posts
Posted - 26 January 2006 :  14:10:17  Show Profile  Visit masterao's Homepage
It is there in case M_AUHIDE already exists in the member-table.
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts
Posted - 26 January 2006 :  14:12:07  Show Profile  Visit AnonJr's Homepage
Then why is it in the script twice?
Go to Top of Page

cripto9t
Average Member

USA
881 Posts
Posted - 27 January 2006 :  06:57:13  Show Profile
quote:
Originally posted by masterao

It is there in case M_AUHIDE already exists in the member-table.
Thanks, I see it now.

If anyone is interested, I did some searching and testing and in mySql use
ALTER TABLE FORUM_MEMBERS CHANGE COLUMN M_AUHIDE[old name] M_AUHIDE[new name] varchar(1) NULL
or
ALTER TABLE FORUM_MEMBERS MODIFY COLUMN M_AUHIDE varchar(1) NULL
ALTER COLUMN is used to set or reset a default value.
    _-/Cripto9t\-_
Go to Top of Page

masterao
Senior Member

Sweden
1678 Posts
Posted - 27 January 2006 :  15:18:00  Show Profile  Visit masterao's Homepage
The two lines aren't the same, AnonJr. The first line adds M_AUHIDE while the second line alters M_AUHIDE. If M_AUHIDE already exists, the first line (ADD) will throw an error and the second line (ALTER) will run. If M_AUHIDE doesn't exist, the first line will work while the second will throw an error. The reason for the alter command is to reset M_AUHIDE to the default value, as cripto9t said.
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts
Posted - 27 January 2006 :  19:04:53  Show Profile  Visit AnonJr's Homepage
Gotcha. I was a little foggy on why you would add a field and then immediately alter it... Now that you explain it, it makes sense.
Go to Top of Page

masterao
Senior Member

Sweden
1678 Posts
Posted - 28 January 2006 :  19:15:42  Show Profile  Visit masterao's Homepage
I was a bit curious about it too when I looked at the dbs-file the first time .
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07