38 lines
1.4 KiB
SQL
38 lines
1.4 KiB
SQL
create table {PREFIX}tempauthors (
|
|
realname varchar(255) NOT NULL default '',
|
|
username varchar(32) default null,
|
|
password varchar(64) default null,
|
|
authorid {AUTOINCREMENT} {PRIMARY},
|
|
mail_comments int(1) default '1',
|
|
mail_trackbacks int(1) default '1',
|
|
email varchar(128) not null default '',
|
|
userlevel int(4) {UNSIGNED} not null default '0',
|
|
right_publish int(1) default '1',
|
|
hashtype int(1) default '0'
|
|
) {UTF_8};
|
|
|
|
INSERT INTO {PREFIX}tempauthors
|
|
(realname,username,password,authorid,mail_comments,mail_trackbacks,email,userlevel,right_publish,hashtype) SELECT
|
|
realname,username,password,authorid,mail_comments,mail_trackbacks,email,userlevel,right_publish,0 FROM {PREFIX}authors;
|
|
DROP TABLE {PREFIX}authors;
|
|
|
|
create table {PREFIX}authors (
|
|
realname varchar(255) NOT NULL default '',
|
|
username varchar(32) default null,
|
|
password varchar(64) default null,
|
|
authorid {AUTOINCREMENT} {PRIMARY},
|
|
mail_comments int(1) default '1',
|
|
mail_trackbacks int(1) default '1',
|
|
email varchar(128) not null default '',
|
|
userlevel int(4) {UNSIGNED} not null default '0',
|
|
right_publish int(1) default '1',
|
|
hashtype int(1) default '0'
|
|
) {UTF_8};
|
|
|
|
|
|
INSERT INTO {PREFIX}authors
|
|
(realname,username,password,authorid,mail_comments,mail_trackbacks,email,userlevel,right_publish,hashtype) SELECT
|
|
realname,username,password,authorid,mail_comments,mail_trackbacks,email,userlevel,right_publish,hashtype FROM {PREFIX}tempauthors;
|
|
DROP TABLE {PREFIX}tempauthors;
|
|
|