Wikipedia:Old PHP script

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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