[Sommaire] [Imprimer]

   1  CREATE TABLE private_msg (
   2    pm_id int(10) unsigned NOT NULL auto_increment,
   3    pm_from int(10) unsigned NOT NULL default '0',
   4    pm_to varchar(250) NOT NULL default '',
   5    pm_sent int(10) unsigned NOT NULL default '0',
   6    pm_read int(10) unsigned NOT NULL default '0',
   7    pm_subject text NOT NULL,
   8    pm_text text NOT NULL,
   9    pm_sent_del tinyint(1) unsigned NOT NULL default '0',
  10    pm_read_del tinyint(1) unsigned NOT NULL default '0',
  11    pm_attachments text NOT NULL,
  12    pm_option varchar(250) NOT NULL default '',
  13    pm_size int(10) unsigned NOT NULL default '0',
  14    PRIMARY KEY  (pm_id)
  15  ) TYPE=MyISAM AUTO_INCREMENT=1 ;
  16  
  17  CREATE TABLE private_msg_block (
  18    pm_block_id int(10) unsigned NOT NULL auto_increment,
  19    pm_block_from int(10) unsigned NOT NULL default '0',
  20    pm_block_to int(10) unsigned NOT NULL default '0',
  21    pm_block_datestamp int(10) unsigned NOT NULL default '0',
  22    pm_block_count int(10) unsigned NOT NULL default '0',
  23    PRIMARY KEY  (pm_block_id)
  24  ) TYPE=MyISAM AUTO_INCREMENT=1 ;