Wikipedia:Old PHP script: Difference between revisions
Content deleted Content added
m moved Wikipedia PHP script/The mysql sql ddl to Wikipedia:Old PHP script: Going to kill XNR, but want to save the old history first. |
m Graham87 moved page Wikipedia:Wikipedia PHP script/The mysql sql ddl to Wikipedia:Old PHP script without leaving a redirect: revert |
||
| (3 intermediate revisions by 2 users not shown) | |||
Line 1:
<pre>
CREATE TABLE WIKI_cur (
cur_id int(10) unsigned NOT NULL auto_increment,
cur_title varchar(255) NOT NULL,
cur_text text NOT NULL,
cur_comment varchar(255) NOT NULL,
cur_user int(10) unsigned NOT NULL,
cur_user_text varchar(255) NOT NULL,
cur_old_version mediumint(8) unsigned NOT NULL,
cur_timestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
cur_minor_edit tinyint(4) NOT NULL,
cur_restrictions varchar(255) NOT NULL,
PRIMARY KEY (cur_id),
UNIQUE cur_title (cur_title)
);
CREATE TABLE WIKI_old (
old_id int(10) unsigned NOT NULL auto_increment,
old_title varchar(255) NOT NULL,
old_text text NOT NULL,
old_comment varchar(255) NOT NULL,
old_user int(10) unsigned NOT NULL,
old_user_text varchar(255) NOT NULL,
old_old_version int(10) unsigned NOT NULL,
old_timestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
old_minor_edit tinyint(4) NOT NULL,
PRIMARY KEY (old_id)
);
CREATE TABLE WIKI_user (
user_id int(10) unsigned NOT NULL auto_increment,
user_name varchar(255) NOT NULL,
user_password varchar(255) NOT NULL,
user_rights varchar(255) NOT NULL,
PRIMARY KEY (user_id),
UNIQUE user_name (user_name)
);
</pre>
:''See also :'' [[Wikipedia PHP script]]
| |||