[Sommaire] [Imprimer]

   1  ALTER TABLE banner CHANGE bid bid smallint(5) unsigned not null auto_increment, change cid cid tinyint(3) unsigned not null, CHANGE imptotal imptotal mediumint(8) unsigned NOT NULL, CHANGE impmade impmade mediumint(8) unsigned NOT NULL, CHANGE clicks clicks mediumint(8) unsigned NOT NULL, ADD htmlbanner tinyint(1) NOT NULL, ADD htmlcode text NOT NULL;
   2  
   3  ALTER TABLE bannerclient CHANGE cid cid smallint(5) unsigned NOT NULL auto_increment;
   4  
   5  ALTER TABLE bannerfinish CHANGE bid bid smallint(5) unsigned NOT NULL auto_increment, CHANGE cid cid smallint(5) unsigned NOT NULL, CHANGE impressions impressions mediumint(8) unsigned NOT NULL, CHANGE clicks clicks mediumint(8) unsigned NOT NULL, CHANGE datestart datestart int(10) unsigned NOT NULL, CHANGE dateend dateend int(10) unsigned NOT NULL;
   6  
   7  ALTER TABLE groups CHANGE groupid groupid smallint(5) unsigned NOT NULL auto_increment, CHANGE description description text NOT NULL, CHANGE type group_type varchar(10) NOT NULL;
   8  
   9  CREATE TABLE group_permission (
  10    gperm_id int(10) unsigned NOT NULL auto_increment,
  11    gperm_groupid smallint(5) unsigned NOT NULL default '0',
  12    gperm_itemid mediumint(8) unsigned NOT NULL default '0',
  13    gperm_modid mediumint(5) unsigned NOT NULL default '0',
  14    gperm_name varchar(50) NOT NULL default '',
  15    PRIMARY KEY  (gperm_id),
  16    KEY groupid (gperm_groupid),
  17    KEY itemid (gperm_itemid),
  18    KEY gperm_modid (gperm_modid,gperm_name(10))
  19  ) TYPE=MyISAM;
  20  
  21  
  22  ALTER TABLE groups_users_link CHANGE groupid groupid smallint(5) unsigned NOT NULL, CHANGE uid uid mediumint(8) unsigned NOT NULL, ADD linkid mediumint(8) unsigned NOT NULL auto_increment PRIMARY KEY FIRST;
  23  
  24  DROP TABLE metafooter ;
  25  
  26  ALTER TABLE modules CHANGE mid mid smallint(5) unsigned NOT NULL auto_increment, CHANGE version version smallint(5) unsigned NOT NULL default '100', CHANGE last_update last_update int(10) unsigned NOT NULL, CHANGE weight weight smallint(3) unsigned NOT NULL, CHANGE isactive isactive tinyint(1) unsigned NOT NULL, CHANGE hasmain hasmain tinyint(1) unsigned NOT NULL, CHANGE hasadmin hasadmin tinyint(1) unsigned NOT NULL, CHANGE hassearch hassearch tinyint(1) unsigned NOT NULL, ADD hasconfig tinyint(1) unsigned NOT NULL, ADD hascomments tinyint(1) unsigned NOT NULL, ADD hasnotification tinyint(1) unsigned NOT NULL default '0';
  27  
  28  ALTER TABLE newblocks CHANGE bid bid mediumint(8) unsigned NOT NULL auto_increment, CHANGE mid mid smallint(5) unsigned NOT NULL, CHANGE func_num func_num tinyint(3) unsigned NOT NULL, DROP position, CHANGE title title VARCHAR(255) NOT NULL, CHANGE side side tinyint(1) unsigned NOT NULL, CHANGE weight weight smallint(5) unsigned NOT NULL, CHANGE visible visible tinyint(1) unsigned NOT NULL, CHANGE isactive isactive tinyint(1) unsigned NOT NULL, ADD template varchar(50) NOT NULL default '', ADD bcachetime int(10) unsigned NOT NULL, ADD last_modified int(10) unsigned NOT NULL, CHANGE type block_type char(1) NOT NULL;
  29  
  30  ALTER TABLE priv_msgs CHANGE msg_id msg_id mediumint(8) unsigned NOT NULL auto_increment, CHANGE from_userid from_userid mediumint(8) unsigned NOT NULL, CHANGE subject subject varchar(255) NOT NULL, CHANGE to_userid to_userid mediumint(8) unsigned NOT NULL, CHANGE msg_time msg_time int(10) unsigned NOT NULL, CHANGE msg_text msg_text  text NOT NULL, CHANGE read_msg read_msg tinyint(1) unsigned NOT NULL;
  31  
  32  ALTER TABLE ranks CHANGE rank_id rank_id smallint(5) unsigned NOT NULL auto_increment, CHANGE rank_min rank_min mediumint(8) unsigned NOT NULL, CHANGE rank_max rank_max mediumint(8) unsigned NOT NULL, CHANGE rank_special rank_special tinyint(1) unsigned NOT NULL;
  33  
  34  DROP TABLE session ;
  35  
  36  CREATE TABLE session (
  37    sess_id varchar(32) NOT NULL default '',
  38    sess_updated int(10) unsigned NOT NULL default '0',
  39    sess_ip varchar(15) NOT NULL default '',
  40    sess_data text NOT NULL,
  41    PRIMARY KEY  (sess_id),
  42    KEY updated (sess_updated)
  43  ) TYPE=MyISAM;
  44  
  45  ALTER TABLE smiles CHANGE id id smallint(5) unsigned NOT NULL auto_increment, CHANGE code code VARCHAR(50) NOT NULL, CHANGE smile_url smile_url VARCHAR(100) NOT NULL, CHANGE emotion emotion VARCHAR(75) NOT NULL, ADD display tinyint(1) NOT NULL;
  46  
  47  ALTER TABLE stories CHANGE uid uid mediumint(8) unsigned NOT NULL, CHANGE title title VARCHAR(255) NOT NULL, CHANGE created created int(10) unsigned NOT NULL, CHANGE published published int(10) unsigned NOT NULL, CHANGE topicid topicid smallint(5) unsigned NOT NULL, CHANGE type story_type VARCHAR(5) NOT NULL, ADD expired int(10) unsigned NOT NULL, ADD comments smallint(5) unsigned NOT NULL;
  48  
  49  ALTER TABLE users CHANGE uid uid mediumint(8) unsigned NOT NULL auto_increment, CHANGE user_avatar user_avatar VARCHAR(30) NOT NULL default 'blank.gif', CHANGE user_regdate user_regdate int(10) unsigned NOT NULL, CHANGE user_icq user_icq VARCHAR(15) NOT NULL, CHANGE user_from user_from VARCHAR(100) NOT NULL, CHANGE user_sig user_sig tinytext NOT NULL, CHANGE user_viewemail user_viewemail tinyint(1) unsigned NOT NULL, CHANGE actkey actkey VARCHAR(8) NOT NULL, CHANGE user_aim user_aim VARCHAR(18) NOT NULL, CHANGE user_yim user_yim VARCHAR(25) NOT NULL, CHANGE user_msnm user_msnm VARCHAR(100) NOT NULL, CHANGE posts posts mediumint(8) unsigned NOT NULL, CHANGE attachsig attachsig tinyint(1) unsigned NOT NULL, CHANGE rank rank smallint(5) unsigned NOT NULL, CHANGE level level tinyint(3) unsigned NOT NULL default '1', CHANGE last_login last_login int(10) unsigned NOT NULL, CHANGE uorder uorder tinyint(1) unsigned NOT NULL, CHANGE user_occ user_occ VARCHAR(100) NOT NULL, CHANGE user_intrest user_intrest VARCHAR(150) NOT NULL, ADD user_mailok tinyint(1) unsigned NOT NULL default '1', ADD notify_mode tinyint(1) NOT NULL default '0' after uorder, ADD notify_method tinyint(1) NOT NULL default '1' after uorder;
  50  
  51  CREATE TABLE avatar (
  52    avatar_id mediumint(8) unsigned NOT NULL auto_increment,
  53    avatar_file varchar(30) NOT NULL default '',
  54    avatar_name varchar(100) NOT NULL default '',
  55    avatar_mimetype varchar(30) NOT NULL default '',
  56    avatar_created int(10) NOT NULL default '0',
  57    avatar_display tinyint(1) unsigned NOT NULL default '0',
  58    avatar_weight smallint(5) unsigned NOT NULL default '0',
  59    avatar_type char(1) NOT NULL default '',
  60    PRIMARY KEY  (avatar_id),
  61    KEY avatar_type (avatar_type,avatar_display)
  62  ) TYPE=MyISAM;
  63  
  64  
  65  CREATE TABLE avatar_user_link (
  66    avatar_id mediumint(8) unsigned NOT NULL default '0',
  67    user_id mediumint(8) unsigned NOT NULL default '0',
  68    KEY avatar_user_id (avatar_id,user_id)
  69  ) TYPE=MyISAM;
  70  
  71  CREATE TABLE block_module_link (
  72    block_id mediumint(8) unsigned NOT NULL default '0',
  73    module_id smallint(5) NOT NULL default '0',
  74    KEY module_id (module_id),
  75    KEY block_id (block_id)
  76  ) TYPE=MyISAM;
  77  
  78  CREATE TABLE xoopscomments (
  79    com_id mediumint(8) unsigned NOT NULL default '0',
  80    com_pid mediumint(8) unsigned NOT NULL default '0',
  81    com_rootid mediumint(8) unsigned NOT NULL default '0',
  82    com_modid smallint(5) unsigned NOT NULL default '0',
  83    com_itemid mediumint(8) unsigned NOT NULL default '0',
  84    com_icon varchar(25) NOT NULL default '',
  85    com_created int(10) unsigned NOT NULL default '0',
  86    com_modified int(10) unsigned NOT NULL default '0',
  87    com_uid mediumint(8) unsigned NOT NULL default '0',
  88    com_ip varchar(15) NOT NULL default '',
  89    com_title varchar(255) NOT NULL default '',
  90    com_text text NOT NULL,
  91    com_sig tinyint(1) unsigned NOT NULL default '0',
  92    com_status tinyint(1) unsigned NOT NULL default '0',
  93    com_exparams varchar(255) NOT NULL default '',
  94    dohtml tinyint(1) unsigned NOT NULL default '0',
  95    dosmiley tinyint(1) unsigned NOT NULL default '0',
  96    doxcode tinyint(1) unsigned NOT NULL default '0',
  97    doimage tinyint(1) unsigned NOT NULL default '0',
  98    dobr tinyint(1) unsigned NOT NULL default '0',
  99    KEY com_pid (com_pid),
 100    KEY com_itemid (com_itemid),
 101    KEY com_uid (com_uid),
 102    KEY com_title (com_title(40))
 103  ) TYPE=MyISAM;
 104  
 105  
 106  CREATE TABLE config (
 107    conf_id smallint(5) unsigned NOT NULL auto_increment,
 108    conf_modid smallint(5) unsigned NOT NULL default '0',
 109    conf_catid smallint(5) unsigned NOT NULL default '0',
 110    conf_name varchar(25) NOT NULL default '',
 111    conf_title varchar(30) NOT NULL default '',
 112    conf_value text NOT NULL,
 113    conf_desc varchar(30) NOT NULL default '',
 114    conf_formtype varchar(15) NOT NULL default '',
 115    conf_valuetype varchar(10) NOT NULL default '',
 116    conf_order smallint(5) unsigned NOT NULL default '0',
 117    PRIMARY KEY  (conf_id),
 118    KEY conf_mod_cat_id (conf_modid,conf_catid)
 119  ) TYPE=MyISAM;
 120  
 121  
 122  CREATE TABLE configcategory (
 123    confcat_id smallint(5) unsigned NOT NULL auto_increment,
 124    confcat_name varchar(25) NOT NULL default '',
 125    confcat_order smallint(5) unsigned NOT NULL default '0',
 126    PRIMARY KEY  (confcat_id)
 127  ) TYPE=MyISAM;
 128  
 129  
 130  CREATE TABLE configoption (
 131    confop_id mediumint(8) unsigned NOT NULL auto_increment,
 132    confop_name varchar(255) NOT NULL default '',
 133    confop_value varchar(255) NOT NULL default '',
 134    conf_id smallint(5) unsigned NOT NULL default '0',
 135    PRIMARY KEY  (confop_id),
 136    KEY conf_id (conf_id)
 137  ) TYPE=MyISAM;
 138  
 139  CREATE TABLE groups_system_link (
 140    linkid mediumint(8) unsigned NOT NULL auto_increment,
 141    groupid smallint(5) unsigned NOT NULL default '0',
 142    itemid smallint(5) unsigned NOT NULL default '0',
 143    permtype char(1) NOT NULL default '',
 144    PRIMARY KEY  (linkid)
 145  ) TYPE=MyISAM;
 146  
 147  CREATE TABLE image (
 148    image_id mediumint(8) unsigned NOT NULL auto_increment,
 149    image_name varchar(30) NOT NULL default '',
 150    image_nicename varchar(255) NOT NULL default '',
 151    image_mimetype varchar(30) NOT NULL default '',
 152    image_created int(10) unsigned NOT NULL default '0',
 153    image_display tinyint(1) unsigned NOT NULL default '0',
 154    image_weight smallint(5) unsigned NOT NULL default '0',
 155    imgcat_id smallint(5) unsigned NOT NULL default '0',
 156    PRIMARY KEY  (image_id),
 157    KEY imgcat_id (imgcat_id),
 158    KEY image_display (image_display)
 159  ) TYPE=MyISAM;
 160  
 161  CREATE TABLE imagebody (
 162    image_id mediumint(8) unsigned NOT NULL default '0',
 163    image_body mediumblob,
 164    KEY image_id (image_id)
 165  ) TYPE=MyISAM;
 166  
 167  CREATE TABLE imagecategory (
 168    imgcat_id smallint(5) unsigned NOT NULL auto_increment,
 169    imgcat_name varchar(100) NOT NULL default '',
 170    imgcat_maxsize int(8) unsigned NOT NULL default '0',
 171    imgcat_maxwidth smallint(3) unsigned NOT NULL default '0',
 172    imgcat_maxheight smallint(3) unsigned NOT NULL default '0',
 173    imgcat_display tinyint(1) unsigned NOT NULL default '0',
 174    imgcat_weight smallint(3) unsigned NOT NULL default '0',
 175    imgcat_type char(1) NOT NULL default '',
 176    imgcat_storetype varchar(5) NOT NULL default '',
 177    PRIMARY KEY  (imgcat_id),
 178    KEY imgcat_display (imgcat_display)
 179  ) TYPE=MyISAM;
 180  
 181  
 182  CREATE TABLE imgset (
 183    imgset_id smallint(5) unsigned NOT NULL auto_increment,
 184    imgset_name varchar(50) NOT NULL default '',
 185    imgset_refid mediumint(8) unsigned NOT NULL default '0',
 186    PRIMARY KEY  (imgset_id),
 187    KEY imgset_refid (imgset_refid)
 188  ) TYPE=MyISAM;
 189  
 190  CREATE TABLE imgset_tplset_link (
 191    imgset_id smallint(5) unsigned NOT NULL default '0',
 192    tplset_name varchar(50) NOT NULL default '',
 193    KEY tplset_name (tplset_name(10))
 194  ) TYPE=MyISAM;
 195  
 196  
 197  CREATE TABLE imgsetimg (
 198    imgsetimg_id mediumint(8) unsigned NOT NULL auto_increment,
 199    imgsetimg_file varchar(50) NOT NULL default '',
 200    imgsetimg_body blob NOT NULL,
 201    imgsetimg_imgset smallint(5) unsigned NOT NULL default '0',
 202    PRIMARY KEY  (imgsetimg_id),
 203    KEY imgsetimg_imgset (imgsetimg_imgset)
 204  ) TYPE=MyISAM;
 205  
 206  CREATE TABLE online (
 207    online_uid mediumint(8) unsigned NOT NULL default '0',
 208    online_uname varchar(25) NOT NULL default '',
 209    online_updated int(10) unsigned NOT NULL default '0',
 210    online_module smallint(5) unsigned NOT NULL default '0',
 211    online_ip varchar(15) NOT NULL default '',
 212    KEY online_module (online_module)
 213  ) TYPE=MyISAM;
 214  
 215  CREATE TABLE tplset (
 216    tplset_id int(7) unsigned NOT NULL auto_increment,
 217    tplset_name varchar(50) NOT NULL default '',
 218    tplset_desc varchar(255) NOT NULL default '',
 219    tplset_credits text NOT NULL,
 220    tplset_created int(10) unsigned NOT NULL default '0',
 221    PRIMARY KEY  (tplset_id)
 222  ) TYPE=MyISAM;
 223  
 224  
 225  CREATE TABLE tplfile (
 226    tpl_id mediumint(7) unsigned NOT NULL auto_increment,
 227    tpl_refid smallint(5) unsigned NOT NULL default '0',
 228    tpl_module varchar(25) NOT NULL default '',
 229    tpl_tplset varchar(50) NOT NULL default '',
 230    tpl_file varchar(50) NOT NULL default '',
 231    tpl_desc varchar(255) NOT NULL default '',
 232    tpl_lastmodified int(10) unsigned NOT NULL default '0',
 233    tpl_lastimported int(10) unsigned NOT NULL default '0',
 234    tpl_type varchar(20) NOT NULL default '',
 235    PRIMARY KEY  (tpl_id),
 236    KEY tpl_refid (tpl_refid,tpl_type),
 237    KEY tpl_theme (tpl_tplset,tpl_file(10))
 238  ) TYPE=MyISAM;
 239  
 240  
 241  CREATE TABLE tplsource (
 242    tpl_id mediumint(7) unsigned NOT NULL default '0',
 243    tpl_source mediumtext NOT NULL,
 244    KEY tpl_id (tpl_id)
 245  ) TYPE=MyISAM;
 246  
 247  CREATE TABLE xoopsnotifications (
 248    not_id mediumint(8) unsigned NOT NULL auto_increment,
 249    not_modid smallint(5) unsigned NOT NULL default '0',
 250    not_itemid mediumint(8) unsigned NOT NULL default '0',
 251    not_category varchar(30) NOT NULL default '',
 252    not_event varchar(30) NOT NULL default '',
 253    not_uid mediumint(8) unsigned NOT NULL default '0',
 254    not_mode tinyint(1) NOT NULL default 0,
 255    PRIMARY KEY (not_id),
 256    KEY not_modid (not_modid),
 257    KEY not_itemid (not_itemid),
 258    KEY not_class (not_category),
 259    KEY not_uid (not_uid),
 260    KEY not_event (not_event)
 261  ) TYPE=MyISAM;