Hello Jay -
On Thu, 11 Nov 1999, Jay West wrote:
> ----- Original Message -----
> From: Jay West <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, November 09, 1999 6:44 AM
> Subject: Question on auth by sql setup
>
>
> > We're trying to switch from DBM user files to mySQL user files. I have one
> > simple question...
> >
> > The script that is given to build the tables initially from flat files
> > mentions something to the effect that it is a bare-bones sample, and that
> > you will probably want to add additional fields, etc.
> >
> > Being fairly new to msSQL, I was wondering if it's easy to add these
> fields
> > later after user records and accounting records are active in SQL, or - is
> > it a much better idea to get all the requisit fields built initially.
> >
I thought someone with operational experience might have answered, but in any
case here are my thoughts.
This depends to a certain extent on the database you are using (and I don't
know anything about msSQL). Some databases (like mysql) will allow you to
modify tables on the fly, while others don't. You should probably try to get
close to what you want to begin with, and even if you can't modify the tables
on the fly, all that is required to make a modification is to dump the
database, redefine the tables, and reload the data. Its a pretty normal
exercise to dump and reload a database.
hth
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
