[ivan: Re: part_svc]

[Ivan Kohler]

----- Forwarded message from Ivan Kohler <ivan> -----

Date: Sat, 7 Nov 1998 02:07:39 -0500
From: Ivan Kohler <ivan>
To: "Tom T. Thai" <tomthai at future.net>
Subject: Re: part_svc

On Fri, Oct 23, 1998 at 02:06:34PM -0500, Tom T. Thai wrote:
> yes this now makes sense.. I'm wondering if this is an effective way to
> handle additional tables for svc_xxxx that an ISP might add.  I think
> there should be a way for the isp to add additional svc_xxx tables with
> out having to change the codes.

Can you clarify what you're trying to say, specifically what do you mean
by `codes'?

What alternative do you suggest?

> Thomas T. Thai          Infomedia Interactive Communications
> 
> On Fri, 23 Oct 1998, Ivan Kohler wrote:
> 
> > On Fri, 23 Oct 1998, Tom T. Thai wrote:
> > 
> > > part_svc - Service definitions 
> > >           svcpart - primary key 
> > >           svc - name of this service 
> > >           svcdb - table used for this service: svc_acct, svc_acct_sm,
> > >                   svc_domain, svc_charge or svc_wo 
> > >           table__field - Default or fixed value for field in table 
> > >           table__field_flag - null, D or F 
> > > 
> > > Does the table_field above represent the VALUE that is to be in a
> > > particular FIELD from a table represented by svcdb?
> > 
> > Yes.
> > 
> > >  If so, how do you know what the name of the field is for that
> > > particular svcdb table? 
> > 
> > You're reading `table__field' abover *literally*.  There isn't a column in
> > the table named `table__field', there are lots of columns in the database
> > with `table' replaced by a table name, and `field' replace by a
> > field/column name.  If you look at the database itself you will see
> > columns like: 
> > 
> > svc_acct__slipip and svc_acct__slipip_flag
> > ^^^^^^^^  ^^^^^^     ^^^^^^^^  ^^^^^^
> > table     field      table     field
> > 
> > Does that clear things up?
> > 
> > > I don't know, it would seem logical to me that one would need
> > > table_field_name up there.
> > > ..............          ....................................
> > > Thomas T. Thai          Infomedia Interactive Communications
> > > tom at iic.net             TEL 612.376.9090 * FAX 612.376.9087
> > > 
> > > 
> > > 
> > 
> > -- 
> > Ivan Kohler <ivan at sisd.com> - finger for PGP key
> > Silicon Interactive Software Design - http://www.sisd.com/ - 888-670-SISD
> > Open-source billing and administration for ISPs - http://www.sisd.com/freeside
> > 20 4,16 * * * saytime # please don't be surprised if you find me dreaming too
> > 
> > 
> 

-- 
Ivan Kohler <ivan at sisd.com> - finger for PGP key
Silicon Interactive Software Design - http://www.sisd.com/ - 888-670-SISD
Open-source billing and administration for ISPs - http://www.sisd.com/freeside
20 4,16 * * * saytime # please don't be surprised if you find me dreaming too

----- End forwarded message -----

-- 
Ivan Kohler <ivan at sisd.com> - finger for PGP key
Silicon Interactive Software Design - http://www.sisd.com/ - 888-670-SISD
Open-source billing and administration for ISPs - http://www.sisd.com/freeside
20 4,16 * * * saytime # please don't be surprised if you find me dreaming too