creating tables in MySQL.
Posted: Sun Aug 07, 2005 10:01 am
Hi, i am new in the forum as you can see, i am also new to MySQL, i am a C++, Pascal, Delphi, Assembler programmer, and a graphic designer. recently i had an idea to make a text based RPG, so i made this SQL code for the database:
the problem is that i want to make that 'RACE' will get a value from a drop down box, how do i do that?
feyd | tweaked title to make quicker sense
Code: Select all
CREATE TABLE `content` (
`id` int(11) NOT NULL auto_increment,
`title` text NOT NULL,
`body` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
CREATE TABLE `nav` (
`id` int(11) NOT NULL auto_increment,
`menus` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
CREATE TABLE `news` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`author` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`date` date NOT NULL default '0000-00-00',
`body` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(50) NOT NULL default '',
`pass` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`race` varchar(255) NOT NULL default '', <------- this is the 'RACE'...
`first` varchar(255) default NULL,
`location` varchar(255) default NULL,
`website` varchar(255) default NULL,
`level` int(11) NOT NULL default '0',
`showemail` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM ;feyd | tweaked title to make quicker sense