akshikaakalanka

SQL_Error

May 15th, 2016
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. Error
  2. SQL query:
  3.  
  4.  
  5. CREATE TABLE `active_list` (
  6. `active_list_id` int(11) NOT NULL,
  7. `active_list_type_id` int(11) NOT NULL,
  8. `person_id` int(11) NOT NULL,
  9. `concept_id` int(11) NOT NULL,
  10. `start_obs_id` int(11) DEFAULT NULL,
  11. `stop_obs_id` int(11) DEFAULT NULL,
  12. `start_date` datetime NOT NULL,
  13. `end_date` datetime DEFAULT NULL,
  14. `comments` varchar(255) DEFAULT NULL,
  15. `creator` int(11) NOT NULL,
  16. `date_created` datetime NOT NULL,
  17. `voided` tinyint(1) NOT NULL DEFAULT '0',
  18. `voided_by` int(11) DEFAULT NULL,
  19. `date_voided` datetime DEFAULT NULL,
  20. `void_reason` varchar(255) DEFAULT NULL,
  21. `uuid` char(38) NOT NULL
  22. ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  23. MySQL said: Documentation
  24.  
  25. #1050 - Table 'active_list' already exists
Advertisement
Add Comment
Please, Sign In to add comment