--
-- Host: mysql    Database: ribarik_proba3
-- ------------------------------------------------------


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

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;

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

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,'','ribarik_proba3','','','../ask_success.html','hu',0,'ribarik_proba3.date_reg'),(8,'ribarik_proba3_reg',20,'','ribarik_proba3','','','../auth_success.html','hu',1,'ribarik_proba3.date_last');

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

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;

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

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,'ribarik_proba3.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,'ribarik_proba3.First',NULL,'','Please enter your first name!','',''),(28,3,'I','Last name','','reqf','','answer',5,1,37,1,NULL,'',0,'ribarik_proba3.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,'ribarik_proba3.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,'ribarik_proba3.Rel',NULL,'','','G',''),(35,3,'S','Semester','','question','','answer',14,1,27,0,NULL,'',0,'ribarik_proba3.Semester',NULL,'','','G',''),(34,3,'S','Only for alumni: <BR>Academic year','N/A','question','','answer',13,1,1,0,NULL,'',0,'ribarik_proba3.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,'ribarik_proba3.Address',NULL,'','','',''),(39,3,'I','City','','question','','answer',19,1,1,0,NULL,'',0,'ribarik_proba3.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,'ribarik_proba3.State',NULL,'','','',''),(42,3,'I','ZIP code','','question','','answer',22,1,1,0,NULL,'',0,'ribarik_proba3.ZIP',NULL,'','','',''),(43,3,'I','Country','','question','','answer',23,1,17,0,NULL,'',0,'ribarik_proba3.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,'ribarik_proba3.Tel',NULL,'','','',''),(47,3,'I','Fax','','question','','answer',26,1,13,0,NULL,'',0,'ribarik_proba3.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,'ribarik_proba3.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,'ribarik_proba3.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,'ribarik_proba3.rq_dietary',NULL,'','','G',''),(54,3,'I','If yes, please specify','','question','','answer',32,1,5,0,NULL,'',0,'ribarik_proba3.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,'ribarik_proba3.rq_sp_help',NULL,'','','G',''),(57,3,'I','If yes, please specify','','question','','answer',35,1,1,0,NULL,'',0,'ribarik_proba3.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,'ribarik_proba3.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,'ribarik_proba3.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,'ribarik_proba3.comments',NULL,'','','T',''),(158,8,'I','Title','','regszoveg','','',1,1,1,0,NULL,'',0,'ribarik_proba3.Title',NULL,'','','',''),(159,8,'I','First name','','','','',2,1,1,0,NULL,'',0,'ribarik_proba3.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,'ribarik_proba3.last',NULL,'','','',''),(162,8,'I','Affiliation','','regszoveg','szeles','',8,1,9,0,NULL,'',0,'ribarik_proba3.position',NULL,'','','',''),(163,8,'I','Postal address','','regszoveg','szeles','',10,1,7,0,NULL,'',0,'ribarik_proba3.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,'ribarik_proba3.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,'ribarik_proba3.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,'ribarik_proba3.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,'ribarik_proba3.dietary',NULL,'','','',''),(176,8,'I','Phone','','regszoveg','','',12,1,1,0,NULL,'',0,'ribarik_proba3.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,'ribarik_proba3.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);

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

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;

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

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');

--
-- Table structure for table `ribarik_proba3`
--

CREATE TABLE `ribarik_proba3` (
  `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 AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ribarik_proba3`
--

INSERT INTO `ribarik_proba3` VALUES (1,'78bd492','id-8209308547','ribarik@renyi.hu','Dr.','Gabor','Ribarik','postdoctoral fellow','1111, xxx, yyy','+3548u58u545',NULL,'01-01','12-31',NULL,'ddd','2012-02-08 15:00:04','2008-01-30');

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

CREATE TABLE `test` (
  `x` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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;

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



