Wikipedia:Old PHP script

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) );


 * See also : Wikipedia PHP script