Просмотр файла f2.sql

--
-- Database: `f2_table`
--

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

--
-- Table structure for table `ftwo_action_cat`
--

CREATE TABLE IF NOT EXISTS `ftwo_action_cat` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `ftwo_announcement`
--

CREATE TABLE IF NOT EXISTS `ftwo_announcement` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `idc` int(15) NOT NULL,
  `ida` tinyint(1) NOT NULL DEFAULT '4',
  `subj` varchar(250) COLLATE utf8_bin NOT NULL,
  `text` text COLLATE utf8_bin NOT NULL,
  `time_add` int(15) NOT NULL,
  `city` varchar(250) COLLATE utf8_bin NOT NULL,
  `email` varchar(250) COLLATE utf8_bin NOT NULL,
  `phone` varchar(30) COLLATE utf8_bin NOT NULL,
  `url` varchar(250) COLLATE utf8_bin NOT NULL,
  `view` tinyint(1) NOT NULL,
  `ip` varchar(15) COLLATE utf8_bin NOT NULL,
  `browser` varchar(250) COLLATE utf8_bin NOT NULL,
  `paid` tinyint(1) NOT NULL,
  `admin_view` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `ftwo_antispam`
--

CREATE TABLE IF NOT EXISTS `ftwo_antispam` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `ip` varchar(15) COLLATE utf8_bin NOT NULL,
  `time` int(15) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `ftwo_category`
--

CREATE TABLE IF NOT EXISTS `ftwo_category` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) COLLATE utf8_bin NOT NULL,
  `about` text COLLATE utf8_bin NOT NULL,
  `num_ann` varchar(50) COLLATE utf8_bin NOT NULL,
  `view_act` varchar(50) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;