Changeset 360

Timestamp:

05/22/06 13:06:21 (3 years ago)

Author:

sven

Message:

homogenising/shortening the access field in various tables

Files:

• devel/lib/db/mysql.php (modified) (1 diff)
• devel/lib/db/mysql.sql (modified) (6 diffs)
• devel/version.php (modified) (1 diff)

devel/lib/db/mysql.php

@@ -283 +283 @@
-    }
-
+    if ($oldversion < 2006052200) {
+        // homogenise access field, shortest one was vc16, longest vc255
+        execute_sql("ALTER TABLE `{$CFG->prefix}file_folders` CHANGE `access` `access` VARCHAR(20) NOT NULL DEFAULT 'PUBLIC' ;",false);
+        execute_sql("ALTER TABLE `{$CFG->prefix}files` CHANGE `access` `access` VARCHAR(20) NOT NULL DEFAULT 'PUBLIC' ;",false);
+        execute_sql("ALTER TABLE `{$CFG->prefix}groups` CHANGE `access` `access` VARCHAR(20) NOT NULL DEFAULT 'PUBLIC' ;",false);
+        execute_sql("ALTER TABLE `{$CFG->prefix}profile_data` CHANGE `access` `access` VARCHAR(20) NOT NULL DEFAULT 'PUBLIC' ;",false);
+        execute_sql("ALTER TABLE `{$CFG->prefix}tags` CHANGE `access` `access` VARCHAR(20) NOT NULL DEFAULT 'PUBLIC' ;",false);
+        execute_sql("ALTER TABLE `{$CFG->prefix}weblog_posts` CHANGE `access` `access` VARCHAR(20) NOT NULL DEFAULT 'PUBLIC' ;",false);
+    }
+
-    return $result; 
-}

devel/lib/db/mysql.sql

@@ -32 +32 @@
-  `parent` int(11) NOT NULL default '0',
-  `name` varchar(128) NOT NULL default '',
-55) NOT NULL default '
+0) NOT NULL default 'PUBLIC
-  PRIMARY KEY  (`ident`),
-  KEY `files_owner` (`files_owner`),
@@ -71 +71 @@
-  `description` varchar(255) NOT NULL default '',
-  `location` varchar(255) NOT NULL default '',
-55) NOT NULL default '
+0) NOT NULL default 'PUBLIC
-  `size` int(11) NOT NULL default '0',
-  `time_uploaded` int(11) NOT NULL default '0',
@@ -136 +136 @@
-  `owner` int(11) NOT NULL default '0',
-  `name` varchar(128) NOT NULL default '',
-55
+0
-  PRIMARY KEY  (`ident`),
-  KEY `owner` (`owner`,`name`),
@@ -199 +199 @@
-  `ident` int(10) unsigned NOT NULL auto_increment,
-  `owner` int(10) unsigned NOT NULL default '0',
-16) NOT NULL default '0
+20) NOT NULL default 'PUBLIC
-  `name` varchar(255) NOT NULL default '',
-  `value` text NOT NULL,
@@ -217 +217 @@
-  `tagtype` varchar(128) NOT NULL default '',
-  `ref` int(11) NOT NULL default '0',
-128) NOT NULL default '
+20) NOT NULL default 'PUBLIC
-  `owner` int(11) NOT NULL default '0',
-  PRIMARY KEY  (`ident`),
@@ -360 +360 @@
-  `owner` int(11) NOT NULL default '0',
-  `weblog` int(11) NOT NULL default '-1',
-55) NOT NULL default '
+0) NOT NULL default 'PUBLIC
-  `posted` int(11) NOT NULL default '0',
-  `title` text NOT NULL,

devel/version.php

@@ -7 +7 @@
-// whether upgrades should be performed (see lib/db/*.php)
-
-1
+2
-                           //         X  = Elgg Point release (0,1,2...)
-                           //          Y = Interim incrementer