View file Spiderwap.in File Hosting/sql.sql

CREATE TABLE IF NOT EXISTS `acc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nick` varchar(50) NOT NULL,
  `pass` char(32) NOT NULL,
  `assec` enum('0','1','2') DEFAULT '0',
  `time` int(11) DEFAULT NULL,
  `name` varchar(35) NOT NULL,
  `icq` int(10) NOT NULL,
  `email` varchar(70) NOT NULL,
  `last` int(11) NOT NULL,
  `kol` int(5) NOT NULL DEFAULT '0',
  `balls` int(11) NOT NULL DEFAULT '0',
  `lastfile` int(11) NOT NULL,
  `site` varchar(50) NOT NULL,
  `osebe` varchar(150) NOT NULL,
  `skype` varchar(25) NOT NULL,
  `siti` varchar(50) NOT NULL,
  `ava` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `acc`
--


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

--
-- Table structure for table `cat`
--

CREATE TABLE IF NOT EXISTS `cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ros` varchar(255) DEFAULT NULL,
  `user` enum('0','1','2') DEFAULT '2',
  `max` int(11) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cat`
--


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

--
-- Table structure for table `config`
--

CREATE TABLE IF NOT EXISTS `config` (
  `balls` int(10) NOT NULL,
  `onp` int(3) NOT NULL,
  `new` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `config`
--

INSERT INTO `config` (`balls`, `onp`, `new`) VALUES
(5, 10, 1);

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

--
-- Table structure for table `files`
--

CREATE TABLE IF NOT EXISTS `files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `opis` varchar(255) DEFAULT NULL,
  `real` varchar(255) DEFAULT NULL,
  `add` varchar(255) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  `pass` char(32) DEFAULT '',
  `kol` int(11) DEFAULT '0',
  `rait` int(11) DEFAULT '0',
  `ext` varchar(7) NOT NULL,
  `size` bigint(20) NOT NULL,
  `raitis` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `files`
--


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

--
-- Table structure for table `komm`
--

CREATE TABLE IF NOT EXISTS `komm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  `text` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `komm`
--


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

--
-- Table structure for table `zhal`
--

CREATE TABLE IF NOT EXISTS `zhal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `file_id` int(11) DEFAULT NULL,
  `theme` varchar(50) DEFAULT NULL,
  `komm` varchar(150) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `zhal`
--