-- Timestamp MySQL Format: 0000-00-00 00:00:00

-- Command Line Syntax

-- Create Database workflow

-- MySQL -u username -p
-- enter password: password
-- CREATE DATABASE workflow;

-- Grant Priviledges for user
-- GRANT ALL ON workflow.* TO 'user'*'serverhost' IDENTIFIED BY 'password';



-- Workflow database structure file
-- to be inlcuded

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `workflow`
-- 

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

-- 
-- Table structure for table `wf_projects`
-- 

CREATE TABLE `wf_projects` (
  `pr_iKey` int(11) NOT NULL auto_increment,
  `pr_iCreatedBy` int(11) default NULL,
  `pr_sName` varchar(35) default NULL,
  `pr_sDescription` text,
  `pr_iStatus` int(3) default '0',
  `pr_iCritical` int(3) default '0',
  `pr_tCreate` timestamp NOT NULL default '0000-00-00 00:00:00',
  `pr_tModify` timestamp NOT NULL default '0000-00-00 00:00:00',
  `pr_tFinish` timestamp NOT NULL default '0000-00-00 00:00:00',
  `pr_iCompletedBy` int(11) default NULL,
  `pr_iSignedOff` int(1) default '0',
  `pr_tDeadLine` timestamp NOT NULL default '0000-00-00 00:00:00',
  `pr_tMoneyOffer` decimal(8,2) NOT NULL default '0.00',
  `pr_allusers` int(11) default '0',
  PRIMARY KEY  (`pr_iKey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `wf_projects`
-- 


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

-- 
-- Table structure for table `wf_projusers`
-- 

CREATE TABLE `wf_projusers` (
  `pu_iKey` int(11) NOT NULL auto_increment,
  `pu_iUserID` int(11) NOT NULL,
  `pu_iProjID` int(11) NOT NULL,
  PRIMARY KEY  (`pu_iKey`),
  KEY `pu_iUserID` (`pu_iUserID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `wf_projusers`
-- 


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

-- 
-- Table structure for table `wf_projwork`
-- 

CREATE TABLE `wf_projwork` (
  `pw_iKey` int(11) NOT NULL auto_increment,
  `pw_iUserID` int(11) default NULL,
  `pw_iProjID` int(11) default NULL,
  `pw_sTimeEstimate` varchar(11) default '00:00:00:00',
  `pw_sMoneyEstimate` decimal(8,2) default '0.00',
  `pw_tTimeCreate` timestamp NULL default NULL,
  `pw_tTimeModify` timestamp NULL default NULL,
  `pw_sNote` text,
  PRIMARY KEY  (`pw_iKey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `wf_projwork`
-- 


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

-- 
-- Table structure for table `wf_PTime`
-- 

CREATE TABLE `wf_PTime` (
  `pt_iKey` int(11) NOT NULL,
  `pt_iUserID` int(11) NOT NULL,
  `pt_iProjID` int(11) NOT NULL,
  `pt_tTimeStart` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `pt_tTimeStop` timestamp NOT NULL default '0000-00-00 00:00:00',
  `pt_tModStart` timestamp NOT NULL default '0000-00-00 00:00:00',
  `pt_tModStop` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`pt_iKey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `wf_PTime`
-- 


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

-- 
-- Table structure for table `wf_users`
-- 

CREATE TABLE `wf_users` (
  `us_iKey` int(11) NOT NULL auto_increment,
  `us_sUserName` varchar(20) default NULL,
  `us_sPassword` varchar(20) default NULL,
  `us_sNameFirst` varchar(20) default NULL,
  `us_sNameLast` varchar(20) default NULL,
  `us_sEmail` varchar(35) default NULL,
  `us_sAddress` varchar(35) default NULL,
  `us_sCity` varchar(20) default NULL,
  `us_sState` varchar(5) default NULL,
  `us_sZip` varchar(10) default NULL,
  `us_sPhone` varchar(15) default NULL,
  `us_sCName` varchar(35) default NULL,
  `us_sCAddress` varchar(35) default NULL,
  `us_sCCity` varchar(20) default NULL,
  `us_sCState` varchar(5) default NULL,
  `us_sCZip` varchar(10) default NULL,
  `us_sCPhone` varchar(15) default NULL,
  `us_sCWebAddress` varchar(35) default NULL,
  `us_iStatus` int(3) NOT NULL default '0',
  `us_sTemplate` varchar(20) default NULL,
  PRIMARY KEY  (`us_iKey`),
  UNIQUE KEY `us_sUserName` (`us_sUserName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `wf_users`
-- 


mysql -u root -p your_db < tabledata.sql

