USE PandaDevDB;

DROP TABLE IF EXISTS sitesInfo;
CREATE TABLE `sitesInfo` (
       `NAME`      varchar(60)  NOT NULL,
       `NICK`      varchar(12)  NOT NULL,
       `CONTACT`   varchar(30),
       `EMAIL`     varchar(30),
       `STATUS`    varchar(12),
       `LRC`       varchar(30),
       `GRIDCAT`   mediumint,
       `MONALISA`  varchar(20),   
       `QUEMON`    varchar(120), 
       `UPDTIME`   int,
       `NDATASETS` mediumint,
       `NFILES`    mediumint,
       `TIMESTAMP` int
) TYPE=NDB;

DROP TABLE IF EXISTS siteQueues;
CREATE TABLE `siteQueues` (
      `NICK`        varchar(12) NOT NULL,
      `QUEUE`       varchar(60) NOT NULL,
      `GATEKEEPER`  varchar(60),
      `PARAMS`      varchar(255),
      `TIMESTAMP`   int unsigned
) TYPE NDB;
    
INSERT INTO sitesInfo VALUES('Brookhaven National Laboratory',
                             'BNL',
                             'Torre Wenaus',
                             'wenaus@bnl.gov',
                             'Active',
                             'http://dms02.usatlas.bnl.gov/sites/bnl/lrc',
                             17,
                             'BNL_ATLAS_2',
                             0,
                             0,
                             0,
                             0);
INSERT INTO sitesInfo VALUES('Boston University',
                             'BU', 
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'http://dms02.usatlas.bnl.gov/sites/bu/lrc',
                             24,
                             'agt_bu_edu',   
                             0,
                             0,
                             0,
                             0);
INSERT INTO sitesInfo VALUES('The University of Texas at Arlington',
                             'UTA',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'http://dms02.usatlas.bnl.gov/sites/uta/lrc',
                             23,
                             'UTA-DPCC',  
                             0,
                             0,
                             0,
                             0);
INSERT INTO sitesInfo VALUES('The University of Oklahoma',
                             'OU',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('The University of Chicago',
                             'UC',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'http://dms02.usatlas.bnl.gov/sites/uc/lrc',
                             0 ,
                             'UC_ATLAS_MWT2',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('Purdue University',
                             'Purdue',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);


INSERT INTO sitesInfo VALUES('Academia Sinica',
                             'ASCC',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('California Institute of Technology',
                             'caltech',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('University at Buffalo',
                             'UB',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('Fermi National Laboratory',
                             'FNAL',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('The University of Iowa',
                             'UIOWA',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('Indiana University',
                             'IU',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('Penn State University',
                             'PSU',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('University of Wisconsin',
                             'UWM',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('Stanford University',
                             'SLAC',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('Universidade de Sao Paoloa',
                             'SAO_PAOLO',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);
INSERT INTO sitesInfo VALUES('Texas Tech University',
                             'TTU',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('University at Albany',
                             'ALBANY',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('The University of New Mexico',
                             'UNM',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('Binghamton University',
                             'BINGHAMTON',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);


INSERT INTO sitesInfo VALUES('University of Florida',
                             'UFL',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('University of Wisconsin-Madison',
                             'UWMadison',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);


INSERT INTO sitesInfo VALUES('Vanderbilt University',
                             'Vanderbilt',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('Hampton University',
                             'HAMPTONU',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('The University of Texas at Austin',
                             'TACC',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('The University of Nebraska Lincoln',
                             'Nebraska',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('Universidade do Estado do Rio de Janeiro',
                             'UERJ',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('National Energy Research Scientific Computing Center',
                             'NERSC',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);

INSERT INTO sitesInfo VALUES('National Taiwan University',
                             'NTU-TW',
                             'tbd',
                             'tbd@panda.tbd',
                             'Active',
                             'tbd',
                             0 ,
                             'tbd',
                             0,
                             0,
                             0,
                             0);


commit;


     