-- MySQL dump 10.9
--
-- Host: localhost    Database: t_sub_db
-- ------------------------------------------------------
-- Server version	4.1.20-community-nt

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `t_sub_db`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `t_sub_db` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `t_sub_db`;

--
-- Table structure for table `tbl_course`
--

DROP TABLE IF EXISTS `tbl_course`;
CREATE TABLE `tbl_course` (
  `id` tinyint(3) unsigned NOT NULL auto_increment,
  `int_order` tinyint(4) NOT NULL default '0',
  `int_min_participants` tinyint(4) NOT NULL default '0',
  `int_max_participants` tinyint(4) NOT NULL default '0',
  `int_waiting_list` tinyint(4) NOT NULL default '0',
  `b_active` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_course`
--


/*!40000 ALTER TABLE `tbl_course` DISABLE KEYS */;
LOCK TABLES `tbl_course` WRITE;
INSERT INTO `tbl_course` VALUES (1,1,8,16,4,1),(2,2,6,10,3,1),(3,3,8,16,4,1),(4,4,8,10,3,1),(5,5,8,12,3,1),(6,6,8,10,3,1),(7,7,8,25,4,1),(8,8,8,16,4,1),(9,9,8,20,4,1),(10,10,8,20,4,1),(11,11,8,12,3,1),(12,12,8,10,3,1),(13,13,8,16,4,1),(14,14,8,12,3,1),(15,15,8,20,4,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `tbl_course` ENABLE KEYS */;

--
-- Table structure for table `tbl_course_registration`
--

DROP TABLE IF EXISTS `tbl_course_registration`;
CREATE TABLE `tbl_course_registration` (
  `id_course` tinyint(3) unsigned NOT NULL default '0',
  `int_registration` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_course`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_course_registration`
--


/*!40000 ALTER TABLE `tbl_course_registration` DISABLE KEYS */;
LOCK TABLES `tbl_course_registration` WRITE;
INSERT INTO `tbl_course_registration` VALUES (1,2),(2,5),(3,0),(4,0),(5,1),(6,0),(7,0),(8,0),(9,0),(10,0),(11,0),(12,0),(13,0),(14,0),(15,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `tbl_course_registration` ENABLE KEYS */;

--
-- Table structure for table `tbl_person_course`
--

DROP TABLE IF EXISTS `tbl_person_course`;
CREATE TABLE `tbl_person_course` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `id_person` int(11) unsigned NOT NULL default '0',
  `id_course` tinyint(3) unsigned NOT NULL default '0',
  `int_priority` tinyint(4) NOT NULL default '0',
  `b_active` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_person_course`
--


/*!40000 ALTER TABLE `tbl_person_course` DISABLE KEYS */;
LOCK TABLES `tbl_person_course` WRITE;
INSERT INTO `tbl_person_course` VALUES (1,1,2,1,0),(2,1,3,2,1),(3,1,4,3,1),(4,2,1,1,1),(5,2,2,2,1),(6,2,3,3,1),(7,3,2,1,1),(8,3,3,2,1),(9,3,4,3,1),(10,1,1,1,0),(11,1,5,1,1),(12,4,1,1,1),(13,4,2,2,1),(14,4,3,3,1),(15,5,2,1,1),(16,5,3,2,1),(17,5,4,3,1),(18,6,2,1,1),(19,6,3,2,1),(20,6,4,3,1),(21,7,2,1,1),(22,7,3,2,1),(23,7,4,3,1),(24,8,2,1,1),(25,8,3,2,1),(26,8,4,3,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `tbl_person_course` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;