Files
cmsPRO/updates/1.30/ver_1.362_sql.txt
2026-02-22 21:59:33 +01:00

4 lines
366 B
Plaintext

CREATE TABLE pp_users_privileges ( id int(11) NOT NULL, name text COLLATE utf8_polish_ci NOT NULL, id_user int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
ALTER TABLE pp_users_privileges ADD PRIMARY KEY ( id );
ALTER TABLE pp_users_privileges MODIFY id int(11) NOT NULL AUTO_INCREMENT;
UPDATE pp_users SET active_to = NULL WHERE id = 1;