Ticket #458: bbm.sql

File bbm.sql, 353 bytes (added by beaulebens, 1 year ago)

Here's the SQL that I use for my table with BBM

Line 
1 CREATE TABLE `wp_blogmeta` (
2   `bmeta_id` bigint(20) unsigned NOT NULL auto_increment,
3   `blog_id` bigint(20) NOT NULL default '0',
4   `user_id` bigint(20) default '0',
5   `meta_key` varchar(255) NOT NULL,
6   `meta_value` longtext,
7   PRIMARY KEY  (`bmeta_id`),
8   UNIQUE KEY `blog_meta` (`blog_id`,`user_id`,`meta_key`)
9 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;