[Summary view] [Print] [Text view]

   1  DROP TABLE IF EXISTS `class_name`;
   2  CREATE TABLE `class_name` (
   3    `id` int(11) NOT NULL auto_increment,
   4    `title` varchar(255) character set utf8 collate utf8_bin default NULL,
   5    PRIMARY KEY  (`id`)
   6  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
   7  DROP TABLE IF EXISTS `document`;
   8  CREATE TABLE `document` (
   9    `id` bigint(20) NOT NULL auto_increment,
  10    `annotation` text,
  11    `content` longtext,
  12    `is_published` tinyint(1) default '0',
  13    `node_id` bigint(20) default NULL,
  14    PRIMARY KEY  (`id`),
  15    KEY `node_id` (`node_id`),
  16    KEY `actual_docs` (`is_published`)
  17  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  18  DROP TABLE IF EXISTS `file_object`;
  19  CREATE TABLE `file_object` (
  20    `id` int(11) NOT NULL auto_increment,
  21    `file_name` varchar(255) default NULL,
  22    `mime_type` varchar(100) NOT NULL default '',
  23    `size` int(10) unsigned default NULL,
  24    `etag` varchar(32) default NULL,
  25    `uid` varchar(32) default NULL,
  26    `node_id` bigint(20) default NULL,
  27    PRIMARY KEY  (`id`),
  28    KEY `id` (`id`)
  29  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  30  DROP TABLE IF EXISTS `image`;
  31  CREATE TABLE `image` (
  32    `id` bigint(20) NOT NULL auto_increment,
  33    `original_id` bigint(20) default NULL,
  34    `thumbnail_id` bigint(20) default NULL,
  35    `icon_id` bigint(20) default NULL,
  36    `node_id` bigint(20) default NULL,
  37    PRIMARY KEY  (`id`),
  38    KEY `node_id` (`node_id`)
  39  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  40  DROP TABLE IF EXISTS `news_item`;
  41  CREATE TABLE `news_item` (
  42    `id` bigint(20) NOT NULL auto_increment,
  43    `annotation` text,
  44    `content` longtext,
  45    `image_id` bigint(20) default NULL,
  46    `news_date` int(11) default NULL,
  47    PRIMARY KEY  (`id`)
  48  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  49  DROP TABLE IF EXISTS `node`;
  50  CREATE TABLE `node` (
  51    `id` int(11) NOT NULL auto_increment,
  52    `root_id` int(11) NOT NULL default '0',
  53    `parent_id` int(11) NOT NULL default '0',
  54    `priority` int(11) NOT NULL default '0',
  55    `level` int(11) NOT NULL default '0',
  56    `identifier` varchar(128) NOT NULL default '',
  57    `path` varchar(255) NOT NULL default '',
  58    `children` int(11) NOT NULL default '0',
  59    `title` varchar(255) NOT NULL default '',
  60    `controller_id` int(11) NOT NULL default '0',
  61    `object_class_id` int(11) default NULL,
  62    `object_id` bigint(20) default NULL,
  63    `kind` varchar(255) default NULL,
  64    `ultra_id` bigint(20) default NULL,
  65    PRIMARY KEY  (`id`),
  66    KEY `root_id` (`root_id`),
  67    KEY `level` (`level`),
  68    KEY `rlr` (`root_id`),
  69    KEY `parent_id` (`parent_id`),
  70    KEY `id` (`id`,`parent_id`),
  71    KEY `object_id` (`object_id`),
  72    KEY `identifier` (`identifier`,`level`),
  73    KEY `ultra_id` (`ultra_id`)
  74  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;