Not picking up Primary Key

T

Tomas

Guest
I have the following table:

CREATE TABLE `member_master` (
`member_id` varchar(30) NOT NULL default '',
`fname` varchar(50) default NULL,
`user_name` varchar(30) NOT NULL default '',
`user_pass` varchar(30) NOT NULL default '',
`lname` varchar(50) default NULL,
`address1` varchar(255) default NULL,
`address2` varchar(255) default NULL,
`city` varchar(30) default NULL,
`state` varchar(255) default NULL,
`country` varchar(30) default NULL,
`zip` varchar(30) default NULL,
`phone` varchar(30) default NULL,
`email` varchar(50) default NULL,
`news_type` int(3) default '0',
`is_active` char(1) default 'Y',
`is_deleted` char(1) default 'N',
`added_on` datetime default NULL,
`last_modified` datetime default NULL,
PRIMARY KEY (`member_id`),
KEY `member_id` (`member_id`)
) TYPE=MyISAM;

When going to install the table on DaDaBik I'm getting the following error:
Internal table dadabik_2_member_master correctly created......

Your table member_master hasn't any primary keys set, if you don't set a primary key DaDaBIK won't show the edit/delete/details buttons.

......DaDaBIK correctly installed!!

As you can see it's not recognising that my table has a primary key.
Can somebody please help!
Thanks,
Tomas.
 
R

ron

Guest
The primary key usually is an integer.....

CREATE TABLE `member_master` (
`member_id` int(12) NOT NULL auto_increment,
`fname` varchar(50) default NULL,
`user_name` varchar(30) NOT NULL default '',
`user_pass` varchar(30) NOT NULL default '',
`lname` varchar(50) default NULL,
`address1` varchar(255) default NULL,
`address2` varchar(255) default NULL,
`city` varchar(30) default NULL,
`state` varchar(255) default NULL,
`country` varchar(30) default NULL,
`zip` varchar(30) default NULL,
`phone` varchar(30) default NULL,
`email` varchar(50) default NULL,
`news_type` int(3) default '0',
`is_active` char(1) default 'Y',
`is_deleted` char(1) default 'N',
`added_on` datetime default NULL,
`last_modified` datetime default NULL,
PRIMARY KEY (`member_id`),
) TYPE=MyISAM;

you dont need this:
KEY `member_id` (`member_id`)
thats to create another index on another
column. Stating PRIMARY KEY gives
member_id an index.



ron
 
R

ron

Guest
The primary key usually is an integer.....

CREATE TABLE `member_master` (
`member_id` int(12) NOT NULL auto_increment,
`fname` varchar(50) default NULL,
`user_name` varchar(30) NOT NULL default '',
`user_pass` varchar(30) NOT NULL default '',
`lname` varchar(50) default NULL,
`address1` varchar(255) default NULL,
`address2` varchar(255) default NULL,
`city` varchar(30) default NULL,
`state` varchar(255) default NULL,
`country` varchar(30) default NULL,
`zip` varchar(30) default NULL,
`phone` varchar(30) default NULL,
`email` varchar(50) default NULL,
`news_type` int(3) default '0',
`is_active` char(1) default 'Y',
`is_deleted` char(1) default 'N',
`added_on` datetime default NULL,
`last_modified` datetime default NULL,
PRIMARY KEY (`member_id`),
) TYPE=MyISAM;

you dont need this:
KEY `member_id` (`member_id`)
thats to create another index on another
column. Stating PRIMARY KEY gives
member_id an index.



ron
 
E

Eugenio

Guest
Duplicated post, see here:
http://www.dadabik.org/forum/read.php?f=2&i=234&t=231



(Latest version of DaDaBIK when this message was posted: 2.2.1)
 
You must log in or register to reply here.
Top