[Phpgroupware-cvs] CVS: napster/doc/examples/sql create_tables.mysql,NONE,1.1 create_tables.pgsql,NONE,1.1 drop_tables.sql,NONE,1.1

[Luca - De Whiskey's - De Vitis <address@hidden>]

Update of /cvsroot/phpgroupware/napster/doc/examples/sql
In directory subversions:/tmp/cvs-serv15597/napster/doc/examples/sql

Added Files:
        create_tables.mysql create_tables.pgsql drop_tables.sql 
Log Message:


Minor changes to directory structure:
- Moved old sql files to a more suitable place.
- Moved chora/docs to chora/doc


***** Error reading new file: [Errno 2] No such file or directory: 
'create_tables.mysql'
--- NEW FILE ---

CREATE TABLE napster_servers (
  name        varchar(255) NOT NULL,
  ip          varchar(255) NOT NULL,
  port        int          NOT NULL,
  network     varchar(255) NOT NULL,
  users       int          NOT NULL,
  files       int          NOT NULL,
  gb          int          NOT NULL,
  lastupdated int          NOT NULL,
  UNIQUE (name)
);

CREATE TABLE napster_speeds (
  speed       varchar(255) NOT NULL,
  UNIQUE (speed)
);

INSERT INTO napster_speeds VALUES('slow');
INSERT INTO napster_speeds VALUES('14.4K');
INSERT INTO napster_speeds VALUES('28.8K');
INSERT INTO napster_speeds VALUES('33.6K');
INSERT INTO napster_speeds VALUES('56K');
INSERT INTO napster_speeds VALUES('64K');
INSERT INTO napster_speeds VALUES('128K');
INSERT INTO napster_speeds VALUES('Cable');
INSERT INTO napster_speeds VALUES('DSL');
INSERT INTO napster_speeds VALUES('T1');
INSERT INTO napster_speeds VALUES('T3+');

CREATE TABLE napster_compares (
  operator    varchar(255) NOT NULL,
  UNIQUE (operator)
);

INSERT INTO napster_compares VALUES('AT LEAST');
INSERT INTO napster_compares VALUES('EQUAL TO');
INSERT INTO napster_compares VALUES('AT BEST'); 

CREATE TABLE napster_ports (
  port  int              NOT NULL,
  state int    DEFAULT 0 NOT NULL,
  UNIQUE (port)
);

INSERT INTO napster_ports VALUES(6699,0);
INSERT INTO napster_ports VALUES(6700,0);
INSERT INTO napster_ports VALUES(6701,0);
INSERT INTO napster_ports VALUES(6702,0);
INSERT INTO napster_ports VALUES(6703,0);
INSERT INTO napster_ports VALUES(6704,0);


--- NEW FILE ---
DROP TABLE napster_servers;
DROP TABLE napster_speeds;
DROP TABLE napster_compares;
DROP TABLE napster_ports;