USE [% ncls %];

ALTER TABLE `[% table_prefix %]_nucleus_blog` DROP COLUMN `bsendping`;
ALTER TABLE `[% table_prefix %]_nucleus_blog` DROP INDEX `bnumber`;

ALTER TABLE `[% table_prefix %]_nucleus_comment` DROP INDEX `cnumber`;

ALTER TABLE `[% table_prefix %]_nucleus_item` DROP INDEX `inumber`;

ALTER TABLE `[% table_prefix %]_nucleus_member` CHANGE COLUMN `mname` `mname` varchar(32) NOT NULL default '';
ALTER TABLE `[% table_prefix %]_nucleus_member` DROP INDEX `mname`;
ALTER TABLE `[% table_prefix %]_nucleus_member` ADD UNIQUE `mname` (`mname`);
ALTER TABLE `[% table_prefix %]_nucleus_member` DROP INDEX `mnumber`;

ALTER TABLE `[% table_prefix %]_nucleus_plugin` DROP INDEX `pid`;

ALTER TABLE `[% table_prefix %]_nucleus_skin_desc` DROP INDEX `sdnumber`;
ALTER TABLE `[% table_prefix %]_nucleus_skin_desc` DROP INDEX `sdname`;
ALTER TABLE `[% table_prefix %]_nucleus_skin_desc` ADD UNIQUE `sdname` (`sdname`);

ALTER TABLE `[% table_prefix %]_nucleus_template_desc` DROP INDEX `tdnumber`;

--
-- Table structure for table `[% table_prefix %]_nucleus_plug_securityenforcer`
--

DROP TABLE IF EXISTS `[% table_prefix %]_nucleus_plug_securityenforcer`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `[% table_prefix %]_nucleus_plug_securityenforcer` (
  `login` varchar(255) default NULL,
  `fails` int(11) NOT NULL default '0',
  `lastfail` bigint(20) NOT NULL default '0',
  KEY `login` (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `[% table_prefix %]_nucleus_plug_securityenforcer`
--

LOCK TABLES `[% table_prefix %]_nucleus_plug_securityenforcer` WRITE;
/*!40000 ALTER TABLE `[% table_prefix %]_nucleus_plug_securityenforcer` DISABLE KEYS */;
/*!40000 ALTER TABLE `[% table_prefix %]_nucleus_plug_securityenforcer` ENABLE KEYS */;
UNLOCK TABLES;

