Sql
Aus Alexander's Wiki
Version vom 14. November 2013, 14:02 Uhr von Admin (Diskussion | Beiträge) (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, …“)
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);