set sTime = (select DATE_FORMAT((select ADDDATE(sTime,1)),'%Y%m%d')); set sName = CONCAT('tbl_resp_',sTime); set uid = CONCAT('idx_id_resp_',sTime); set orderId = CONCAT('idx_order_resp_',sTime);
select count(1) from information_schema.tables where table_name = sName and TABLE_SCHEMA=tchema into @cnt; if @cnt = 0 then
set sqlVar=CONCAT(' create table ',sName, ' ( id varchar(60) NOT NULL, ', ' order varchar(100) NOT NULL, ', ' ads int(10) NOT NULL, ', ' type varchar(60) NOT NULL, ', ' group int(10) NOT NULL, ', ' template int(10) NOT NULL, ', ' banner varchar(100) DEFAULT NULL, ', ' app varchar(100) DEFAULT NULL, ', ' create_time datetime NOT NULL, ', ' key ',uid ,' (uid),', ' key ',orderId ,' (order_id)', ' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ');
set @v_s=sqlVar; prepare stmt from @v_s; EXECUTE stmt; DEALLOCATE PREPARE stmt; end if;
