deltasql - latest scripts

[Test Module] db update Phil

admin — 2012-05-04 16:26:48

select * from dual ;

[Test Module] db update

admin — 2012-05-01 12:08:33

CREATE TABLE `HPOS_CATTRIBUTE` ( `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `NAME` varchar(60) NOT NULL, `CATTRIBUTE_ID` bigint(20) unsigned NOT NULL DEFAULT '1' COMMENT '¸¸½Úµã', `DISABLED` bit(1) NOT NULL DEFAULT b'0', PRIMARY KEY (`ID`), KEY `fk_commodity_attribute_tb_commodity_attribute_tb1` (`CATTRIBUTE_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ÉÌÆ·ÊôÐÔ±í(ÉÌÆ·¹ÌÓÐµÄÊôÐÔÐÅÏ¢£¬±ÈÈç³¤³Ç¸É°×ÊôÓÚ¾Æ£¬ÊôÓÚºì¾Æ£©';

[Test Module] db update

admin — 2012-03-21 19:48:29

/* test */ -- moved to test module insert into table values (1, 2)

[Test Module] db update

virus — 2012-03-21 09:08:13

-- just a script to test stats UPDATE tbtest SET done=1;

[Test Module] testpgs

admin — 2012-03-20 14:17:38

/* test bytea postgres */ -- moved to test module create table testpgs (text bytea);

[deltasql-module] db update

admin — 2012-03-05 08:46:25

/* Renaming statistics tables. */ alter table tbusagehistory rename tbsyncstats; alter table tbphonetranscript rename tbstats;

[deltasql-module] db update

admin — 2012-03-02 10:45:36

/* Changing structure of stats tables for datetime capabilities */ ALTER TABLE `tbphonetranscript` CHANGE `create_dt` `create_dt` DATETIME NULL DEFAULT NULL; ALTER TABLE `tbusagehistory` CHANGE `update_dt` `update_dt` DATETIME NULL DEFAULT NULL;

[Test Module] db update

admin — 2012-03-01 15:56:24

/* t_players */ CREATE TABLE `°ÁÊÀìáÝ¦ÈË` ( `c_factionname` varchar(255) collate utf8_bin default NULL, `c_faction_level` varchar(255) collate utf8_bin default NULL, `c_familyname` varchar(255) collate utf8_bin default NULL, `c_familylevel` varchar(255) collate utf8_bin default NULL, `c_playername` varchar(255) collate utf8_bin default NULL, `c_level` varchar(255) collate utf8_bin default NULL, `c_userid` varchar(255) collate utf8_bin default NULL, `a` varchar(255) collate utf8_bin default NULL, `b` varchar(255) collate utf8_bin default NULL ) ENGINE=myisam DEFAULT CHARSET=utf8 COLLATE=utf8_bin; insert into `°ÁÊÀìáÝ¦ÈË`(`c_factionname`,`c_faction_level`,`c_familyname`,`c_familylevel`,`c_playername`,`c_level`,`c_userid`,`a`,`b`) values ('c_factionname','c_faction_level','c_familyname','c_familylevel','c_playername','c_level','c_userid','a','b'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','ËÀÍöVIÄ¹±®','40','a765995095','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','¨t¡ïÉñ¡ï¨s','32','ai516919189','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','±ß³ÇÀË×Ó','51','axing0515','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','±óÁÙÌìÏÂ','39','bin1980bin','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','ÎÒÃÇÐ¡Ê±ºò','32','c515290777','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','ÎªÒÁÊØºò','23','caiyong1978','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','¼ÅÄ¯Ò»¸öÈË','28','chenfeng2194','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','©g²¼ÒÂÐ¡½´¨q','38','congjunzi8','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','°®¾²Ð¡Ð¡Öí','39','fubin520530','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','ß±ÉñÐ°±ø','52','fzdsh','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','oÈºÄ§ÂÒÎèo','40','gao123_001','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','ÐýÂÉÖÐµÄôÎôÎ','61','hhf27843182','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','Íû¸ç¹éÀ´','53','kosf','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','©YÝ¦ÈË¨rÖ¸¼ä','28','lanping1988','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','Áú¡ï°ÁÊÀ','54','lg812129cd','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','êª¡ïÉñ','58','liu356389178','1000','-910'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','»¯Éñìá½£','55','liu58016008','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','ºûµûÁ÷ÐÇ½£¤Î','22','lnsyfk87','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','¡ïÐ¦²ÔÌì¡ï','31','lt0913','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','Ð¡Ð¡ÂÀ²¼','41','lxaxh521','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','Ý¦ÈË¡¢ÈðÉÙ','65','lylhome015','200000','-81042'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','³Â¹ÚÏ£Ø¼','34','lzy19920908','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','ÐíÄã±ÊÄ«ÈýÇ§','33','m635659064','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','¶¹¶¹°ü°ü','57','mts24129957','2000','-1803'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','Ô©¼ÒÂ·Õ','45','mzyzdn701608','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','Ð¡��±´','51','pangzhen0916','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','¶£µ±','37','pta77992','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','Ò»±²×ÓÇ¹','32','pta77993','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','ÌìÖ®Àá','41','qq1376859197','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','¶º¡¨¶º','32','qq175625778','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','kak','33','rongzhiqiang','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','ÖÎÁÆÍòËê','30','shao65447','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','×íÎÔ»Æ»è','44','tz156303519','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','×ó°¶¡úÓÒ×ª¡î','43','w419696107','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','ÏûÊ§µÄ³ÐÅµ','41','w479360475','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','©e©nÓ£Ê÷¨t�É','47','wanglin1278','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','À¶Æë¶ù','68','wangqi198331','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','ÒÀ¡¤Áµ','45','wg1399823342','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','ÊÀ½çÖ®áÛ','49','wr13854212','1500','-1500'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','Ôø»¨Ð»Âä','29','xcy1995222','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','@ÌìÏÉÅä@','49','xiaocan521','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','@¶ÓÀ@','46','xiaocan5210','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','·çÄ§ËéÑÀ','53','xiaogou5522','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','Ò¶ÎäØ¼á°','29','yuwei5210','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','Æß¸ç¸ç','37','zgh5444','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','o¶À°ÔÌìÏÂo','36','zhang0008','0','0'),('°ÁÊÀìáÝ¦ÈË','4','Ý¦ÈË¡¢»á¹Ý','3','Õß±ð','47','zxw171299219','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','XxÐ¡»ï¡¢','45','a279422279a','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','»Ã¡ï¾õ','32','a787206577','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','ÁéÎïÓê','41','a877630621','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','µóÂù�e¹«Ö÷','41','abcdef197869','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','ºìs¶¹','39','anansxm6000','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','aslong','35','aslongs','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','°®©±©mÄÑ·Ö.','44','bailu627','1000','-498'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','°ÔÆø£¡Ð¡Ë³','44','bshun123','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','xiao·É','49','cuishuren000','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','¾ÛÏÉØ¼ÅáÔªÇì','41','dalian_jx5','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','Çå·ç³ÎÖ','43','feixiangdu','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','DGGH','40','fjj888119','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','Ð¡»ï¾ÍÊÇµð','46','gwy110','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','´óÄ®¹ÂÓ¥*±ù','41','gyc1351419','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','¹â»ÔÉñ','40','gymshuai','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','¶ÅÑîÅôÔ½','43','jackydxfyl','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','ÐùÔ¯°ÙÕ½','41','jklip1411','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','¨qóìÉí`Ö»ãí','44','kongdefa1990','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','´óÄêÒ¹ÓÄ»ê','40','li8687ke','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','Âþ²½ÉîÀ½','50','lxlei2962','10000','-3100'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','Áè³Ù','48','ouyouyou2599','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','ÄªìáØÐ¡¼ÑØ','48','qq8934165','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','Q´óÏÉ¶ùQ','40','qwe444124777','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','Éî¶È','66','rxh271828','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','ÍùÊÂHÈçÑÌ','46','sht115123','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','¡ÌÔµ','43','sjf1003','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','¶«±±¡î°Ôµ¶','41','smy4467','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','¹Þ×Ó','31','ss460895591','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','°ÔÆø£Þ´Ì¿Í','42','suenjiwei521','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','°ÑÇ®·ÅÏÂ','44','syszyq123','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','Ä§Éñò¿ÓÈ','44','tyxzyy8005','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','º®Ëª','35','ufo8962','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','°ÔÆø£¡·ÉÓð','28','w13845642559','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','°ÔÆø£¡ÒõÑô','47','w139455','1500','-1498'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','¶«·½¿©Â¡ÃÀ¶û','32','w13946193285','1500','-1428'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','£¬Ê¥¶àÃÀÁË','48','w3a4n9g0200','5000','-2550'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','·ÉÏÉ¶ù','39','wang30294216','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','¡ì¶ÊÂ»á¡ì·ã','39','wangchuan88','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','°ÔÆø£¡ºÆ½Ù','18','wbok20006','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','*Ò¹Áé*','33','wgyeling','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','·ïÎè¾ÅÌì','61','wx851219','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','ÀÏÄ¾','39','wxz405090','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','ÁúÇ¹','40','x2115454','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','É±Â¾»úÆ÷','41','x62714','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','¡ó¡óØ¼ÀÚ×Ó¡£','47','ximandula','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','¿ñÕ½deÄ§','49','xuebin527','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','ÐùÔ¯VÕ¶ÎÞ','44','y305971622y','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','Ã»ÎÒdeËÀ','36','yjmr806','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','Ñ×»ÆÉñÁú','57','zhang1976205','3000','-1350'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','°ÔÆø!Ð¡Ìì','64','zi00383','0','0'),('°ÁÊÀìáÝ¦ÈË','4','°ÔÆø||µÛ¹ú','3','ÈÐØ¼Ð¡ÅÖ','40','zxc523608016','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','Ð¡ÑýÅ®ÄÄÀïÅÜ','33','a138979598','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','EseØ¼Æ¤Ð¬','30','a3466812','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','³ÁÄ¬vµØÖ÷','23','a5peace1','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','Å·ÑôÒÔÄÏ','43','a631319722','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','¾ø¤ÎµÛ','41','caohongye','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','¢ÝÐÄ','32','czc735099022','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','¾ÛÏÉØ¼µ¥ÐÛÐÅ','39','dalian_jx3','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','áÝáå¡Ë·ÉÓã','63','daohaosiyij','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','cÎÒ±¾ÉÆÁ¼y','43','daoke1981','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','´ó±¦µÄÐ¡±¦','48','feiaihao','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','ÐÄ-ÔÚÄÄ','53','gu280','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','ÐÄ-¹éºÎ´¦','50','gu280111','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','¨�¨�Éñ¨�¨�','33','kakadebao','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','ÉîÔ¨µÄÎ¢Ð¦','46','liubin800714','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','¹Â¶À½£¶ù','42','ll413637548','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','åÐÒ£¤ÎÇ¿','65','lq530618210','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','Ð¡Ë®Ð¦','45','lxcalx','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','Ë¼ÄÈ','47','ming801011','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','ÓÄ»ê¡¢Äþ²É³¼','60','o0xiaoge0o','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','ÌÙÌïÒÝÐù','22','qaqerqqq12','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','´¦ÄÐ','31','qq1046645206','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','à»à»µÄÆ¯ÁÁ','63','qq380949969','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','ÖÁ×ðÍÀÉñ','64','qq58812346','100000','-104120'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','¶þÀÉÉñËû°Ö','50','qubowei','0','-340'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','¿ñÁú¾ÅÏü','49','snob01','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','vÒ»½£Çã³Çv','40','stephenze221','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','ÂäÒ¶çÍ·×°Á','35','wang62097158','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','ÁúÖ®×Ó¤Î¿¡Îõ','66','wj236439278','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','×Ïð½ÏÉ×Ó','51','wj34371480','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','äìäìÏÉ×Ó','36','wowanjuju','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','¹íÁå','51','x1351445','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','½£Õ¶Ð°ÏÉ','61','xiaozhe123','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','½£ÎÞÐé·¢','49','xlh1986','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','ESC²ÐÕ½','45','xu5365245','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','Ìì³Ú¡ëÏÉ¹Ù','40','zhuzi0222','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','©aËØÑÕ¡¢³Ù¡ã','28','zl443001783','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','×¨ÒµÁé¹Ù','30','zw98776698','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','×¨ÒµÌì¾ý','30','zw98776699','0','0'),('°ÁÊÀìáÝ¦ÈË','4','ïLë�ÊÀ¼Ò','4','°ÙºÏ','31','zy1973911','0','0');

[Test Module] db update

admin — 2012-01-25 10:18:01

/* Another test script to test email notification :-) */ UPDATE test SET qr=3 WHERE id=5;

[Test Module] db update

admin — 2012-01-13 11:11:57

/* Test script to test notification by email */ update test set qr=1 where id=1;

[deltasql-module] db update

admin — 2012-01-12 10:21:59

/* Modifying unique key for table tbparameter */ ALTER TABLE `tbparameter` DROP INDEX `paramtype`; ALTER TABLE `tbparameter` ADD UNIQUE KEY `paramtype` (`paramtype`,`paramname`,`user_id`);

[deltasql-module] db update

admin — 2012-01-05 09:09:20

/* Introducing customizable parameters for each user (user's preferences) */ ALTER TABLE `tbparameter` ADD `user_id` int(11) NULL;

[Test Module] db update

admin — 2011-12-22 10:25:50

/* testing from ken */ CREATE TABLE ken (id number PRIMARY KEY);

[Test Module] db update

admin — 2011-09-15 15:58:05

create table test (id number primary key);

[Test Module] db update

admin — 2011-09-13 14:33:03

/* Initial syncrhonization information for TestProject. */ -- DROP TABLE TBSYNCHRONIZE; CREATE TABLE TBSYNCHRONIZE ( PROJECTNAME VARCHAR2(64) NOT NULL, UPDATE_DT DATE DEFAULT SYSDATE NOT NULL, UPDATE_USER VARCHAR2(64) NULL, UPDATE_TYPE VARCHAR2(32) NULL, VERSIONNR INTEGER NOT NULL, BRANCHNAME VARCHAR2(128) NULL, TAGNAME VARCHAR2(128) NULL, UPDATE_FROMVERSION INTEGER NULL, UPDATE_FROMSOURCE VARCHAR2(128) NULL, DBTYPE VARCHAR2(32) NULL, CONSTRAINT UN_VERSIONNR UNIQUE (VERSIONNR) ); -- this stored procedure verifies that scripts are executed in the correct schema CREATE OR REPLACE PROCEDURE DELTASQL_VERIFY_SCHEMA (versionExt INTEGER, branchnameExt VARCHAR2,projectnameExt VARCHAR2) AS versionV INTEGER; branchnameV VARCHAR2(128); projectnameV VARCHAR2(64); BEGIN SELECT versionnr INTO versionV FROM tbsynchronize WHERE versionnr = (SELECT max(versionnr) FROM tbsynchronize); SELECT branchname INTO branchnameV FROM tbsynchronize WHERE versionnr = (SELECT max(versionnr) FROM tbsynchronize); SELECT projectname INTO projectnameV FROM tbsynchronize WHERE versionnr = (SELECT max(versionnr) FROM tbsynchronize); IF (branchnameV <> branchnameExt) OR (versionV <> versionExt) OR (projectnameV <> projectnameExt) then raise_application_error(-20001, 'This script is for another schema or it was already executed!!!'); end IF; END; / INSERT INTO tbsynchronize (PROJECTNAME, VERSIONNR, BRANCHNAME, UPDATE_USER, UPDATE_TYPE, DBTYPE) VALUES ('TestProject', 202, 'HEAD', 'INTERNAL', 'deltasql-server', 'Oracle'); COMMIT;

[deltasql-module] db update

admin — 2011-09-09 16:39:00

/* Removing fields schemaname and description as they are not used anymore. */ ALTER TABLE `tbsynchronize` DROP `schemaname`; ALTER TABLE `tbusagehistory` DROP `schemaname`; ALTER TABLE `tbsynchronize` DROP `description`; ALTER TABLE `tbusagehistory` DROP `description`;

[deltasql-module] db update

admin — 2011-08-23 09:53:45

/* Adding ip to tbusagehistory to troubleshoot client issues. */ ALTER TABLE `tbusagehistory` ADD `ip` VARCHAR( 32 ) NULL ;

[deltasql-module] db update

admin — 2011-06-03 23:29:39

/* We record on the database the deltasql version, so that we can detect upgrades in source code. */ UPDATE tbsynchronize SET tagname='TAG_deltasql_1.3.7' WHERE versionnr=0;

[deltasql-module] db update

admin — 2011-06-03 21:51:38

/* Added parameter to salt password hashes. */ INSERT INTO `tbparameter` VALUES ('', 'SECURITY', 'PWD_HASH_SALT', 'CHANGEMETOANYRANDOMSTRING');

[deltasql-module] db update

admin — 2011-06-03 15:50:02

/* Adding columns for password encryption (1.3.7) */ ALTER TABLE `tbuser` ADD `encrypted` TINYINT( 1 ) NOT NULL DEFAULT '0', ADD `passwhash` VARCHAR( 40 ) NULL ;