Blog Documentation Book a Demo

/utility/structure don´t work

EdwinJuradoEdwinJurado New
in Vanilla 2.0 - 2.8

Good day, I'm having problems with the tool /utility/structure I find several problems, but it does not solve them, I would like to know how I could solve these problems by hand or how I do so that /utility/structure works well

alter table GDN_UserAuthenticationNonce
-- [Existing: Timestamp timestamp not null default CURRENT_TIMESTAMP, New: Timestamp timestamp not null]
change Timestamp Timestamp timestamp not null;

alter table GDN_UserAuthenticationToken
-- [Existing: Timestamp timestamp not null default CURRENT_TIMESTAMP, New: Timestamp timestamp not null]
change Timestamp Timestamp timestamp not null;

alter table GDN_AccessToken
-- [Existing: DateInserted timestamp not null default CURRENT_TIMESTAMP, New: DateInserted timestamp not null default current_timestamp]
change DateInserted DateInserted timestamp not null default current_timestamp,
-- [Existing: DateExpires timestamp not null default CURRENT_TIMESTAMP, New: DateExpires timestamp not null default current_timestamp]
change DateExpires DateExpires timestamp not null default current_timestamp;

update GDN_User User
set Permissions = ''
where Permissions <> '';

insert GDN_UserMeta
(UserID, Name, Value)
values ('0', 'stubcontent.record.locale', 'es');

Comments

  • R_JR_J Admin

    Those are harmless. The Timestamp messages are new to me but I suspect this is a upper/lower spelling issue, but no problem.

    The stubcontent message is also something I've never seen before, but it isn't needed, either.

    You will never be able to get rid of that permissions note, but that isn't needed.

    So just ignore all those messages and go on =)

  • EdwinJuradoEdwinJurado New

    ok thanks

Sign In or Register to comment.