CREATE TABLE `tickets_tickets` (
  `tickets_id` smallint(5) unsigned NOT NULL auto_increment,
  `tickets_username` varchar(16) NOT NULL default '',
  `tickets_subject` varchar(50) NOT NULL default '',
  `tickets_timestamp` bigint(10) unsigned NOT NULL default '0',
  `tickets_status` varchar(10) NOT NULL default '',
  `tickets_name` varchar(50) NOT NULL default '',
  `tickets_email` varchar(50) NOT NULL default '',
  `tickets_urgency` enum('Low','Medium','High','Very High') NOT NULL default 'Low',
  `tickets_admin` varchar(20) NOT NULL default '',
  `tickets_child` smallint(5) unsigned NOT NULL default '0',
  `tickets_question` text NOT NULL,
  PRIMARY KEY  (`tickets_id`),
  KEY `tickets_username` (`tickets_username`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `tickets_users`
#

CREATE TABLE `tickets_users` (
  `tickets_users_id` tinyint(3) unsigned NOT NULL auto_increment,
  `tickets_users_name` varchar(50) NOT NULL default '',
  `tickets_users_username` varchar(16) NOT NULL default '',
  `tickets_users_password` varchar(16) NOT NULL default '',
  `tickets_users_email` varchar(100) NOT NULL default '',
  `tickets_users_status` tinyint(1) unsigned NOT NULL default '1',
  PRIMARY KEY  (`tickets_users_id`),
  KEY `tickets_users_username` (`tickets_users_username`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
