View file fpt.sql

--
-- Структура таблицы `fpt_ads`
--

CREATE TABLE IF NOT EXISTS `fpt_ads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `link` varchar(250) NOT NULL,
  `click` int(11) NOT NULL DEFAULT '0',
  `date` int(11) NOT NULL,
  `pos` int(1) NOT NULL,
  `delete` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `fpt_modules`
--

CREATE TABLE IF NOT EXISTS `fpt_modules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Дамп данных таблицы `fpt_modules`
--

INSERT INTO `fpt_modules` (`id`, `name`) VALUES
(1, 'route');
-- --------------------------------------------------------


CREATE TABLE IF NOT EXISTS `fpt_route` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idi` int(11) NOT NULL,
  `type` varchar(20) NOT NULL,
  `name` varchar(250) NOT NULL,
  `modul` varchar(25) NOT NULL,
  `pos` int(11) NOT NULL,
  `view` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Дамп данных таблицы `fpt_route`
--

INSERT INTO `fpt_route` (`id`, `idi`, `type`, `name`, `modul`, `pos`, `view`) VALUES
(1, 0, 'cat', 'О fportal', '', 1, 1),
(2, 1, 'sys', '', 'route', 1, 1),
(3, 1, 'mod', '', 'user', 2, 1);
--
-- Структура таблицы `fpt_system`
--

CREATE TABLE IF NOT EXISTS `fpt_system` (
  `name` varchar(250) NOT NULL,
  `value` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `fpt_system`
--

INSERT INTO `fpt_system` (`name`, `value`) VALUES
('name', 'FPORTAL'),
('des', 'DES'),
('key', 'KEY'),
('style', 'default'),
('copy', 'Development by CoMMoN 2014');

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

--
-- Структура таблицы `fpt_users`
--

CREATE TABLE IF NOT EXISTS `fpt_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(250) NOT NULL,
  `password` varchar(250) NOT NULL,
  `level` int(11) NOT NULL DEFAULT '1',
  `reg` int(11) NOT NULL,
  `last` int(11) NOT NULL,
  `email` varchar(100) NOT NULL,
  `anketa` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `fpt_smiles`
--

CREATE TABLE IF NOT EXISTS `fpt_smiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `path` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- Дамп данных таблицы `fpt_smiles`
--

INSERT INTO `fpt_smiles` (`id`, `code`, `path`) VALUES
(1, ':)', 'images/smiles/face-smile.png'),
(2, ':(', 'images/smiles/face-sad.png'),
(3, ':D', 'images/smiles/face-smile-big.png'),
(4, ';)', 'images/smiles/face-wink.png'),
(5, ':devil:', 'images/smiles/face-devil-grin.png'),
(6, ':monkey:', 'images/smiles/face-monkey.png'),
(7, ':shock:', 'images/smiles/face-surprise.png'),
(8, ':angry:', 'images/smiles/face-angry.png'),
(9, ':sleep:', 'images/smiles/face-asleep.png');