-- 
-- Table structure for table `yass_image_config`
-- 

CREATE TABLE `yass_image_config` (
  `uid` tinyint(3) unsigned NOT NULL,
  `iid` tinyint(1) NOT NULL,
  `name` char(64) character set utf8 collate utf8_unicode_ci NOT NULL,
  `updated` datetime NOT NULL,
  `bg_colour` char(7) NOT NULL default '#FFFFFF',
  `bg_x` smallint(3) unsigned NOT NULL default '500',
  `bg_y` smallint(3) unsigned NOT NULL default '100',
  `bg_url` smallint(6) NOT NULL default '2',
  `dp` tinyint(1) unsigned NOT NULL default '3',
  `dp_x` smallint(3) unsigned NOT NULL default '14',
  `dp_y` smallint(3) unsigned NOT NULL default '14',
  `statusimg` tinyint(1) NOT NULL default '1',
  `statusimg_x` smallint(3) unsigned NOT NULL default '100',
  `statusimg_y` smallint(3) unsigned NOT NULL default '5',
  `statusimg_online` smallint(6) NOT NULL default '5',
  `statusimg_busy` smallint(6) NOT NULL default '6',
  `statusimg_away` smallint(6) NOT NULL default '7',
  `statusimg_offline` smallint(6) NOT NULL default '8',
  `statustext` tinyint(1) NOT NULL default '1',
  `statustext_trailnick` tinyint(1) NOT NULL default '0',
  `statustext_x` smallint(3) unsigned NOT NULL default '120',
  `statustext_y` smallint(3) unsigned NOT NULL default '18',
  `statustext_font` smallint(6) NOT NULL default '1',
  `statustext_size` tinyint(2) unsigned NOT NULL default '8',
  `statustext_colour` char(7) NOT NULL default '#FFFFFF',
  `nick` tinyint(1) NOT NULL default '1',
  `nick_x` smallint(3) NOT NULL default '100',
  `nick_y` smallint(3) NOT NULL default '39',
  `nick_xmax` smallint(3) unsigned NOT NULL default '395',
  `nick_font` smallint(6) NOT NULL default '1',
  `nick_size` tinyint(2) NOT NULL default '14',
  `nick_colour` char(7) NOT NULL default '#FFFFFF',
  `nick_resize` tinyint(1) NOT NULL default '1',
  `psm` tinyint(1) NOT NULL default '1',
  `psm_x` smallint(3) unsigned NOT NULL default '100',
  `psm_y` smallint(3) unsigned NOT NULL default '60',
  `psm_xmax` smallint(3) unsigned NOT NULL default '395',
  `psm_font` smallint(6) NOT NULL default '1',
  `psm_size` tinyint(2) unsigned NOT NULL default '10',
  `psm_colour` char(7) NOT NULL default '#FFFFFF',
  `psm_mediacolour` char(7) NOT NULL default '#33CCFF',
  `psm_wrap` tinyint(1) NOT NULL default '1',
  `psm_music` smallint(6) NOT NULL default '9',
  `psm_office` smallint(6) NOT NULL default '10',
  `psm_game` smallint(6) NOT NULL default '11',
  `time` tinyint(1) NOT NULL default '1',
  `time_x` smallint(3) unsigned NOT NULL default '330',
  `time_y` smallint(3) unsigned NOT NULL default '95',
  `time_font` smallint(6) NOT NULL default '1',
  `time_size` tinyint(2) unsigned NOT NULL default '7',
  `time_colour` char(7) NOT NULL default '#FFFFFF',
  `time_date` char(20) NOT NULL default 'M j, g:ia',
  `time_headstring` char(20) NOT NULL default 'Updated',
  `time_tailstring` char(20) NOT NULL default ' GMT',
  PRIMARY KEY  (`uid`,`iid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `yass_image_template`
-- 

CREATE TABLE `yass_image_template` (
  `tid` tinyint(3) unsigned NOT NULL auto_increment,
  `name` char(64) character set utf8 collate utf8_unicode_ci NOT NULL,
  `creator` char(64) NOT NULL,
  `bg_colour` char(7) NOT NULL,
  `bg_x` smallint(3) unsigned NOT NULL,
  `bg_y` smallint(3) unsigned NOT NULL,
  `bg_url` smallint(6) NOT NULL,
  `dp` tinyint(1) unsigned NOT NULL,
  `dp_x` smallint(3) NOT NULL,
  `dp_y` smallint(3) NOT NULL,
  `statusimg` tinyint(1) NOT NULL,
  `statusimg_x` smallint(3) unsigned NOT NULL,
  `statusimg_y` smallint(3) unsigned NOT NULL,
  `statusimg_online` smallint(6) NOT NULL,
  `statusimg_busy` smallint(6) NOT NULL,
  `statusimg_away` smallint(6) NOT NULL,
  `statusimg_offline` smallint(6) NOT NULL,
  `statustext` tinyint(1) NOT NULL,
  `statustext_x` smallint(3) unsigned NOT NULL,
  `statustext_y` smallint(3) unsigned NOT NULL,
  `statustext_font` smallint(6) NOT NULL,
  `statustext_size` tinyint(2) unsigned NOT NULL,
  `statustext_colour` char(7) NOT NULL,
  `nick` tinyint(1) NOT NULL,
  `nick_x` smallint(3) NOT NULL,
  `nick_y` smallint(3) NOT NULL,
  `nick_xmax` smallint(3) unsigned NOT NULL,
  `nick_font` smallint(6) NOT NULL,
  `nick_size` tinyint(2) NOT NULL,
  `nick_colour` char(7) NOT NULL,
  `nick_resize` tinyint(1) NOT NULL,
  `psm` tinyint(1) NOT NULL,
  `psm_x` smallint(3) unsigned NOT NULL,
  `psm_y` smallint(3) unsigned NOT NULL,
  `psm_xmax` smallint(3) unsigned NOT NULL,
  `psm_font` smallint(6) NOT NULL,
  `psm_size` tinyint(2) unsigned NOT NULL,
  `psm_colour` char(7) NOT NULL,
  `psm_mediacolour` char(7) NOT NULL,
  `psm_wrap` tinyint(1) NOT NULL,
  `psm_music` smallint(6) NOT NULL,
  `psm_office` smallint(6) NOT NULL,
  `psm_game` smallint(6) NOT NULL,
  `time` tinyint(1) NOT NULL,
  `time_x` smallint(3) unsigned NOT NULL,
  `time_y` smallint(3) unsigned NOT NULL,
  `time_font` smallint(6) NOT NULL,
  `time_size` tinyint(2) unsigned NOT NULL,
  `time_colour` char(7) NOT NULL,
  `time_date` char(20) NOT NULL,
  `time_headstring` char(20) NOT NULL,
  `time_tailstring` char(20) NOT NULL,
  PRIMARY KEY  (`tid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;