--
-- Table structure for table `chat_kick`
--
CREATE TABLE `chat_kick` (
`id` int(11) NOT NULL auto_increment,
`nick` text NOT NULL,
`razlog` text NOT NULL,
`vreme` text NOT NULL,
`banovan` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `chat_kick`
--
-- --------------------------------------------------------
--
-- Table structure for table `chat_on`
--
CREATE TABLE `chat_on` (
`nick` text character set swe7 NOT NULL,
`time` text character set swe7 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `chat_on`
--
-- --------------------------------------------------------
--
-- Table structure for table `chat_pass`
--
CREATE TABLE `chat_pass` (
`id` int(99) NOT NULL auto_increment,
`nick` text character set swe7 NOT NULL,
`pass` text character set swe7 NOT NULL,
`activ` text character set swe7 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=316 ;
--
-- Dumping data for table `chat_pass`
--
-- --------------------------------------------------------
--
-- Table structure for table `chat_pps`
--
CREATE TABLE `chat_pps` (
`id` int(99) NOT NULL auto_increment,
`pp` text NOT NULL,
`kome` varchar(100) character set swe7 NOT NULL,
`odkoga` varchar(255) character set swe7 NOT NULL,
`procitana` text character set swe7 NOT NULL,
`sat` text character set swe7 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=249191 ;
--
-- Dumping data for table `chat_pps`
--
-- --------------------------------------------------------
--
-- Table structure for table `chat_users`
--
CREATE TABLE `chat_users` (
`id` int(11) NOT NULL auto_increment,
`nick` text NOT NULL,
`poseta` text,
`ip` text,
`soft` text,
`zadnjasoba` varchar(20) character set swe7 NOT NULL default 'Ludnica',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14527 ;
--
-- Dumping data for table `chat_users`
--
-- --------------------------------------------------------
--
-- Table structure for table `maxonline`
--
CREATE TABLE `online` (
`id` int(1) NOT NULL,
`maxonline` text character set swe7 NOT NULL,
`date` text character set swe7 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `online`
--
-- --------------------------------------------------------
--
-- Table structure for table `private`
--
CREATE TABLE `private` (
`id` int(20) NOT NULL auto_increment,
`nick` varchar(20) NOT NULL,
`text` text NOT NULL,
`sat` varchar(50) NOT NULL,
`kljuc` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;
--
-- Dumping data for table `private`
--
-- -------------------------------------------------------
--
-- Table structure for table `statusi`
--
CREATE TABLE `statusi` (
`id` int(11) NOT NULL auto_increment,
`nick` text NOT NULL,
`admin` text NOT NULL,
`mods` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `statusi`
--
skripta se nalazi nja http://e.r8.org ! Pocetnik sam!
Hvala unapred......