# phpMyAdmin MySQL-Dump
# version 2.2.4
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: localhost
# Generation Time: May 17, 2002 at 07:33 AM
# Server version: 3.23.49
# PHP Version: 4.1.1
# Database : `phptest`
# --------------------------------------------------------

#
# Table structure for table `groups`
#

--DROP TABLE IF EXISTS groups;
--CREATE TABLE groups (
--  g_id tinyint(4) NOT NULL auto_increment,
--  description varchar(50) NOT NULL default '',
--  PRIMARY KEY  (g_id)
--) TYPE=MyISAM;

#
# Dumping data for table `groups`
#

--INSERT INTO groups VALUES (1, 'Tier 1 tech support');
--INSERT INTO groups VALUES (2, 'Tier 2 tech support');
--INSERT INTO groups VALUES (3, 'Supervisors');
# --------------------------------------------------------

#
# Table structure for table `questions`
#

DROP TABLE IF EXISTS questions;
CREATE TABLE questions (
  q_id int(11) NOT NULL auto_increment,
  m_id int(11) NOT NULL default '0',
  required enum('yes','no') NOT NULL default 'no',
  type enum('Multiple Choice','True or False','Essay') NOT NULL default 'Essay',
  weight tinyint(4) NOT NULL default '1',
  question text NOT NULL,
  answer text NOT NULL,
  alt_1 text NOT NULL,
  alt_2 text NOT NULL,
  alt_3 text NOT NULL,
  PRIMARY KEY  (q_id),
  FOREIGN KEY  (m_id) REFERENCES modules
) TYPE=MyISAM;

#
# Dumping data for table `questions`
#

INSERT INTO questions VALUES (1, 1, 'no', 'Multiple Choice', 1, 'What does GNU stand for?', 'Gnu\'s not Unix', 'General nondescript unix', 'Generic new Unix', 'Gotta new U-Boataaaa');
INSERT INTO questions VALUES (2, 1, 'yes', 'True or False', 1, 'Linux is a tradmark of Linus Torvalds', 'True', 'empty', 'empty', 'empty');
INSERT INTO questions VALUES (3, 1, 'yes', 'True or False', 3, 'Maplebot, by Adrian Montero, is a 1337 bot written in C', 'True', 'empty', 'empty', 'empty');
INSERT INTO questions VALUES (4, 1, 'no', 'Multiple Choice', 1, 'What package management software does Debian use?', 'APT, the advanced package took', 'RPM, the Redhat Package Manager', 'the Ports system', 'You have to compile from source');
INSERT INTO questions VALUES (5, 1, 'yes', 'True or False', 4, 'Redhat was the first Linux distribution', 'False', 'empty', 'empty', 'empty');
INSERT INTO questions VALUES (6, 1, 'yes', 'Multiple Choice', 2, 'What is the command to list all files in a directory in Linux?', 'ls -a', 'ls', 'ls -l', 'ls --color');
INSERT INTO questions VALUES (7, 1, 'yes', 'Multiple Choice', 2, 'What is the command to view the current process list?', 'ps', 'grep ', 'rm', 'ustat');
INSERT INTO questions VALUES (8, 1, 'no', 'True or False', 5, 'Emacs is a better editor than VI', 'True', 'empty', 'empty', 'empty');
INSERT INTO questions VALUES (9, 1, 'no', 'Multiple Choice', 2, 'Which of the below is NOT a linux command', 'mkp', 'cat', 'tar', 'mv');
INSERT INTO questions VALUES (10, 1, 'no', 'Multiple Choice', 1, 'What does the command \'grep\' do', 'searches for occuranes of a string in a file', 'copies files from one directory to another', 'groups similar files together', 'renames conflicting filenames');
INSERT INTO questions VALUES (11, 1, 'no', 'True or False', 1, 'Apache is an open source ftp server', 'False', 'empty', 'empty', 'empty');
INSERT INTO questions VALUES (12, 1, 'no', 'True or False', 2, 'CGI stands for Common Graphics Interface', 'False', 'empty', 'empty', 'empty');
INSERT INTO questions VALUES (13, 1, 'no', 'True or False', 2, 'Perl is the hackers swiss-army knife', 'True', 'empty', 'empty', 'empty');
INSERT INTO questions VALUES (18, 7, 'yes', 'True or False', 1, 'OS X is based of off OS 9', 'False', 'empty', 'empty', 'empty');
INSERT INTO questions VALUES (19, 7, 'yes', 'True or False', 2, 'The top of the line new imacs come with a built-in dvd drive and look like a lamp.', 'True', 'empty', 'empty', 'empty');
INSERT INTO questions VALUES (20, 7, 'yes', 'Multiple Choice', 1, 'It has been said that OS X has a nice interface.  What do you think is the reason for this?', 'Just look at it!  It\'s badass!', 'Mac users are zealots', 'Mac designers spent a lot of time browsing themes.org', 'Who knows?');
INSERT INTO questions VALUES (21, 7, 'yes', 'Multiple Choice', 4, 'What is the codename of OS X\'s kernel?', 'Darwin', 'Jehova', 'Morman', 'Christian');
INSERT INTO questions VALUES (22, 6, 'no', 'True or False', 1, 'BSOD stands for \'Blue Screen of Death\'', 'True', 'empty', 'empty', 'empty');
INSERT INTO questions VALUES (23, 6, 'yes', 'Multiple Choice', 1, 'How do you shut down a windows 95 pc?', 'Click on the start menu, then click on Shutdown', 'Throw the PC out the window', 'Windows 95 is so stable, you never have to shut down', 'I have no clue');
INSERT INTO questions VALUES (24, 6, 'no', 'True or False', 3, 'Pretty much any configuration change to a win9x computer will require a reboot.', 'True', 'empty', 'empty', 'empty');
INSERT INTO questions VALUES (25, 6, 'yes', 'True or False', 1, 'Bill Gates is rich.', 'True', 'empty', 'empty', 'empty');
INSERT INTO questions VALUES (26, 6, 'no', 'Multiple Choice', 1, 'What kernel is windows XP based off of?', 'Windows NT', 'Windows 95', 'Windows CE', 'Windows 3.1');
INSERT INTO questions VALUES (27, 6, 'yes', 'True or False', 1, 'Internet Explorer doesn\'t come bundled with Windows XP', 'False', 'empty', 'empty', 'empty');
INSERT INTO questions VALUES (28, 8, 'yes', 'True or False', 3, 'The Customer is always right.', 'True', 'empty', 'empty', 'empty');
# --------------------------------------------------------

