-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Gazda: localhost
-- Timp de generare: 23 Oct 2010 la 03:38
-- Versiune server: 5.1.41
-- Versiune PHP: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Baza de date: `share`
--

-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `active_guests`
--

CREATE TABLE IF NOT EXISTS `active_guests` (
  `ip` varchar(15) NOT NULL DEFAULT '',
  `timestamp` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Salvarea datelor din tabel `active_guests`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `active_users`
--

CREATE TABLE IF NOT EXISTS `active_users` (
  `username` varchar(30) NOT NULL DEFAULT '',
  `timestamp` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Salvarea datelor din tabel `active_users`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `banip`
--

CREATE TABLE IF NOT EXISTS `banip` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` text NOT NULL,
  `motiv` text NOT NULL,
  `user` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `banip`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `banned`
--

CREATE TABLE IF NOT EXISTS `banned` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(255) NOT NULL DEFAULT '',
  `time` varchar(255) NOT NULL DEFAULT '',
  `long` varchar(255) NOT NULL DEFAULT '',
  `reason` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `banned`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `b_banemails`
--

CREATE TABLE IF NOT EXISTS `b_banemails` (
  `emailid` bigint(20) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`emailid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `b_banemails`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `b_categories`
--

CREATE TABLE IF NOT EXISTS `b_categories` (
  `categoryid` bigint(20) NOT NULL AUTO_INCREMENT,
  `categoryname` varchar(255) NOT NULL DEFAULT '',
  `catsort` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`categoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `b_categories`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `b_forums`
--

CREATE TABLE IF NOT EXISTS `b_forums` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `parentID` bigint(20) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `description` tinytext NOT NULL,
  `numtopics` bigint(20) NOT NULL DEFAULT '0',
  `numposts` bigint(20) NOT NULL DEFAULT '0',
  `lastpost` varchar(255) NOT NULL DEFAULT '',
  `sort` bigint(20) NOT NULL DEFAULT '0',
  `lastpostuser` varchar(255) NOT NULL DEFAULT '',
  `permission_min` int(11) NOT NULL DEFAULT '0',
  `permission_post` int(11) NOT NULL DEFAULT '0',
  `permission_reply` int(11) NOT NULL DEFAULT '0',
  `lastposttime` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `b_forums`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `b_pms`
--

CREATE TABLE IF NOT EXISTS `b_pms` (
  `pmID` bigint(20) NOT NULL AUTO_INCREMENT,
  `sender` bigint(20) NOT NULL DEFAULT '0',
  `receiver` bigint(20) NOT NULL DEFAULT '0',
  `therealtime` bigint(20) NOT NULL DEFAULT '0',
  `subject` varchar(255) NOT NULL DEFAULT '',
  `message` mediumtext NOT NULL,
  `hasread` int(11) NOT NULL DEFAULT '0',
  `vartime` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`pmID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `b_pms`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `b_posts`
--

CREATE TABLE IF NOT EXISTS `b_posts` (
  `ID` bigint(21) NOT NULL AUTO_INCREMENT,
  `title` varchar(60) NOT NULL DEFAULT '',
  `author` bigint(20) NOT NULL DEFAULT '0',
  `telapsed` bigint(21) NOT NULL DEFAULT '0',
  `timepost` varchar(100) NOT NULL DEFAULT '',
  `numreplies` int(10) NOT NULL DEFAULT '0',
  `post` longtext NOT NULL,
  `threadparent` bigint(21) NOT NULL DEFAULT '0',
  `lastpost` varchar(255) NOT NULL DEFAULT '',
  `postforum` bigint(20) NOT NULL DEFAULT '0',
  `views` bigint(20) NOT NULL DEFAULT '0',
  `nosmilies` int(11) NOT NULL DEFAULT '0',
  `value` int(11) NOT NULL DEFAULT '0',
  `ipaddress` varchar(255) NOT NULL DEFAULT '',
  `locked` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `b_posts`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `b_ranks`
--

CREATE TABLE IF NOT EXISTS `b_ranks` (
  `rankID` bigint(20) NOT NULL AUTO_INCREMENT,
  `rankname` varchar(255) NOT NULL DEFAULT '',
  `postsneeded` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rankID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `b_ranks`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `b_templates`
--

CREATE TABLE IF NOT EXISTS `b_templates` (
  `templateid` bigint(20) NOT NULL AUTO_INCREMENT,
  `templatepath` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`templateid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Salvarea datelor din tabel `b_templates`
--

INSERT INTO `b_templates` (`templateid`, `templatepath`) VALUES
(1, 'default');

-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `b_users`
--

CREATE TABLE IF NOT EXISTS `b_users` (
  `userID` bigint(21) NOT NULL AUTO_INCREMENT,
  `username` varchar(60) NOT NULL DEFAULT '',
  `password` varchar(255) NOT NULL DEFAULT '',
  `status` int(20) NOT NULL DEFAULT '0',
  `posts` bigint(20) NOT NULL DEFAULT '0',
  `email` varchar(255) NOT NULL DEFAULT '',
  `validated` int(11) NOT NULL DEFAULT '0',
  `keynode` bigint(21) NOT NULL DEFAULT '0',
  `sig` tinytext NOT NULL,
  `banned` varchar(255) NOT NULL DEFAULT 'no',
  `rank` varchar(255) NOT NULL DEFAULT '0',
  `usepm` int(11) NOT NULL DEFAULT '1',
  `AIM` varchar(50) NOT NULL DEFAULT '',
  `ICQ` varchar(50) NOT NULL DEFAULT '',
  `location` varchar(255) NOT NULL DEFAULT '',
  `showprofile` smallint(6) NOT NULL DEFAULT '1',
  `lastposttime` bigint(20) NOT NULL DEFAULT '0',
  `tsgone` bigint(20) NOT NULL DEFAULT '0',
  `oldtime` bigint(20) NOT NULL DEFAULT '0',
  `avatar` varchar(255) NOT NULL DEFAULT '',
  `photo` varchar(255) NOT NULL DEFAULT '',
  `rating` bigint(255) NOT NULL DEFAULT '0',
  `totalvotes` bigint(20) NOT NULL DEFAULT '0',
  `votedfor` longtext NOT NULL,
  `rps` int(11) NOT NULL DEFAULT '1',
  `rpsscore` bigint(20) NOT NULL DEFAULT '0',
  `lasttime` bigint(20) NOT NULL DEFAULT '0',
  `templateclass` bigint(20) NOT NULL DEFAULT '1',
  PRIMARY KEY (`userID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `b_users`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `categorii`
--

CREATE TABLE IF NOT EXISTS `categorii` (
  `id` varchar(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `detalies` varchar(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Salvarea datelor din tabel `categorii`
--

INSERT INTO `categorii` (`id`, `name`, `detalies`) VALUES
('1', 'Audio', ''),
('2', 'Ringtones', ''),
('3', 'Videoclips', ''),
('4', 'Mobile Video', ''),
('5', 'Java Applications', ''),
('6', 'Java Games', ''),
('7', 'Windows Smartphone', ''),
('8', 'PocketPC', ''),
('9', 'Symbian UIQ', ''),
('10', 'Symbian S60v2 Games', ''),
('11', 'Symbian S60v3 Games', ''),
('12', 'Symbian S60v3 Apps', ''),
('13', 'Photos/Images', ''),
('14', 'Funny pictures', ''),
('15', 'Tutorials', ''),
('16', 'PC-Phone Tools', ''),
('17', 'PC Misc', ''),
('18', 'Symbian S60v2 Apps', ''),
('19', 'Sony Themes', ''),
('20', 'Nokia Themes', ''),
('25', 'Flash Video (FLV)', ''),
('24', 'Firmware Base', ''),
('23', 'Siemens Themes', ''),
('22', 'Motorola Themes', ''),
('21', 'Serials/Keygen', ''),
('26', 'Linux', ''),
('27', 'Android', ''),
('28', 'Manele', ''),
('29', 'Avatare', ''),
('30', 'iPhone', ''),
('0', '0 No Category', ''),
('31', 'Blackberry', ''),
('32', 'Symbian s60v4/v5 App', ''),
('33', 'Symbian s60v4/v5 Games', ''),
('34', 'Subtitle', ''),
('35', 'Scripts', ''),
('36', 'Torrents', '');

-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `cereri`
--

CREATE TABLE IF NOT EXISTS `cereri` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `message` longtext NOT NULL,
  `date` varchar(20) NOT NULL,
  `raspuns` text NOT NULL,
  `pid` varchar(9999) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `cereri`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uname` varchar(42) DEFAULT NULL,
  `file` varchar(700) DEFAULT NULL,
  `date` int(10) DEFAULT NULL,
  `comment` varchar(10000) NOT NULL,
  `mail` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `comments`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `counter_ips`
--

CREATE TABLE IF NOT EXISTS `counter_ips` (
  `ip` varchar(15) NOT NULL,
  `visit` datetime NOT NULL,
  UNIQUE KEY `ip` (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Salvarea datelor din tabel `counter_ips`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `counter_values`
--

CREATE TABLE IF NOT EXISTS `counter_values` (
  `id` bigint(11) NOT NULL,
  `day_id` bigint(11) NOT NULL,
  `day_value` bigint(11) NOT NULL,
  `yesterday_id` bigint(11) NOT NULL,
  `yesterday_value` bigint(11) NOT NULL,
  `week_id` bigint(11) NOT NULL,
  `week_value` bigint(11) NOT NULL,
  `month_id` bigint(11) NOT NULL,
  `month_value` bigint(11) NOT NULL,
  `year_id` bigint(11) NOT NULL,
  `year_value` bigint(11) NOT NULL,
  `all_value` bigint(11) NOT NULL,
  `record_date` datetime NOT NULL,
  `record_value` bigint(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Salvarea datelor din tabel `counter_values`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `favorite`
--

CREATE TABLE IF NOT EXISTS `favorite` (
  `uid` text NOT NULL,
  `fid` text NOT NULL,
  `id` bigint(21) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `favorite`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `fisiere`
--

CREATE TABLE IF NOT EXISTS `fisiere` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `file` varchar(200) NOT NULL DEFAULT '',
  `user` varchar(200) NOT NULL DEFAULT 'guest',
  `description` varchar(250) NOT NULL DEFAULT '',
  `size` int(50) NOT NULL DEFAULT '0',
  `ftype` varchar(10) NOT NULL DEFAULT '',
  `view` int(20) NOT NULL DEFAULT '0',
  `download` int(20) NOT NULL DEFAULT '0',
  `browse` varchar(200) NOT NULL DEFAULT '',
  `uploaded` mediumtext NOT NULL,
  `lastaccess` varchar(200) NOT NULL DEFAULT '',
  `ip` varchar(50) NOT NULL DEFAULT '',
  `pass` varchar(50) NOT NULL DEFAULT '',
  `banned` varchar(50) NOT NULL DEFAULT 'no',
  `categorie` varchar(100) NOT NULL,
  `reclamant` varchar(100) NOT NULL,
  `motiv` text NOT NULL,
  `abuse` int(11) NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `fisiere`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `guestsonline`
--

CREATE TABLE IF NOT EXISTS `guestsonline` (
  `guestid` bigint(20) NOT NULL AUTO_INCREMENT,
  `guestip` varchar(255) NOT NULL DEFAULT '',
  `time` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`guestid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `guestsonline`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titlu` varchar(255) DEFAULT NULL,
  `news` text NOT NULL,
  `tags` text NOT NULL,
  `uploader` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `data_ad` datetime DEFAULT NULL,
  `hits` int(6) NOT NULL,
  `poza` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `news` (`news`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `news`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `pm`
--

CREATE TABLE IF NOT EXISTS `pm` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `subiect` varchar(255) NOT NULL,
  `continut` text NOT NULL,
  `sender` varchar(32) NOT NULL,
  `reciever` varchar(32) NOT NULL,
  `data` datetime NOT NULL,
  `vazut` int(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `pm`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `pm_users`
--

CREATE TABLE IF NOT EXISTS `pm_users` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL DEFAULT '',
  `password` varchar(100) NOT NULL DEFAULT '',
  `name` varchar(150) NOT NULL DEFAULT '',
  `gender` varchar(10) NOT NULL DEFAULT '',
  `country` varchar(50) NOT NULL DEFAULT '',
  `reg_ip` varchar(20) NOT NULL DEFAULT '',
  `reg_date` varchar(12) NOT NULL DEFAULT '',
  `last_signin` varchar(12) NOT NULL DEFAULT '',
  `email` varchar(150) NOT NULL DEFAULT '',
  `favorite` enum('0','1') NOT NULL DEFAULT '1',
  `power` enum('0','1','2') NOT NULL DEFAULT '0',
  `about` text NOT NULL,
  `avatar` varchar(255) NOT NULL DEFAULT 'no_avatar.gif',
  `activation_key` varchar(20) NOT NULL DEFAULT '',
  `new_password` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `pm_users`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `rates`
--

CREATE TABLE IF NOT EXISTS `rates` (
  `id` int(11) DEFAULT NULL,
  `rate` int(11) NOT NULL,
  `vote` int(11) NOT NULL,
  `fid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Salvarea datelor din tabel `rates`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `setting`
--

CREATE TABLE IF NOT EXISTS `setting` (
  `id` int(11) NOT NULL,
  `hit` int(11) NOT NULL DEFAULT '0',
  `data` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Salvarea datelor din tabel `setting`
--

INSERT INTO `setting` (`id`, `hit`, `data`) VALUES
(1, 417955, 2010);

-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `shoutbox`
--

CREATE TABLE IF NOT EXISTS `shoutbox` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` mediumtext NOT NULL,
  `message` longtext NOT NULL,
  `data` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `shoutbox`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `site`
--

CREATE TABLE IF NOT EXISTS `site` (
  `id` int(11) NOT NULL,
  `user` varchar(100) NOT NULL,
  `titlu` varchar(200) NOT NULL,
  `link` varchar(100) NOT NULL,
  `vizite` int(11) NOT NULL DEFAULT '0',
  `accesari` int(11) NOT NULL DEFAULT '0',
  `activ` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Salvarea datelor din tabel `site`
--

INSERT INTO `site` (`id`, `user`, `titlu`, `link`, `vizite`, `accesari`, `activ`) VALUES
(1, '1', 'wWw.ExtremShare.Net', 'http://extremshare.net', 0, 0, 1);

-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `tags`
--

CREATE TABLE IF NOT EXISTS `tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cautare` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `tags`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `tv`
--

CREATE TABLE IF NOT EXISTS `tv` (
  `id` int(11) NOT NULL,
  `name` varchar(1000) NOT NULL,
  `adress` text NOT NULL,
  `detalies` text NOT NULL,
  `user` varchar(500) NOT NULL,
  `date` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Salvarea datelor din tabel `tv`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `useronline`
--

CREATE TABLE IF NOT EXISTS `useronline` (
  `timestamp` int(15) NOT NULL DEFAULT '0',
  `ip` varchar(40) NOT NULL DEFAULT '',
  `useronline` varchar(100) NOT NULL,
  `file` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`timestamp`),
  KEY `ip` (`ip`),
  KEY `file` (`file`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Salvarea datelor din tabel `useronline`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `user_temp`
--

CREATE TABLE IF NOT EXISTS `user_temp` (
  `nume` varchar(32) DEFAULT NULL,
  `incercari` decimal(1,0) DEFAULT '0',
  `ip` varchar(18) DEFAULT NULL,
  `data` varchar(32) DEFAULT NULL,
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `user_temp`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `utilizatori`
--

CREATE TABLE IF NOT EXISTS `utilizatori` (
  `id` bigint(21) NOT NULL AUTO_INCREMENT,
  `nume` varchar(60) NOT NULL,
  `parola` varchar(255) NOT NULL,
  `status` int(20) NOT NULL DEFAULT '0',
  `email` varchar(255) NOT NULL DEFAULT '',
  `aprobat` int(11) NOT NULL DEFAULT '0',
  `keynode` bigint(21) NOT NULL DEFAULT '0',
  `banned` varchar(255) NOT NULL DEFAULT 'no',
  `rank` varchar(255) NOT NULL DEFAULT '0',
  `lastposttime` bigint(20) NOT NULL DEFAULT '0',
  `tsgone` bigint(20) NOT NULL DEFAULT '0',
  `oldtime` bigint(20) NOT NULL DEFAULT '0',
  `avatar` varchar(255) NOT NULL DEFAULT 'no_avatar.gif',
  `lasttime` bigint(20) NOT NULL DEFAULT '0',
  `templateclass` bigint(20) NOT NULL DEFAULT '1',
  `ip` varchar(111) NOT NULL,
  `pass` varchar(500) NOT NULL,
  `online` varchar(500) NOT NULL,
  `data` varchar(32) NOT NULL,
  `color` varchar(1000) NOT NULL DEFAULT '2966B8',
  `warn` varchar(10) NOT NULL DEFAULT '0',
  `setavatar` varchar(2) NOT NULL DEFAULT '0',
  `fisiere` int(255) DEFAULT '0',
  `motiv` text NOT NULL,
  `reclamant` varchar(100) NOT NULL,
  `views` varchar(55555) NOT NULL DEFAULT '0',
  `stare` text NOT NULL,
  `download` text NOT NULL,
  `usepm` int(11) NOT NULL DEFAULT '1',
  `ptup` int(11) NOT NULL DEFAULT '0',
  `ptdown` int(11) NOT NULL DEFAULT '0',
  `link` varchar(1000) NOT NULL DEFAULT 'http://www.extremshare.net',
  `timestamp` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `utilizatori`
--


/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
