[pLog-svn] db differences

Jon Daley plogworld at jon.limedaley.com
Fri Mar 31 15:24:51 GMT 2006


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?





More information about the pLog-svn mailing list