[SR-Users] pipelimit db schema

[Daniel-Constantin Mierla]

Hello,

On 2/23/11 12:30 AM, thrillerbee wrote:
> Can anyone point me to the db schema for the new pipelimit module?

seems I forgot to add it to db creation script. I will fix that in the 
next days. Meanwhile you can use:

INSERT INTO version (table_name, table_version) values ('pl_pipes','1');
CREATE TABLE pl_pipes (
   id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
   pipeid VARCHAR(64) DEFAULT '' NOT NULL,
   algorithm VARCHAR(32) DEFAULT '' NOT NULL,
   plimit INT DEFAULT 0 NOT NULL,
   CONSTRAINT pipeid_idx UNIQUE (pipeid)
) ENGINE=MyISAM;

This is inside sources, modules/pipelimit/pl_db.c

Thanks, Daniel

-- 
Daniel-Constantin Mierla
http://www.asipto.com