MkKanban
Présentation
Une application de kanban board
Télécharger
Télécharger l'application Github
https://github.com/imikado/mkKanban
git clone https://github.com/imikado/mkKanban .
SQL de la base de données
Ci dessous la requête SQL de création de la structure de la base
CREATE DATABASE IF NOT EXISTS `mkKanbanDb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `mkKanbanDb`;
CREATE TABLE `kColumns` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`project_id` int(11) NOT NULL,
`position` int(11) NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE `kProjects` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL,
PRIMARY KEY (id)
) ;
CREATE TABLE `kSprints` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL,
`project_id` int(11) NOT NULL,
`position` int(11) NOT NULL,
PRIMARY KEY (id)
) ;
CREATE TABLE `kTasks` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL,
`description` text NOT NULL,
`column_id` int(11) NOT NULL,
`position` int(11) NOT NULL,
`complexity` int(11) NOT NULL,
PRIMARY KEY (id)
) ;
CREATE TABLE `kTasksInSprints` (
`id` int(11) NOT NULL auto_increment,
`task_id` int(11) NOT NULL,
`sprint_id` int(11) NOT NULL,
PRIMARY KEY (id)
) ;