[pLog-svn] Notification of required database changes

[Mark Wu]

I think those changes will take care by the new upgrade  process.

Because it use the pdb dictionary to syncronize the db structure. 

Do you remember you upgrade it using the old wizard or new wizard(after
oscar implement the db dictionary)?

** about the filter content, and block hosting? Maybe we can move it to
plugins. Let the plugin to take care of them.

Mark

> -----Original Message-----
> From: plog-svn-bounces at devel.lifetype.net 
> [mailto:plog-svn-bounces at devel.lifetype.net] On Behalf Of Jon Daley
> Sent: Wednesday, April 05, 2006 10:29 PM
> To: plog-svn at devel.lifetype.net
> Subject: RE: [pLog-svn] Notification of required database changes
> 
>  	Yes.
> 
> On Wed, 5 Apr 2006, Mark Wu wrote:
> 
> > You mean this one? I think I miss this mail :P
> >
> > Mark
> >
> > ================
> > I noticed an error in my sql log on 1.1, so I went through and 
> > compared all of my tables to the wizard.  This is what I found:
> >
> > plog_articles:
> > category_id int(10) unsigned NOT NULL default '0'
> > is not added on upgrade, only new install.
> >
> >
> > plog_articles_comments:
> >   properties TEXT NOT NULL DEFAULT '', is not added on 
> upgrade, only 
> > new install
> >
> > plog_blogs:
> > | properties       | text             |      |     |        
>              |
> > | custom_domain    | varchar(50)      | YES  |     | NULL   
>              |
> > My db has a properties field, this is supposed to be gone, so we 
> > should erase it when installing 1.1?
> > I will add the custom_domain, I only added it on upgrade, 
> not on new 
> > install.
> >
> >
> > plog_gallery_resources:
> >  file_size int(20) not null default 0;  properties TEXT NOT NULL 
> > DEFAULT ''; These are not in my 1.0 install
> >
> >
> > DB questions:
> >
> > plog_host_blocking_rules:
> > should this be in the wizard??  It is a plugin now, right?
> >
> > plog_filtered_content:
> > I don't know what this is, is it used?
> >
> >
> >
> > _______________________________________________
> > pLog-svn mailing list
> > pLog-svn at devel.lifetype.net
> > http://devel.lifetype.net/mailman/listinfo/plog-svn
> >
> > ==============
> >
> >
> >> -----Original Message-----
> >> From: plog-svn-bounces at devel.lifetype.net
> >> [mailto:plog-svn-bounces at devel.lifetype.net] On Behalf Of Jon Daley
> >> Sent: Wednesday, April 05, 2006 9:39 PM
> >> To: plog-svn at devel.lifetype.net
> >> Subject: RE: [pLog-svn] Notification of required database changes
> >>
> >> On Wed, 5 Apr 2006, Mark Wu wrote:
> >>> I think it is because there is no lt_trackbacks table in
> >> 1.1. When I
> >>> click next, it will go back to step one again.
> >>  	I forget if I wrote about this the other day - is this table 
> >> removed on an upgrade?  It wasn't before the schema changes.
> >>
> >>  	Actually, I don't think anyone responded to my email 
> the other day 
> >> of all the differences my install has from the default.
> >>
> >> _______________________________________________
> >> pLog-svn mailing list
> >> pLog-svn at devel.lifetype.net
> >> http://devel.lifetype.net/mailman/listinfo/plog-svn
> >
> > _______________________________________________
> > pLog-svn mailing list
> > pLog-svn at devel.lifetype.net
> > http://devel.lifetype.net/mailman/listinfo/plog-svn
> >
> 
> **************************************
> Jon Daley
> http://jon.limedaley.com/
> 
> A nuclear war can ruin your whole day.
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn