[Summary view] [Print] [Text view]

   1  DROP TABLE IF EXISTS `node`;
   2  CREATE TABLE `node` (
   3    `id` int(11) NOT NULL auto_increment,
   4    `root_id` int(11) NOT NULL default '0',
   5    `parent_id` int(11) NOT NULL default '0',
   6    `priority` int(11) NOT NULL default '0',
   7    `level` int(11) NOT NULL default '0',
   8    `identifier` varchar(128) NOT NULL default '',
   9    `path` varchar(255) NOT NULL default '',
  10    `children` int(11) NOT NULL default '0',
  11    `title` varchar(255) NOT NULL default '',
  12    `controller_id` int(11) NOT NULL default '0',
  13    `object_class_id` int(11) NULL default '0',
  14    `object_id` int(11) NULL default '0',
  15    `kind` varchar(255) NOT NULL,
  16    PRIMARY KEY  (`id`),
  17    KEY `root_id` (`root_id`),
  18    KEY `level` (`level`),
  19    KEY `rlr` (`root_id`),
  20    KEY `parent_id` (`parent_id`),
  21    KEY `id` (`id`,`parent_id`),
  22    KEY `object_id` (`object_id`)
  23  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  24  
  25  DROP TABLE IF EXISTS `news_item`;
  26  CREATE TABLE `news_item` (
  27   `id` bigint(20) NOT NULL auto_increment,
  28   `annotation` text,
  29   `content` longtext,
  30   `news_date` int(11) default NULL,
  31   `date_start` int(11) default NULL,
  32   `date_end` int(11) default NULL,
  33   `is_featured` tinyint(1) default NULL,
  34   `modify_date` int(11) default NULL,
  35   `is_published` tinyint(1) default NULL,
  36    `node_id` bigint(20) NOT NULL,
  37    `image_id` bigint(20),
  38   PRIMARY KEY  (`id`)
  39  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  40  
  41  DROP TABLE IF EXISTS `poll`;
  42  CREATE TABLE `poll` (
  43    `id` bigint(20) NOT NULL auto_increment,
  44    `date_start` int(11) default NULL,
  45    `date_end` int(11) default NULL,
  46    `question` varchar(255) NOT NULL default '',
  47    `is_published` tinyint(1) default NULL,
  48    PRIMARY KEY  (`id`)
  49  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  50  
  51  DROP TABLE IF EXISTS `poll_answer`;
  52  CREATE TABLE `poll_answer` (
  53   `id` bigint(20) NOT NULL auto_increment,
  54   `count` int(11) NOT NULL default '0',
  55   `title` varchar(50) NOT NULL default '',
  56   `poll_id` bigint(20) NOT NULL,
  57   PRIMARY KEY  (`id`),
  58   KEY `poll_id` (`poll_id`)
  59  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  60  
  61  DROP TABLE IF EXISTS `poll_ip`;
  62  CREATE TABLE `poll_ip` (
  63   `id` bigint(20) NOT NULL auto_increment,
  64   `poll_id` bigint(20) default NULL,
  65   `ip` varchar(15) default NULL,
  66   PRIMARY KEY  (`id`),
  67   KEY `poll_id` (`poll_id`)
  68  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  69  
  70  DROP TABLE IF EXISTS `testing_node_object`;
  71  CREATE TABLE `testing_node_object` (
  72    `id` bigint(20) NOT NULL auto_increment,
  73    `content` varchar(255) NOT NULL default '',
  74    `node_id` bigint(20) NOT NULL,
  75    PRIMARY KEY  (`id`)
  76  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  77  
  78  DROP TABLE IF EXISTS `class_name`;
  79  CREATE TABLE `class_name` (
  80    `id` int(11) NOT NULL auto_increment,
  81    `title` varchar(255) NOT NULL default '',
  82    PRIMARY KEY  (`id`)
  83  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  84  
  85  DROP TABLE IF EXISTS `guestbook`;
  86  CREATE TABLE `guestbook` (
  87   `id` int(11) NOT NULL auto_increment,
  88   `sender` varchar(255) NOT NULL default '',
  89   `sender_email` varchar(255) NOT NULL default '',
  90   `message` text NOT NULL,
  91   `comment` text,
  92   `comment_author` varchar(255) default NULL,
  93   `comment_author_email` varchar(255) default NULL,
  94   `subject` varchar(255) default NULL,
  95   `is_published` tinyint(1) default NULL,
  96   `date_created` int(11) default NULL,
  97   `date_modified` int(11) default NULL,
  98   `sender_ip` varchar(15) default NULL,
  99   PRIMARY KEY  (`id`)
 100  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 101  
 102  DROP TABLE IF EXISTS `file_object`;
 103  CREATE TABLE `file_object` (
 104   `id` int(11) NOT NULL auto_increment,
 105   `file_name` varchar(255) default NULL,
 106   `mime_type` varchar(100) NOT NULL default '',
 107   `size` int(10) unsigned default NULL,
 108   `etag` varchar(32) default NULL,
 109   `uid` varchar(32) default NULL,
 110   `node_id` bigint(20) default NULL,
 111   PRIMARY KEY  (`id`),
 112   KEY `id` (`id`)
 113  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 114  
 115  
 116  DROP TABLE IF EXISTS `image`;
 117  CREATE TABLE `image` (
 118    `id` bigint(20) NOT NULL auto_increment,
 119    `original_id` bigint(20) default NULL,
 120    `thumbnail_id` bigint(20) default NULL,
 121    `icon_id` bigint(20) default NULL,
 122    `node_id` bigint(20) default NULL,
 123    PRIMARY KEY  (`id`),
 124    KEY `node_id` (`node_id`)
 125  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 126  
 127  DROP TABLE IF EXISTS `pump_data`;
 128  CREATE TABLE `pump_data` (
 129    `id` bigint(20) NOT NULL auto_increment,
 130    `old_node_id` bigint(20) NOT NULL,
 131    `new_node_id` bigint(20) NOT NULL,
 132    `old_object_id` bigint(20) NOT NULL,
 133    `new_object_id` bigint(20) NOT NULL,
 134    `info_name` varchar(100) NOT NULL,
 135    PRIMARY KEY  (`id`),
 136    KEY `new_node_id` (`new_node_id`),
 137    KEY `old_object_id` (`old_object_id`),
 138    KEY `old_node_id` (`old_node_id`)
 139  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 140  
 141  DROP TABLE IF EXISTS `document`;
 142  CREATE TABLE `document` (
 143    `id` bigint(20) NOT NULL auto_increment,
 144    `annotation` text,
 145    `content` longtext,
 146    `date_start` int(11) default NULL,
 147    `date_end` int(11) default NULL,
 148    `modify_date` int(11) default NULL,
 149    `date` int(11) default NULL,
 150    `use_annotation_as_intro` tinyint(1) default NULL,
 151    `show_content` tinyint(1) default NULL,
 152    `show_child_annotations` tinyint(1) default NULL,
 153    `show_child_images` tinyint(1) default NULL,
 154    `show_child_dates` tinyint(1) default NULL,
 155    `is_published` tinyint(1) default '0',
 156    `node_id` bigint(20) default NULL,
 157    `image_id` bigint(20) default NULL,
 158    `locale` varchar(2) default 'ru',
 159    PRIMARY KEY  (`id`),
 160    KEY `node_id` (`node_id`)
 161  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 162  
 163  DROP TABLE IF EXISTS `object_for_testing`;
 164  CREATE TABLE `object_for_testing` (
 165   `id` bigint(20) NOT NULL auto_increment,
 166   `field` varchar(255) default NULL,
 167   `node_id` bigint(20) default NULL,
 168   PRIMARY KEY  (`id`),
 169   KEY `node_id` (`node_id`)
 170  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;