text: 	DROP TABLE IF EXISTS `Requirement`;
  
  	/*!40101 SET @saved_cs_client     = @@character_set_client */;
  	/*!40101 SET character_set_client = utf8 */;
  	CREATE TABLE `Requirement` (
  
      `RequirementId`   	bigint         NOT NULL UNIQUE
    	, `SeqId`				bigint 			NOT NULL 
    	, `Level`				smallint 		NOT NULL 
     , `LeftRank`			bigint			NOT NULL
   	, `RightRank`			bigint			NOT NULL
  	, `Prio`            	smallint       NOT NULL
  	, `Name`            	varchar(200)   NOT NULL
  	, `DeadLine` datetime 	DEFAULT NULL
  	, `Description`     	varchar(4000)  NOT NULL
  	, `Weight`          	smallint       DEFAULT NULL
  	, `UpdateTime` 		datetime 		DEFAULT NULL	
  
  	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  	/*!40101 SET character_set_client = @saved_cs_client */;
  
  
  	-- now check that the table exists 
  	SELECT 'if the name is shown bellow the table has been created' ; 
  	SHOW TABLES LIKE 'Requirement';
  
  
  	-- now check that the table exists 
  	SHOW TABLES LIKE 'Requirement';
  	
  	SELECT FOUND_ROWS() AS 'FOUND'  ;
  
  	-- NOW CHECK THE COLUMNS
  	SELECT CONCAT ( TABLE_NAME  , '.' , COLUMN_NAME  )
  	AS 'TABLE.COLUMNS'
  	from information_schema.COLUMNS
  	WHERE 1=1
  	AND TABLE_SCHEMA=DATABASE()
  	AND TABLE_NAME='Requirement' ; 
  