[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/links_page/links_page_sql.php,v $
  14  |     $Revision: 1.3 $
  15  |     $Date: 2005/11/01 19:38:52 $
  16  |     $Author: sweetas $
  17  +----------------------------------------------------------------------------+
  18  */
  19  header("location:../index.php");
  20  exit;
  21  ?>
  22  # Table structure for table `links_page_cat`
  23  #
  24  CREATE TABLE links_page_cat (
  25    link_category_id int(10) unsigned NOT NULL auto_increment,
  26    link_category_name varchar(100) NOT NULL default '',
  27    link_category_description varchar(250) NOT NULL default '',
  28    link_category_icon varchar(100) NOT NULL default '',
  29    link_category_order int(10) unsigned NOT NULL default '0',
  30    link_category_class varchar(100) NOT NULL default '0',
  31    link_category_datestamp int(10) unsigned NOT NULL default '0',
  32    PRIMARY KEY  (link_category_id)
  33  ) TYPE=MyISAM;
  34  # --------------------------------------------------------
  35  
  36  # Table structure for table `links_page`
  37  #
  38  CREATE TABLE links_page (
  39    link_id int(10) unsigned NOT NULL auto_increment,
  40    link_name varchar(100) NOT NULL default '',
  41    link_url varchar(200) NOT NULL default '',
  42    link_description text NOT NULL,
  43    link_button varchar(100) NOT NULL default '',
  44    link_category tinyint(3) unsigned NOT NULL default '0',
  45    link_order int(10) unsigned NOT NULL default '0',
  46    link_refer int(10) unsigned NOT NULL default '0',
  47    link_open tinyint(1) unsigned NOT NULL default '0',
  48    link_class tinyint(3) unsigned NOT NULL default '0',
  49    link_datestamp int(10) unsigned NOT NULL default '0',
  50    link_author varchar(255) NOT NULL default '',
  51    PRIMARY KEY  (link_id)
  52  ) TYPE=MyISAM;
  53  # --------------------------------------------------------