--
-- Host: localhost    Database: d0mcen
---------------------------------------------------------

--
-- Current Database: d0mcen
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ d0mcen;

USE d0mcen;

--
-- Table structure for table 'area'
--

CREATE TABLE area (
  id int(1) NOT NULL auto_increment,
  value char(10) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY value (value)
) TYPE=MyISAM;

--
-- Dumping data for table 'area'
--


INSERT INTO area VALUES (1,'FNAL');
INSERT INTO area VALUES (2,'Test Stand');
INSERT INTO area VALUES (3,'Boston');

--
-- Table structure for table 'fdate'
--

CREATE TABLE fdate (
  id int(11) NOT NULL auto_increment,
  value date default NULL,
  PRIMARY KEY  (id),
  KEY value (value)
) TYPE=MyISAM;

--
-- Dumping data for table 'fdate'
--


INSERT INTO fdate VALUES (1,'2003-01-03');

--
-- Table structure for table 'firmware'
--

CREATE TABLE firmware (
  id int(11) NOT NULL auto_increment,
  version char(10) default NULL,
  installed date default NULL,
  PRIMARY KEY  (id),
  KEY version (version),
  KEY installed (installed)
) TYPE=MyISAM;

--
-- Dumping data for table 'firmware'
--


INSERT INTO firmware VALUES (1,'12/12/02','2002-01-03');
INSERT INTO firmware VALUES (2,'11/05/02','2002-01-03');

--
-- Table structure for table 'fversion'
--

CREATE TABLE fversion (
  id int(11) NOT NULL auto_increment,
  value char(10) default NULL,
  PRIMARY KEY  (id),
  KEY value (value)
) TYPE=MyISAM;

--
-- Dumping data for table 'fversion'
--


INSERT INTO fversion VALUES (3,'12/12/02');
INSERT INTO fversion VALUES (2,'11/05/02');
INSERT INTO fversion VALUES (1,'11/22/02');

--
-- Table structure for table 'gs'
--

CREATE TABLE gs (
  id int(1) NOT NULL auto_increment,
  value char(7) default NULL,
  PRIMARY KEY  (id),
  KEY value (value)
) TYPE=MyISAM;

--
-- Dumping data for table 'gs'
--


INSERT INTO gs VALUES (1,'North');
INSERT INTO gs VALUES (2,'South');
INSERT INTO gs VALUES (3,'Central');

--
-- Table structure for table 'issues'
--

CREATE TABLE issues (
  id int(11) NOT NULL auto_increment,
  problems char(255) default NULL,
  solutions char(255) default NULL,
  PRIMARY KEY  (id),
  KEY problems (problems),
  KEY solutions (solutions)
) TYPE=MyISAM;

--
-- Dumping data for table 'issues'
--



--
-- Table structure for table 'layer'
--

CREATE TABLE layer (
  id int(1) NOT NULL auto_increment,
  value char(2) default NULL,
  PRIMARY KEY  (id),
  KEY value (value)
) TYPE=MyISAM;

--
-- Dumping data for table 'layer'
--


INSERT INTO layer VALUES (1,'A');
INSERT INTO layer VALUES (2,'B');
INSERT INTO layer VALUES (3,'C');

--
-- Table structure for table 'main'
--

