tags/0.4.3.1-pre2/sql/004003000.sql

   1 #0.4.3
   2 alter table user
   3   modify column id bigint unsigned not null auto_increment,
   4   drop primary key,
   5   add primary key using btree (id),
   6   drop key nick,
   7   add key nick using hash (nick),
   8   drop key ip,
   9   add key using btree (ip);
  10
  11 # Duplicate key given PRIMARY already indexes this column first.
  12 ALTER TABLE `nickalias` DROP KEY `root`;
  13
  14 # Duplicate keys given PRIMARY already indexes this column first.
  15 ALTER TABLE `akick` DROP INDEX `chan`;
  16 ALTER TABLE `silence` DROP KEY `nick`;
  17 ALTER TABLE `nickid` DROP INDEX `id`, ADD KEY `nrid` (`nrid`);
  18 ALTER TABLE `watch` DROP KEY `nick`;
  19
  20 # merged into above 'alter table user'
  21 #ALTER TABLE `user` MODIFY `id` bigint unsigned NOT NULL auto_increment;
  22 DROP TABLE `srsv_schema`;
  23 CREATE table `srsv_schema` (
  24         `ver` int unsigned NOT NULL,
  25         `singleton` int unsigned default 0,
  26         PRIMARY KEY (`singleton`)
  27 ) ENGINE=MyISAM;
  28 REPLACE INTO `srsv_schema` (`ver`) VALUES (4003000);