Code: Select all
SHOW CREATE TABLE `tablename`;Moderator: General Moderators
Code: Select all
SHOW CREATE TABLE `tablename`;Code: Select all
CREATE TABLE `tep_roboveda` (
`team_id` mediumint(9) NOT NULL auto_increment,
`team_name` varchar(150) NOT NULL default '',
`events` varchar(150) NOT NULL default '',
`team_leader_name` varchar(50) NOT NULL default '',
`member_id` mediumint(9) NOT NULL default '0',
`team_leader_email` varchar(50) NOT NULL default '',
`team_leader_number` varchar(20) NOT NULL default '',
`college` varchar(150) NOT NULL default '',
`bryr` varchar(20) NOT NULL default '',
`city` varchar(20) NOT NULL default '',
`state` varchar(20) NOT NULL default '',
`member_1` varchar(50) NOT NULL default '',
`email_1` varchar(50) NOT NULL default '',
`member_id_1` mediumint(9) NOT NULL default '0',
`member_2` varchar(50) NOT NULL default '',
`email_2` varchar(50) NOT NULL default '',
`member_id_2` mediumint(9) NOT NULL default '0',
`member_3` varchar(50) NOT NULL default '',
`email_3` varchar(50) NOT NULL default '',
`member_id_3` mediumint(9) NOT NULL default '0',
`member_4` varchar(50) NOT NULL default '',
`email_4` varchar(50) NOT NULL default '',
`member_id_4` mediumint(9) NOT NULL default '0',
`comments` text NOT NULL,
`col_1` varchar(80) NOT NULL default '',
`col_2` varchar(80) NOT NULL default '',
`col_3` varchar(80) NOT NULL default '',
`col_4` varchar(80) NOT NULL default '',
PRIMARY KEY (`team_id`),
UNIQUE KEY `team_leader_name` (`team_leader_name`)
) ENGINE=MyISAM AUTO_INCREMENT=414 DEFAULT CHARSET=latin1