Tadashi Okoshi
slash****@users*****
2006年 5月 29日 (月) 21:08:49 JST
Index: affelio/CHANGES
diff -u affelio/CHANGES:1.35 affelio/CHANGES:1.36
--- affelio/CHANGES:1.35 Fri May 26 12:16:37 2006
+++ affelio/CHANGES Mon May 29 21:08:48 2006
@@ -1,7 +1,26 @@
+2006-0529
+ **** Structure: MyNews and NeighborNews tables
+ DB structuure changed. (MySQL case)
+ In MySQL case, we changed type of "datetime" column in those
+ tables from INTEGER :< to DATETIME. Since MySQL can wisely
+ input 'YYYYMMDDHHMMSS' format string as an input to DATETIME-typed
+ column, our modification in source code has been minimized.
+
+ In Sqlite case, we are still using INTEGER type.
+
+ upgrade.cgi needs to be executed.
+ #CAUTION!!!!!
+ #Implementation in upgrade.cgi has not been completed.
+ #Sorry!!
+
+
2006-0511
Structure:
AFuser_CORE_friends and AFuser_CORE_friendsfriends tables
- are modified.
+ are modified.
+
+ upgrade.cgi needs to be executed.
+
2006-0501
Debug: incoming.cgi and outgoing.cgi didn't handle
Index: affelio/upgrade.cgi
diff -u affelio/upgrade.cgi:1.9 affelio/upgrade.cgi:1.10
--- affelio/upgrade.cgi:1.9 Fri May 26 12:16:37 2006
+++ affelio/upgrade.cgi Mon May 29 21:08:48 2006
@@ -282,6 +282,19 @@
add_column($af, 'AFuser_CORE_friendsfriends', 'type', "TEXT", "'Personal'");
add_column($af, 'AFuser_CORE_friendsfriends', 'flag', "TEXT", "NULL");
+ ################################
+ #Change AFuser_CORE_my_news.datetime from INTEGER to LONG
+ ################################
+ #TBD
+ #TBD
+ #TBD
+
+ ################################
+ #Change AFuser_CORE_nhgr_news.datetime from INTEGER to LONG
+ ################################
+ #TBD
+ #TBD
+ #TBD
################################
print "Done.<BR>";