data/mysql-ultimate28.sql

   1 DROP TABLE IF EXISTS chan;
   2 DROP TABLE IF EXISTS ison;
   3 DROP TABLE IF EXISTS server;
   4 DROP TABLE IF EXISTS user;
   5 DROP TABLE IF EXISTS maxvalues;
   6
   7 CREATE TABLE chan (
   8   chanid int unsigned NOT NULL auto_increment,
   9   channel varchar(33) binary NOT NULL default '',
  10   topic text,
  11   topicauthor varchar(31) default NULL,
  12   topictime datetime default NULL,
  13   mode_le enum('Y','N') NOT NULL default 'N',
  14   mode_lf enum('Y','N') NOT NULL default 'N',
  15   mode_lh enum('Y','N') NOT NULL default 'N',
  16   mode_li enum('Y','N') NOT NULL default 'N',
  17   mode_lk enum('Y','N') NOT NULL default 'N',
  18   mode_ll enum('Y','N') NOT NULL default 'N',
  19   mode_lm enum('Y','N') NOT NULL default 'N',
  20   mode_ln enum('Y','N') NOT NULL default 'N',
  21   mode_lp enum('Y','N') NOT NULL default 'N',
  22   mode_lr enum('Y','N') NOT NULL default 'N',
  23   mode_ls enum('Y','N') NOT NULL default 'N',
  24   mode_lt enum('Y','N') NOT NULL default 'N',
  25   mode_lv enum('Y','N') NOT NULL default 'N',
  26   mode_lx enum('Y','N') NOT NULL default 'N',
  27   mode_ua enum('Y','N') NOT NULL default 'N',
  28   mode_ui enum('Y','N') NOT NULL default 'N',
  29   mode_uk enum('Y','N') NOT NULL default 'N',
  30   mode_ul enum('Y','N') NOT NULL default 'N',
  31   mode_uo enum('Y','N') NOT NULL default 'N',
  32   mode_ur enum('Y','N') NOT NULL default 'N',
  33   mode_us enum('Y','N') NOT NULL default 'N',
  34   mode_ll_data int(10) NOT NULL default '0',
  35   mode_lk_data varchar(23) NOT NULL default '',
  36   mode_ul_data varchar(33) NOT NULL default '',
  37   PRIMARY KEY  (chanid),
  38   UNIQUE KEY channel (channel)
  39 ) TYPE=MyISAM;
  40
  41 CREATE TABLE ison (
  42   nickid int unsigned NOT NULL default '0',
  43   chanid int unsigned NOT NULL default '0',
  44   mode_lh enum('Y','N') NOT NULL default 'N',
  45   mode_lo enum('Y','N') NOT NULL default 'N',
  46   mode_lv enum('Y','N') NOT NULL default 'N',
  47   PRIMARY KEY  (nickid,chanid),
  48   KEY nickid (nickid),
  49   KEY chanid (chanid)
  50 ) TYPE=MyISAM;
  51
  52 CREATE TABLE server (
  53   servid int unsigned NOT NULL auto_increment,
  54   server varchar(64) NOT NULL default '',
  55   comment varchar(255) NOT NULL default '',
  56   linkedto int unsigned default NULL,
  57   connecttime datetime default NULL,
  58   online enum('Y','N') NOT NULL DEFAULT 'Y',
  59   lastsplit datetime default NULL,
  60   PRIMARY KEY  (servid),
  61   UNIQUE KEY server (server),
  62   KEY linkedto (linkedto)
  63 ) TYPE=MyISAM;
  64
  65
  66 CREATE TABLE user (
  67   nickid int unsigned NOT NULL auto_increment,
  68   nick varchar(31) NOT NULL default '',
  69   realname varchar(51) NOT NULL default '',
  70   hostname varchar(64) NOT NULL default '',
  71   hiddenhostname varchar(64) NOT NULL default '',
  72   ipaddr varchar(16) NOT NULL default '',
  73   username varchar(11) NOT NULL default '',
  74   connecttime datetime NOT NULL default '0000-00-00 00:00:00',
  75   servid int unsigned NOT NULL default '0',
  76   away enum('Y','N') NOT NULL default 'N',
  77   awaymsg text,
  78   online enum('Y','N') NOT NULL DEFAULT 'Y',
  79   lastquit datetime default NULL,
  80   mode_la enum('Y','N') NOT NULL default 'N',
  81   mode_lb enum('Y','N') NOT NULL default 'N',
  82   mode_lc enum('Y','N') NOT NULL default 'N',
  83   mode_ld enum('Y','N') NOT NULL default 'N',
  84   mode_lf enum('Y','N') NOT NULL default 'N',
  85   mode_lg enum('Y','N') NOT NULL default 'N',
  86   mode_lh enum('Y','N') NOT NULL default 'N',
  87   mode_li enum('Y','N') NOT NULL default 'N',
  88   mode_lk enum('Y','N') NOT NULL default 'N',
  89   mode_lm enum('Y','N') NOT NULL default 'N',
  90   mode_ln enum('Y','N') NOT NULL default 'N',
  91   mode_lo enum('Y','N') NOT NULL default 'N',
  92   mode_lp enum('Y','N') NOT NULL default 'N',
  93   mode_lr enum('Y','N') NOT NULL default 'N',
  94   mode_ls enum('Y','N') NOT NULL default 'N',
  95   mode_lt enum('Y','N') NOT NULL default 'N',
  96   mode_lw enum('Y','N') NOT NULL default 'N',
  97   mode_lx enum('Y','N') NOT NULL default 'N',
  98   mode_lz enum('Y','N') NOT NULL default 'N',
  99   mode_ua enum('Y','N') NOT NULL default 'N',
 100   mode_ub enum('Y','N') NOT NULL default 'N',
 101   mode_uc enum('Y','N') NOT NULL default 'N',
 102   mode_uf enum('Y','N') NOT NULL default 'N',
 103   mode_ug enum('Y','N') NOT NULL default 'N',
 104   mode_um enum('Y','N') NOT NULL default 'N',
 105   mode_un enum('Y','N') NOT NULL default 'N',
 106   mode_uo enum('Y','N') NOT NULL default 'N',
 107   mode_up enum('Y','N') NOT NULL default 'N',
 108   mode_ur enum('Y','N') NOT NULL default 'N',
 109   mode_us enum('Y','N') NOT NULL default 'N',
 110   mode_ut enum('Y','N') NOT NULL default 'N',
 111   mode_uw enum('Y','N') NOT NULL default 'N',
 112   mode_ux enum('Y','N') NOT NULL default 'N',
 113   mode_uz enum('Y','N') NOT NULL default 'N',
 114   PRIMARY KEY  (nickid),
 115   UNIQUE KEY nick (nick),
 116   KEY servid (servid)
 117 ) TYPE=MyISAM;
 118
 119 CREATE TABLE maxvalues (
 120   type varchar(10) NOT NULL default '',
 121   val int unsigned NOT NULL default '0',
 122   time datetime NOT NULL default '0000-00-00 00:00:00',
 123   PRIMARY KEY(type)
 124 ) TYPE=MyISAM;