ALTER TABLE `webtyps`
ADD `tmpPics` tinyint unsigned NOT NULL AFTER `TypResume`,
ADD `tmpPExt` varchar(12) COLLATE ''utf8_general_ci'' NULL AFTER `tmpPics`,
ADD `tmpList` varchar(12) COLLATE ''utf8_general_ci'' NOT NULL AFTER `tmpPExt`,
ADD `tmpLink` varchar(12) COLLATE ''utf8_general_ci'' NOT NULL AFTER `tmpList`,
ADD `tmpShow` varchar(12) COLLATE ''utf8_general_ci'' NOT NULL AFTER `tmpLink`,
ADD `tmpRem` varchar(12) COLLATE ''utf8_general_ci'' NULL AFTER `tmpShow`,
ADD `tmpVote` varchar(12) COLLATE ''utf8_general_ci'' NOT NULL AFTER `tmpRem`,
ADD `tmpNext` varchar(12) COLLATE ''utf8_general_ci'' NULL AFTER `tmpVote`,
COMMENT=''''
REMOVE PARTITIONING;
ALTER TABLE `admsyst`
ADD `tmpPics` tinyint unsigned NOT NULL AFTER `SysNEng`,
ADD `tmpPExt` varchar(12) COLLATE ''utf8_general_ci'' NULL AFTER `tmpPics`,
ADD `tmpList` varchar(12) COLLATE ''utf8_general_ci'' NOT NULL AFTER `tmpPExt`,
ADD `tmpLink` varchar(12) COLLATE ''utf8_general_ci'' NOT NULL AFTER `tmpList`,
ADD `tmpShow` varchar(12) COLLATE ''utf8_general_ci'' NOT NULL AFTER `tmpLink`,
ADD `tmpRem` varchar(12) COLLATE ''utf8_general_ci'' NULL AFTER `tmpShow`,
ADD `tmpVote` varchar(12) COLLATE ''utf8_general_ci'' NOT NULL AFTER `tmpRem`,
ADD `tmpNext` varchar(12) COLLATE ''utf8_general_ci'' NULL AFTER `tmpVote`,
COMMENT=''''
REMOVE PARTITIONING;