[Linpha-cvs] SF.net SVN: linpha: [4753] trunk/linpha2

[<bz...@us...>]

Revision: 4753
          http://svn.sourceforge.net/linpha/?rev=4753&view=rev
Author:   bzrudi
Date:     2007-07-13 01:47:19 -0700 (Fri, 13 Jul 2007)

Log Message:
-----------
hopefully fixed install issue error MySQL5 on M$

Modified Paths:
--------------
    trunk/linpha2/ChangeLog
    trunk/linpha2/install/sql/sql.mysql.php

Modified: trunk/linpha2/ChangeLog
===================================================================
--- trunk/linpha2/ChangeLog	2007-07-13 08:31:36 UTC (rev 4752)
+++ trunk/linpha2/ChangeLog	2007-07-13 08:47:19 UTC (rev 4753)
@@ -1,7 +1,7 @@
 2007-07-13 bzrudi
  * Make installer really abort when detecting serious problem. No longer 
    support "Continue at own risk", as it make absolutely no sense.
- * 
+ * Hopefully fixed some install issues on MySQL windows (strict mode)
  
 2007-07-12 bzrudi
  * Rewrite linGetImageSize() to make videos and other filetypes like pdf 

Modified: trunk/linpha2/install/sql/sql.mysql.php
===================================================================
--- trunk/linpha2/install/sql/sql.mysql.php	2007-07-13 08:31:36 UTC (rev 4752)
+++ trunk/linpha2/install/sql/sql.mysql.php	2007-07-13 08:47:19 UTC (rev 4753)
@@ -36,8 +36,8 @@
 		"password VARCHAR(32) NOT NULL default '' , " .
 		"user_email VARCHAR(255) NOT NULL default '' , " .
 		"display_name VARCHAR(255) NOT NULL default '' , " .
-		"stats_downloads INT NOT NULL , " .
-		"stats_downloads_size INT NOT NULL, " .
+		"stats_downloads INT default '0', " .
+		"stats_downloads_size INT default '0', " .
 		"PRIMARY KEY (id) " .
 	")",
 	"CREATE TABLE ".$linpha_tables['groups']." ( ".
@@ -47,8 +47,8 @@
 	")",
 	"CREATE TABLE ".$linpha_tables['user_group']." ( ".
 		"id INT NOT NULL AUTO_INCREMENT, " .
-		"group_id INT NOT NULL, " .
-		"user_id INT NOT NULL, " .
+		"group_id INT NOT NULL default '0', " .
+		"user_id INT NOT NULL default '0', " .
 		"PRIMARY KEY (id) " .
 	")",
 	"CREATE TABLE ".$linpha_tables['permissions']." ( ".
@@ -62,7 +62,7 @@
 		"id INT NOT NULL AUTO_INCREMENT, " .
 		"parent_id INT NOT NULL default '0', " .
 		"img_type INT NOT NULL default '0', " .
-		"name VARCHAR(255) NOT NULL, " .
+		"name VARCHAR(255) NOT NULL default '', " .
 		"md5sum VARCHAR(32) NOT NULL default '', " .
 		"width INT NOT NULL default '0', " .
 		"height INT NOT NULL default '0', " .


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.