کد:
SQL query:
--
-- Database: `enterhos_smftomybb`
--
-- --------------------------------------------------------
--
-- Table structure for table `smf_members`
--
CREATE TABLE `smf_members` (
`ID_MEMBER` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`memberName` varchar( 80 ) NOT NULL default '',
`dateRegistered` int( 10 ) unsigned NOT NULL default '0',
`posts` mediumint( 8 ) unsigned NOT NULL default '0',
`ID_GROUP` smallint( 5 ) unsigned NOT NULL default '0',
`lngfile` tinytext NOT NULL ,
`lastLogin` int( 10 ) unsigned NOT NULL default '0',
`realName` tinytext NOT NULL ,
`instantMessages` smallint( 5 ) NOT NULL default '0',
`unreadMessages` smallint( 5 ) NOT NULL default '0',
`buddy_list` text NOT NULL ,
`pm_ignore_list` tinytext NOT NULL ,
`messageLabels` text NOT NULL ,
`passwd` varchar( 64 ) NOT NULL default '',
`emailAddress` tinytext NOT NULL ,
`personalText` tinytext NOT NULL ,
`gender` tinyint( 4 ) unsigned NOT NULL default '0',
`birthdate` date NOT NULL default '0001-01-01',
`websiteTitle` tinytext NOT NULL ,
`websiteUrl` tinytext NOT NULL ,
`location` tinytext NOT NULL ,
`ICQ` tinytext NOT NULL ,
`AIM` varchar( 16 ) NOT NULL default '',
`YIM` varchar( 32 ) NOT NULL default '',
`MSN` tinytext NOT NULL ,
`hideEmail` tinyint( 4 ) NOT NULL default '0',
`showOnline` tinyint( 4 ) NOT NULL default '1',
`timeFormat` varchar( 80 ) NOT NULL default '',
`signature` text NOT NULL ,
`timeOffset` float NOT NULL default '0',
`avatar` tinytext NOT NULL ,
`pm_email_notify` tinyint( 4 ) NOT NULL default '0',
`karmaBad` smallint( 5 ) unsigned NOT NULL default '0',
`karmaGood` smallint( 5 ) unsigned NOT NULL default '0',
`usertitle` tinytext NOT NULL ,
`notifyAnnouncements` tinyint( 4 ) NOT NULL default '1',
`notifyOnce` tinyint( 4 ) NOT NULL default '1',
`notifySendBody` tinyint( 4 ) NOT NULL default '0',
`notifyTypes` tinyint( 4 ) NOT NULL default '2',
`memberIP` tinytext NOT NULL ,
`memberIP2` tinytext NOT NULL ,
`secretQuestion` tinytext NOT NULL ,
`secretAnswer` varchar( 64 ) NOT NULL default '',
`ID_THEME` tinyint( 4 ) unsigned NOT NULL default '0',
`is_activated` tinyint( 3 ) unsigned NOT NULL default '1',
`validation_code` varchar( 10 ) NOT NULL default '',
`ID_MSG_LAST_VISIT` int( 10 ) unsigned NOT NULL default '0',
`additionalGroups` tinytext NOT NULL ,
`smileySet` varchar( 48 ) NOT NULL default '',
`ID_POST_GROUP` smallint( 5 ) unsigned NOT NULL default '0',
`totalTimeLoggedIn` int( 10 ) unsigned NOT NULL default '0',
`passwordSalt` varchar( 8 ) NOT NULL default '',
PRIMARY KEY ( `ID_MEMBER` ) ,
KEY `memberName` ( `memberName` ( 30 ) ) ,
KEY `dateRegistered` ( `dateRegistered` ) ,
KEY `ID_GROUP` ( `ID_GROUP` ) ,
KEY `birthdate` ( `birthdate` ) ,
KEY `posts` ( `posts` ) ,
KEY `lastLogin` ( `lastLogin` ) ,
KEY `lngfile` ( `lngfile` ( 30 ) ) ,
KEY `ID_POST_GROUP` ( `ID_POST_GROUP` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =39;
MySQL said: Documentation
#1050 - Table 'smf_members' already exists
علاقه مندی ها (Bookmarks)