From Wikipedia, the free encyclopedia
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