-- MySQL dump 10.11
--
-- Host: rubin    Database: proba2010
-- ------------------------------------------------------
-- Server version	5.0.51a-24+lenny2

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;

--
-- Table structure for table `page`
--

DROP TABLE IF EXISTS `page`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `page` (
  `id` int(4) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `cache_width` int(4) default NULL,
  `t_class` varchar(100) default NULL,
  `login_table` varchar(100) default NULL,
  `join_where` varchar(255) default NULL,
  `dest_mail` varchar(255) default NULL,
  `good_addr` varchar(255) default NULL,
  `lang` char(2) default NULL,
  `rq_auth` tinyint(1) default NULL,
  `date_f` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `page`
--

LOCK TABLES `page` WRITE;
/*!40000 ALTER TABLE `page` DISABLE KEYS */;
INSERT INTO `page` VALUES (1,'new_page',0,'','test_tbl','','','show_dlg.php?page_name=auth_page','hu',0,''),(2,'auth_page',6,'','test_tbl','','','?page_name=auth_page','hu',1,''),(7,'ask',0,'','proba2010','','','../ask_success.html','hu',0,'proba2010.date_reg'),(8,'proba2010_reg',20,'','proba2010','','','../auth_success.html','hu',1,'proba2010.date_last');
/*!40000 ALTER TABLE `page` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `page_control`
--

DROP TABLE IF EXISTS `page_control`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `page_control` (
  `id` int(4) NOT NULL auto_increment,
  `page_id` int(4) NOT NULL default '0',
  `ct_type` char(1) NOT NULL default '',
  `title` varchar(200) default NULL,
  `default_value` varchar(150) default NULL,
  `css_text_td` varchar(20) default NULL,
  `css_ctrl` varchar(20) default NULL,
  `css_ctrl_td` varchar(20) default NULL,
  `order_id` int(4) default NULL,
  `cache_text_cspan` int(4) default NULL,
  `cache_ctrl_cspan` int(4) default NULL,
  `rq_notnull` tinyint(1) default NULL,
  `rq_numeric` tinyint(1) default NULL,
  `rq_regexp` varchar(40) default NULL,
  `hide_output` tinyint(1) default NULL,
  `dest_field` varchar(40) default NULL,
  `rw_field` varchar(40) default NULL,
  `validate_js` varchar(255) default NULL,
  `verify_error` varchar(255) default NULL,
  `ct_subtype` char(1) default NULL,
  `on_change` varchar(40) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=181 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `page_control`
--

LOCK TABLES `page_control` WRITE;
/*!40000 ALTER TABLE `page_control` DISABLE KEYS */;
INSERT INTO `page_control` VALUES (1,1,'B',NULL,NULL,NULL,'',NULL,1,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,'I','email','test2','','','',2,1,1,0,NULL,'',0,'test_tbl.email',NULL,'','','',''),(18,2,'I','t2','','','','',4,1,3,1,NULL,'',0,'test_tbl.t2',NULL,'','t2-t adja meg','',''),(17,2,'B',NULL,NULL,NULL,'',NULL,3,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(15,2,'B',NULL,NULL,NULL,'',NULL,1,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(16,2,'I','t1','','','','',2,1,5,1,NULL,'',0,'test_tbl.t2',NULL,'','t1-et adja meg','',''),(19,2,'S','s1','','','','',6,1,1,0,NULL,'',0,'test_tbl.t1',NULL,'','','',''),(20,2,'S','s2','','','','',8,1,-1,0,NULL,'',0,'test_tbl.t1',NULL,'','','G',''),(21,2,'B',NULL,NULL,NULL,'',NULL,5,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(22,2,'B',NULL,NULL,NULL,'',NULL,7,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(23,3,'B',NULL,NULL,NULL,'',NULL,1,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(25,3,'S','Title','','question','','answer',2,1,41,0,NULL,'',0,'proba2010.Title',NULL,'','','G',''),(26,3,'B',NULL,NULL,NULL,'',NULL,3,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(27,3,'I','First name','','reqf','','answer',4,1,1,1,NULL,'',0,'proba2010.First',NULL,'','Please enter your first name!','',''),(28,3,'I','Last name','','reqf','','answer',5,1,37,1,NULL,'',0,'proba2010.Last',NULL,'','Please enter your last name!','',''),(29,3,'B',NULL,NULL,NULL,'',NULL,6,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(30,3,'I','Current position','','question','','answer',7,1,35,0,NULL,'',0,'proba2010.Position',NULL,'','','',''),(31,3,'B',NULL,NULL,NULL,'',NULL,8,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(32,3,'S','Relationship with BSM','','question','','answer',9,1,1,0,NULL,'',0,'proba2010.Rel',NULL,'','','G',''),(35,3,'S','Semester','','question','','answer',14,1,27,0,NULL,'',0,'proba2010.Semester',NULL,'','','G',''),(34,3,'S','Only for alumni: <BR>Academic year','N/A','question','','answer',13,1,1,0,NULL,'',0,'proba2010.Year',NULL,'','','',''),(36,3,'B',NULL,NULL,NULL,'',NULL,15,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(38,3,'I','Address','','question','','answer',17,1,25,0,NULL,'',0,'proba2010.Address',NULL,'','','',''),(39,3,'I','City','','question','','answer',19,1,1,0,NULL,'',0,'proba2010.City',NULL,'','','',''),(40,3,'B',NULL,NULL,NULL,'',NULL,21,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(41,3,'I','State','','question','','answer',20,1,21,0,NULL,'',0,'proba2010.State',NULL,'','','',''),(42,3,'I','ZIP code','','question','','answer',22,1,1,0,NULL,'',0,'proba2010.ZIP',NULL,'','','',''),(43,3,'I','Country','','question','','answer',23,1,17,0,NULL,'',0,'proba2010.Country',NULL,'','','',''),(44,3,'B',NULL,NULL,NULL,'',NULL,24,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(46,3,'I','Tel','','question','','answer',25,1,1,0,NULL,'',0,'proba2010.Tel',NULL,'','','',''),(47,3,'I','Fax','','question','','answer',26,1,13,0,NULL,'',0,'proba2010.Fax',NULL,'','','',''),(48,3,'B',NULL,NULL,NULL,'',NULL,27,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(49,3,'I','Arrival date (yyyy.mm.dd)','1900.1.1','question','','answer',28,1,1,0,NULL,'',0,'proba2010.Arrival',NULL,'dateValidate','Wrong arrival date, please check format','',''),(50,3,'I','Departure date (yyyy.mm.dd)','1900.1.1','question','','answer',29,1,9,0,NULL,'',0,'proba2010.Departure',NULL,'dateValidate','Wrong departure date, please check format','',''),(51,3,'B',NULL,NULL,NULL,'',NULL,30,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(53,3,'S','Special dietary requirement','','question','','answer',31,1,1,0,NULL,'',0,'proba2010.rq_dietary',NULL,'','','G',''),(54,3,'I','If yes, please specify','','question','','answer',32,1,5,0,NULL,'',0,'proba2010.dietary',NULL,'','','',''),(55,3,'B',NULL,NULL,NULL,'',NULL,33,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(56,3,'S','Will you require special help?','','question','','answer',34,1,1,0,NULL,'',0,'proba2010.rq_sp_help',NULL,'','','G',''),(57,3,'I','If yes, please specify','','question','','answer',35,1,1,0,NULL,'',0,'proba2010.SpecHelp',NULL,'','','',''),(58,4,'B',NULL,NULL,NULL,'',NULL,1,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(124,5,'I','Arrival (yyyy.mm.dd)','1990.1.1','question','','answer',6,1,1,0,NULL,'',0,'proba2010.hotel_arrival',NULL,'dateValidate','Wrong date at arrival!','',''),(123,5,'B',NULL,NULL,NULL,'',NULL,5,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(142,7,'I','e-mail','','reqf','','',2,1,-1,1,NULL,'/^.+@.+$/',0,'proba2010.email',NULL,'','Please fill out the e-mail form','',''),(143,3,'B',NULL,NULL,NULL,'',NULL,11,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(157,3,'I','Suggestions, comments','','question','','answer',38,1,-1,0,NULL,'',0,'proba2010.comments',NULL,'','','T',''),(158,8,'I','Title','','regszoveg','','',1,1,1,0,NULL,'',0,'proba2010.Title',NULL,'','','',''),(159,8,'I','First name','','','','',2,1,1,0,NULL,'',0,'proba2010.first',NULL,'','','',''),(160,8,'B',NULL,NULL,NULL,'HR',NULL,4,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(161,8,'I','Last name','','regszoveg','','',3,1,15,0,NULL,'',0,'proba2010.last',NULL,'','','',''),(162,8,'I','Affiliation','','regszoveg','szeles','',8,1,9,0,NULL,'',0,'proba2010.position',NULL,'','','',''),(163,8,'I','Postal address','','regszoveg','szeles','',10,1,7,0,NULL,'',0,'proba2010.address',NULL,'','','',''),(175,8,'B',NULL,NULL,NULL,'',NULL,7,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(165,8,'B',NULL,NULL,NULL,'',NULL,9,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(166,8,'I','Arrival date <br>(mm-dd)','01-01','regszoveg','','',5,1,1,0,NULL,'',0,'proba2010.arrival',NULL,'dateValidate','Wrong arrival date, please check format','',''),(167,8,'I','Departure date <br>(mm-dd)','12-31','regszoveg','','',6,1,11,0,NULL,'',0,'proba2010.departure',NULL,'dateValidate','Wrong departure date, please check format','',''),(168,8,'B',NULL,NULL,NULL,'',NULL,11,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(169,8,'I','Comments','','regszoveg','szeles','',17,1,-1,0,NULL,'',0,'proba2010.topicother',NULL,'','','T',''),(170,8,'B',NULL,NULL,NULL,'',NULL,16,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(171,8,'I','Special diet','','regszoveg','szeles','',15,1,1,0,NULL,'',0,'proba2010.dietary',NULL,'','','',''),(176,8,'I','Phone','','regszoveg','','',12,1,1,0,NULL,'',0,'proba2010.tel',NULL,'','','',''),(173,8,'B',NULL,NULL,NULL,'',NULL,7,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(177,8,'I','Mobile (to reach you in Budapest)','','','','',13,1,3,0,NULL,'',0,'proba2010.fax',NULL,'','','',''),(178,8,'B',NULL,NULL,NULL,'',NULL,14,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(179,8,'B',NULL,NULL,NULL,'',NULL,14,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL),(180,8,'B',NULL,NULL,NULL,'',NULL,11,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `page_control` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `page_selvals`
--

DROP TABLE IF EXISTS `page_selvals`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `page_selvals` (
  `id` int(4) NOT NULL auto_increment,
  `page_control_id` int(4) NOT NULL default '0',
  `k` varchar(150) default NULL,
  `v` varchar(150) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `page_selvals`
--

LOCK TABLES `page_selvals` WRITE;
/*!40000 ALTER TABLE `page_selvals` DISABLE KEYS */;
INSERT INTO `page_selvals` VALUES (1,19,'1','yes'),(2,19,'0','no'),(3,20,'1','yes'),(4,20,'0','no'),(5,25,'Prof','Prof'),(6,25,'Dr','Dr'),(7,25,'Mr','Mr'),(8,25,'Ms','Ms');
/*!40000 ALTER TABLE `page_selvals` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `proba2010`
--

DROP TABLE IF EXISTS `proba2010`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `proba2010` (
  `id` int(4) NOT NULL auto_increment,
  `password` varchar(25) default NULL,
  `login_id` varchar(25) default NULL,
  `email` varchar(250) default NULL,
  `Title` varchar(10) default NULL,
  `First` varchar(100) default NULL,
  `Last` varchar(100) default NULL,
  `Position` varchar(100) default NULL,
  `Address` varchar(250) default NULL,
  `Tel` varchar(100) default NULL,
  `Fax` varchar(100) default NULL,
  `Arrival` varchar(100) default NULL,
  `Departure` varchar(100) default NULL,
  `dietary` varchar(250) default NULL,
  `TopicOther` varchar(200) default NULL,
  `date_last` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `date_reg` date default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `proba2010`
--

LOCK TABLES `proba2010` WRITE;
/*!40000 ALTER TABLE `proba2010` DISABLE KEYS */;
/*!40000 ALTER TABLE `proba2010` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `test`
--

DROP TABLE IF EXISTS `test`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `test` (
  `x` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `test`
--

LOCK TABLES `test` WRITE;
/*!40000 ALTER TABLE `test` DISABLE KEYS */;
/*!40000 ALTER TABLE `test` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `test_tbl`
--

DROP TABLE IF EXISTS `test_tbl`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `test_tbl` (
  `id` int(4) NOT NULL auto_increment,
  `password` varchar(15) default NULL,
  `login_id` varchar(25) default NULL,
  `email` varchar(25) default NULL,
  `t1` varchar(25) default NULL,
  `t2` varchar(25) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `test_tbl`
--

LOCK TABLES `test_tbl` WRITE;
/*!40000 ALTER TABLE `test_tbl` DISABLE KEYS */;
/*!40000 ALTER TABLE `test_tbl` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!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 */;

-- Dump completed on 2010-02-02 14:23:03
