[Sommaire] [Imprimer]

   1  <?php
   2  /*
   3  + ----------------------------------------------------------------------------+
   4  |     e107 website system
   5  |
   6  |     ©Steve Dunstan 2001-2002
   7  |     http://e107.org
   8  |     jalist@e107.org
   9  |
  10  |     Released under the terms and conditions of the
  11  |     GNU General Public License (http://gnu.org).
  12  |
  13  |     $Source: /cvsroot/e107/e107_0.7/e107_plugins/content/content_sql.php,v $
  14  |     $Revision: 1.3 $
  15  |     $Date: 2005/06/26 07:51:02 $
  16  |     $Author: lisa_ $
  17  +----------------------------------------------------------------------------+
  18  */
  19  header("location:../index.php");
  20  exit;
  21  ?>
  22  # Table structure for table `content`
  23  #
  24  
  25  CREATE TABLE pcontent (
  26    content_id int(10) unsigned NOT NULL auto_increment,
  27    content_heading varchar(255) NOT NULL default '',
  28    content_subheading varchar(255) NOT NULL default '',
  29    content_summary text NOT NULL,
  30    content_text longtext NOT NULL,
  31    content_author varchar(255) NOT NULL default '',
  32    content_icon varchar(255) NOT NULL default '',
  33    content_file text NOT NULL,
  34    content_image text NOT NULL,
  35    content_parent varchar(50) NOT NULL default '',
  36    content_comment tinyint(1) unsigned NOT NULL default '0',
  37    content_rate tinyint(1) unsigned NOT NULL default '0',
  38    content_pe tinyint(1) unsigned NOT NULL default '0',
  39    content_refer text NOT NULL,
  40    content_datestamp int(10) unsigned NOT NULL default '0',
  41    content_enddate int(10) unsigned NOT NULL default '0',
  42    content_class varchar(255) NOT NULL default '',
  43    content_pref text NOT NULL, 
  44    content_order varchar(10) NOT NULL default '0',
  45    content_score tinyint(3) unsigned NOT NULL default '0',
  46    content_meta text NOT NULL,
  47    content_layout varchar(255) NOT NULL default '',
  48    PRIMARY KEY  (content_id)
  49  ) TYPE=MyISAM;
  50  # --------------------------------------------------------
  51