»

todo

todo —

todo

Column nameTypeNullDefaultDescription
todoidint unsigned auto_increment  
journalidint unsigned 0 
posteridint unsigned 0 
owneridint unsigned 0 
statuslinevarchar(40)  
securityenum('public','private','friends') public 
subjectvarchar(100)  
desvarchar(255)  
priorityenum('1','2','3','4','5') 3 
datecreatedatetime 0000-00-00 00:00:00 
dateupdatedatetimeYES 
dateduedatetimeYES 
datecloseddatetimeYES 
progresstinyint unsigned 0 
Key nameTypeColumn(s)
PRIMARYPRIMARY
journalidINDEX
owneridINDEX
posteridINDEX