my super simple AGILE can be used for PM purposes database

PM_agile_method_features_stories_database.sql

		
		--/*
		--features: 
		--	feature_id feature created modified
		--*/
		--/*
		--stories:
		--	story_id story feature_id_fk
		--*/
		--
		--/*
		--story_owners:
		--	story_id user_id
		--*/
		--
		--/*
		--	userse:
		--	user_id user_name password email
		--*/



--more simplified version: (single story per user)
--(can be copy pasted into your database)
CREATE TABLE `tbl_features` (
  `feature_id` int(11) NOT NULL AUTO_INCREMENT,
  `feature` text COLLATE utf8_unicode_ci NOT NULL,
  `created` date NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`feature_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `tbl_stories`;
CREATE TABLE `tbl_stories` (
  `story_id` int(11) NOT NULL AUTO_INCREMENT,
  `story` text COLLATE utf8_unicode_ci NOT NULL,
  `feature_id_fk` int(11) DEFAULT NULL,
  `user_id_fk` int(11) DEFAULT NULL COMMENT 'user who will develop this story',
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`story_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;