#
# Table structure for table `results`
#

DROP TABLE IF EXISTS results;
CREATE TABLE results (
--  r_id int(11) NOT NULL auto_increment,
  m_id int(11) NOT NULL default '0',
  user_id int(11) NOT NULL default '0',
  points int(11) NOT NULL default '0',
  points_possible int(11) NOT NULL default '0',
  score tinyint(4) NOT NULL default '0',
  answers text NOT NULL,
  date datetime NOT NULL default '0000-00-00 00:00:00',
--  PRIMARY KEY  (r_id)
  PRIMARY KEY (user_id,m_id,date),
  FOREIGN KEY (user_id) REFERENCES users
) TYPE=MyISAM;

#
# Dumping data for table `results`
#

INSERT INTO results VALUES (1, 2, 17, 25, 68, 'Question #1 (2): What is the command to view the current process list?:\r\nUser\'s answer: ustat\r\nCorrect answer: ps\r\n\r\nQuestion #2 (1): Linux is a tradmark of Linus Torvalds:\r\nUser\'s answer: True\r\nCorrect answer: True\r\n\r\nQuestion #3 (3): Maplebot, by Adrian Montero, is a 1337 bot written in C:\r\nUser\'s answer: True\r\nCorrect answer: True\r\n\r\nQuestion #4 (4): Redhat was the first Linux distribution:\r\nUser\'s answer: True\r\nCorrect answer: False\r\n\r\nQuestion #5 (2): What is the command to list all files in a directory in Linux?:\r\nUser\'s answer: ls -a\r\nCorrect answer: ls -a\r\n\r\nQuestion #6 (5): Emacs isa  better editor than VI:\r\nUser\'s answer: True\r\nCorrect answer: True\r\n\r\nQuestion #7 (2): Perl is the hackers swiss-army knife:\r\nUser\'s answer: False\r\nCorrect answer: True\r\n\r\nQuestion #8 (2): Which of the below is NOT a linux command:\r\nUser\'s answer: mkp\r\nCorrect answer: mkp\r\n\r\nQuestion #9 (2): CGI stands for Common Graphics Interface:\r\nUser\'s answer: False\r\nCorrect answer: False\r\n\r\nQuestion #10 (2): What does GNU stand for?:\r\nUser\'s answer: Gnu\\\'s not Unix\r\nCorrect answer: Gnu\'s not Unix\r\n\r\n', '2002-04-05 11:14:44');
INSERT INTO results VALUES (9, 1, 2, 8, 25, 'Question #: 1 (2): The top of the line new imacs come with a built-in dvd drive and look like a lamp.:\nUser\'s answer:  True\nCorrect answer:  True\n\nQuestion #: 2 (1): It has been said that OS X has a nice interface.  What do you think is the reason for this?:\nUser\'s answer:  Mac users are zealots\nCorrect answer:  Just look at it!  It\'s badass!\n\nQuestion #: 3 (4): What is the codename of OS X\'s kernel?:\nUser\'s answer:  Christian\nCorrect answer:  Darwin\n\nQuestion #: 4 (1): OS X is based of off OS 9:\nUser\'s answer:  True\nCorrect answer:  False\n\n', '2002-05-14 11:07:14');
# --------------------------------------------------------

