Sludinjuma datubaze

CREATE DATABASE `sludinajumi`;

USE `sludinajumi`;

CREATE TABLE `slud` (

`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

`text` TEXT NOT NULL,

`phone` TEXT NOT NULL,

`mail` VARCHAR(80) NOT NULL,

`photo` TEXT,

`date` INT UNSIGNED NOT NULL,

`ip` INT(11),

`views` INT DEFAULT 0,

`valid` INT UNSIGNED NOT NULL,

`category` int(3) UNSIGNED NOT NULL,

`type` INT(1) UNSIGNED NOT NULL,

`location` VARCHAR(300),  

`price_type` INT NOT NULL DEFAULT 0,

`paid` INT NOT NULL DEFAULT 0,`

`deleted` ENUM('y','n') DEFAULT 'n',

PRIMARY KEY (`id`),

FULLTEXT INDEX `text` (`text`),

INDEX `mail` (`mail`),

INDEX `cat_type` (`category`,`type`),

INDEX `location` (`location`),

INDEX `valid` (`valid`)

);

CREATE TABLE `payment` (

`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,

`date` int NOT NULL,

`paysummLvl` int(10) NOT NULL, 

`paysummEur` int(10),

`type` ENUM('sms','bank'),

`customerid` VARCHAR,

`slud_id` INT(10) NOT NOLL, 

`pvn` INT(2),

PRIMARY KEY (`ID`)

);

CREATE TABLE `category` (

`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, 

`name` TEXT NOT NULL, 

PRIMARY KEY (`id`), 

INDEX `name` (`name`)

);

CREATE TABLE `stats` (

);

$sql = "SELECT `text`,`mail`,`phone`,`location`,`date`,`views`,`type`,`photo` FROM `slud` WHERE `valid`>'".time()."' AND `deleted`='n' AND `category`= '".$kategorija."' AND (`price_type`=0 OR `paid`=1)";

IP + TIMESTAMP + BROWSER