NoName Mobile

NoName » Project Parasy » 请问r46里面修改的trunk/sql/parasy.mysql.sql怎么使用?

请问r46里面修改的trunk/sql/parasy.mysql.sql怎么使用?

by elicip at 2008-4-13 12:27

请问r46里面修改的trunk/sql/parasy.mysql.sql怎么使用?
如题,谢谢!

Modified: trunk/sql/parasy.mysql.sql
==============================================================================
--- trunk/sql/parasy.mysql.sql  (original)
+++ trunk/sql/parasy.mysql.sql  Wed Mar 19 07:02:01 2008
@@ -16,6 +16,7 @@
  ALTER TABLE `cdb_members` ADD `idx_cloud` tinyint(1) NOT NULL default '0';
  ALTER TABLE `cdb_members` ADD `usr_geo` varchar(100) NOT NULL default 'earth';
  ALTER TABLE `cdb_members` ADD `side_buddy` TINYINT( 1 ) NOT NULL DEFAULT '0';
+ALTER TABLE `cdb_memberfields` ADD `hits` INT( 10 ) NOT NULL DEFAULT '0';

--
  -- Table structure for table `cdb_savepoint`

似乎idx_cloud等这些字段在r46之前就升级过了阿..

# 1 - Sai at 2008-4-13 13:39

+ALTER TABLE `cdb_memberfields` ADD `hits` INT( 10 ) NOT NULL DEFAULT '0';

注意前面那个小+号

# 2 - elicip at 2008-4-13 13:49

呃...
  ALTER TABLE `cdb_members` ADD `idx_cloud` tinyint(1) NOT NULL default '0';
  ALTER TABLE `cdb_members` ADD `usr_geo` varchar(100) NOT NULL default 'earth';
  ALTER TABLE `cdb_members` ADD `side_buddy` TINYINT( 1 ) NOT NULL DEFAULT '0';
这些是为了方便知道+这一句的位置用的么?

# 3 - Sai at 2008-4-13 14:14

嗯

# 4 - elicip at 2008-4-13 14:17

呵呵,谢谢拉.