NpS5e5t7

1--
2-- Table structure for table `wp_wsms_student`
3--
4
5DROP TABLE IF EXISTS `wp_wsms_student`;
6/*!40101 SET @saved_cs_client     = @@character_set_client */;
7/*!40101 SET character_set_client = utf8 */;
8CREATE TABLE `wp_wsms_student` (
9  `id` int(10) NOT NULL AUTO_INCREMENT,
10  `student_name` longtext,
11  `student_class_id` int(30) DEFAULT NULL,
12  `user_type` int(30) DEFAULT NULL,
13  `student_reg_number` int(30) DEFAULT NULL,
14  `student_birthday` date DEFAULT NULL,
15  `student_gender` varchar(10) DEFAULT NULL,
16  `student_permanent_address` longtext,
17  `student_present_address` longtext,
18  `student_present_address_cp` longtext,
19  `student_present_address_localite` longtext,
20  `student_phone_number` varchar(50) DEFAULT NULL,
21  `student_email` varchar(64) DEFAULT NULL,
22  `student_pass` varchar(64) DEFAULT NULL,
23  `student_photo_url` longtext,
24  `student_surname` longtext,
25  `student_nationality` longtext,
26  `student_subject` longtext,
27  `student_guardian_id` int(30) DEFAULT NULL,
28  `student_validate` int(10) DEFAULT NULL,
29  `student_class_2011` varchar(10) DEFAULT NULL,
30  `student_class_2012` varchar(10) DEFAULT NULL,
31  `student_class_2013` varchar(10) DEFAULT NULL,
32  `student_class_2014` varchar(10) DEFAULT NULL,
33  `student_class_2015` varchar(10) DEFAULT NULL,
34  `student_mutuelle` varchar(45) DEFAULT NULL,
35  `student_payment_method` varchar(45) DEFAULT NULL,
36  `student_payment_comments` longtext,
37  `student_comments` longtext,
38  PRIMARY KEY (`id`)
39) ENGINE=InnoDB AUTO_INCREMENT=4931 DEFAULT CHARSET=utf8;
40/*!40101 SET character_set_client = @saved_cs_client */;