1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
|
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.
|
