Advertisement
badlogic

migration script for college dpr

May 22nd, 2017
322
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.42 KB | None | 0 0
  1. //migration script for college dpr
  2.  
  3. CREATE TABLE `college_academic_quarter` (
  4.   `caq_id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
  5.   `caq_open` int(6) NOT NULL,
  6.   `updatedwho` int(10) NOT NULL,
  7.   `sy_id` int(6) NOT NULL,
  8.   `updatedwhen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  9.   `dept_id` int(11) NOT NULL,
  10.   `depttype_id` int(11) NOT NULL,
  11.   `cs_id` int(11) NOT NULL
  12. ) ENGINE='MyISAM' COLLATE 'utf8_general_ci';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement