src/hg/qaPushQ/pushQ.sql 1.13

Index: src/hg/qaPushQ/pushQ.sql
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/qaPushQ/pushQ.sql,v
retrieving revision 1.12
retrieving revision 1.13
diff -b -B -U 1000000 -r1.12 -r1.13
--- src/hg/qaPushQ/pushQ.sql	27 Jan 2009 10:36:28 -0000	1.12
+++ src/hg/qaPushQ/pushQ.sql	18 Nov 2009 19:38:56 -0000	1.13
@@ -1,52 +1,52 @@
 # pushQ.sql was originally generated by the autoSql program, which also 
 # generated pushQ.c and pushQ.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #Push Queue
 CREATE TABLE pushQ (
     qid char(6) not null,	# Queue Id
     pqid char(6) not null,	# Parent Queue Id if split off another
     priority char(1) not null,	# Priority
     rank int unsigned not null,	# Rank for display sort
     qadate char(10) not null,	# QA (re)-submission date
     newYN char(1) not null,	# new (track)?
     track varchar(255) not null,	# Track
     dbs varchar(255) not null,	# Databases
     tbls longblob not null,	# Tables
     cgis varchar(255) not null,	# CGI(s)
     files longblob not null,	# File(s)
     sizeMB int unsigned not null,	# Size MB
     currLoc char(20) not null,	# Current Location
     makeDocYN char(1) not null,	# MakeDoc verified?
     onlineHelp char(50) not null,	# Online Help
     ndxYN char(1) not null,	# Index verified?
     joinerYN char(1) not null,	# all.joiner verified?
     stat varchar(255) not null,	# Status
     sponsor char(50) not null,	# Sponsor
     reviewer char(50) not null,	# QA Reviewer
     extSource char(128) not null,	# External Source
     openIssues longblob not null,	# Open issues
     notes longblob not null,	# Notes
     pushState char(1) not null,	# Push State = NYD = No, Yes, Done
     initdate char(10) not null,	# Initial Submission Date
     lastdate char(10) not null,	# Last QA Date
     bounces int unsigned not null,	# Bounce-count (num times bounced back to developer)
     lockUser char(8) not null,	# User who has locked record, or empty string
     lockDateTime char(16) not null,	# When user placed lock, or empty string
     releaseLog longblob not null,	# Release Log entry
     featureBits longblob not null,	# Feature Bits results
     releaseLogUrl longblob not null,	# Release Log URL
               #Indices
     PRIMARY KEY(qid)
 );
 
 #PushQ Users
 CREATE TABLE users (
-    user char(8) not null,	# User
+    user char(16) not null,	# User
     password char(34) not null,	# Password
     role char(8) not null,	# Role=admin,dev,qa
     contents longblob not null,	# pushq-cart contents
               #Indices
     PRIMARY KEY(user)
 );