Просмотр архива FPORTAL


--
-- Структура таблицы `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');