Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Tut]How to make SQL's

Newbie Spellweaver
Joined
Aug 9, 2008
Messages
8
Reaction score
0
Dummy's guide to how to make an SQL. Example:
Let's say you want to Make an SQL like a database for your Maple story server Okay?

First things first, Right click on Desktop > New > Text document.

Once you have the Text document up.
Here's an example: If you want to make a Reporting system SQL.
Insert this:
CREATE TABLE IF NOT EXISTS `reports` (
`id` int(10) unsigned NOT NULL auto_increment,
`reporttime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`reporterid` int(11) NOT NULL,
`victimid` int(11) NOT NULL,
`reason` tinyint(4) NOT NULL,
`chatlog` text NOT NULL,
`status` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Once done. Hit File>Save as> Name it whatever i guess.
Example: Report system SQL
After you have your title, Insert this at the end.
.sql

Your Title would be
Report system.sql

Once done press File>Save as> (Insert Title) Save

Now it will look like a Notepad document but you will be able to execute it in MySQL!
 
Experienced Elementalist
Joined
Jul 1, 2008
Messages
270
Reaction score
0
Re: [Guide] How to make SQL's

You would have to be a complete idiot to not know how to do this. And I've been able to run regular text documents in sql. Sorry but, useless thread
 
Newbie Spellweaver
Joined
Jun 19, 2008
Messages
47
Reaction score
0
Re: [Guide] How to make SQL's

horrible?

dosent tell u what it all does...

no flame =/
 
Newbie Spellweaver
Joined
Aug 9, 2008
Messages
8
Reaction score
0
Re: [Guide] How to make SQL's

yea sorry guys, It's my first guide I'm a bit rusty at it.
 
Master Summoner
Joined
Jul 28, 2008
Messages
503
Reaction score
0
Re: [Guide] How to make SQL's

i guess its ok even if you did some mistakes
 
Back
Top