Need help about new table

[isaw4sal3]

is there a way to create new table format for phpMyadmin? i dropped my char table. need your help guys my players can't create their new characters. /sob

[Flaid]

Try this

CREATE TABLE IF NOT EXISTS `char` (
 `char_id` int(11) unsigned NOT NULL auto_increment,
 `account_id` int(11) unsigned NOT NULL default '0',
 `char_num` tinyint(1) NOT NULL default '0',
 `name` varchar(30) NOT NULL default '',
 `class` smallint(6) unsigned NOT NULL default '0',
 `base_level` smallint(6) unsigned NOT NULL default '1',
 `job_level` smallint(6) unsigned NOT NULL default '1',
 `base_exp` bigint(20) unsigned NOT NULL default '0',
 `job_exp` bigint(20) unsigned NOT NULL default '0',
 `zeny` int(11) unsigned NOT NULL default '0',
 `str` smallint(4) unsigned NOT NULL default '0',
 `agi` smallint(4) unsigned NOT NULL default '0',
 `vit` smallint(4) unsigned NOT NULL default '0',
 `int` smallint(4) unsigned NOT NULL default '0',
 `dex` smallint(4) unsigned NOT NULL default '0',
 `luk` smallint(4) unsigned NOT NULL default '0',
 `max_hp` mediumint(8) unsigned NOT NULL default '0',
 `hp` mediumint(8) unsigned NOT NULL default '0',
 `max_sp` mediumint(6) unsigned NOT NULL default '0',
 `sp` mediumint(6) unsigned NOT NULL default '0',
 `status_point` int(11) unsigned NOT NULL default '0',
 `skill_point` int(11) unsigned NOT NULL default '0',
 `option` int(11) NOT NULL default '0',
 `karma` tinyint(3) NOT NULL default '0',
 `manner` smallint(6) NOT NULL default '0',
 `party_id` int(11) unsigned NOT NULL default '0',
 `guild_id` int(11) unsigned NOT NULL default '0',
 `pet_id` int(11) unsigned NOT NULL default '0',
 `homun_id` int(11) unsigned NOT NULL default '0',
 `elemental_id` int(11) unsigned NOT NULL default '0',
 `hair` tinyint(4) unsigned NOT NULL default '0',
 `hair_color` smallint(5) unsigned NOT NULL default '0',
 `clothes_color` smallint(5) unsigned NOT NULL default '0',
 `weapon` smallint(6) unsigned NOT NULL default '0',
 `shield` smallint(6) unsigned NOT NULL default '0',
 `head_top` smallint(6) unsigned NOT NULL default '0',
 `head_mid` smallint(6) unsigned NOT NULL default '0',
 `head_bottom` smallint(6) unsigned NOT NULL default '0',
 `robe` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
 `last_map` varchar(11) NOT NULL default '',
 `last_x` smallint(4) unsigned NOT NULL default '53',
 `last_y` smallint(4) unsigned NOT NULL default '111',
 `save_map` varchar(11) NOT NULL default '',
 `save_x` smallint(4) unsigned NOT NULL default '53',
 `save_y` smallint(4) unsigned NOT NULL default '111',
 `partner_id` int(11) unsigned NOT NULL default '0',
 `online` tinyint(2) NOT NULL default '0',
 `father` int(11) unsigned NOT NULL default '0',
 `mother` int(11) unsigned NOT NULL default '0',
 `child` int(11) unsigned NOT NULL default '0',
 `fame` int(11) unsigned NOT NULL default '0',
 `rename` SMALLINT(3) unsigned NOT NULL default '0',
 `delete_date` INT(11) UNSIGNED NOT NULL DEFAULT '0',
 PRIMARY KEY  (`char_id`),
 KEY `account_id` (`account_id`),
 KEY `party_id` (`party_id`),
 KEY `guild_id` (`guild_id`),
 KEY `name` (`name`),
 KEY `online` (`online`)
) ENGINE=MyISAM AUTO_INCREMENT=150000; 

[isaw4sal3]

how can i connect it to sql? can i make text document and paste it?

[Flaid]

You just choose the database when you're on your phpmyadmin, click SQL on the top, paste it in and execute it.

[Joseph]

All the SQL files are located in trunk/sql-files.