tags:

views:

19

answers:

1
Q: 

Can You Add A Column To Wordpress Table? Will Upgrade Remove It?

Is this possible to add a column to wp_post? What will happen to it when it is upgraded? Is it possible to tell wordpress not to delete column if upgrade might remove it?

** Please do not post why I should use the other tables or make a new table. **

A: 

I do not know off the top of my head whether it will get deleted when upgrading, but why would you want to do that? That's what the postmeta table is for.

John P Bloch  2010-06-18 23:26:22
Yes but there is a particular architecture that in the end would be better to require a column since a column is better than longtext fields or creating an extra table ( especially for WPMU w/ 3000 blogs ). Also, the db will be exported to sqlite dbs in another server, and trying to fetch a specific field export from many fields in post-meta isn't proper in the long term.
James  2010-06-19 05:32:14

related questions

What's the best way to develop against WordPress on Windows when you already have IIS/SQL Server installed?
How do I use SCM with a PHP app such as Wordpress?
Getting IIS6 to play nice with WordPress Pretty Permalinks
YouTube embeds not working in WordPress after import from Blogger
Wordpress.. Is it a CMS?
How should a blog be structured to easily extract its data?
What database privileges does a Wordpress Blog really need?
What's the best way to run Wordpress on the same domain as a Rails application?
Is the syntax for the Wordpress style.css template element available anywhere?
How do you add a JavaScript widget to a Wordpress.com hosted blog?
What is the best CSS grid framework that integrates with Wordpress?
Using Apache mod_rewrite to remove sub-directories from URL
Joomla Blog/Wordpress Integration
Running a scheduled task in a Wordpress plug-in
Wordpress Category Template Question
Wordpress MediaWiki Cookie Integration
Preview theme in Wordpress
Seeking code highlighter recommendation for WordPress
Wordpress MediaWiki Integration
How do I list all Entries with a certain tag in Wordpress?
Mysql: Using "AND" Operation on tags and categories tables in Wordpress
How do I display database query statistics on Wordpress site?
Resources on wordpress theme-development
What is best blogging host for programmers/code formatting?
Wordpress theme development offline tools