Advertisement
Guest User

Untitled

a guest
May 19th, 2019
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.72 KB | None | 0 0
  1. -- Adminer 4.7.1 MySQL dump
  2.  
  3. SET NAMES utf8;
  4. SET time_zone = '+00:00';
  5. SET foreign_key_checks = 0;
  6. SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
  7.  
  8. SET NAMES utf8mb4;
  9.  
  10. DROP TABLE IF EXISTS `ATTACHEMENTS`;
  11. CREATE TABLE `ATTACHEMENTS` (
  12.   `BDZID` INT(11) NOT NULL,
  13.   `CODE_MO` INT(6) NOT NULL,
  14.   `INFO_TYPE` INT(1) NOT NULL,
  15.   `ATTACH_DT_MO` DATE NOT NULL,
  16.   `DETACH_DT_MO` DATE DEFAULT NULL,
  17.   `DETACH_CAUSE_MO` INT(11) DEFAULT NULL,
  18.   `PODR` INT(11) NOT NULL,
  19.   `OTD` INT(11) NOT NULL,
  20.   `UCH` INT(11) NOT NULL,
  21.   `UCH_TYPE` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
  22.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  23.   PRIMARY KEY (`id`)
  24. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  25.  
  26.  
  27. -- 2019-05-19 11:29:39
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement