Admin: Die Seite wurde neu angelegt: „ALTER TABLE user CHANGE name username VARCHAR(50) NOT NULL; ALTER TABLE groups AUTO_INCREMENT = 1; CREATE VIEW role AS SELECT gr.id, name, …“

2013-11-14T13:02:53Z

Die Seite wurde neu angelegt: „ALTER TABLE user CHANGE name username VARCHAR(50) NOT NULL; ALTER TABLE groups AUTO_INCREMENT = 1; CREATE VIEW role AS SELECT gr.id, name, …“

Neue Seite

ALTER TABLE user CHANGE name username VARCHAR(50) NOT NULL;

ALTER TABLE groups AUTO_INCREMENT = 1;

CREATE VIEW role AS
SELECT gr.id,
name,
description,
appcode,
created AS created_when,
created_by,
modified AS modified_when,
modified_by
FROM groups gr JOIN tmp_role_adone tra ON gr.id = tra.id;

ALTER TABLE user ADD UNIQUE (name);

ALTER TABLE user ADD CONSTRAINT fk_user_group
FOREIGN KEY (group_id)
REFERENCES groups(id);

Sql - Versionsgeschichte

Admin: Die Seite wurde neu angelegt: „ALTER TABLE user CHANGE name username VARCHAR(50) NOT NULL; ALTER TABLE groups AUTO_INCREMENT = 1; CREATE VIEW role AS SELECT gr.id, name, …“