#
# Table structure for table `security`
#

DROP TABLE IF EXISTS security;
CREATE TABLE security (
  l_id int(11) NOT NULL auto_increment,
  user_id int(11) NOT NULL default '0',
  ip varchar(15) NOT NULL default '',
  page varchar(255) NOT NULL default '0',
  date datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (l_id)
) TYPE=MyISAM;

#
# Dumping data for table `security`
#

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

DROP TABLE IF EXISTS courses;
CREATE TABLE courses (
  c_id int(11) NOT NULL auto_increment,
  name TEXT NOT NULL,
  description TEXT NOT NULL,
  PRIMARY KEY (c_id)
) TYPE=MyISAM;

INSERT INTO courses VALUES (1,'First','This is just the first one');

#
# Table structure for table `modules`
#

DROP TABLE IF EXISTS modules;
CREATE TABLE modules (
  m_id int(11) NOT NULL auto_increment,
  c_id int(11) NOT NULL,
  name text NOT NULL,
  description text NOT NULL default '',
  prereq int(11) NOT NULL,

-- stuff relating to the test
  title varchar(255) NOT NULL default '',
  notes text NOT NULL,
  num_required int(11) NOT NULL default '0',
  num_random int(11) NOT NULL default '0',
--  start_date datetime NOT NULL default '0000-00-00 00:00:00',
--  end_date datetime NOT NULL default '0000-00-00 00:00:00',
--  g_id int(11) NOT NULL default '0',
  
  PRIMARY KEY  (m_id),
  FOREIGN KEY  (c_id) REFERENCES courses
) TYPE=MyISAM;


#
# Dumping data for table `skill_levels`
#

INSERT INTO modules VALUES (1,1,'Linux',0,'Linux quiz','This is the example linux quiz that comes with phpTest.  Better answer \'true\' to the \'emacs is better than VI\' question, it\'s worth 5 points ;)\r\n\r\n ', 5, 5);

--INSERT INTO modules VALUES (1, 'Linux');
--INSERT INTO modules VALUES (8, 'Customer Service');
--INSERT INTO modules VALUES (7, 'Macintosh');
--INSERT INTO modules VALUES (6, 'Windows');

