-- MySQL dump 8.22
--
-- Host: localhost    Database: status_test
---------------------------------------------------------
-- Server version	3.23.52-Max-log

--
-- Table structure for table 'DamageData'
--


--
-- Table structure for table 'conflict'
--

DROP TABLE IF EXISTS conflict;
CREATE TABLE conflict (
  conflictid int(11) NOT NULL auto_increment,
  explanation varchar(255) default NULL,
  PRIMARY KEY  (conflictid)
) TYPE=MyISAM;

--
-- Dumping data for table 'conflict'
--


INSERT INTO conflict VALUES (1,NULL);
INSERT INTO conflict VALUES (2,NULL);

--
-- Table structure for table 'conflict_context'
--

DROP TABLE IF EXISTS conflict_context;
CREATE TABLE conflict_context (
  conflictid int(11) NOT NULL default '0',
  valueid int(11) NOT NULL default '0',
  PRIMARY KEY  (conflictid,valueid),
  KEY conflictid (conflictid),
  KEY valueid (valueid)
) TYPE=MyISAM;

--
-- Dumping data for table 'conflict_context'
--


INSERT INTO conflict_context VALUES (2,3);

--
-- Table structure for table 'conflict_error'
--

DROP TABLE IF EXISTS conflict_error;
CREATE TABLE conflict_error (
  conflictid int(11) NOT NULL default '0',
  valueid int(11) NOT NULL default '0',
  PRIMARY KEY  (conflictid,valueid),
  KEY valueid (valueid),
  KEY conflictid (conflictid)
) TYPE=MyISAM;

--
-- Dumping data for table 'conflict_error'
--


INSERT INTO conflict_error VALUES (1,1);
INSERT INTO conflict_error VALUES (1,2);
INSERT INTO conflict_error VALUES (2,4);

--
-- Table structure for table 'conflict_obmission'
--

DROP TABLE IF EXISTS conflict_obmission;
CREATE TABLE conflict_obmission (
  conflictid int(11) NOT NULL default '0',
  valueid int(11) NOT NULL default '0',
  PRIMARY KEY  (conflictid,valueid),
  KEY conflictid (conflictid),
  KEY valueid (valueid)
) TYPE=MyISAM;

--
-- Dumping data for table 'conflict_obmission'
--


INSERT INTO conflict_obmission VALUES (2,5);

--
-- Table structure for table 'fixture'
--

DROP TABLE IF EXISTS fixture;
CREATE TABLE fixture (
  id int(11) NOT NULL auto_increment,
  type varchar(255) NOT NULL default '',
  name varchar(255) default NULL,
  projectid int(11) default NULL,
  PRIMARY KEY  (id),
  KEY projectid (projectid)
) TYPE=MyISAM;

--
-- Dumping data for table 'fixture'
--


INSERT INTO fixture VALUES (1,'sewer','first67890',1);
INSERT INTO fixture VALUES (2,'sewer','sec4567890',1);

--
-- Table structure for table 'fixture_attributes'
--

DROP TABLE IF EXISTS fixture_attributes;
CREATE TABLE fixture_attributes (
  fixtureid int(11) NOT NULL default '0',
  value varchar(255) default NULL,
  name varchar(255) NOT NULL default '',
  PRIMARY KEY  (fixtureid,name),
  KEY fixtureid (fixtureid)
) TYPE=MyISAM;

--
-- Dumping data for table 'fixture_attributes'
--



--
-- Table structure for table 'headerconflict'
--

DROP TABLE IF EXISTS headerconflict;
CREATE TABLE headerconflict (
  id int(11) NOT NULL auto_increment,
  type varchar(255) NOT NULL default '',
  inspectionid int(11) default NULL,
  description varchar(255) default NULL,
  rawconflict int(11) default NULL,
  PRIMARY KEY  (id),
  KEY rawconflict (rawconflict),
  KEY inspectionid (inspectionid)
) TYPE=MyISAM;

--
-- Dumping data for table 'headerconflict'
--


