[wp-hackers] DB options table; useless columns?

DD32 wordpress at dd32.id.au
Sun Apr 22 11:12:22 GMT 2007


Hi all,
first of all, Apologies if there is actually a use for any of these  
columns,
But from what i can see (And after doing a grep of the WP source fo the  
terms)
The following columns from the Options table seem completely useless?
My only reasoning for mentioning this was to gain better insight into the  
underlaying db structure,


   option_can_override enum('Y','N') NOT NULL default 'Y',
   option_type int(11) NOT NULL default '1',
   option_width int(11) NOT NULL default '20',
   option_height int(11) NOT NULL default '8',
   option_admin_level int(11) NOT NULL default '1',

C:\www\wordpress>grep -r option_can_override *
	wp-admin/upgrade-schema.php:  option_can_override enum('Y','N') NOT NULL  
default 'Y',
C:\www\wordpress>grep -r option_type *
	wp-admin/upgrade-schema.php:  option_type int(11) NOT NULL default '1',
C:\www\wordpress>grep -r option_width *
	wp-admin/upgrade-schema.php:  option_width int(11) NOT NULL default '20',
C:\www\wordpress>grep -r option_height *
	wp-admin/upgrade-schema.php:  option_height int(11) NOT NULL default '8',
C:\www\wordpress>grep -r option_admin_level *
	wp-admin/upgrade-schema.php:  option_admin_level int(11) NOT NULL default  
'1',

A Quick glance at WP-MU didnt reveal any use either:

C:\www\wordpress-mu>grep -r option_can_override *
	wp-admin/upgrade-schema.php:  option_can_override enum('Y','N') NOT NULL  
default 'Y',
C:\www\wordpress-mu>grep -r option_type *
	wp-admin/upgrade-schema.php:  option_type int(11) NOT NULL default '1',
C:\www\wordpress-mu>grep -r option_width *
	wp-admin/upgrade-schema.php:  option_width int(11) NOT NULL default '20',
C:\www\wordpress-mu>grep -r option_height *
	wp-admin/upgrade-schema.php:  option_height int(11) NOT NULL default '8',
C:\www\wordpress-mu>grep -r option_admin_level *
	wp-admin/upgrade-schema.php:  option_admin_level int(11) NOT NULL default  
'1',


More information about the wp-hackers mailing list