[Linpha-cvs] SF.net SVN: linpha: [4894] trunk/linpha2/lib/include/sql/sql.tables.php

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

Revision: 4894
          http://linpha.svn.sourceforge.net/linpha/?rev=4894&view=rev
Author:   bzrudi
Date:     2008-02-25 06:55:38 -0800 (Mon, 25 Feb 2008)

Log Message:
-----------
PGSQL doesn't like boolean (L) operator, so just make it I(1) to get rid of it. Please note that this creates a TINYINT(4) on MySQL and a INT(2) on PG. However we don't need to take care of it anyway. 

Modified Paths:
--------------
    trunk/linpha2/lib/include/sql/sql.tables.php

Modified: trunk/linpha2/lib/include/sql/sql.tables.php
===================================================================
--- trunk/linpha2/lib/include/sql/sql.tables.php	2008-02-22 09:26:52 UTC (rev 4893)
+++ trunk/linpha2/lib/include/sql/sql.tables.php	2008-02-25 14:55:38 UTC (rev 4894)
@@ -102,7 +102,7 @@
         "option_name C(255) NOTNULL DEFAULT '' UNIQUE INDEX, " .
         "option_value C(255) NOTNULL DEFAULT '', " .
         "user_id I DEFAULT 0, " .
-        "override I DEFAULT 0",
+        "override I1 DEFAULT 0",
 
     LIN_PREFIX.'users' => 
         "id I AUTO KEY, " .
@@ -140,11 +140,11 @@
         "time_add I(10) DEFAULT 0, " .
         "time_mod I(10) DEFAULT 0, " .
         "time_exif I(10) DEFAULT 0, " .
-        "rotate I DEFAULT 0, " .
+        "rotate I1 DEFAULT 0, " .
         "stats_numbers I DEFAULT 0, " .
         "stats_views I DEFAULT 0, " .
         "stats_downloads I DEFAULT 0, " .
-        "geodata I DEFAULT 0",
+        "geodata I1 DEFAULT 0",
 
     LIN_PREFIX.'photos_cache' => 
         "id I AUTO KEY, " .
@@ -153,8 +153,8 @@
         "img_height I DEFAULT 0, " .
         "img_quality I DEFAULT 0, " .
         "img_size I DEFAULT 0, " .
-        "is_rotated I DEFAULT 0, " .
-        "has_watermark I DEFAULT 0, " .
+        "is_rotated I1 DEFAULT 0, " .
+        "has_watermark I1 DEFAULT 0, " .
         "time_add I(10) DEFAULT 0, " .
         "time_use I(10) DEFAULT 0, " .
         "time_creating I(10) DEFAULT 0, " .
@@ -170,7 +170,7 @@
         "id I AUTO KEY, " .
         "field_id I DEFAULT 0, " .
         "name C(255) NOTNULL, " .
-        "isprivate L DEFAULT 0",
+        "isprivate I1 DEFAULT 0",
 
     LIN_PREFIX.'meta_exif' => 
         "md5sum C(32) KEY, " .
@@ -358,7 +358,7 @@
     LIN_PREFIX.'meta_comments' => 
         "id I AUTO KEY, " .
         "md5sum C(32) NOTNULL INDEX idx_meco_md5, " .
-        "meta_time I DEFAULT 0, " .
+        "meta_time I(10) DEFAULT 0, " .
         "meta_author C(255) DEFAULT '', " .
         "meta_comment I DEFAULT 0",
 
@@ -369,4 +369,5 @@
         "meta_data C(255) DEFAULT ''",
 );
 
-?>
\ No newline at end of file
+/* vi: set ts=4 sw=4 sts=4 */
+?>


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