PHP Classes

File: .install.sql

Recommend this page to a friend!
  Classes of rche  >  PHP Comments  >  .install.sql  >  Download  
File: .install.sql
Role: Auxiliary data
Content type: text/plain
Description: mySQL dump for install
Class: PHP Comments
Manage comments stored in a MySQL database
Author: By
Last change: Update of .install.sql
Date: 1 month ago
Size: 3,050 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump -- version 3.4.9 -- http://www.phpmyadmin.net -- -- Хост: localhost -- Время создания: Фев 10 2012 г., 14:34 -- Версия сервера: 5.1.58 -- Версия PHP: 5.2.17 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!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 */; -- -- База данных: `rcheru` -- -- -------------------------------------------------------- -- -- Структура таблицы `rche_comments` -- CREATE TABLE IF NOT EXISTS `rche_comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `reply` int(11) NOT NULL, `user` int(11) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `comment` varchar(2000) NOT NULL, `date` bigint(20) NOT NULL, `url` varchar(255) NOT NULL, `pass` varchar(10) NOT NULL, `urlOpen` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; /*!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 */; -- phpMyAdmin SQL Dump -- version 3.4.9 -- http://www.phpmyadmin.net -- -- Хост: localhost -- Время создания: Мар 06 2012 г., 16:12 -- Версия сервера: 5.1.61 -- Версия PHP: 5.2.17 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!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 */; -- -- База данных: `rcheru` -- -- -------------------------------------------------------- -- -- Структура таблицы `rche_users` -- CREATE TABLE IF NOT EXISTS `rche_users` ( `userID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(50) NOT NULL DEFAULT '', `password` varchar(100) NOT NULL DEFAULT '', `email` varchar(150) NOT NULL DEFAULT '', `family` varchar(50) NOT NULL, `name` varchar(50) NOT NULL, `name_two` varchar(50) NOT NULL, `wm` varchar(15) NOT NULL, `photo` varchar(255) NOT NULL, `active` tinyint(1) NOT NULL DEFAULT '0', `gid` int(11) NOT NULL, `date` varchar(20) NOT NULL, `rate` int(11) NOT NULL, `money` float NOT NULL, `desc` varchar(255) NOT NULL, `profile` text NOT NULL, `country` int(11) NOT NULL, `region` int(11) NOT NULL, `city` int(11) NOT NULL, `online` int(11) NOT NULL, `alertmail` int(11) NOT NULL, `alertlich` int(11) NOT NULL, PRIMARY KEY (`userID`), UNIQUE KEY `username` (`username`), UNIQUE KEY `email` (`email`), KEY `active` (`active`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3293 ; /*!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 */;