1
I installed the Membership 0.6 module, mainly because I want to alter it (change attributes of displayed fileds) to suit my site's needs, but...I'm certainly no expert on MySQL, but the error message I get when creating the tables is driving me nuts...I took a look at it but I can't see the error PHP MyAdmin states is there. Here's the table structure for the Membership 0.6 module (installing Membership 0.6 via my site's admin backend doesn't create any tables in the database---I had to do this separately from the module installation, so maybe that had something to do with it?):
# Table structure for table `memb_conf`
CREATE TABLE memb_conf (
att_id smallint(3) unsigned NOT NULL auto_increment,
att_name varchar(100) NOT NULL default '',
att_type varchar(10) NOT NULL default 'char',
att_label varchar(30) default '',
att_desc varchar(255) default '',
att_active ENUM('0','1') DEFAULT '1' NOT NULL,
disp_width tinyint unsigned NOT NULL default '10',
disp_order tinyint unsigned NOT NULL default '1',
map_table varchar(100) default '',
map_field varchar(100) default '',
PRIMARY KEY (att_id)
) TYPE=MyISAM;
memb_attribs table holds the attributes for each member.
# Table structure for table `memb_attribs`
CREATE TABLE memb_attribs (
userid mediumint(8) unsigned NOT NULL,
name varchar(100) NOT NULL default '',
value_txt mediumblob default '',
value_date datetime,
PRIMARY KEY (userid,name)
) TYPE=MyISAM;
