diff options
| -rw-r--r-- | updates/1.00-to-2.00.mysql | 41 | ||||
| -rw-r--r-- | updates/2.00-to-x.xx.mysql | 342 | ||||
| -rw-r--r-- | updates/3.00-to-x.xx.mysql | 176 | ||||
| -rw-r--r-- | updates/3.00-to-x.xx.php | 88 |
4 files changed, 0 insertions, 647 deletions
diff --git a/updates/1.00-to-2.00.mysql b/updates/1.00-to-2.00.mysql deleted file mode 100644 index dd9bec7aa..000000000 --- a/updates/1.00-to-2.00.mysql +++ /dev/null @@ -1,41 +0,0 @@ -# 03/03/2001: FAQ module -CREATE TABLE faqs ( - id int(11) DEFAULT '0' NOT NULL auto_increment, - question varchar(255) DEFAULT '' NOT NULL, - answer text NOT NULL, - weight tinyint(3) DEFAULT '0' NOT NULL, - UNIQUE question (question), - PRIMARY KEY (id) -); - -# 26/02/2001: performance optimization -ALTER TABLE comments ADD INDEX lid_link (lid, link); - -# 19/02/2001: internationalization / translation -alter table users add language varchar(2) DEFAULT '0' NOT NULL; -CREATE TABLE locales ( - id int(11) DEFAULT '0' NOT NULL auto_increment, - location varchar(128) DEFAULT '' NOT NULL, - string TEXT DEFAULT '' NOT NULL, - en TEXT DEFAULT '' NOT NULL, - PRIMARY KEY (id) -); - -# 18/02/2001: permissions / access / group -alter table users drop permissions; -alter table users add access varchar(255) DEFAULT '' NOT NULL; - -# 07/02/2001: value calculation -alter table users add rating decimal(8,4) DEFAULT '0' NOT NULL; - -# 31/01/2001: block rehashing -alter table blocks add remove tinyint(1) DEFAULT '0' NOT NULL; - -# 21/01/2001: section manager -alter table stories change category section varchar(64) DEFAULT '' NOT NULL; - -# 20/01/2001: comment/discussion code rewrite: -alter table users modify mode tinyint(1) DEFAULT '' NOT NULL; -alter table comments change sid lid int(6) DEFAULT '0' NOT NULL; -alter table comments add link varchar(16) DEFAULT '' NOT NULL; -update comments set link = 'article'; diff --git a/updates/2.00-to-x.xx.mysql b/updates/2.00-to-x.xx.mysql deleted file mode 100644 index 7a58c6a08..000000000 --- a/updates/2.00-to-x.xx.mysql +++ /dev/null @@ -1,342 +0,0 @@ -# 01/04/2001: -CREATE TABLE access ( - id tinyint(10) DEFAULT '0' NOT NULL auto_increment, - mask varchar(255) DEFAULT '' NOT NULL, - reason text NOT NULL, - UNIQUE mask (mask), - PRIMARY KEY (id) -); - -CREATE TABLE book ( - lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - nid int(10) unsigned DEFAULT '0' NOT NULL, - body text NOT NULL, - section int(10) DEFAULT '0' NOT NULL, - parent int(10) DEFAULT '0' NOT NULL, - weight tinyint(3) DEFAULT '0' NOT NULL, - PRIMARY KEY (lid) -); - -CREATE TABLE story ( - lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - nid int(10) unsigned DEFAULT '0' NOT NULL, - abstract text NOT NULL, - body text NOT NULL, - section varchar(64) DEFAULT '' NOT NULL, - PRIMARY KEY (lid) -); - -CREATE TABLE node ( - nid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - lid int(10) DEFAULT '0' NOT NULL, - pid int(10) DEFAULT '0' NOT NULL, - log text NOT NULL, - type varchar(16) DEFAULT '' NOT NULL, - title varchar(128) DEFAULT '' NOT NULL, - score int(11) DEFAULT '0' NOT NULL, - votes int(11) DEFAULT '0' NOT NULL, - author int(6) DEFAULT '0' NOT NULL, - status int(4) DEFAULT '1' NOT NULL, - timestamp int(11) NOT NULL, - KEY type (lid, type), - KEY author (author), - KEY title (title, type), - PRIMARY KEY (nid) -); - -alter table users change stories nodes tinyint(2) DEFAULT '10'; -alter table comments drop link; - -# 07/04/2001: -CREATE TABLE page ( - lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - nid int(10) unsigned DEFAULT '0' NOT NULL, - body text NOT NULL, - format tinyint(2) DEFAULT '0' NOT NULL, - PRIMARY KEY (lid) -); - -CREATE TABLE variable ( - name varchar(32) DEFAULT '' NOT NULL, - value text DEFAULT '' NOT NULL, - PRIMARY KEY (name) -); - -CREATE TABLE rating ( - user int(6) DEFAULT '0' NOT NULL, - new int(6) DEFAULT '0' NOT NULL, - old int(6) DEFAULT '0' NOT NULL, - PRIMARY KEY (user) -); - -CREATE TABLE watchdog ( - id int(5) DEFAULT '0' NOT NULL auto_increment, - user int(6) DEFAULT '0' NOT NULL, - type varchar(16) DEFAULT '' NOT NULL, - link varchar(16) DEFAULT '' NOT NULL, - message varchar(255) DEFAULT '' NOT NULL, - location varchar(128) DEFAULT '' NOT NULL, - hostname varchar(128) DEFAULT '' NOT NULL, - timestamp int(11) DEFAULT '0' NOT NULL, - PRIMARY KEY (id) -); - -ALTER TABLE users CHANGE rating rating decimal(8,2); - -# 14/04/2001: -ALTER TABLE node ADD cid int(10) unsigned DEFAULT '0' NOT NULL; -ALTER TABLE node ADD tid int(10) unsigned DEFAULT '0' NOT NULL; -ALTER TABLE story DROP section; -ALTER TABLE comments ADD KEY(lid); - -CREATE TABLE category ( - cid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - name varchar(32) DEFAULT '' NOT NULL, - type varchar(16) DEFAULT '' NOT NULL, - post int(3) DEFAULT '0' NOT NULL, - dump int(3) DEFAULT '0' NOT NULL, - expire int(3) DEFAULT '0' NOT NULL, - comment int(2) unsigned DEFAULT '0' NOT NULL, - submission int(2) unsigned DEFAULT '0' NOT NULL, - UNIQUE (name), - PRIMARY KEY (cid) -); - -CREATE TABLE topic ( - tid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - pid int(10) unsigned DEFAULT '0' NOT NULL, - name varchar(32) DEFAULT '' NOT NULL, - UNIQUE (name), - PRIMARY KEY (tid) -); - -# 19/04/2001: -ALTER TABLE node ADD comment int(2) DEFAULT '1' NOT NULL; -ALTER TABLE node ADD promote int(2) DEFAULT '1' NOT NULL; -ALTER TABLE category ADD promote int(2) unsigned DEFAULT '0' NOT NULL; - -CREATE TABLE cvs ( - user varchar(32) DEFAULT '' NOT NULL, - files text, - status int(2) DEFAULT '0' NOT NULL, - message text, - timestamp int(11) DEFAULT '0' NOT NULL -); - -# 27/04/2001: -CREATE TABLE forum ( - lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - nid int(10) unsigned DEFAULT '0' NOT NULL, - body text NOT NULL, - PRIMARY KEY (lid) -); - -# 01/05/2001: -ALTER TABLE node ADD moderate TEXT NOT NULL; - -# 10/05/2001: -ALTER TABLE topic ADD moderate TEXT NOT NULL; - -# 16/05/2001 -ALTER TABLE node ADD users TEXT NOT NULL; -ALTER TABLE comments ADD users TEXT NOT NULL; -ALTER TABLE users DROP history; - -# 19/05/2001 -DROP TABLE crons; - -# 25/05/2001 - TEMPORARY - UNDER HEAVY CHANGE - - -CREATE TABLE entry ( - eid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - name varchar(32) DEFAULT '' NOT NULL, - keyword varchar(255) DEFAULT '' NOT NULL, - collection varchar(32) DEFAULT '' NOT NULL, - UNIQUE name (name, collection), - PRIMARY KEY (eid) -); - -CREATE TABLE bundle ( - bid int(11) DEFAULT '0' NOT NULL auto_increment, - title varchar(255) DEFAULT '' NOT NULL, - attribute varchar(255) DEFAULT '' NOT NULL, - UNIQUE (title), - PRIMARY KEY (bid) -); - -CREATE TABLE feed ( - fid int(11) DEFAULT '0' NOT NULL auto_increment, - title varchar(255) DEFAULT '' NOT NULL, - url varchar(255) DEFAULT '' NOT NULL, - link varchar(255) DEFAULT '' NOT NULL, - refresh int(11), - uncache int(11), - timestamp int(11), - attribute varchar(255) DEFAULT '' NOT NULL, - UNIQUE (title), - UNIQUE (link), - PRIMARY KEY (fid) -); - -CREATE TABLE item ( - iid int(11) DEFAULT '0' NOT NULL auto_increment, - fid int(11) DEFAULT '0' NOT NULL, - title varchar(255) DEFAULT '' NOT NULL, - link varchar(255) DEFAULT '' NOT NULL, - author varchar(255) DEFAULT '' NOT NULL, - description TEXT DEFAULT '' NOT NULL, - timestamp int(11), - attribute varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (iid) -); - -# 31/05/01 - -CREATE TABLE poll ( - lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - nid int(10) unsigned DEFAULT '0' NOT NULL, - runtime int(10) DEFAULT '0' NOT NULL, - voters text NOT NULL, - active int(2) unsigned DEFAULT '0' NOT NULL, - PRIMARY KEY (lid) -); - -CREATE TABLE poll_choices ( - chid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - nid int(10) unsigned DEFAULT '0' NOT NULL, - chtext varchar(128) DEFAULT '' NOT NULL, - chvotes int(6) DEFAULT '0' NOT NULL, - chorder int(2) DEFAULT '0' NOT NULL, - PRIMARY KEY (chid) -); - -# 04/06/01 - -ALTER TABLE node ADD timestamp_posted int(11) NOT NULL; -ALTER TABLE node ADD timestamp_queued int(11) NOT NULL; -ALTER TABLE node ADD timestamp_hidden int(11) NOT NULL; -ALTER TABLE node ADD attribute varchar(255) DEFAULT '' NOT NULL; - -# 10/06/01 -ALTER TABLE node DROP cid; -ALTER TABLE node DROP tid; - -# 11/06/01 -UPDATE users SET access = REPLACE(access, ':', '='); -UPDATE users SET access = REPLACE(access, ';', ','); -UPDATE comments SET users = REPLACE(users, ';', ','); -UPDATE comments SET users = REPLACE(users, ':', '='); -UPDATE node SET users = REPLACE(users, ';', ','); -UPDATE node SET users = REPLACE(users, ':', '='); -UPDATE node SET attributes = REPLACE(attributes, ';', ','); -UPDATE node SET attributes = REPLACE(attributes, ':', '='); -UPDATE entry SET attributes = REPLACE(attributes, ';', ','); -UPDATE entry SET attributes = REPLACE(attributes, ':', '='); - -ALTER TABLE entry CHANGE keyword attributes varchar(255) DEFAULT '' NOT NULL; -ALTER TABLE node CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL; -ALTER TABLE bundle CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL; -ALTER TABLE feed CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL; -ALTER TABLE item CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL; - -# 12/06/01 -ALTER TABLE watchdog DROP link; - -# 15/06/01 -CREATE TABLE tag ( - tid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - name varchar(32) DEFAULT '' NOT NULL, - attributes varchar(255) DEFAULT '' NOT NULL, - collections varchar(32) DEFAULT '' NOT NULL, - UNIQUE name (name, collections), - PRIMARY KEY (tid) -); - -CREATE TABLE collection ( - cid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - name varchar(32) DEFAULT '' NOT NULL, - types varchar(128) DEFAULT '' NOT NULL, - UNIQUE name (name), - PRIMARY KEY (cid) -); - -# 17/06/01 -ALTER TABLE book ADD pid int(10) DEFAULT '0' NOT NULL; -ALTER TABLE book ADD log text NOT NULL; -ALTER TABLE node DROP pid; -ALTER TABLE node DROP log; -DROP TABLE headlines; - -# 20/06/01 -CREATE TABLE role ( - rid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - name varchar(32) DEFAULT '' NOT NULL, - perm text DEFAULT '' NOT NULL, - UNIQUE name (name), - PRIMARY KEY (rid) -); - -ALTER TABLE users ADD role varchar(32) DEFAULT '' NOT NULL; -ALTER TABLE users DROP access; -UPDATE users SET role = 'authenticated user'; - -# 23/06/01 -ALTER TABLE users CHANGE userid userid VARCHAR(32) DEFAULT '' NOT NULL; - -# 24/06/01 -CREATE TABLE referer ( - url varchar(255) DEFAULT '' NOT NULL, - timestamp int(11) NOT NULL -); - -# 30/06/01 -ALTER TABLE boxes CHANGE subject title varchar(64) DEFAULT '' NOT NULL; -ALTER TABLE boxes CHANGE content body TEXT; -ALTER TABLE boxes CHANGE id bid tinyint(4) DEFAULT '0' NOT NULL auto_increment; - -CREATE TABLE cache ( - url varchar(255) DEFAULT '' NOT NULL, - data text NOT NULL, - timestamp int(11) NOT NULL, - PRIMARY KEY (url) -); - -# 08/06/01 -CREATE TABLE site ( - sid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - title varchar(128) DEFAULT '' NOT NULL, - url varchar(255) DEFAULT '' NOT NULL, - size text NOT NULL, - timestamp int(11) NOT NULL, - UNIQUE (title), - UNIQUE (url), - PRIMARY KEY (sid) -); - -# 09/06/01 -ALTER TABLE feed CHANGE link url varchar(255) DEFAULT '' NOT NULL; -ALTER TABLE feed ADD link varchar(255) DEFAULT '' NOT NULL; -ALTER TABLE feed ADD description TEXT DEFAULT '' NOT NULL; - -# 12/06/01 -CREATE TABLE blog ( - lid int(10) unsigned NOT NULL auto_increment, - nid int(10) unsigned NOT NULL, - body text NOT NULL, - PRIMARY KEY (lid) -); - -#13/06/01 -ALTER TABLE site CHANGE title name varchar(128) DEFAULT '' NOT NULL; -ALTER TABLE site CHANGE url link varchar(255) DEFAULT '' NOT NULL; -ALTER TABLE site ADD feed varchar(255) DEFAULT '' NOT NULL; - - -#17/06/01 -ALTER TABLE page ADD link varchar(128) DEFAULT '' NOT NULL AFTER nid; - -#09/08/01 -ALTER TABLE users ADD UNIQUE name (name); -ALTER TABLE users ADD UNIQUE userid (userid); -ALTER TABLE users ADD UNIQUE real_email (real_email); -UPDATE users SET name = userid WHERE name = ''; diff --git a/updates/3.00-to-x.xx.mysql b/updates/3.00-to-x.xx.mysql deleted file mode 100644 index b8d90b2bc..000000000 --- a/updates/3.00-to-x.xx.mysql +++ /dev/null @@ -1,176 +0,0 @@ - -ALTER TABLE boxes DROP link; - -ALTER TABLE users RENAME AS user; -ALTER TABLE user DROP INDEX real_email; -ALTER TABLE user DROP fake_email; -ALTER TABLE user DROP nodes; -ALTER TABLE user DROP bio; -ALTER TABLE user DROP hash; -ALTER TABLE user ADD session varchar(32) DEFAULT '' NOT NULL; -ALTER TABLE user ADD jabber varchar(128) DEFAULT '' NULL; -ALTER TABLE user ADD drupal varchar(128) DEFAULT '' NULL; -ALTER TABLE user ADD init varchar(64) DEFAULT '' NULL; -ALTER TABLE user CHANGE passwd pass varchar(24) DEFAULT '' NOT NULL; -ALTER TABLE user CHANGE real_email mail varchar(64) DEFAULT '' NULL; -ALTER TABLE user CHANGE last_access timestamp int(11) DEFAULT '0' NOT NULL; -ALTER TABLE user CHANGE last_host hostname varchar(128) DEFAULT '' NOT NULL; -ALTER TABLE user CHANGE id uid int(10) unsigned DEFAULT '0' NOT NULL auto_increment; -ALTER TABLE user CHANGE url homepage varchar(128) DEFAULT '' NOT NULL; -UPDATE user SET status = 1 WHERE status = 2; -UPDATE user SET name = userid; -ALTER TABLE user DROP userid; -UPDATE user SET init = mail; - -DROP TABLE access; - -CREATE TABLE access ( - aid tinyint(10) DEFAULT '0' NOT NULL auto_increment, - mask varchar(255) DEFAULT '' NOT NULL, - type varchar(255) DEFAULT '' NOT NULL, - status tinyint(2) DEFAULT '0' NOT NULL, - UNIQUE mask (mask), - PRIMARY KEY (aid) -); - -CREATE TABLE moderate ( - cid int(10) DEFAULT '0' NOT NULL, - nid int(10) DEFAULT '0' NOT NULL, - uid int(10) DEFAULT '0' NOT NULL, - score int(2) DEFAULT '0' NOT NULL, - timestamp int(11) DEFAULT '0' NOT NULL, - INDEX (cid), - INDEX (nid) -); - -ALTER TABLE comments DROP score; -ALTER TABLE comments DROP votes; -ALTER TABLE comments DROP users; - -# PEAR - -ALTER TABLE user RENAME AS users; -ALTER TABLE users CHANGE pass pass varchar(32) DEFAULT '' NOT NULL; -ALTER TABLE watchdog CHANGE user userid int(10) DEFAULT '0' NOT NULL; -ALTER TABLE rating CHANGE user userid int(10) DEFAULT '0' NOT NULL; -ALTER TABLE layout CHANGE user userid int(10) DEFAULT '0' NOT NULL; -ALTER TABLE blocks CHANGE offset delta tinyint(2) DEFAULT '0' NOT NULL; - -# 14/10/01 (updated 16/10/01!) - -ALTER TABLE watchdog CHANGE id wid int(5) DEFAULT '0' NOT NULL auto_increment; -ALTER TABLE locales CHANGE id lid int(10) DEFAULT '0' NOT NULL auto_increment; -ALTER TABLE watchdog CHANGE userid uid int(10) DEFAULT '0' NOT NULL; -ALTER TABLE layout CHANGE userid uid int(10) DEFAULT '0' NOT NULL; -ALTER TABLE rating CHANGE userid uid int(10) DEFAULT '0' NOT NULL; - -## 16/10/01 - -# remove the "auto_increment"s: -ALTER TABLE story CHANGE nid nid int(10) unsigned DEFAULT '0' NOT NULL; -ALTER TABLE blog CHANGE nid nid int(10) unsigned DEFAULT '0' NOT NULL; -ALTER TABLE page CHANGE nid nid int(10) unsigned DEFAULT '0' NOT NULL; -ALTER TABLE forum CHANGE nid nid int(10) unsigned DEFAULT '0' NOT NULL; -ALTER TABLE book CHANGE nid nid int(10) unsigned DEFAULT '0' NOT NULL; - -# drop the "lid"s: -ALTER TABLE story DROP lid; -ALTER TABLE blog DROP lid; -ALTER TABLE page DROP lid; -ALTER TABLE forum DROP lid; -ALTER TABLE book DROP lid; - -# rename "author" to "uid": -ALTER TABLE comments CHANGE author uid int(10) DEFAULT '0' NOT NULL; -ALTER TABLE node CHANGE author uid int(10) DEFAULT '0' NOT NULL; -ALTER TABLE node DROP KEY author; -ALTER TABLE node ADD KEY uid (uid); - -# resize some "id"s: -ALTER TABLE feed CHANGE fid fid int(10) NOT NULL auto_increment; -ALTER TABLE bundle CHANGE bid bid int(10) NOT NULL auto_increment; -ALTER TABLE item CHANGE iid iid int(10) NOT NULL auto_increment; -ALTER TABLE item CHANGE fid fid int(10) NOT NULL; -ALTER TABLE comments CHANGE cid cid int(10) NOT NULL auto_increment; -ALTER TABLE comments CHANGE pid pid int(10) NOT NULL; -ALTER TABLE comments CHANGE lid lid int(10) NOT NULL; - -## 17/10/01: - -# add primary keys: -ALTER TABLE story ADD PRIMARY KEY nid (nid); -ALTER TABLE blog ADD PRIMARY KEY nid (nid); -ALTER TABLE page ADD PRIMARY KEY nid (nid); -ALTER TABLE forum ADD PRIMARY KEY nid (nid); -ALTER TABLE book ADD PRIMARY KEY nid (nid); - -## 22/10/01 - -# add new field to blocks -ALTER TABLE blocks ADD path varchar(255) NOT NULL DEFAULT ''; - -## 01/31/01 - -# rename the body fields: -ALTER TABLE story CHANGE body body_old TEXT DEFAULT '' NOT NULL; -ALTER TABLE page CHANGE body body_old TEXT DEFAULT '' NOT NULL; -ALTER TABLE blog CHANGE body body_old TEXT DEFAULT '' NOT NULL; -ALTER TABLE forum CHANGE body body_old TEXT DEFAULT '' NOT NULL; -ALTER TABLE book CHANGE body body_old TEXT DEFAULT '' NOT NULL; - -# update the node table: -ALTER TABLE node DROP lid; -ALTER TABLE node ADD teaser TEXT DEFAULT '' NOT NULL; -ALTER TABLE node ADD body TEXT DEFAULT '' NOT NULL; -ALTER TABLE node ADD changed int(11) DEFAULT '0' NOT NULL; -ALTER TABLE node CHANGE timestamp created int(11) DEFAULT '0' NOT NULL; -ALTER TABLE node CHANGE comment comment int(2) DEFAULT '0' NOT NULL; -ALTER TABLE node CHANGE promote promote int(2) DEFAULT '0' NOT NULL; -ALTER TABLE node CHANGE moderate moderate int(2) DEFAULT '0' NOT NULL; -ALTER TABLE node DROP timestamp_posted; -ALTER TABLE node DROP timestamp_queued; -ALTER TABLE node DROP timestamp_hidden; -UPDATE node SET status = 0 WHERE status = 1; -UPDATE node SET status = 0 WHERE status = 2; -UPDATE node SET status = 1 WHERE status = 3; - -# -# Run the second part of updates/3.00-to-x.xx.php: -# visit http://www.yoursite.com/3.00-to-x.xx.php?part=2 -# - -ALTER TABLE book DROP section; -ALTER TABLE users CHANGE session sid varchar(32) DEFAULT '' NOT NULL; - -# 02/11/01: -ALTER TABLE node ADD revisions TEXT DEFAULT '' NOT NULL; - -# 04/11/01: -ALTER TABLE book ADD revision int(2) DEFAULT '1' NOT NULL; -ALTER TABLE book DROP log; -ALTER TABLE book DROP pid; - -# -# Run the third part of updates/3.00-to-x.xx.php: -# visit http://www.yoursite.com/3.00-to-x.xx.php?part=3 -# - -# 08/11/01: -ALTER TABLE watchdog CHANGE message message text NOT NULL; - -# 14/11/01: -CREATE TABLE authmap ( - aid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - authname varchar(128) DEFAULT '' NOT NULL, - uid int(10) DEFAULT '' NOT NULL, - module varchar(128) DEFAULT '' NOT NULL, - UNIQUE authname (authname), - PRIMARY KEY (aid) -); - -DELETE FROM variable WHERE name = 'user_jabber'; -DELETE FROM variable WHERE name = 'user_drupal'; - -# TODO: -# write some PHP code that moves the 'jabber' and 'drupal' fields -# to the new 'authmap' table. diff --git a/updates/3.00-to-x.xx.php b/updates/3.00-to-x.xx.php deleted file mode 100644 index 04ccfd0bc..000000000 --- a/updates/3.00-to-x.xx.php +++ /dev/null @@ -1,88 +0,0 @@ -<?php -// $Id$ - -/* -** Move this file to the root of your Drupal tree and access it (execute -** it) through your browser. Make sure to delete this file afterwards so -** it can not be accessed by Malicious Mallory. -*/ - -include "includes/common.inc"; - -/* -** If not in 'safe mode', increase the maximum execution time: -*/ - -if (!get_cfg_var("safe_mode")) { - set_time_limit(180); -} - -/* -** Create sequence tables for pear-ification of MySQL -*/ - -if ($part == 1) { - - foreach (module_list() as $name) { - if (module_hook($name, "status")) { - print "$name ..."; - db_query("DROP TABLE IF EXISTS ". $name ."_seq"); - db_query("CREATE TABLE ". $name ."_seq (id INTEGER UNSIGNED AUTO_INCREMENT NOT NULL, PRIMARY KEY(id))"); - $result = db_query("SELECT MAX(". ($name == "node" ? "nid" : "lid") .") FROM $name", 1); - $count = $result ? db_result($result, 0) : 0; - db_query("INSERT INTO ". $name ."_seq (id) VALUES ('$count')"); - print "done ($count)<br />"; - } - } - -} - -/* -** Give old nodes a teaser: -** update your source tree and database first -*/ - -if ($part == 2) { - $result = db_query("SELECT nid FROM node"); - - while ($object = db_fetch_object($result)) { - - $node = node_load(array("nid" => $object->nid)); - - $body = db_result(db_query("SELECT body_old FROM $node->type WHERE nid = $node->nid"), 0); - - switch ($node->type) { - case "forum": - case "story": - case "book": - case "page": - case "blog": - node_save($node, array("nid", "body" => $body, "teaser" => node_teaser($body))); - print "updated node $node->nid '$node->title' ($node->type)<br />"; - break; - default: - print "unknown node $node->nid '$node->title' ($node->type)<br />"; - } - - unset($node); - unset($body); - } -} - -/* -** Remove old book pages: -*/ - -if ($part == 3) { - - // remove book pages that used to be 'expired': - $result = db_query("SELECT n.nid, n.title FROM node n WHERE n.type = 'book' AND n.status = 0"); - while ($node = db_fetch_object($result)) { - print "removing node $node->nid '$node->title' (dumped node)<br />"; - db_query("DELETE FROM node WHERE nid = '$node->nid'"); - db_query("DELETE FROM book WHERE nid = '$node->nid'"); - db_query("DELETE FROM comments WHERE lid = '$node->nid'"); - } -} - -?>
\ No newline at end of file |