Sem noção
SQLyog Community Edition- MySQL GUI v8.18
MySQL - 5.0.45-community-nt-log : Database - char
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`char` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `char`;
/*Table structure for table `account_data` */
DROP TABLE IF EXISTS `account_data`;
CREATE TABLE `account_data` ( `acct` int(30) NOT NULL, `uiconfig0` blob, `uiconfig1` blob, `uiconfig2` blob, `uiconfig3` blob, `uiconfig4` blob, `uiconfig5` blob, `uiconfig6` blob, `uiconfig7` blob, `uiconfig8` blob, PRIMARY KEY (`acct`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*Data for the table `account_data` */
/*Table structure for table `account_forced_permissions` */
DROP TABLE IF EXISTS `account_forced_permissions`;
CREATE TABLE `account_forced_permissions` ( `login` varchar(50) NOT NULL, `permissions` varchar(100) NOT NULL, PRIMARY KEY (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*Data for the table `account_forced_permissions` */
/*Table structure for table `accounts` */
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` ( `acct` int(10) unsigned NOT NULL auto_increment COMMENT 'Unique ID', `login` varchar(32) collate utf8_unicode_ci NOT NULL COMMENT 'Login username', `password` varchar(32) collate utf8_unicode_ci NOT NULL COMMENT 'Login password', `encrypted_password` varchar(42) collate utf8_unicode_ci NOT NULL default '', `gm` varchar(32) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Game permissions', `banned` int(10) unsigned NOT NULL