[mevi]

gerekli filtreleme yapilmiyor. kayit sayisi hala ayni geliyor.

CREATE TABLE `tblauthor` (
`Author_ID` int(11) NOT NULL auto_increment,
`Group_ID` int(11) NOT NULL default '0',
`Username` varchar(25) NOT NULL default '',
`Real_name` varchar(40) default NULL,
`User_code` varchar(50) NOT NULL default '',
`Password` varchar(50) NOT NULL default '',
`Salt` varchar(30) default NULL,
`Author_email` varchar(75) default NULL,
`Homepage` varchar(50) default NULL,
`Location` varchar(60) default NULL,
`MSN` varchar(75) default NULL,
`Yahoo` varchar(75) default NULL,
`ICQ` varchar(20) default NULL,
`AIM` varchar(75) default NULL,
`Occupation` varchar(60) default NULL,
`Interests` varchar(160) default NULL,
`DOB` datetime default NULL,
`Signature` varchar(255) NOT NULL default '',
`No_of_posts` int(11) NOT NULL default '0',
`Join_date` datetime NOT NULL default '0000-00-00 00:00:00',
`Avatar` varchar(100) NOT NULL default '',
`Avatar_title` varchar(70) default NULL,
`Last_visit` datetime NOT NULL default '0000-00-00 00:00:00',
`Time_offset` char(1) NOT NULL default '',
`Time_offset_hours` smallint(4) NOT NULL default '0',
`Date_format` varchar(10) default NULL,
`No_of_PM` int(11) NOT NULL default '0',
`Show_email` tinyint(1) NOT NULL default '0',
`Attach_signature` tinyint(1) NOT NULL default '0',
`Active` tinyint(1) NOT NULL default '0',
`Rich_editor` tinyint(1) NOT NULL default '0',
`Reply_notify` tinyint(1) NOT NULL default '0',
`PM_notify` tinyint(1) NOT NULL default '0',
`Skype` varchar(30) default NULL,
`Login_attempt` int(11) NOT NULL default '0',
`Banned` tinyint(1) NOT NULL default '0',
`Info` varchar(255) NOT NULL default '',
`personal_title` varchar(250) default 'personal_title',
PRIMARY KEY (`Author_ID`),
UNIQUE KEY `User_code` (`User_code`),
UNIQUE KEY `Username` (`Username`),
KEY `Author_ID` (`Author_ID`),
KEY `Group_ID` (`Group_ID`),
KEY `tblGrouptblAuthor` (`Group_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=453 DEFAULT CHARSET=latin1;


CREATE TABLE `tblbuddylist` (
`Address_ID` int(11) NOT NULL auto_increment,
`Author_ID` int(11) NOT NULL default '0',
`Buddy_ID` int(11) NOT NULL default '0',
`Description` varchar(60) NOT NULL default '',
`Block` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`Address_ID`),
KEY `Address_ID` (`Address_ID`),
KEY `Author_ID` (`Buddy_ID`),
KEY `Buddy_ID` (`Author_ID`),
KEY `tblAuthortblBuddyList` (`Buddy_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=544 DEFAULT CHARSET=latin1;



CREATE TABLE `photo_gallery` (
`photo_id` int(11) NOT NULL auto_increment,
`photo_url` varchar(255) default NULL,
`photo_owner` int(11) default NULL,
`photo_description` varchar(255) NOT NULL default '',
`photo_album_user` int(11) default NULL,
`photo_album_admin` int(11) default NULL,
`photo_date` datetime NOT NULL default '0000-00-00 00:00:00',
`photo_active` int(1) default '1',
`photo_counter` int(11) default NULL,
`photo_visible` int(2) NOT NULL default '0',
PRIMARY KEY (`photo_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2916 DEFAULT CHARSET=latin1;