summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--database/database.mysql23
-rw-r--r--update.php8
2 files changed, 8 insertions, 23 deletions
diff --git a/database/database.mysql b/database/database.mysql
index 2e96cda1e..2adcf53be 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -202,7 +202,7 @@ CREATE TABLE item (
# Table structure for table 'layout'
#
CREATE TABLE layout (
- user int(11) DEFAULT '0' NOT NULL,
+ uid int(11) DEFAULT '0' NOT NULL,
block varchar(64) DEFAULT '' NOT NULL
) TYPE=MyISAM;
@@ -317,25 +317,6 @@ CREATE TABLE poll_choices (
) TYPE=MyISAM;
#
-# Table structure for table 'project'
-#
-
-CREATE TABLE project (
- nid int(10) unsigned NOT NULL default '0',
- pid int(10) unsigned NOT NULL default '0',
- pstatus tinyint(2) NOT NULL default '0',
- area varchar(255) NOT NULL default '',
- priority tinyint(2) NOT NULL default '0',
- version varchar(255) NOT NULL default '',
- assigned int(10) unsigned NOT NULL default '0',
- file text,
- ptype varchar(255) NOT NULL default '',
- PRIMARY KEY (nid),
- KEY pid (pid),
- KEY assigned (assigned)
-) TYPE=MyISAM;
-
-#
# Table structure for table 'rating'
#
@@ -421,7 +402,7 @@ CREATE TABLE users (
sid varchar(32) NOT NULL default '',
init varchar(64) default '',
session varchar(32) NOT NULL default '',
- extrafields text,
+ data text,
PRIMARY KEY (uid),
UNIQUE KEY name (name)
) TYPE=MyISAM;
diff --git a/update.php b/update.php
index 90564ea21..b053b0578 100644
--- a/update.php
+++ b/update.php
@@ -44,6 +44,7 @@ $mysql_updates = array(
"2001-12-31" => "update_17",
"2002-01-05" => "update_18",
"2002-01-17" => "update_19",
+ "2002-01-27" => "update_20"
);
// Update functions
@@ -317,6 +318,10 @@ function update_19() {
update_sql("ALTER TABLE users ADD data TEXT;");
}
+function update_20() {
+ update_sql("INSERT INTO blocks SET name='User information', module='user', delta='0', status='2', weight='0', region='1', remove='0', path='';");
+}
+
/*
** System functions
*/
@@ -385,13 +390,12 @@ function update_page() {
}
print "<html><h1>Drupal update</h1>";
+// Security check:
if (user_access(NULL)) {
update_page();
}
else {
print message_access();
}
-
print "</html>";
-
?> \ No newline at end of file