All pastes #2093802 Raw Edit

Untitled

public text v1 · immutable
#2093802 ·published 2011-11-11 13:50 UTC
rendered paste body
DROP TABLE IF EXISTS `new_struct`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `new_struct` (
  `id` int(11) NOT NULL auto_increment,
  `header` text NOT NULL,
  `level` int(11) NOT NULL default '0',
  `parents` text NOT NULL,
  `path` text NOT NULL,
  `has_child` enum('1','0') NOT NULL default '0',
  `hide` enum('0','1') NOT NULL default '0',
  `url` varchar(255) NOT NULL default '',
  `url_name` varchar(255) NOT NULL default '',
  `cut` varchar(255) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `type` varchar(255) NOT NULL default '',
  `sort_type` varchar(255) NOT NULL default '',
  `sort_desc` varchar(255) NOT NULL default '',
  `sort_param` int(11) NOT NULL default '0',
  `last_changed` datetime NOT NULL default '0000-00-00 00:00:00',
  `temporary` enum('1','0') NOT NULL default '0',
  `anons` text NOT NULL,
  `text` text NOT NULL,
  `dat` date NOT NULL default '0000-00-00',
  `dat_tim` datetime NOT NULL default '0000-00-00 00:00:00',
  `pic1` varchar(255) NOT NULL default '',
  `pic` varchar(255) NOT NULL default '',
  `hide1` enum('1','0') NOT NULL default '0',
  `hide2` enum('1','0') NOT NULL default '0',

  `ccut` varchar(255) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `keywords` text NOT NULL,
  `description` text NOT NULL,
  `header1` varchar(255) NOT NULL default '',
  `per_page` varchar(255) NOT NULL default '',
  `ccut1` varchar(255) NOT NULL default '',
  `c_header1` varchar(255) NOT NULL default '',
  `c_header2` varchar(255) NOT NULL default '',
  `c_header3` varchar(255) NOT NULL default '',
  `c_pic1` varchar(255) NOT NULL default '',
  `b_type1` varchar(255) NOT NULL default 'type8',
  `b_type2` varchar(255) NOT NULL default 'type8',
  `b_type3` varchar(255) NOT NULL default 'type8',
  `b_type4` varchar(255) NOT NULL default 'type8',
  `b_header1` varchar(255) NOT NULL default '',
  `b_header2` varchar(255) NOT NULL default '',
  `b_header3` varchar(255) NOT NULL default '',
  `b_header4` varchar(255) NOT NULL default '',
  `b_text1` text NOT NULL,
  `b_text2` text NOT NULL,
  `b_text3` text NOT NULL,
  `b_text4` text NOT NULL,
  `b_cut1` varchar(255) NOT NULL default '',
  `b_cut2` varchar(255) NOT NULL default '',
  `b_cut3` varchar(255) NOT NULL default '',
  `b_cut4` varchar(255) NOT NULL default '',
  `b_count1` varchar(255) NOT NULL default '',
  `b_count2` varchar(255) NOT NULL default '',
  `b_count3` varchar(255) NOT NULL default '',
  `b_count4` varchar(255) NOT NULL default '',
  `per_page1` varchar(255) NOT NULL default '',
  `text1` text NOT NULL,
  `c_cut1` varchar(255) NOT NULL default '',
  `scripts` text NOT NULL,
  `c_header4` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1302 DEFAULT CHARSET=cp1251;
SET character_set_client = @saved_cs_client;