관리-도구

편집 파일: easyp.sql

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 */;

--
-- Database: `easyp1`
--

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

--
-- Table structure for table `easypoll`
--

CREATE TABLE `easypoll` (
  `number` mediumint(9) NOT NULL auto_increment,
  `question` varchar(200) NOT NULL default '',
  `a1` varchar(100) NOT NULL default '',
  `a2` varchar(100) NOT NULL default '',
  `a3` varchar(100) NOT NULL default '',
  `a4` varchar(100) NOT NULL default '',
  `a5` varchar(100) NOT NULL default '',
  `n1` mediumint(8) unsigned NOT NULL default '0',
  `n2` mediumint(8) unsigned NOT NULL default '0',
  `n3` mediumint(8) unsigned NOT NULL default '0',
  `n4` mediumint(8) unsigned NOT NULL default '0',
  `n5` mediumint(8) unsigned NOT NULL default '0',
  `p1` tinyint(3) unsigned NOT NULL default '0',
  `p2` tinyint(3) unsigned NOT NULL default '0',
  `p3` tinyint(3) unsigned NOT NULL default '0',
  `p4` tinyint(3) unsigned NOT NULL default '0',
  `p5` tinyint(3) unsigned NOT NULL default '0',
  `votes` smallint(5) unsigned NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '0',
  `time` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`number`)
) 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 */;