[MySQL] How do I set up a database?
#2

You have to use custom code depending on what your database contains (such as which tables, table names, row names).

Here's an example:

Код:
CREATE TABLE IF NOT EXISTS `adminlog` (
 `id` mediumint(7) NOT NULL auto_increment,
 `command` varchar(14) NOT NULL,
 `admin` varchar(21) NOT NULL,
 `adminid` mediumint(7) NOT NULL,
 `player` varchar(21) NOT NULL default '*',
 `playerid` mediumint(7) NOT NULL default '-1',
 `str` varchar(128) NOT NULL default '*',
 `time` int(11) NOT NULL,
 PRIMARY KEY (`id`),
 KEY `adminid` (`adminid`),
 KEY `playerid` (`playerid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Reply


Messages In This Thread
[MySQL] How do I set up a database? - by Lejo - 09.04.2010, 04:18
Re: [MySQL] How do I set up a database? - by Grim_ - 09.04.2010, 05:57
Re: [MySQL] How do I set up a database? - by Calgon - 09.04.2010, 06:20

Forum Jump:


Users browsing this thread: 1 Guest(s)