1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| CREATE TABLE IF NOT EXISTS `work_assign` (
`idassign` smallint(3) NOT NULL AUTO_INCREMENT,
`idprofil` smallint(3) NOT NULL,
`title_assign` varchar(50) NOT NULL,
`desc_assign` varchar(150) NOT NULL,
`date_assign` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`statut_assign` smallint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`idassign`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Contenu de la table `work_assign`
--
INSERT INTO `work_assign` (`idassign`, `idprofil`, `title_assign`, `desc_assign`, `date_assign`, `statut_assign`) VALUES
(1, 1, 'projet de test', 'projet de test pour savoir si sa fonctionne', '2009-03-29 17:17:01', 1),
(2, 1, 'autre test', 'autre test, d un petit test accordeon', '2009-03-29 17:31:06', 1),
(3, 0, 'travail supplementaire', 'apercu d un travail termine', '2009-03-29 18:28:42', 2),
(4, 0, 'travail supplementaire', 'apercu d un travail termine', '2009-03-29 18:29:36', 2),
(5, 1, 'travail supplementaire', 'apercu d un travail termine', '2009-03-29 18:30:54', 2); |
Partager