#
# Table structure for table 'myMedia'
#

CREATE TABLE myMedia (
  id int(11) NOT NULL auto_increment,
  pid int(6) unsigned default '0',
  uid int(6) unsigned default '1',
  datesub int(11) unsigned NOT NULL default '1033141070',
  subject varchar(255) default NULL,
  informations text,
  nohtml tinyint(1) unsigned default '0',
  nosmiley tinyint(1) unsigned default '0',
  noxcode tinyint(1) unsigned default '0',
  notitle tinyint(1) unsigned default '0',
  nologo tinyint(1) unsigned default '0',
  nomain tinyint(1) unsigned default '0',
  noblock tinyint(1) unsigned default '0',
  counter int(8) unsigned default '0',
  offline tinyint(1) unsigned default '1',
  media varchar(255) NOT NULL default '',
  media_url varchar(255) NOT NULL default '',
  media_size varchar(10) NOT NULL default '',
  cancomment tinyint(1) unsigned default '1',
  artimage varchar(255) NOT NULL default 'blank.gif',
  groups varchar(255) NOT NULL default '',
  hidden tinyint(1) unsigned default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;