dbnumrows(dbquery("SHOW INDEX FROM ".TABLEPREFIX."fanfiction_inseries WHERE Key_name = 'seriesid'"));
dbquery("alter table ".TABLEPREFIX."fanfiction_inseries drop index seriesid;");

dbnumrows(dbquery("SHOW INDEX FROM ".TABLEPREFIX."fanfiction_inseries WHERE Key_name = 'inorder'"));
dbquery("alter table ".TABLEPREFIX."fanfiction_inseries drop index inorder;");
dbquery("alter table ".TABLEPREFIX."fanfiction_inseries add index (seriesid,inorder);");

dbnumrows(dbquery("SHOW INDEX FROM ".TABLEPREFIX."fanfiction_inseries WHERE Key_name = 'sid'"));
dbquery("alter table ".TABLEPREFIX."fanfiction_inseries drop index sid;");

dbnumrows(dbquery("SHOW INDEX FROM ".TABLEPREFIX."fanfiction_inseries WHERE Key_name = 'PRIMARY'"));
dbquery("alter table ".TABLEPREFIX."fanfiction_inseries drop primary key");
dbquery("alter ignore table ".TABLEPREFIX."fanfiction_inseries add primary key (sid,seriesid,subseriesid);");



SHOW INDEX FROM [tableprefix]_fanfiction_inseries WHERE Key_name = 'seriesid';
alter table [tableprefix]_fanfiction_inseries drop index seriesid;

SHOW INDEX FROM [tableprefix]_fanfiction_inseries WHERE Key_name = 'inorder';
alter table [tableprefix]_fanfiction_inseries drop index inorder;
alter table [tableprefix]_fanfiction_inseries add index (seriesid,inorder);

SHOW INDEX FROM [tableprefix]_fanfiction_inseries WHERE Key_name = 'sid';
alter table [tableprefix]_fanfiction_inseries drop index sid;

SHOW INDEX FROM [tableprefix]_fanfiction_inseries WHERE Key_name = 'PRIMARY';
alter table [tableprefix]_fanfiction_inseries drop primary key;
alter ignore table [tableprefix]_fanfiction_inseries add primary key (sid,seriesid,subseriesid);



SELECT * FROM [tableprefix]_fanfiction_inseries WHERE 'seriesid';
alter table [tableprefix]_fanfiction_inseries drop index seriesid;

SELECT * FROM [tableprefix]_fanfiction_inseries WHERE 'sid';
alter table [tableprefix]_fanfiction_inseries drop index sid;

SELECT * FROM [tableprefix]_fanfiction_inseries WHERE 'inorder';
alter table [tableprefix]_fanfiction_inseries drop index inorder;

SELECT * FROM [tableprefix]_fanfiction_inseries WHERE 'subseriesid';
alter table [tableprefix]_fanfiction_inseries add index (seriesid,inorder);

SELECT * FROM [tableprefix]_fanfiction_inseries WHERE 'confirmed';

SELECT * FROM [tableprefix]_fanfiction_inseries WHERE 'PRIMARY';
alter table [tableprefix]_fanfiction_inseries drop primary key;
alter ignore table [tableprefix]_fanfiction_inseries add primary key (sid,seriesid,subseriesid);