CREATE TABLE main (
  id int(11) NOT NULL auto_increment,
  serial_number int(11) NOT NULL default '0',
  pb_number int(4) default NULL,
  type int(1) NOT NULL default '0',
  area int(1) NOT NULL default '0',
  gs int(1) default NULL,
  layer int(1) default NULL,
  slot int(2) default NULL,
  fversion int(11) default NULL,
  fdate int(11) default NULL,
  entry_time time default NULL,
  entry_date date default NULL,
  comments char(255) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'main'
--


INSERT INTO main VALUES (1,1,NULL,1,1,1,1,1,3,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (2,2,NULL,2,1,1,1,2,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (3,3,NULL,2,1,1,1,3,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (4,4,NULL,2,1,1,1,4,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (5,5,19,2,1,1,1,5,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (6,6,1,2,1,1,1,6,2,1,'17:15:00','2003-03-05','RX 10 is hot. RX 6 seems noisy on the FE');
INSERT INTO main VALUES (7,7,2,2,1,1,1,7,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (8,8,NULL,2,1,1,1,8,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (9,9,NULL,2,1,1,1,9,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (10,10,3,3,1,1,1,10,2,1,'17:16:00','2003-03-05','About 4% RX, FE difference. Favors RX.');
INSERT INTO main VALUES (11,11,4,3,1,1,1,11,2,1,'17:17:00','2003-03-05','About 4% RX, FE difference.');
INSERT INTO main VALUES (12,12,5,3,1,1,1,12,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (13,13,6,3,1,1,1,13,2,1,'17:19:00','2003-03-05','About 20% RX, FE difference on RX side in RX 7');
INSERT INTO main VALUES (14,14,NULL,1,1,2,1,1,3,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (15,15,NULL,2,1,2,1,2,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (16,16,NULL,2,1,2,1,3,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (17,17,NULL,2,1,2,1,4,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (18,18,NULL,2,1,2,1,5,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (19,19,NULL,2,1,2,1,6,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (20,20,NULL,2,1,2,1,7,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (21,21,NULL,2,1,2,1,8,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (22,22,NULL,2,1,2,1,9,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (23,23,NULL,3,1,2,1,10,2,1,'17:19:00','2003-03-05','About 2% RX, FE difference on RX side.');
INSERT INTO main VALUES (24,24,NULL,3,1,2,1,11,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (25,25,NULL,3,1,2,1,12,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (26,26,NULL,3,1,2,1,13,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (27,27,NULL,1,1,1,2,1,3,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (28,28,25,2,1,1,2,2,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (29,29,NULL,2,1,1,2,3,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (30,30,7,2,1,1,2,4,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (31,31,8,2,1,1,2,5,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (32,32,NULL,2,1,1,2,6,2,1,'17:21:00','2003-03-05','Very hot FE in RX 2. Definately an FE problem.');
INSERT INTO main VALUES (33,33,NULL,2,1,1,2,7,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (34,34,9,2,1,1,2,8,2,1,'17:22:00','2003-03-05','RX, FE don\'t match at all. TX, Sim, FE don\'t match either.');
INSERT INTO main VALUES (35,35,10,2,1,1,2,9,2,1,'17:23:00','2003-03-05','RX 11 very hot gives extra TXs.');
INSERT INTO main VALUES (36,36,11,2,1,1,3,10,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (37,37,12,2,1,1,3,11,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (38,38,NULL,1,1,2,2,1,3,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (39,39,NULL,2,1,2,2,2,2,1,'17:25:00','2003-03-05','Many RX, FE mismatches. TX, FE also.');
INSERT INTO main VALUES (40,40,24,2,1,2,2,3,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (41,41,NULL,2,1,2,2,4,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (42,42,NULL,2,1,2,2,5,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (43,43,NULL,2,1,2,2,6,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (44,44,NULL,2,1,2,2,7,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (45,45,23,2,1,2,2,8,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (46,46,22,2,1,2,2,9,2,1,'17:26:00','2003-03-05','Many RX, FE and TX, FE mismatches.');
INSERT INTO main VALUES (47,47,NULL,2,1,2,3,10,2,1,'17:26:00','2003-03-05','Many RX, FE and TX, FE mismatches.');
INSERT INTO main VALUES (48,48,20,2,1,2,3,11,2,1,'17:31:00','2003-03-05','Very hot RX 3. Negative TX-Sim, pos. TX-FE. Two channels masked off: 4, 5');
INSERT INTO main VALUES (49,49,NULL,2,1,2,3,12,2,1,'17:28:00','2003-03-05','Many RX, FE and TX, FE mismatches.');
INSERT INTO main VALUES (50,50,21,2,1,2,3,13,2,1,'17:29:00','2003-03-05','Many RX, FE and TX, FE mismatches. One channel masked off: 11');
INSERT INTO main VALUES (51,51,NULL,1,1,3,NULL,1,3,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (52,52,NULL,3,1,3,NULL,2,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (53,53,NULL,3,1,3,NULL,3,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (54,54,NULL,3,1,3,NULL,4,2,1,'17:00:00','2003-03-05',NULL);
INSERT INTO main VALUES (55,55,13,2,2,NULL,NULL,NULL,NULL,NULL,'17:00:00','2003-03-05','Never have looked at this on the stand. Was labeled as \'Central Mismatch\'. Who knows what firmware it has.');
INSERT INTO main VALUES (56,56,14,2,2,NULL,NULL,NULL,2,1,'17:00:00','2003-03-05','Stuck two\'s bit on VME address');
INSERT INTO main VALUES (57,57,15,2,2,NULL,NULL,NULL,2,1,'17:00:00','2003-03-05','This one was hard to diagnose on the stand. No bad channels on leds, but output is unstable.');
INSERT INTO main VALUES (58,58,16,2,2,NULL,NULL,NULL,2,1,'17:00:00','2003-03-05','The Infamous \'MCEN\' 7. Gives B1 error unless all channels - except RX1 - are masked off.');
INSERT INTO main VALUES (59,59,17,2,2,NULL,NULL,NULL,2,1,'17:00:00','2003-03-05','Might be a stuck bit somewhere on RX 1-3. Often gives WC=2.');
INSERT INTO main VALUES (60,60,18,2,2,NULL,NULL,NULL,2,1,'17:00:00','2003-03-05','Might not be sending L2 data all the time. RX 1 is bad (has been masked off for quite a while when it was in the detector.');
INSERT INTO main VALUES (61,61,NULL,1,2,NULL,NULL,NULL,1,1,'17:00:00','2003-03-05','I had trouble jtagging this with the newest firmware');
INSERT INTO main VALUES (62,6,1,2,1,1,1,5,2,1,'12:00:00','2003-03-08','RX 10 is hot somewhere on the board. This does not lead to extra centroids. It is not masked off.');
INSERT INTO main VALUES (63,28,25,2,1,1,1,6,2,1,'12:00:00','2003-03-08','RX 11 is often somewhat hot. No extra centroids formed. This location has been flaky in the past.');
INSERT INTO main VALUES (64,10,3,3,1,1,1,10,2,1,'12:00:00','2003-03-08',NULL);
INSERT INTO main VALUES (65,11,4,3,1,1,1,11,2,1,'12:00:00','2003-03-08',NULL);
INSERT INTO main VALUES (66,13,6,3,1,1,1,13,2,1,'12:00:00','2003-03-08',NULL);
INSERT INTO main VALUES (67,23,NULL,3,1,2,1,10,2,1,'12:00:00','2003-03-08',NULL);
INSERT INTO main VALUES (68,5,19,2,1,1,2,2,2,1,'12:00:00','2003-03-08',NULL);
INSERT INTO main VALUES (69,32,NULL,2,1,1,2,6,2,1,'12:00:00','2003-03-08',NULL);
INSERT INTO main VALUES (70,36,11,2,1,1,2,8,2,1,'12:00:00','2003-03-08',NULL);
INSERT INTO main VALUES (71,37,12,2,1,1,2,9,2,1,'12:00:00','2003-03-08','RX 11 very hot gives extra TXs. Definately before the board.');
INSERT INTO main VALUES (72,34,9,2,1,1,3,10,2,1,'12:00:00','2003-03-08',NULL);
INSERT INTO main VALUES (73,35,10,2,1,1,3,11,2,1,'12:00:00','2003-03-08','Extra FE hits not on RX at about 20%. RX 8 is bad and is masked off.');
INSERT INTO main VALUES (74,40,24,2,1,2,2,2,2,1,'12:00:00','2003-03-08','Many RX, FE mismatches. TX, FE also.Definately before the board. Leads to very few extra centroids.');
INSERT INTO main VALUES (75,39,NULL,2,1,2,2,3,2,1,'12:00:00','2003-03-08','Only 1 FE hit.');
INSERT INTO main VALUES (76,46,22,2,1,2,2,8,2,1,'12:00:00','2003-03-08',NULL);
INSERT INTO main VALUES (77,45,23,2,1,2,2,9,2,1,'12:00:00','2003-03-08',NULL);
INSERT INTO main VALUES (78,47,NULL,2,1,2,3,10,2,1,'12:00:00','2003-03-08',NULL);
INSERT INTO main VALUES (79,50,21,2,1,2,3,11,2,1,'12:00:00','2003-03-08','Extra FE hits not on RX. Makes some FE centroids. Bad RXs 3,8,11 masked off.');
INSERT INTO main VALUES (80,49,NULL,2,1,2,3,12,2,1,'12:00:00','2003-03-08',NULL);
INSERT INTO main VALUES (81,56,14,2,3,NULL,NULL,NULL,2,1,'12:00:00','2003-03-08','Stuck two\'s bit on VME address');
INSERT INTO main VALUES (82,57,15,2,3,NULL,NULL,NULL,2,1,'12:00:00','2003-03-08','This one was hard to diagnose on the stand. No bad channels on leds, but output is unstable.');
INSERT INTO main VALUES (83,58,16,2,3,NULL,NULL,NULL,2,1,'12:00:00','2003-03-08','The Infamous \'MCEN\' 7. Gives B1 error unless all channels - except RX1 - are masked off.');
INSERT INTO main VALUES (84,59,17,2,3,NULL,NULL,NULL,2,1,'12:00:00','2003-03-08','Might be a stuck bit somewhere on RX 1-3. Often gives WC=2.');
INSERT INTO main VALUES (85,60,18,2,3,NULL,NULL,NULL,2,1,'12:00:00','2003-03-08','Might not be sending L2 data all the time. RX 1 is bad (has been masked off for quite a while when it was in the detector.');
INSERT INTO main VALUES (86,61,NULL,1,3,NULL,NULL,NULL,3,1,'12:00:00','2003-03-08','I had trouble jtagging this with the newest firmware');
INSERT INTO main VALUES (87,48,20,2,2,NULL,NULL,NULL,2,1,'12:00:00','2003-03-08','RX 3 very hot.');

--
-- Table structure for table 'pb_number'
--

CREATE TABLE pb_number (
  id int(4) NOT NULL auto_increment,
  value int(4) default NULL,
  PRIMARY KEY  (id),
  KEY value (value)
) TYPE=MyISAM;

--
-- Dumping data for table 'pb_number'
--


INSERT INTO pb_number VALUES (1,58);
INSERT INTO pb_number VALUES (2,57);
INSERT INTO pb_number VALUES (3,55);
INSERT INTO pb_number VALUES (4,51);
INSERT INTO pb_number VALUES (5,38);
INSERT INTO pb_number VALUES (6,49);
INSERT INTO pb_number VALUES (7,46);
INSERT INTO pb_number VALUES (8,18);
INSERT INTO pb_number VALUES (9,1);
INSERT INTO pb_number VALUES (10,31);
INSERT INTO pb_number VALUES (11,29);
INSERT INTO pb_number VALUES (12,5);
INSERT INTO pb_number VALUES (13,999);
INSERT INTO pb_number VALUES (14,2);
INSERT INTO pb_number VALUES (15,65);
INSERT INTO pb_number VALUES (16,54);
INSERT INTO pb_number VALUES (17,33);
INSERT INTO pb_number VALUES (18,66);
INSERT INTO pb_number VALUES (19,14);
INSERT INTO pb_number VALUES (20,64);
INSERT INTO pb_number VALUES (21,23);
INSERT INTO pb_number VALUES (22,11);
INSERT INTO pb_number VALUES (23,52);
INSERT INTO pb_number VALUES (24,9);
INSERT INTO pb_number VALUES (25,20);

--
-- Table structure for table 'serial_number'
--

CREATE TABLE serial_number (
  id int(11) NOT NULL auto_increment,
  value int(4) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY value (value)
) TYPE=MyISAM;

--
-- Dumping data for table 'serial_number'
--


INSERT INTO serial_number VALUES (1,680);
INSERT INTO serial_number VALUES (2,681);
INSERT INTO serial_number VALUES (3,682);
INSERT INTO serial_number VALUES (4,683);
INSERT INTO serial_number VALUES (5,14);
INSERT INTO serial_number VALUES (6,58);
INSERT INTO serial_number VALUES (7,57);
INSERT INTO serial_number VALUES (8,687);
INSERT INTO serial_number VALUES (9,688);
INSERT INTO serial_number VALUES (10,55);
INSERT INTO serial_number VALUES (11,51);
INSERT INTO serial_number VALUES (12,56);
INSERT INTO serial_number VALUES (13,49);
INSERT INTO serial_number VALUES (14,880);
INSERT INTO serial_number VALUES (15,881);
INSERT INTO serial_number VALUES (16,882);
INSERT INTO serial_number VALUES (17,883);
INSERT INTO serial_number VALUES (18,884);
INSERT INTO serial_number VALUES (19,885);
INSERT INTO serial_number VALUES (20,886);
INSERT INTO serial_number VALUES (21,887);
INSERT INTO serial_number VALUES (22,888);
INSERT INTO serial_number VALUES (23,889);
INSERT INTO serial_number VALUES (24,890);
INSERT INTO serial_number VALUES (25,891);
INSERT INTO serial_number VALUES (26,892);
INSERT INTO serial_number VALUES (27,1680);
INSERT INTO serial_number VALUES (28,39);
INSERT INTO serial_number VALUES (29,1682);
INSERT INTO serial_number VALUES (30,46);
INSERT INTO serial_number VALUES (31,18);
INSERT INTO serial_number VALUES (32,1685);
INSERT INTO serial_number VALUES (33,1686);
INSERT INTO serial_number VALUES (34,31);
INSERT INTO serial_number VALUES (35,53);
INSERT INTO serial_number VALUES (36,29);
INSERT INTO serial_number VALUES (37,62);
INSERT INTO serial_number VALUES (38,1880);
INSERT INTO serial_number VALUES (39,1881);
INSERT INTO serial_number VALUES (40,24);
INSERT INTO serial_number VALUES (41,1883);
INSERT INTO serial_number VALUES (42,1884);
INSERT INTO serial_number VALUES (43,1885);
INSERT INTO serial_number VALUES (44,1886);
INSERT INTO serial_number VALUES (45,52);
INSERT INTO serial_number VALUES (46,11);
INSERT INTO serial_number VALUES (47,1889);
INSERT INTO serial_number VALUES (48,64);
INSERT INTO serial_number VALUES (49,1891);
INSERT INTO serial_number VALUES (50,23);
INSERT INTO serial_number VALUES (51,580);
INSERT INTO serial_number VALUES (52,581);
INSERT INTO serial_number VALUES (53,582);
INSERT INTO serial_number VALUES (54,583);
INSERT INTO serial_number VALUES (55,36);
INSERT INTO serial_number VALUES (56,4);
INSERT INTO serial_number VALUES (57,63);
INSERT INTO serial_number VALUES (58,54);
INSERT INTO serial_number VALUES (59,33);
INSERT INTO serial_number VALUES (60,8);
INSERT INTO serial_number VALUES (61,1);

--
-- Table structure for table 'slot'
--

CREATE TABLE slot (
  id int(2) NOT NULL auto_increment,
  value int(2) default NULL,
  PRIMARY KEY  (id),
  KEY value (value)
) TYPE=MyISAM;

--
-- Dumping data for table 'slot'
--


INSERT INTO slot VALUES (1,-1);
INSERT INTO slot VALUES (2,0);
INSERT INTO slot VALUES (3,1);
INSERT INTO slot VALUES (4,2);
INSERT INTO slot VALUES (5,3);
INSERT INTO slot VALUES (6,4);
INSERT INTO slot VALUES (7,5);
INSERT INTO slot VALUES (8,6);
INSERT INTO slot VALUES (9,7);
INSERT INTO slot VALUES (10,8);
INSERT INTO slot VALUES (11,9);
INSERT INTO slot VALUES (12,10);
INSERT INTO slot VALUES (13,11);
INSERT INTO slot VALUES (14,12);
INSERT INTO slot VALUES (15,13);
INSERT INTO slot VALUES (16,14);
INSERT INTO slot VALUES (17,15);

--
-- Table structure for table 'type'
--

CREATE TABLE type (
  id int(1) NOT NULL auto_increment,
  value char(4) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY value (value)
) TYPE=MyISAM;

--
-- Dumping data for table 'type'
--


INSERT INTO type VALUES (1,'MCCM');
INSERT INTO type VALUES (2,'MCEN');
INSERT INTO type VALUES (3,'MCON');

--
-- Current Database: mcen_user
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ mcen_user;

USE mcen_user;

--
-- Current Database: mysql
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ mysql;

USE mysql;

--
-- Table structure for table 'columns_priv'
--

CREATE TABLE columns_priv (
  Host char(60) binary NOT NULL default '',
  Db char(64) binary NOT NULL default '',
  User char(16) binary NOT NULL default '',
  Table_name char(64) binary NOT NULL default '',
  Column_name char(64) binary NOT NULL default '',
  Timestamp timestamp(14) NOT NULL,
  Column_priv set('Select','Insert','Update','References') NOT NULL default '',
  PRIMARY KEY  (Host,Db,User,Table_name,Column_name)
) TYPE=MyISAM COMMENT='Column privileges';

--
-- Dumping data for table 'columns_priv'
--



--
-- Table structure for table 'db'
--

CREATE TABLE db (
  Host char(60) binary NOT NULL default '',
  Db char(64) binary NOT NULL default '',
  User char(16) binary NOT NULL default '',
  Select_priv enum('N','Y') NOT NULL default 'N',
  Insert_priv enum('N','Y') NOT NULL default 'N',
  Update_priv enum('N','Y') NOT NULL default 'N',
  Delete_priv enum('N','Y') NOT NULL default 'N',
  Create_priv enum('N','Y') NOT NULL default 'N',
  Drop_priv enum('N','Y') NOT NULL default 'N',
  Grant_priv enum('N','Y') NOT NULL default 'N',
  References_priv enum('N','Y') NOT NULL default 'N',
  Index_priv enum('N','Y') NOT NULL default 'N',
  Alter_priv enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (Host,Db,User),
  KEY User (User)
) TYPE=MyISAM COMMENT='Database privileges';

--
-- Dumping data for table 'db'
--


INSERT INTO db VALUES ('%','test','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
INSERT INTO db VALUES ('%','test\\_%','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
INSERT INTO db VALUES ('%','d0stt','anonymous','Y','N','N','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','d0sttmb','d0sttgroup','Y','Y','Y','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','d0stt','d0sttgroup','Y','Y','Y','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','d0sttmb','anonymous','Y','N','N','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','pwcrypt','pwadmin','Y','N','Y','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','d0log','pwadmin','Y','Y','N','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','d0stc','anonymous','Y','N','N','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','d0lb','anonymous','Y','N','N','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','d0user','pwadmin','Y','N','Y','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','d0stc','d0sttgroup','Y','Y','Y','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','d0lb','d0sttgroup','Y','Y','Y','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','d0bc','anonymous','Y','N','N','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','d0bc','d0sttgroup','Y','Y','Y','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','d0frc','anonymous','Y','N','N','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','d0frc','d0sttgroup','Y','Y','Y','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','d0tfc','anonymous','Y','N','N','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','d0tfc','d0sttgroup','Y','Y','Y','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','d0mcen','d0mcen','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
INSERT INTO db VALUES ('%','d0mcen','jkasper','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
INSERT INTO db VALUES ('localhost','d0mcen','d0mcen','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
INSERT INTO db VALUES ('localhost','d0mcen','jkasper','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
INSERT INTO db VALUES ('%','d0mcen','anonymous','Y','N','N','N','N','N','N','N','N','N');
INSERT INTO db VALUES ('%','mcen_user','pwadmin','Y','N','Y','N','N','N','N','N','N','N');

--
-- Table structure for table 'func'
--

CREATE TABLE func (
  name char(64) binary NOT NULL default '',
  ret tinyint(1) NOT NULL default '0',
  dl char(128) NOT NULL default '',
  type enum('function','aggregate') NOT NULL default 'function',
  PRIMARY KEY  (name)
) TYPE=MyISAM COMMENT='User defined functions';

--
-- Dumping data for table 'func'
--



--
-- Table structure for table 'host'
--

CREATE TABLE host (
  Host char(60) binary NOT NULL default '',
  Db char(64) binary NOT NULL default '',
  Select_priv enum('N','Y') NOT NULL default 'N',
  Insert_priv enum('N','Y') NOT NULL default 'N',
  Update_priv enum('N','Y') NOT NULL default 'N',
  Delete_priv enum('N','Y') NOT NULL default 'N',
  Create_priv enum('N','Y') NOT NULL default 'N',
  Drop_priv enum('N','Y') NOT NULL default 'N',
  Grant_priv enum('N','Y') NOT NULL default 'N',
  References_priv enum('N','Y') NOT NULL default 'N',
  Index_priv enum('N','Y') NOT NULL default 'N',
  Alter_priv enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (Host,Db)
) TYPE=MyISAM COMMENT='Host privileges;  Merged with database privileges';

--
-- Dumping data for table 'host'
--



--
-- Table structure for table 'tables_priv'
--

CREATE TABLE tables_priv (
  Host char(60) binary NOT NULL default '',
  Db char(64) binary NOT NULL default '',
  User char(16) binary NOT NULL default '',
  Table_name char(60) binary NOT NULL default '',
  Grantor char(77) NOT NULL default '',
  Timestamp timestamp(14) NOT NULL,
  Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') NOT NULL default '',
  Column_priv set('Select','Insert','Update','References') NOT NULL default '',
  PRIMARY KEY  (Host,Db,User,Table_name),
  KEY Grantor (Grantor)
) TYPE=MyISAM COMMENT='Table privileges';

--
-- Current Database: pwcrypt
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ pwcrypt;

USE pwcrypt;

--
-- Table structure for table 'datetemp'
--

CREATE TABLE datetemp (
  id int(11) NOT NULL auto_increment,
  test_date date default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'datetemp'
--


INSERT INTO datetemp VALUES (1,'2003-03-12');

--
-- Table structure for table 'pwtemp'
--

CREATE TABLE pwtemp (
  id int(11) NOT NULL auto_increment,
  user varchar(16) NOT NULL default '',
  encrypted varchar(16) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'pwtemp'
--


INSERT INTO pwtemp VALUES (1,'temp','3159122976c91f07');

