gamecenter应用新建表
gamecenter应用新建表


insert into app_category(category_name) values("网页游戏");
update app_category set category_name = "下载类游戏" where id = 1 ;

insert into app_page(page_name,company,introduction,web_logo_url,wap_logo_url,web_snapshot,wap_snapshot,keyword,display_order,status,source,source_url,add_time) values( "植物大战僵尸","POPCAP","由宝开（PopCap Games）开发的一款社交类休闲游戏。 相对于单机版而言，社区版拥有更变态的竞技玩法，更有趣的僵尸，更多样的道具！当然，还可以让你和好友并肩作战！","www.renren.com/icon.png","http://wap.renren.com/icon.png","由宝开（PopCap Games）开发的一款社交类休闲游戏。","由宝开（PopCap Games）开发的一款社交类休闲游戏。","僵尸","1","0","来源","http://source.url.com","2011-07-11 14:45:23");

insert into app_page(page_name,company,introduction,web_logo_url,wap_logo_url,web_snapshot,wap_snapshot,keyword,display_order,status,source,source_url,add_time) values( "愤怒的小鸟","POPCAP","由宝开（PopCap Games）开发的一款社交类休闲游戏。 相对于单机版而言，社区版拥有更变态的竞技玩法，更有趣的小鸟，更多样的道具！当然，还可以让你和好友并肩作战！","www.renren.com/icon.png","http://wap.renren.com/icon.png","由宝开（PopCap Games）开发的一款社交类休闲游戏。","由宝开（PopCap Games）开发的一款社交类休闲游戏。","小鸟","1","0","来源","http://source.url.com","2011-07-11 15:23:23");
insert into app_page(page_name,company,introduction,web_logo_url,wap_logo_url,web_snapshot,wap_snapshot,keyword,display_order,status,source,source_url,add_time) values( "fruit ninja","POPCAP","由宝开（PopCap Games）开发的一款社交类休闲游戏。 相对于单机版而言，社区版拥有更变态的竞技玩法，更有趣的水果，更多样的道具！当然，还可以让你和好友并肩作战！","www.renren.com/icon.png","http://wap.renren.com/icon.png","由宝开（PopCap Games）开发的一款社交类休闲游戏。","由宝开（PopCap Games）开发的一款社交类休闲游戏。","切水果","1","0","来源","http://source.url.com","2011-07-11 15:26:23");
         
delete from app_page;
删除头2条，id编号从3开始

truncate table app_page;
truncate table app_category_relation;
truncate table app_page_support;
truncate table app_page_relation;
//这样不但将数据全部删除，而且重新定位自增的字段

insert into app_category_relation(app_page_id,category_id,category_name) values(1,1,"下载类游戏");
insert into app_category_relation(app_page_id,category_id,category_name) values(2,2,"下载类应用");
insert into app_category_relation(app_page_id,category_id,category_name) values(3,1,"网页游戏");
------------------------------------------------

DELIMITER $$

DROP PROCEDURE IF EXISTS `fuxi`.`test3_insert`$$

CREATE DEFINER=``@`` PROCEDURE `test3_insert`()
BEGIN
DECLARE i INT DEFAULT 1;

WHILE i<=1000 DO

insert into app_category_relation(app_page_id,category_id,category_name) values(i,1,"下载类游戏");
SET i=i+1;
insert into app_category_relation(app_page_id,category_id,category_name) values(i,2,"下载类应用");
SET i=i+1;
insert into app_category_relation(app_page_id,category_id,category_name) values(i,3,"网页游戏");
SET i=i+1;
insert into app_category_relation(app_page_id,category_id,category_name) values(i,4,"策略");
SET i=i+1;
insert into app_category_relation(app_page_id,category_id,category_name) values(i,5,"益智");
SET i=i+1;
insert into app_category_relation(app_page_id,category_id,category_name) values(i,6,"棋牌");
SET i=i+1;
insert into app_category_relation(app_page_id,category_id,category_name) values(i,7,"射击");
SET i=i+1;
insert into app_category_relation(app_page_id,category_id,category_name) values(i,8,"RPG");
SET i=i+1;
insert into app_category_relation(app_page_id,category_id,category_name) values(i,9,"DOTA");

SET i=i+1;

END WHILE ;
    END$$

DELIMITER ;

------------------------

select * from app_category_relation where category_id = 3

alter table app_page_support change column app_type download_type int;

insert into app_page_support(app_page_id,os,os_version,app_size,download_type,wap_download_url,web_download_url,build_version,release_version,release_note,release_time,app_called) values( "1","0","Iphone","2048kb","1","http://wap.download.com/test.pxl","www.download.com/test.pxl","test v1.0.1","test v1.5.5","注意事项","2011-07-11 15:08:08","appCalled");
insert into app_