[PHPLIB-DEV] Incompatible change to active_sessions and auth_user From: Kristian Koehntopp (kris <email protected>)
Date: 11/06/99

I propose an incompatible change to PHPLIB which will require
both, active_sessions and auth_user to be change. The change
will obviate the need for both active_sessions_split and
auth_user_md5. It will break the new_user.php3 and
view_sessions.php3 scripts, both of which will be rewritten
anyway.

Attached I have the patch which will break things. It is against
the current CVS. Please try it out and tell me what you think.

The new table structures will be like this

CREATE TABLE active_sessions (
   sid varchar(32) NOT NULL,
   name varchar(32) NOT NULL,
   valpos varchar(6) NOT NULL, -- ct_pos from active_sessions_split
   valenc varchar(16) NOT NILL, -- 'base64', 'slashes' or whatever
   val text,
   changed varchar(14) DEFAULT '' NOT NULL,
   PRIMARY KEY (name, sid, valpos),
   KEY changed (changed)
);

CREATE TABLE auth_user (
  user_id varchar(32) DEFAULT '' NOT NULL,
  username varchar(32) DEFAULT '' NOT NULL,
  pwenc varchar(16) DEFAULT '' NOT NULL, -- 'plain', 'md5', 'crypt' or whatever
  password varchar(32) DEFAULT '' NOT NULL,
  perms varchar(255),
  PRIMARY KEY (user_id),
  UNIQUE k_username (username)
);

INSERT INTO auth_user VALUES ('c14cbf141ab1b7cd009356f555b607dc','kris','plain','test','admin');

CREATE TABLE db_sequence (
  seq_name varchar(127) DEFAULT '' NOT NULL,
  nextid int(10) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (seq_name)
);

Kristian 

-- 
"Getting a SCSI chain working is perfectly simple if you remember that
 there must be exactly three terminations: one on one end of the cable,
 one on the far end, and the goat, terminated over the SCSI chain with
 a silver-handled knife whilst burning *black* candles. -- Anthony DeBoer"

- PHPLIB Developers Mailing List. Send messages to <phplib-dev <email protected>>. To unsubscribe, send "unsubscribe" to <phplib-dev-request <email protected>> in the body, not the subject, of your message.