--INSERT INTO tests VALUES (1, 1, 'Linux quiz', 'This is the example linux quiz that comes with phpTest.  Better answer \'true\' to the \'emacs is better than VI\' question, it\'s worth 5 points ;)\r\n\r\n ', 5, 5, '2002-01-01 00:00:00', '2004-01-01 00:00:00', 1);
--INSERT INTO tests VALUES (10, 6, 'Intermediate Windows exam', 'Ah windows, the OS of hackers everywhere.  By hackers I mean h4x0r5 of course.', 3, 2, '2002-05-03 14:00:00', '2004-05-13 14:00:00', 2);
--INSERT INTO tests VALUES (9, 7, 'Beginning Macintosh Exam', 'This is an example test.  I just pulled some questions out of my ass so don\'t take them too seriously.  This text right here is the \'test notes\', and you can edit it to make it say anything you\'d like.  If you press refresh a few times, you\'ll see that the order of the multiple choice answers are changed around.  The actual questions on the test might be different each time you take it as well, if the administrator has set up the test that way.', 4, 0, '2002-05-13 14:00:00', '2004-05-13 14:00:00', 1);
--INSERT INTO tests VALUES (11, 8, 'Customer service exam', 'Customer service, the pinnacle of any organization.  I just added one question because I couldn\'t think of any others.  ', 1, 0, '2002-05-13 14:00:00', '2003-05-13 14:00:00', 3);


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

#
# Table structure for table `tests`
#

--DROP TABLE IF EXISTS tests;
--CREATE TABLE tests (
--  t_id int(11) NOT NULL auto_increment,
--  s_id int(11) NOT NULL default '0',
--  title varchar(255) NOT NULL default '',
--  notes text NOT NULL,
--  num_required int(11) NOT NULL default '0',
--  num_random int(11) NOT NULL default '0',
--  start_date datetime NOT NULL default '0000-00-00 00:00:00',
--  end_date datetime NOT NULL default '0000-00-00 00:00:00',
--  g_id int(11) NOT NULL default '0',
--  PRIMARY KEY  (t_id)
--) TYPE=MyISAM;

#
# Dumping data for table `tests`
#

--INSERT INTO tests VALUES (1, 1, 'Linux quiz', 'This is the example linux quiz that comes with phpTest.  Better answer \'true\' to the \'emacs is better than VI\' question, it\'s worth 5 points ;)\r\n\r\n ', 5, 5, '2002-01-01 00:00:00', '2004-01-01 00:00:00', 1);
--INSERT INTO tests VALUES (10, 6, 'Intermediate Windows exam', 'Ah windows, the OS of hackers everywhere.  By hackers I mean h4x0r5 of course.', 3, 2, '2002-05-03 14:00:00', '2004-05-13 14:00:00', 2);
--INSERT INTO tests VALUES (9, 7, 'Beginning Macintosh Exam', 'This is an example test.  I just pulled some questions out of my ass so don\'t take them too seriously.  This text right here is the \'test notes\', and you can edit it to make it say anything you\'d like.  If you press refresh a few times, you\'ll see that the order of the multiple choice answers are changed around.  The actual questions on the test might be different each time you take it as well, if the administrator has set up the test that way.', 4, 0, '2002-05-13 14:00:00', '2004-05-13 14:00:00', 1);
--INSERT INTO tests VALUES (11, 8, 'Customer service exam', 'Customer service, the pinnacle of any organization.  I just added one question because I couldn\'t think of any others.  ', 1, 0, '2002-05-13 14:00:00', '2003-05-13 14:00:00', 3);
# --------------------------------------------------------

#
# Table structure for table `users`
#

DROP TABLE IF EXISTS users;
CREATE TABLE users (
  user_id int(11) NOT NULL auto_increment,
  username varchar(13) NOT NULL default '',
  password varchar(30) NOT NULL default '',
  email varchar(100) NOT NULL default '',
  real_name varchar(30) NOT NULL default '',
  g_id int(11) NOT NULL default '0',
  date_joined datetime NOT NULL default '0000-00-00 00:00:00',
  admin tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (user_id),
  UNIQUE KEY user_id_2 (user_id),
  KEY user_id (user_id),
  KEY g_id (g_id)
) TYPE=MyISAM;

#
# Dumping data for table `users`
#

INSERT INTO users VALUES (1, 'admin', 'AheqX0OeA2apo', 'none', 'Administrative user', 1, '2002-04-05 10:14:31', 1);
INSERT INTO users VALUES (2, 'guest', 'YZ/gu.pNcd5sE', 'djresonance@yahoo.com', 'guest user', 1, '2002-04-05 11:09:21', 0);