INSERT INTO headerconflict VALUES (1,'com.infodesire.status.project.impl.HeaderConflictData',1,NULL,1);
INSERT INTO headerconflict VALUES (2,'com.infodesire.status.project.impl.HeaderConflictData',2,NULL,2);

--
-- Table structure for table 'impobjinf'
--

DROP TABLE IF EXISTS impobjinf;
CREATE TABLE impobjinf (
  impobjinf int(11) NOT NULL auto_increment,
  filePath varchar(255) default NULL,
  objectCount int(11) default NULL,
  totalRecordCount int(11) default NULL,
  correctRecordCount int(11) default NULL,
  invalidRecordCount int(11) default NULL,
  PRIMARY KEY  (impobjinf)
) TYPE=MyISAM;

--
-- Dumping data for table 'impobjinf'
--


INSERT INTO impobjinf VALUES (1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO impobjinf VALUES (2,NULL,NULL,NULL,NULL,NULL);
INSERT INTO impobjinf VALUES (3,NULL,NULL,NULL,NULL,NULL);
INSERT INTO impobjinf VALUES (4,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table 'importinfo'
--

DROP TABLE IF EXISTS importinfo;
CREATE TABLE importinfo (
  importinfoid int(11) NOT NULL auto_increment,
  length decimal(10,2) default NULL,
  errors int(11) default NULL,
  sewerbase int(11) default NULL,
  sewerinsp int(11) default NULL,
  drainbase int(11) default NULL,
  draininsp int(11) default NULL,
  PRIMARY KEY  (importinfoid),
  KEY sewerbase (sewerbase),
  KEY drainbase (drainbase),
  KEY sewerinsp (sewerinsp),
  KEY draininsp (draininsp)
) TYPE=MyISAM;

--
-- Dumping data for table 'importinfo'
--


INSERT INTO importinfo VALUES (1,NULL,NULL,1,2,3,4);

--
-- Table structure for table 'importrec'
--

DROP TABLE IF EXISTS importrec;
CREATE TABLE importrec (
  importrecid int(11) NOT NULL auto_increment,
  projectid int(11) default NULL,
  rectypeid int(11) default NULL,
  PRIMARY KEY  (importrecid),
  KEY rectypeid (rectypeid),
  KEY projectid (projectid)
) TYPE=MyISAM;

--
-- Dumping data for table 'importrec'
--


INSERT INTO importrec VALUES (1,1,1);
INSERT INTO importrec VALUES (2,1,2);
INSERT INTO importrec VALUES (3,1,1);
INSERT INTO importrec VALUES (4,1,1);
INSERT INTO importrec VALUES (5,1,2);
INSERT INTO importrec VALUES (6,1,1);
INSERT INTO importrec VALUES (7,1,2);
INSERT INTO importrec VALUES (8,1,1);
INSERT INTO importrec VALUES (9,1,2);

--
-- Table structure for table 'imprec_sewerinsps'
--

DROP TABLE IF EXISTS imprec_sewerinsps;
CREATE TABLE imprec_sewerinsps (
  imprecid int(11) NOT NULL default '0',
  inspectionid int(11) NOT NULL default '0',
  PRIMARY KEY  (imprecid,inspectionid),
  KEY imprecid (imprecid),
  KEY inspectionid (inspectionid)
) TYPE=MyISAM;

--
-- Dumping data for table 'imprec_sewerinsps'
--


INSERT INTO imprec_sewerinsps VALUES (7,2);
INSERT INTO imprec_sewerinsps VALUES (8,1);
INSERT INTO imprec_sewerinsps VALUES (8,2);
INSERT INTO imprec_sewerinsps VALUES (9,1);
INSERT INTO imprec_sewerinsps VALUES (9,2);

--
-- Table structure for table 'imprec_sewlininsps'
--

DROP TABLE IF EXISTS imprec_sewlininsps;
CREATE TABLE imprec_sewlininsps (
  imprecid int(11) NOT NULL default '0',
  damageid int(11) NOT NULL default '0',
  PRIMARY KEY  (imprecid,damageid),
  KEY damageid (damageid),
  KEY imprecid (imprecid)
) TYPE=MyISAM;

--
-- Dumping data for table 'imprec_sewlininsps'
--



--
-- Table structure for table 'imprectype'
--

DROP TABLE IF EXISTS imprectype;
CREATE TABLE imprectype (
  imprectypeid int(11) NOT NULL auto_increment,
  name varchar(255) default NULL,
  projectid int(11) default NULL,
  PRIMARY KEY  (imprectypeid),
  KEY projectid (projectid)
) TYPE=MyISAM;

--
-- Dumping data for table 'imprectype'
--


INSERT INTO imprectype VALUES (1,'U',1);
INSERT INTO imprectype VALUES (2,'V',1);

--
-- Table structure for table 'imprectype_propnames'
--

DROP TABLE IF EXISTS imprectype_propnames;
CREATE TABLE imprectype_propnames (
  imprectypeid int(11) NOT NULL default '0',
  propname varchar(255) default NULL,
  KEY imprectypeid (imprectypeid)
) TYPE=MyISAM;

--
-- Dumping data for table 'imprectype_propnames'
--


INSERT INTO imprectype_propnames VALUES (1,'h-3-material');
INSERT INTO imprectype_propnames VALUES (1,'h-3-innenschutz');
INSERT INTO imprectype_propnames VALUES (2,'h-3-untersuchungsrichtung');
INSERT INTO imprectype_propnames VALUES (2,'h-3-profilart');

--
-- Table structure for table 'inspection'
--

DROP TABLE IF EXISTS inspection;
CREATE TABLE inspection (
  id int(11) NOT NULL auto_increment,
  fixtureid int(11) default NULL,
  PRIMARY KEY  (id),
  KEY fixtureid (fixtureid)
) TYPE=MyISAM;

--
-- Dumping data for table 'inspection'
--


INSERT INTO inspection VALUES (1,1);
INSERT INTO inspection VALUES (2,1);

--
-- Table structure for table 'inspection_attributes'
--

DROP TABLE IF EXISTS inspection_attributes;
CREATE TABLE inspection_attributes (
  fixtureid int(11) NOT NULL default '0',
  value varchar(255) default NULL,
  name varchar(255) NOT NULL default '',
  PRIMARY KEY  (fixtureid,name),
  KEY fixtureid (fixtureid)
) TYPE=MyISAM;

--
-- Dumping data for table 'inspection_attributes'
--



--
-- Table structure for table 'project'
--

DROP TABLE IF EXISTS project;
CREATE TABLE project (
  id int(11) NOT NULL auto_increment,
  client varchar(255) default NULL,
  user_name varchar(255) NOT NULL default '',
  procstate smallint(6) NOT NULL default '0',
  importInfo int(11) default NULL,
  moddate date NOT NULL default '0000-00-00',
  group_name varchar(255) NOT NULL default '',
  name varchar(255) default NULL,
  description varchar(255) default NULL,
  PRIMARY KEY  (id),
  KEY importInfo (importInfo)
) TYPE=MyISAM;

--
-- Dumping data for table 'project'
--


INSERT INTO project VALUES (1,'no client','foo',0,1,'2004-05-18','bar','reccnt-tester','Records counting test');

--
-- Table structure for table 'value'
--

DROP TABLE IF EXISTS value;
CREATE TABLE value (
  valueid int(11) NOT NULL auto_increment,
  keystring varchar(255) default NULL,
  value varchar(255) default NULL,
  PRIMARY KEY  (valueid)
) TYPE=MyISAM;

--
-- Dumping data for table 'value'
--


INSERT INTO value VALUES (1,'h-3-material','x');
INSERT INTO value VALUES (2,'h-3-untersuchungsrichtung','y');
INSERT INTO value VALUES (3,'h-3-profilart','a');
INSERT INTO value VALUES (4,'h-3-innenschutz','x');
INSERT INTO value VALUES (5,'h-3-untersuchungsrichtung',NULL);