Migracion usuarios
PostPosted:Wed Feb 03, 2010 12:41 pm
He leido lo siguiente en el WIKI
You need some changes in you database tables:
Change role UserRol to UserRole (tables roles and user_role)
Change role AdminRol to AdminRole (tables roles and user_role)
Table users has a new field usr_name VARCHAR(64)
ALTER TABLE users ADD COLUMN usr_name varchar(64) NULL;
Remember that in this OpenKM release, the defaul setting are for MD5 password encoded, so you have to make this changes.
Add this new table:
CREATE TABLE mail_accounts(ma_id IDENTITY, ma_user VARCHAR(32), ma_mhost VARCHAR(32), ma_muser VARCHAR(32), ma_mpass VARCHAR(32), ma_mfolder VARCHAR(32), ma_active BOOLEAN, PRIMARY KEY(ma_id));
CREATE TABLE twitter_accounts(ta_id IDENTITY, ta_user VARCHAR(32), ta_tuser VARCHAR(32), ta_active BOOLEAN, PRIMARY KEY(ta_id));
Entiendo que dichos cambios se harían en la base de datos de la 3.0 y dichas base de datos se copiarían (los ficheros de base de datos en si) a la version 4.0.
Saludos
You need some changes in you database tables:
Change role UserRol to UserRole (tables roles and user_role)
Change role AdminRol to AdminRole (tables roles and user_role)
Table users has a new field usr_name VARCHAR(64)
ALTER TABLE users ADD COLUMN usr_name varchar(64) NULL;
Remember that in this OpenKM release, the defaul setting are for MD5 password encoded, so you have to make this changes.
Add this new table:
CREATE TABLE mail_accounts(ma_id IDENTITY, ma_user VARCHAR(32), ma_mhost VARCHAR(32), ma_muser VARCHAR(32), ma_mpass VARCHAR(32), ma_mfolder VARCHAR(32), ma_active BOOLEAN, PRIMARY KEY(ma_id));
CREATE TABLE twitter_accounts(ta_id IDENTITY, ta_user VARCHAR(32), ta_tuser VARCHAR(32), ta_active BOOLEAN, PRIMARY KEY(ta_id));
Entiendo que dichos cambios se harían en la base de datos de la 3.0 y dichas base de datos se copiarían (los ficheros de base de datos en si) a la version 4.0.
Saludos