· 8 years ago · Jun 23, 2018, 10:54 PM
1DROP TABLE IF EXISTS `drak_reinos`;
2
3CREATE TABLE `drak_reinos` (
4 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
5 `nombre` varchar(32) NOT NULL,
6 `host` varchar(32) NOT NULL DEFAULT '127.0.0.1',
7 `puerto` int(11) NOT NULL DEFAULT '8085',
8 `char_db` varchar(32) NOT NULL,
9 `world_db` varchar(32) NOT NULL,
10 `ra_user` varchar(128) NOT NULL,
11 `ra_pass` varchar(128) NOT NULL,
12 `version` varchar(64) NOT NULL,
13 PRIMARY KEY (`id`,`ra_user`,`ra_pass`,`char_db`,`world_db`),
14 UNIQUE KEY `idx_name` (`nombre`)
15) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Firetail Realm System';
16
17/*Data for the table `drak_reinos` */
18
19insert into `drak_reinos`(`id`,`nombre`,`host`,`puerto`,`char_db`,`world_db`,`ra_user`,`ra_pass`,`version`) values (1,'FireTail','127.0.0.1',8085,'characters','world','drakantas','clave_encriptada','3.3.5.12340');