-- phpMyAdmin SQL Dump
-- version 2.6.0-rc2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Erstellungszeit: 17. September 2004 um 13:05
-- Server Version: 4.0.18
-- PHP-Version: 5.0.0
-- 
-- Datenbank: `Cuteflow`
-- 

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `cf_attachment`
-- 

DROP TABLE IF EXISTS `cf_attachment`;
CREATE TABLE IF NOT EXISTS `cf_attachment` (
  `nID` int(11) NOT NULL auto_increment,
  `strPath` text NOT NULL,
  `nCirculationHistoryId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`nID`),
  UNIQUE KEY `nID` (`nID`),
  KEY `nID_2` (`nID`)
) TYPE=MyISAM AUTO_INCREMENT=56 ;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `cf_circulationform`
-- 

DROP TABLE IF EXISTS `cf_circulationform`;
CREATE TABLE IF NOT EXISTS `cf_circulationform` (
  `nID` int(11) NOT NULL auto_increment,
  `nSenderId` int(11) NOT NULL default '0',
  `strName` text NOT NULL,
  `nMailingListId` int(11) NOT NULL default '0',
  `bIsArchived` tinyint(4) NOT NULL default '0',
  `nEndAction` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`nID`),
  UNIQUE KEY `nID` (`nID`),
  KEY `nID_2` (`nID`)
) TYPE=MyISAM AUTO_INCREMENT=261 ;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `cf_circulationhistory`
-- 

DROP TABLE IF EXISTS `cf_circulationhistory`;
CREATE TABLE IF NOT EXISTS `cf_circulationhistory` (
  `nID` int(11) NOT NULL auto_increment,
  `nRevisionNumber` int(11) NOT NULL default '0',
  `dateSending` date NOT NULL default '0000-00-00',
  `strAdditionalText` text NOT NULL,
  `nCirculationFormId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`nID`)
) TYPE=MyISAM AUTO_INCREMENT=21 ;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `cf_circulationprocess`
-- 

DROP TABLE IF EXISTS `cf_circulationprocess`;
CREATE TABLE IF NOT EXISTS `cf_circulationprocess` (
  `nID` int(11) NOT NULL auto_increment,
  `nCirculationFormId` int(11) NOT NULL default '0',
  `nSlotId` int(11) NOT NULL default '0',
  `nUserId` int(11) NOT NULL default '0',
  `dateInProcessSince` date NOT NULL default '0000-00-00',
  `nDecissionState` tinyint(4) NOT NULL default '0',
  `dateDecission` date NOT NULL default '0000-00-00',
  `nIsSubstitiuteOf` int(11) NOT NULL default '0',
  `nCirculationHistoryId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`nID`)
) TYPE=MyISAM AUTO_INCREMENT=1012 ;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `cf_fieldvalue`
-- 

DROP TABLE IF EXISTS `cf_fieldvalue`;
CREATE TABLE IF NOT EXISTS `cf_fieldvalue` (
  `nID` int(11) NOT NULL auto_increment,
  `nInputFieldId` int(11) NOT NULL default '0',
  `strFieldValue` text NOT NULL,
  `nSlotId` int(11) NOT NULL default '0',
  `nFormId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`nID`),
  UNIQUE KEY `nID` (`nID`),
  KEY `nID_2` (`nID`)
) TYPE=MyISAM AUTO_INCREMENT=4083 ;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `cf_formslot`
-- 

DROP TABLE IF EXISTS `cf_formslot`;
CREATE TABLE IF NOT EXISTS `cf_formslot` (
  `nID` int(11) NOT NULL auto_increment,
  `strName` tinytext NOT NULL,
  `nTemplateId` int(11) NOT NULL default '0',
  `nSlotNumber` int(11) NOT NULL default '0',
  PRIMARY KEY  (`nID`),
  UNIQUE KEY `nID` (`nID`),
  KEY `nID_2` (`nID`)
) TYPE=MyISAM AUTO_INCREMENT=28 ;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `cf_formtemplate`
-- 

DROP TABLE IF EXISTS `cf_formtemplate`;
CREATE TABLE IF NOT EXISTS `cf_formtemplate` (
  `nID` int(11) NOT NULL auto_increment,
  `strName` tinytext NOT NULL,
  PRIMARY KEY  (`nID`),
  UNIQUE KEY `nID` (`nID`),
  KEY `nID_2` (`nID`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `cf_inputfield`
-- 

DROP TABLE IF EXISTS `cf_inputfield`;
CREATE TABLE IF NOT EXISTS `cf_inputfield` (
  `nID` int(11) NOT NULL auto_increment,
  `strName` tinytext NOT NULL,
  `nType` int(11) NOT NULL default '0',
  `strStandardValue` text NOT NULL,
  `bReadOnly` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`nID`),
  UNIQUE KEY `nID` (`nID`),
  KEY `nID_2` (`nID`)
) TYPE=MyISAM AUTO_INCREMENT=57 ;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `cf_mailinglist`
-- 

DROP TABLE IF EXISTS `cf_mailinglist`;
CREATE TABLE IF NOT EXISTS `cf_mailinglist` (
  `nID` int(11) NOT NULL auto_increment,
  `strName` text NOT NULL,
  `nTemplateId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`nID`)
) TYPE=MyISAM AUTO_INCREMENT=51 ;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `cf_slottofield`
-- 

DROP TABLE IF EXISTS `cf_slottofield`;
CREATE TABLE IF NOT EXISTS `cf_slottofield` (
  `nID` int(11) NOT NULL auto_increment,
  `nSlotId` int(11) NOT NULL default '0',
  `nFieldId` int(11) NOT NULL default '0',
  `strStandardValue` text NOT NULL,
  `bReadOnly` tinyint(4) NOT NULL default '0',
  `bMandantory` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`nID`)
) TYPE=MyISAM AUTO_INCREMENT=2208 ;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `cf_slottouser`
-- 

DROP TABLE IF EXISTS `cf_slottouser`;
CREATE TABLE IF NOT EXISTS `cf_slottouser` (
  `nID` int(11) NOT NULL auto_increment,
  `nSlotId` int(11) NOT NULL default '0',
  `nMailingListId` int(11) NOT NULL default '0',
  `nUserId` int(11) NOT NULL default '0',
  `nPosition` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`nID`),
  UNIQUE KEY `nID` (`nID`),
  KEY `nID_2` (`nID`)
) TYPE=MyISAM AUTO_INCREMENT=1266 ;

-- --------------------------------------------------------

-- 
-- Tabellenstruktur für Tabelle `cf_user`
-- 

DROP TABLE IF EXISTS `cf_user`;
CREATE TABLE IF NOT EXISTS `cf_user` (
  `nID` int(11) NOT NULL auto_increment,
  `strLastName` tinytext NOT NULL,
  `strFirstName` tinytext NOT NULL,
  `strEMail` tinytext NOT NULL,
  `nAccessLevel` int(11) NOT NULL default '0',
  `strUserId` tinytext NOT NULL,
  `strPassword` tinytext NOT NULL,
  `nSubstitudeId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`nID`),
  UNIQUE KEY `nID` (`nID`),
  KEY `nID_2` (`nID`)
) TYPE=MyISAM AUTO_INCREMENT=40 ;
        
  
INSERT INTO `cf_user` VALUES (12, 'None', 'Administrator', '', 2, 'admin', '21232f297a57a5a743894a0e4a801fc3', 0);