modules/erm/erm_projects.mysql

-- MySQL dump 10.9
--
-- Host: localhost    Database: drupal
-- ------------------------------------------------------
-- Server version	4.1.11-Debian_4sarge7-log

--
-- Table structure for table `erm_projects`
--

DROP TABLE IF EXISTS `erm_projects`;
CREATE TABLE `erm_projects` (
  `id` int(4) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `pdesc` mediumtext NOT NULL,
  `rig` varchar(20) NOT NULL default '',
  `proj_mgr` varchar(30) NOT NULL default '',
  `start_date` date NOT NULL default '0000-00-00',
  `end_date` date NOT NULL default '0000-00-00',
  `submitted_by` varchar(60) default NULL,
  `submitted` date default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1	-- MySQL dump 10.9
2	--
3	-- Host: localhost Database: drupal
4	-- ------------------------------------------------------
5	-- Server version 4.1.11-Debian_4sarge7-log
6
7	--
8	-- Table structure for table `erm_projects`
9	--
10
11	DROP TABLE IF EXISTS `erm_projects`;
12	CREATE TABLE `erm_projects` (
13	`id` int(4) NOT NULL auto_increment,
14	`name` varchar(100) NOT NULL default '',
15	`pdesc` mediumtext NOT NULL,
16	`rig` varchar(20) NOT NULL default '',
17	`proj_mgr` varchar(30) NOT NULL default '',
18	`start_date` date NOT NULL default '0000-00-00',
19	`end_date` date NOT NULL default '0000-00-00',
20	`submitted_by` varchar(60) default NULL,
21	`submitted` date default NULL,
22	PRIMARY KEY (`id`)
23	) ENGINE=MyISAM DEFAULT CHARSET=latin1;