# CocoaMySQL dump
# Version 0.5
# http://cocoamysql.sourceforge.net
#
# Host: localhost (MySQL 4.0.21-standard)
# Database: BaseWODatabase
# Generation Time: 2006-04-10 12:16:56 +0200
# ************************************************************

# Dump of table EO_PK_TABLE
# ------------------------------------------------------------

CREATE TABLE `EO_PK_TABLE` (
  `NAME` char(40) NOT NULL default '',
  `PK` int(11) default NULL,
  PRIMARY KEY  (`NAME`)
) TYPE=MyISAM;



# Dump of table EXPERTFILTER
# ------------------------------------------------------------

CREATE TABLE `EXPERTFILTER` (
  `FILTER_NAME` varchar(64) NOT NULL default '',
  `ENTITY` varchar(32) NOT NULL default '',
  `FILTER_DATA` blob NOT NULL,
  `FK_MANDANT` int(11) default NULL,
  `FK_PERSON_CREATED` int(11) default NULL,
  `PK_EXPERT_FILTER` int(11) NOT NULL default '0',
  PRIMARY KEY  (`PK_EXPERT_FILTER`)
) TYPE=MyISAM;



# Dump of table PROTOTYPES
# ------------------------------------------------------------

CREATE TABLE `PROTOTYPES` (
  `ABSOLUT_PATH` varchar(255) NOT NULL default '',
  `ANYVALUE` char(3) NOT NULL default '',
  `BOOLVALUE` varchar(5) NOT NULL default '',
  `COLOR` varchar(8) NOT NULL default '',
  `CREATE_DATE` date NOT NULL default '0000-00-00',
  `CREATE_TIME` time NOT NULL default '00:00:00',
  `CURRENCY` decimal(17,2) NOT NULL default '0.00',
  `DATE` date NOT NULL default '0000-00-00',
  `DATE_FROM` date NOT NULL default '0000-00-00',
  `FK_` bigint(20) NOT NULL default '0',
  `FK_CREATOR` bigint(20) NOT NULL default '0',
  `FK_UPDATER` bigint(20) NOT NULL default '0',
  `FLOAT_` float NOT NULL default '0',
  `INTTYPE` int(11) NOT NULL default '0',
  `LONGTYPE` bigint(20) NOT NULL default '0',
  `MAIL` varchar(128) NOT NULL default '',
  `MEMO` text NOT NULL,
  `MOBILE` varchar(24) NOT NULL default '',
  `PATH` varchar(80) NOT NULL default '',
  `PERCENT` decimal(3,2) NOT NULL default '0.00',
  `PHONE` varchar(16) NOT NULL default '',
  `PK_` bigint(20) NOT NULL default '0',
  `STRING128` varchar(128) NOT NULL default '',
  `STRING16` varchar(16) NOT NULL default '',
  `STRING32` varchar(32) NOT NULL default '',
  `STRING64` varchar(64) NOT NULL default '',
  `TIME` time NOT NULL default '00:00:00',
  `TIME_FROM` time NOT NULL default '00:00:00',
  `UPDATE_DATE` date NOT NULL default '0000-00-00',
  `UPDATE_TIME` time NOT NULL default '00:00:00',
  PRIMARY KEY  (`PK_`)
) TYPE=MyISAM;



# Dump of table SAMPLERELATEDTABLE
# ------------------------------------------------------------

CREATE TABLE `SAMPLERELATEDTABLE` (
  `AVALUE` char(3) NOT NULL default '',
  `BOOLVALUE` varchar(5) NOT NULL default '',
  `PK_RELATEDSAMPLE` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`PK_RELATEDSAMPLE`)
) TYPE=MyISAM;



# Dump of table SAMPLETABLE
# ------------------------------------------------------------

CREATE TABLE `SAMPLETABLE` (
  `AVALUE` char(3) NOT NULL default '',
  `BOOLVALUE` varchar(5) NOT NULL default '',
  `PK_SAMPLE` bigint(20) NOT NULL default '0',
  `FK_RELATED_TABLE` bigint(20) default NULL,
  PRIMARY KEY  (`PK_SAMPLE`)
) TYPE=MyISAM;

INSERT INTO `SAMPLETABLE` (`AVALUE`,`BOOLVALUE`,`PK_SAMPLE`,`FK_RELATED_TABLE`) VALUES ("a","false","1",NULL);
INSERT INTO `SAMPLETABLE` (`AVALUE`,`BOOLVALUE`,`PK_SAMPLE`,`FK_RELATED_TABLE`) VALUES ("b","true","2",NULL);


# Dump of table _DBUPDATER
# ------------------------------------------------------------

CREATE TABLE `_DBUPDATER` (
  `UPDATE_LOCK` int(11) NOT NULL default '0',
  `VERSION` int(11) NOT NULL default '0'
) TYPE=MyISAM;

INSERT INTO `_DBUPDATER` (`UPDATE_LOCK`,`VERSION`) VALUES ("0","2");