-- Table structure for table `im_reportes_problemas_estatus`
--

CREATE TABLE `im_reportes_problemas_estatus` (
  `codigo` bigint(20) NOT NULL AUTO_INCREMENT,
  `codigo_problema` bigint(20) DEFAULT NULL,
  `codigo_estatus` int(11) DEFAULT NULL,
  `codigo_usuario` int(11) DEFAULT NULL,
  `fecha_visita` int(11) DEFAULT NULL,
  `fecha_creacion` int(11) DEFAULT NULL,
  PRIMARY KEY (`codigo`),
  KEY `codigo_estatus` (`codigo_estatus`),
  KEY `codigo_problema` (`codigo_problema`),
  KEY `codigo_usuario` (`codigo_usuario`),
  CONSTRAINT `im_reportes_problemas_estatus_ibfk_1` FOREIGN KEY (`codigo_estatus`) REFERENCES `im_reportes_estatus` (`codigo`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `im_reportes_problemas_estatus_ibfk_2` FOREIGN KEY (`codigo_problema`) REFERENCES `im_reportes_problemas` (`codigo`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `im_reportes_problemas_estatus_ibfk_3` FOREIGN KEY (`codigo_usuario`) REFERENCES `im_usuarios` (`codigo`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1490 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `im_reportes_problemas_estatus`
--

INSERT INTO `im_reportes_problemas_estatus` VALUES (38,1,1,1,NULL,1473715161),(39,2,1,1,NULL,1473715161),(40,4,1,1,NULL,1473715260),(41,5,1,1,NULL,1473715331),(42,1,7,1,NULL,1473715663),(43,2,7,1,NULL,1473715663),(44,1,23,1,1474056000,1473715863),(45,5,7,1,NULL,1473716929),(46,5,26,1,NULL,1473717079),(47,7,1,1,NULL,1473796749),(48,6,1,1,NULL,1473796749),(49,8,1,1,NULL,1473796749),(50,6,9,1,NULL,1473797667),(51,7,9,1,NULL,1473797667),(52,8,9,1,NULL,1473797667),(53,7,10,1,1473969600,1473797881),(54,9,1,1,NULL,1473798794),(55,9,3,1,NULL,1473799574),(56,9,9,1,NULL,1473799664),(57,9,10,1,1473883200,1473799833),(58,9,10,1,1473883200,1473799994),(59,9,25,1,1473883200,1473800036),(60,9,31,1,NULL,1473800744),(61,32,1,1,NULL,1474131682),(62,33,1,1,NULL,1474131682),(63,34,1,1,NULL,1474131682),(64,38,1,1,NULL,1474137911),(65,39,1,1,NULL,1474137911),(66,40,1,1,NULL,1474137911),(67,2630,1,3,NULL,1474401397),(68,2631,1,3,NULL,1474401397),(69,2632,1,3,NULL,1474401397),(70,2633,1,3,NULL,1474401397),(71,2634,1,3,NULL,1474401397),(72,2635,1,3,NULL,1474401397),(73,2636,1,3,NULL,1474401397),(74,2637,1,3,NULL,1474401397),(75,2639,1,3,NULL,1474401397),(76,2638,1,3,NULL,1474401397),(77,2630,7,3,NULL,1474401726),(78,2631,7,3,NULL,1474401726),(79,2632,7,3,NULL,1474401726),(80,2633,7,3,NULL,1474401726),(81,2634,7,3,NULL,1474401726),(82,2635,7,3,NULL,1474401726),(83,2636,7,3,NULL,1474401726),(84,2637,7,3,NULL,1474401726),(85,2638,7,3,NULL,1474401726),(86,2639,7,3,NULL,1474401726),(87,2640,1,4,NULL,1474402510),(88,2641,1,4,NULL,1474402510),(89,2640,7,4,NULL,1474402578),(90,2641,7,4,NULL,1474402578),(91,2746,1,1,NULL,1474576167),(92,2747,1,1,NULL,1474576167),(93,2748,1,1,NULL,1474576453),(94,2749,1,1,NULL,1474576453),(95,2750,1,1,NULL,1474578840),(96,2751,1,1,NULL,1474578840),(97,2752,1,1,NULL,1474644795),(98,2753,1,1,NULL,1474644795),(100,2755,1,1,NULL,1474661892),(101,2756,1,1,NULL,1474661892),(102,2757,1,1,NULL,1474665090),(103,2758,1,1,NULL,1474688925),(104,2759,1,1,NULL,1474994502),(105,2847,1,1,NULL,1477615882),(106,2848,1,1,NULL,1477616359),(107,2760,1,1,NULL,1477684561),(108,2761,1,1,NULL,1477684561),(109,2777,1,1,NULL,1477928218),(110,2983,1,1,NULL,1478533466),(111,2986,1,1,NULL,1478533466),(112,2990,1,1,NULL,1478533466),(113,2983,7,1,NULL,1478533486),(114,2984,7,1,NULL,1478533486),(115,2985,7,1,NULL,1478533486),(116,2986,7,1,NULL,1478533486),(117,2987,7,1,NULL,1478533486),(118,2988,7,1,NULL,1478533486),(119,2989,7,1,NULL,1478533486),(120,2990,7,1,NULL,1478533486),(121,2991,7,1,NULL,1478533486),(122,2992,7,1,NULL,1478533486),(123,2993,7,1,NULL,1478533486),(124,2994,7,1,NULL,1478533486),(125,2995,7,1,NULL,1478533486),(126,2996,7,1,NULL,1478533486),(127,2997,7,1,NULL,1478533486),(128,2998,7,1,NULL,1478533486),(129,2999,7,1,NULL,1478533486),(130,3000,7,1,NULL,1478533486),(131,3001,7,1,NULL,1478533486),(132,3002,7,1,NULL,1478533486),(133,3003,7,1,NULL,1478533486),(134,3004,7,1,NULL,1478533486),(135,3005,7,1,NULL,1478533486),(136,3006,7,1,NULL,1478533486),(137,3007,7,1,NULL,1478533486),(138,3008,7,1,NULL,1478533486),(139,3009,7,1,NULL,1478533486),(140,3010,7,1,NULL,1478533486),(141,3011,7,1,NULL,1478533486),(142,3012,7,1,NULL,1478533486),(143,3013,7,1,NULL,1478533486),(144,3014,7,1,NULL,1478533486),(145,3015,7,1,NULL,1478533486),(146,3016,7,1,NULL,1478533486),(147,3017,7,1,NULL,1478533486),(148,3018,7,1,NULL,1478533486),(149,3019,7,1,NULL,1478533486),(150,3020,7,1,NULL,1478533486),(151,3021,7,1,NULL,1478533486),(152,3022,7,1,NULL,1478533486),(153,3023,7,1,NULL,1478533486),(154,3024,7,1,NULL,1478533486),(155,3025,7,1,NULL,1478533486),(156,3026,7,1,NULL,1478533486),(157,3027,7,1,NULL,1478533486),(158,3028,7,1,NULL,1478533486),(159,3029,7,1,NULL,1478533486),(160,3030,7,1,NULL,1478533487),(161,3031,7,1,NULL,1478533487),(162,3032,7,1,NULL,1478533487),(163,3033,7,1,NULL,1478533487),(164,3034,7,1,NULL,1478533487),(165,3035,7,1,NULL,1478533487),(166,3036,7,1,NULL,1478533487),(167,3037,7,1,NULL,1478533487),(168,3038,7,1,NULL,1478533487),(169,3039,7,1,NULL,1478533487),(170,3040,7,1,NULL,1478533487),(171,3041,7,1,NULL,1478533487),(172,3042,7,1,NULL,1478533487),(173,3043,7,1,NULL,1478533487),(174,3044,7,1,NULL,1478533487),(175,3045,7,1,NULL,1478533487),(176,3046,7,1,NULL,1478533487),(177,3047,7,1,NULL,1478533487),(178,3048,7,1,NULL,1478533487),(179,3049,7,1,NULL,1478533487),(180,3050,7,1,NULL,1478533487),(181,3051,7,1,NULL,1478533487),(182,3052,7,1,NULL,1478533487),(183,3053,7,1,NULL,1478533487),(184,3054,7,1,NULL,1478533487),(185,3055,7,1,NULL,1478533487),(186,3056,7,1,NULL,1478533487),(187,3057,7,1,NULL,1478533487),(188,3058,7,1,NULL,1478533487),(189,3059,7,1,NULL,1478533487),(190,3060,7,1,NULL,1478533487),(191,3061,7,1,NULL,1478533487),(192,3062,7,1,NULL,1478533487),(193,3063,7,1,NULL,1478533487),(194,3064,7,1,NULL,1478533487),(195,3065,7,1,NULL,1478533487),(196,3066,7,1,NULL,1478533487),(197,3067,7,1,NULL,1478533487),(198,3068,7,1,NULL,1478533487),(199,3069,7,1,NULL,1478533487),(200,3070,7,1,NULL,1478533487),(201,3071,7,1,NULL,1478533487),(202,3072,7,1,NULL,1478533487),(203,3073,7,1,NULL,1478533487),(204,3074,7,1,NULL,1478533487),(205,3075,7,1,NULL,1478533487),(206,3076,7,1,NULL,1478533487),(207,3077,7,1,NULL,1478533487),(208,3078,7,1,NULL,1478533487),(209,3079,7,1,NULL,1478533487),(210,3080,7,1,NULL,1478533487),(211,3081,7,1,NULL,1478533487),(212,3082,7,1,NULL,1478533487),(213,3083,7,1,NULL,1478533487),(214,3084,7,1,NULL,1478533487),(215,3085,7,1,NULL,1478533487),(216,3086,7,1,NULL,1478533487),(217,3087,7,1,NULL,1478533487),(218,3088,7,1,NULL,1478533487),(219,3089,7,1,NULL,1478533487),(220,3090,7,1,NULL,1478533487),(221,3091,7,1,NULL,1478533487),(222,3092,7,1,NULL,1478533487),(223,3093,7,1,NULL,1478533487),(224,3094,7,1,NULL,1478533487),(225,3095,7,1,NULL,1478533487),(226,3096,7,1,NULL,1478533487),(227,3097,7,1,NULL,1478533487),(228,3098,7,1,NULL,1478533487),(229,3099,7,1,NULL,1478533487),(230,3100,7,1,NULL,1478533487),(231,3101,7,1,NULL,1478533487),(232,3102,7,1,NULL,1478533487),(233,3103,7,1,NULL,1478533487),(234,3104,7,1,NULL,1478533487),(235,3105,7,1,NULL,1478533487),(236,3106,7,1,NULL,1478533487),(237,3107,7,1,NULL,1478533487),(238,3108,7,1,NULL,1478533487),(239,3109,7,1,NULL,1478533487),(240,3110,7,1,NULL,1478533487),(241,3111,7,1,NULL,1478533487),(242,3112,7,1,NULL,1478533487),(243,3113,7,1,NULL,1478533487),(244,3114,7,1,NULL,1478533487),(245,3115,7,1,NULL,1478533487),(246,3116,7,1,NULL,1478533487),(247,3117,7,1,NULL,1478533487),(248,3118,1,1,NULL,1478533555),(249,3255,1,1,NULL,1478534957),(250,3383,1,1,NULL,1478536859),(251,3622,1,1,NULL,1478547098),(252,3636,1,1,NULL,1478560890),(253,3487,36,1,NULL,1478614892),(254,3488,36,1,NULL,1478614892),(255,3489,36,1,NULL,1478614892),(256,3490,36,1,NULL,1478614892),(257,3491,36,1,NULL,1478614892),(258,3492,36,1,NULL,1478614892),(259,3493,36,1,NULL,1478614892),(260,3494,36,1,NULL,1478614892),(261,3495,36,1,NULL,1478614892),(262,3496,36,1,NULL,1478614892),(263,3497,36,1,NULL,1478614892),(264,3498,36,1,NULL,1478614892),(265,3499,36,1,NULL,1478614892),(266,3500,36,1,NULL,1478614892),(267,3501,36,1,NULL,1478614892),(268,3502,36,1,NULL,1478614892),(269,3503,36,1,NULL,1478614892),(270,3504,36,1,NULL,1478614892),(271,3505,36,1,NULL,1478614892),(272,3506,36,1,NULL,1478614892),(273,3507,36,1,NULL,1478614892),(274,3508,36,1,NULL,1478614892),(275,3509,36,1,NULL,1478614892),(276,3510,36,1,NULL,1478614892),(277,3511,36,1,NULL,1478614892),(278,3512,36,1,NULL,1478614892),(279,3513,36,1,NULL,1478614892),(280,3514,36,1,NULL,1478614892),(281,3515,36,1,NULL,1478614892),(282,3516,36,1,NULL,1478614892),(283,3517,36,1,NULL,1478614892),(284,3518,36,1,NULL,1478614892),(285,3519,36,1,NULL,1478614892),(286,3520,36,1,NULL,1478614892),(287,3521,36,1,NULL,1478614892),(288,3522,36,1,NULL,1478614892),(289,3523,36,1,NULL,1478614892),(290,3524,36,1,NULL,1478614892),(291,3525,36,1,NULL,1478614892),(292,3526,36,1,NULL,1478614892),(293,3527,36,1,NULL,1478614892),(294,3528,36,1,NULL,1478614892),(295,3529,36,1,NULL,1478614892),(296,3530,36,1,NULL,1478614892),(297,3531,36,1,NULL,1478614892),(298,3532,36,1,NULL,1478614892),(299,3533,36,1,NULL,1478614892),(300,3534,36,1,NULL,1478614892),(301,3535,36,1,NULL,1478614892),(302,3536,36,1,NULL,1478614892),(303,3537,36,1,NULL,1478614892),(304,3538,36,1,NULL,1478614892),(305,3539,36,1,NULL,1478614892),(306,3540,36,1,NULL,1478614892),(307,3541,36,1,NULL,1478614892),(308,3542,36,1,NULL,1478614892),(309,3543,36,1,NULL,1478614892),(310,3544,36,1,NULL,1478614892),(311,3545,36,1,NULL,1478614892),(312,3546,36,1,NULL,1478614892),(313,3547,36,1,NULL,1478614892),(314,3548,36,1,NULL,1478614892),(315,3549,36,1,NULL,1478614892),(316,3550,36,1,NULL,1478614892),(317,3551,36,1,NULL,1478614892),(318,3552,36,1,NULL,1478614892),(319,3553,36,1,NULL,1478614892),(320,3554,36,1,NULL,1478614892),(321,3555,36,1,NULL,1478614892),(322,3556,36,1,NULL,1478614892),(323,3557,36,1,NULL,1478614892),(324,3558,36,1,NULL,1478614892),(325,3559,36,1,NULL,1478614892),(326,3560,36,1,NULL,1478614892),(327,3561,36,1,NULL,1478614892),(328,3562,36,1,NULL,1478614892),(329,3563,36,1,NULL,1478614892),(330,3564,36,1,NULL,1478614892),(331,3565,36,1,NULL,1478614892),(332,3566,36,1,NULL,1478614892),(333,3567,36,1,NULL,1478614892),(334,3568,36,1,NULL,1478614892),(335,3569,36,1,NULL,1478614892),(336,3570,36,1,NULL,1478614892),(337,3571,36,1,NULL,1478614892),(338,3572,36,1,NULL,1478614892),(339,3573,36,1,NULL,1478614892),(340,3574,36,1,NULL,1478614892),(341,3575,36,1,NULL,1478614892),(342,3576,36,1,NULL,1478614892),(343,3577,36,1,NULL,1478614892),(344,3578,36,1,NULL,1478614892),(345,3579,36,1,NULL,1478614892),(346,3580,36,1,NULL,1478614892),(347,3581,36,1,NULL,1478614892),(348,3582,36,1,NULL,1478614892),(349,3583,36,1,NULL,1478614892),(350,3584,36,1,NULL,1478614892),(351,3585,36,1,NULL,1478614892),(352,3586,36,1,NULL,1478614892),(353,3587,36,1,NULL,1478614892),(354,3588,36,1,NULL,1478614892),(355,3589,36,1,NULL,1478614892),(356,3590,36,1,NULL,1478614892),(357,3591,36,1,NULL,1478614892),(358,3592,36,1,NULL,1478614892),(359,3593,36,1,NULL,1478614892),(360,3594,36,1,NULL,1478614892),(361,3595,36,1,NULL,1478614892),(362,3596,36,1,NULL,1478614892),(363,3597,36,1,NULL,1478614892),(364,3598,36,1,NULL,1478614892),(365,3599,36,1,NULL,1478614892),(366,3600,36,1,NULL,1478614892),(367,3601,36,1,NULL,1478614892),(368,3602,36,1,NULL,1478614892),(369,3603,36,1,NULL,1478614892),(370,3604,36,1,NULL,1478614892),(371,3605,36,1,NULL,1478614892),(372,3606,36,1,NULL,1478614892),(373,3607,36,1,NULL,1478614892),(374,3608,36,1,NULL,1478614892),(375,3609,36,1,NULL,1478614892),(376,3610,36,1,NULL,1478614892),(377,3611,36,1,NULL,1478614892),(378,3612,36,1,NULL,1478614892),(379,3613,36,1,NULL,1478614892),(380,3614,36,1,NULL,1478614892),(381,3615,36,1,NULL,1478614892),(382,3616,36,1,NULL,1478614892),(383,3617,36,1,NULL,1478614892),(384,3618,36,1,NULL,1478614892),(385,3619,36,1,NULL,1478614892),(386,3620,36,1,NULL,1478614892),(387,3621,36,1,NULL,1478614892),(388,3758,1,1,NULL,1478622067),(389,3352,1,1,NULL,1478634689),(390,3353,1,1,NULL,1478634689),(391,3979,1,1,NULL,1478636926),(392,3993,1,1,NULL,1478636926),(393,4085,1,1,NULL,1478636926),(394,4150,1,1,NULL,1478659265),(395,4157,1,1,NULL,1478659265),(396,4114,7,1,NULL,1478659895),(397,4115,7,1,NULL,1478659895),(398,4116,7,1,NULL,1478659895),(399,4117,7,1,NULL,1478659895),(400,4118,7,1,NULL,1478659895),(401,4119,7,1,NULL,1478659895),(402,4120,7,1,NULL,1478659895),(403,4121,7,1,NULL,1478659895),(404,4122,7,1,NULL,1478659895),(405,4123,7,1,NULL,1478659895),(406,4124,7,1,NULL,1478659895),(407,4125,7,1,NULL,1478659895),(408,4126,7,1,NULL,1478659895),(409,4127,7,1,NULL,1478659895),(410,4128,7,1,NULL,1478659895),(411,4129,7,1,NULL,1478659895),(412,4130,7,1,NULL,1478659895),(413,4131,7,1,NULL,1478659895),(414,4132,7,1,NULL,1478659895),(415,4133,7,1,NULL,1478659895),(416,4134,7,1,NULL,1478659895),(417,4135,7,1,NULL,1478659895),(418,4136,7,1,NULL,1478659895),(419,4137,7,1,NULL,1478659895),(420,4138,7,1,NULL,1478659895),(421,4139,7,1,NULL,1478659895),(422,4140,7,1,NULL,1478659895),(423,4141,7,1,NULL,1478659895),(424,4142,7,1,NULL,1478659895),(425,4143,7,1,NULL,1478659895),(426,4144,7,1,NULL,1478659895),(427,4145,7,1,NULL,1478659895),(428,4146,7,1,NULL,1478659895),(429,4147,7,1,NULL,1478659895),(430,4148,7,1,NULL,1478659895),(431,4149,7,1,NULL,1478659895),(432,4150,7,1,NULL,1478659895),(433,4151,7,1,NULL,1478659895),(434,4152,7,1,NULL,1478659895),(435,4153,7,1,NULL,1478659895),(436,4154,7,1,NULL,1478659895),(437,4155,7,1,NULL,1478659895),(438,4156,7,1,NULL,1478659895),(439,4157,7,1,NULL,1478659895),(440,4158,7,1,NULL,1478659895),(441,4159,7,1,NULL,1478659895),(442,4160,7,1,NULL,1478659895),(443,4161,7,1,NULL,1478659895),(444,4162,7,1,NULL,1478659895),(445,4163,7,1,NULL,1478659895),(446,4164,7,1,NULL,1478659895),(447,4165,7,1,NULL,1478659895),(448,4166,7,1,NULL,1478659895),(449,4167,7,1,NULL,1478659895),(450,4168,7,1,NULL,1478659895),(451,4169,7,1,NULL,1478659895),(452,4170,7,1,NULL,1478659895),(453,4171,7,1,NULL,1478659895),(454,4172,7,1,NULL,1478659895),(455,4173,7,1,NULL,1478659895),(456,4174,7,1,NULL,1478659895),(457,4175,7,1,NULL,1478659895),(458,4176,7,1,NULL,1478659895),(459,4177,7,1,NULL,1478659895),(460,4178,7,1,NULL,1478659895),(461,4179,7,1,NULL,1478659895),(462,4180,7,1,NULL,1478659895),(463,4181,7,1,NULL,1478659895),(464,4182,7,1,NULL,1478659895),(465,4183,7,1,NULL,1478659895),(466,4184,7,1,NULL,1478659895),(467,4185,7,1,NULL,1478659895),(468,4186,7,1,NULL,1478659895),(469,4187,7,1,NULL,1478659895),(470,4188,7,1,NULL,1478659895),(471,4189,7,1,NULL,1478659895),(472,4190,7,1,NULL,1478659895),(473,4191,7,1,NULL,1478659895),(474,4192,7,1,NULL,1478659895),(475,4193,7,1,NULL,1478659895),(476,4194,7,1,NULL,1478659895),(477,4195,7,1,NULL,1478659895),(478,4196,7,1,NULL,1478659895),(479,4197,7,1,NULL,1478659895),(480,4198,7,1,NULL,1478659895),(481,4199,7,1,NULL,1478659895),(482,4200,7,1,NULL,1478659895),(483,4201,7,1,NULL,1478659895),(484,4202,7,1,NULL,1478659895),(485,4203,7,1,NULL,1478659895),(486,4204,7,1,NULL,1478659895),(487,4205,7,1,NULL,1478659895),(488,4206,7,1,NULL,1478659895),(489,4207,7,1,NULL,1478659895),(490,4208,7,1,NULL,1478659895),(491,4209,7,1,NULL,1478659895),(492,4210,7,1,NULL,1478659895),(493,4211,7,1,NULL,1478659895),(494,4212,7,1,NULL,1478659895),(495,4213,7,1,NULL,1478659895),(496,4214,7,1,NULL,1478659895),(497,4215,7,1,NULL,1478659895),(498,4216,7,1,NULL,1478659895),(499,4217,7,1,NULL,1478659895),(500,4218,7,1,NULL,1478659895),(501,4219,7,1,NULL,1478659895),(502,4220,7,1,NULL,1478659895),(503,4221,7,1,NULL,1478659895),(504,4222,7,1,NULL,1478659895),(505,4223,7,1,NULL,1478659895),(506,4224,7,1,NULL,1478659895),(507,4225,7,1,NULL,1478659895),(508,4226,7,1,NULL,1478659895),(509,4227,7,1,NULL,1478659895),(510,4228,7,1,NULL,1478659895),(511,4229,7,1,NULL,1478659895),(512,4230,7,1,NULL,1478659895),(513,4231,7,1,NULL,1478659895),(514,4232,7,1,NULL,1478659895),(515,4233,7,1,NULL,1478659895),(516,4234,7,1,NULL,1478659895),(517,4235,7,1,NULL,1478659895),(518,4236,7,1,NULL,1478659895),(519,4237,7,1,NULL,1478659895),(520,4238,7,1,NULL,1478659895),(521,4239,7,1,NULL,1478659895),(522,4240,7,1,NULL,1478659895),(523,4241,7,1,NULL,1478659895),(524,4242,7,1,NULL,1478659895),(525,4243,7,1,NULL,1478659895),(526,4244,7,1,NULL,1478659895),(527,4245,7,1,NULL,1478659895),(528,4246,7,1,NULL,1478659895),(529,4247,7,1,NULL,1478659895),(530,4248,7,1,NULL,1478659895),(531,4157,11,1,NULL,1478659913),(532,4150,32,1,NULL,1478659955),(533,4157,26,1,NULL,1478660011),(534,7,20,1,1473969600,1478660930),(535,6,34,1,NULL,1478660965),(536,8,34,1,NULL,1478660973),(537,4249,1,1,NULL,1478661074),(538,4250,1,1,NULL,1478661074),(539,4251,1,1,NULL,1478883079),(540,4252,1,1,NULL,1478883079),(541,4273,1,1,NULL,1478883079),(542,4251,7,1,NULL,1478893124),(543,4252,7,1,NULL,1478893124),(544,4253,7,1,NULL,1478893124),(545,4254,7,1,NULL,1478893124),(546,4255,7,1,NULL,1478893124),(547,4256,7,1,NULL,1478893124),(548,4257,7,1,NULL,1478893124),(549,4258,7,1,NULL,1478893124),(550,4259,7,1,NULL,1478893124),(551,4260,7,1,NULL,1478893124),(552,4261,7,1,NULL,1478893124),(553,4262,7,1,NULL,1478893124),(554,4263,7,1,NULL,1478893124),(555,4264,7,1,NULL,1478893124),(556,4265,7,1,NULL,1478893124),(557,4266,7,1,NULL,1478893124),(558,4267,7,1,NULL,1478893124),(559,4268,7,1,NULL,1478893124),(560,4269,7,1,NULL,1478893124),(561,4270,7,1,NULL,1478893124),(562,4271,7,1,NULL,1478893124),(563,4272,7,1,NULL,1478893124),(564,4273,7,1,NULL,1478893124),(565,4274,7,1,NULL,1478893124),(566,4275,7,1,NULL,1478893124),(567,4276,7,1,NULL,1478893124),(568,4277,7,1,NULL,1478893124),(569,4278,7,1,NULL,1478893124),(570,4279,7,1,NULL,1478893124),(571,4280,7,1,NULL,1478893124),(572,4281,7,1,NULL,1478893124),(573,4282,7,1,NULL,1478893124),(574,4283,7,1,NULL,1478893124),(575,4284,7,1,NULL,1478893124),(576,4285,7,1,NULL,1478893124),(577,4286,7,1,NULL,1478893124),(578,4287,7,1,NULL,1478893124),(579,4288,7,1,NULL,1478893124),(580,4289,7,1,NULL,1478893124),(581,4290,7,1,NULL,1478893124),(582,4291,7,1,NULL,1478893124),(583,4292,7,1,NULL,1478893124),(584,4293,7,1,NULL,1478893124),(585,4294,7,1,NULL,1478893124),(586,4295,7,1,NULL,1478893124),(587,4296,7,1,NULL,1478893124),(588,4297,7,1,NULL,1478893124),(589,4298,7,1,NULL,1478893124),(590,4299,7,1,NULL,1478893124),(591,4300,7,1,NULL,1478893124),(592,4301,7,1,NULL,1478893124),(593,4302,7,1,NULL,1478893124),(594,4303,7,1,NULL,1478893124),(595,4304,7,1,NULL,1478893124),(596,4305,7,1,NULL,1478893124),(597,4306,7,1,NULL,1478893124),(598,4307,7,1,NULL,1478893124),(599,4308,7,1,NULL,1478893124),(600,4309,7,1,NULL,1478893124),(601,4310,7,1,NULL,1478893124),(602,4311,7,1,NULL,1478893124),(603,4312,7,1,NULL,1478893124),(604,4313,7,1,NULL,1478893124),(605,4314,7,1,NULL,1478893124),(606,4315,7,1,NULL,1478893124),(607,4316,7,1,NULL,1478893124),(608,4317,7,1,NULL,1478893124),(609,4318,7,1,NULL,1478893124),(610,4319,7,1,NULL,1478893124),(611,4320,7,1,NULL,1478893124),(612,4321,7,1,NULL,1478893124),(613,4322,7,1,NULL,1478893124),(614,4323,7,1,NULL,1478893124),(615,4324,7,1,NULL,1478893124),(616,4325,7,1,NULL,1478893124),(617,4326,7,1,NULL,1478893124),(618,4327,7,1,NULL,1478893124),(619,4328,7,1,NULL,1478893124),(620,4329,7,1,NULL,1478893124),(621,4330,7,1,NULL,1478893124),(622,4331,7,1,NULL,1478893124),(623,4332,7,1,NULL,1478893124),(624,4333,7,1,NULL,1478893124),(625,4334,7,1,NULL,1478893124),(626,4335,7,1,NULL,1478893124),(627,4336,7,1,NULL,1478893124),(628,4337,7,1,NULL,1478893124),(629,4338,7,1,NULL,1478893124),(630,4339,7,1,NULL,1478893124),(631,4340,7,1,NULL,1478893124),(632,4341,7,1,NULL,1478893124),(633,4342,7,1,NULL,1478893124),(634,4343,7,1,NULL,1478893124),(635,4344,7,1,NULL,1478893124),(636,4345,7,1,NULL,1478893124),(637,4346,7,1,NULL,1478893124),(638,4347,7,1,NULL,1478893124),(639,4348,7,1,NULL,1478893124),(640,4349,7,1,NULL,1478893124),(641,4350,7,1,NULL,1478893124),(642,4351,7,1,NULL,1478893124),(643,4352,7,1,NULL,1478893124),(644,4353,7,1,NULL,1478893124),(645,4354,7,1,NULL,1478893124),(646,4355,7,1,NULL,1478893124),(647,4356,7,1,NULL,1478893124),(648,4357,7,1,NULL,1478893124),(649,4358,7,1,NULL,1478893124),(650,4359,7,1,NULL,1478893124),(651,4360,7,1,NULL,1478893124),(652,4361,7,1,NULL,1478893124),(653,4362,7,1,NULL,1478893124),(654,4363,7,1,NULL,1478893124),(655,4364,7,1,NULL,1478893124),(656,4365,7,1,NULL,1478893124),(657,4366,7,1,NULL,1478893124),(658,4367,7,1,NULL,1478893124),(659,4368,7,1,NULL,1478893124),(660,4369,7,1,NULL,1478893124),(661,4370,7,1,NULL,1478893124),(662,4371,7,1,NULL,1478893124),(663,4372,7,1,NULL,1478893124),(664,4373,7,1,NULL,1478893124),(665,4374,7,1,NULL,1478893124),(666,4375,7,1,NULL,1478893124),(667,4376,7,1,NULL,1478893124),(668,4377,7,1,NULL,1478893124),(669,4378,7,1,NULL,1478893124),(670,4379,7,1,NULL,1478893124),(671,4380,7,1,NULL,1478893124),(672,4381,7,1,NULL,1478893124),(673,4382,7,1,NULL,1478893124),(674,4383,7,1,NULL,1478893124),(675,4384,7,1,NULL,1478893124),(676,4385,7,1,NULL,1478893124),(677,4251,29,1,NULL,1478893588),(678,4251,29,1,NULL,1478893620),(679,4252,29,1,NULL,1478893659),(680,4489,1,1,NULL,1479052697),(681,3923,1,1,NULL,1480183727),(682,4688,1,1,NULL,1480184670),(683,4814,1,1,NULL,1480186906),(684,4954,1,1,NULL,1480187061),(685,5092,1,1,NULL,1480192307),(686,5117,1,1,NULL,1480192708),(687,5247,1,1,NULL,1480200685),(688,5342,1,1,NULL,1483630350),(689,5490,2,1,NULL,1483630400),(690,5491,2,1,NULL,1483630400),(691,5636,1,4,NULL,1484773957),(692,5636,4,4,NULL,1484777008),(693,5637,4,4,NULL,1484777008),(694,5638,4,4,NULL,1484777008),(695,5639,4,4,NULL,1484777008),(696,5640,4,4,NULL,1484777008),(697,5641,4,4,NULL,1484777008),(698,5642,4,4,NULL,1484777008),(699,5643,4,4,NULL,1484777008),(700,5644,4,4,NULL,1484777008),(701,5645,4,4,NULL,1484777008),(702,5646,4,4,NULL,1484777008),(703,5647,4,4,NULL,1484777008),(704,5648,4,4,NULL,1484777008),(705,5649,4,4,NULL,1484777008),(706,5650,4,4,NULL,1484777008),(707,5651,4,4,NULL,1484777008),(708,5652,4,4,NULL,1484777008),(709,5653,4,4,NULL,1484777008),(710,5654,4,4,NULL,1484777008),(711,5655,4,4,NULL,1484777008),(712,5656,4,4,NULL,1484777008),(713,5657,4,4,NULL,1484777008),(714,5658,4,4,NULL,1484777008),(715,5659,4,4,NULL,1484777008),(716,5660,4,4,NULL,1484777008),(717,5661,4,4,NULL,1484777008),(718,5662,4,4,NULL,1484777008),(719,5663,4,4,NULL,1484777008),(720,5664,4,4,NULL,1484777008),(721,5665,4,4,NULL,1484777008),(722,5666,4,4,NULL,1484777008),(723,5667,4,4,NULL,1484777008),(724,5668,4,4,NULL,1484777008),(725,5669,4,4,NULL,1484777008),(726,5670,4,4,NULL,1484777008),(727,5671,4,4,NULL,1484777008),(728,5672,4,4,NULL,1484777008),(729,5673,4,4,NULL,1484777008),(730,5674,4,4,NULL,1484777008),(731,5675,4,4,NULL,1484777008),(732,5676,4,4,NULL,1484777008),(733,5677,4,4,NULL,1484777008),(734,5678,4,4,NULL,1484777008),(735,5679,4,4,NULL,1484777008),(736,5680,4,4,NULL,1484777008),(737,5681,4,4,NULL,1484777008),(738,5682,4,4,NULL,1484777008),(739,5683,4,4,NULL,1484777008),(740,5684,4,4,NULL,1484777008),(741,5685,4,4,NULL,1484777008),(742,5686,4,4,NULL,1484777008),(743,5687,4,4,NULL,1484777008),(744,5688,4,4,NULL,1484777008),(745,5689,4,4,NULL,1484777008),(746,5690,4,4,NULL,1484777008),(747,5691,4,4,NULL,1484777008),(748,5692,4,4,NULL,1484777008),(749,5693,4,4,NULL,1484777008),(750,5694,4,4,NULL,1484777008),(751,5695,4,4,NULL,1484777008),(752,5696,4,4,NULL,1484777008),(753,5697,4,4,NULL,1484777008),(754,5698,4,4,NULL,1484777008),(755,5699,4,4,NULL,1484777008),(756,5700,4,4,NULL,1484777008),(757,5701,4,4,NULL,1484777008),(758,5702,4,4,NULL,1484777008),(759,5703,4,4,NULL,1484777008),(760,5704,4,4,NULL,1484777008),(761,5705,4,4,NULL,1484777008),(762,5706,4,4,NULL,1484777008),(763,5707,4,4,NULL,1484777008),(764,5708,4,4,NULL,1484777008),(765,5709,4,4,NULL,1484777008),(766,5710,4,4,NULL,1484777008),(767,5711,4,4,NULL,1484777008),(768,5712,4,4,NULL,1484777008),(769,5713,4,4,NULL,1484777008),(770,5714,4,4,NULL,1484777008),(771,5715,4,4,NULL,1484777008),(772,5716,4,4,NULL,1484777008),(773,5717,4,4,NULL,1484777008),(774,5718,4,4,NULL,1484777008),(775,5719,4,4,NULL,1484777008),(776,5720,4,4,NULL,1484777008),(777,5721,4,4,NULL,1484777008),(778,5722,4,4,NULL,1484777008),(779,5723,4,4,NULL,1484777008),(780,5724,4,4,NULL,1484777008),(781,5725,4,4,NULL,1484777008),(782,5726,4,4,NULL,1484777008),(783,5727,4,4,NULL,1484777008),(784,5728,4,4,NULL,1484777008),(785,5729,4,4,NULL,1484777008),(786,5730,4,4,NULL,1484777008),(787,5731,4,4,NULL,1484777008),(788,5732,4,4,NULL,1484777008),(789,5733,4,4,NULL,1484777008),(790,5734,4,4,NULL,1484777008),(791,5735,4,4,NULL,1484777008),(792,5736,4,4,NULL,1484777008),(793,5737,4,4,NULL,1484777008),(794,5738,4,4,NULL,1484777008),(795,5739,4,4,NULL,1484777008),(796,5740,4,4,NULL,1484777008),(797,5741,4,4,NULL,1484777008),(798,5742,4,4,NULL,1484777008),(799,5743,4,4,NULL,1484777008),(800,5744,4,4,NULL,1484777008),(801,5745,4,4,NULL,1484777008),(802,5746,4,4,NULL,1484777008),(803,5747,4,4,NULL,1484777008),(804,5748,4,4,NULL,1484777008),(805,5749,4,4,NULL,1484777008),(806,5750,4,4,NULL,1484777008),(807,5751,4,4,NULL,1484777008),(808,5752,4,4,NULL,1484777008),(809,5753,4,4,NULL,1484777008),(810,5754,4,4,NULL,1484777008),(811,5755,4,4,NULL,1484777008),(812,5756,4,4,NULL,1484777008),(813,5757,4,4,NULL,1484777008),(814,5758,4,4,NULL,1484777008),(815,5759,4,4,NULL,1484777008),(816,5760,4,4,NULL,1484777008),(817,5761,4,4,NULL,1484777008),(818,5762,4,4,NULL,1484777008),(819,5763,4,4,NULL,1484777008),(820,5764,4,4,NULL,1484777008),(821,5765,4,4,NULL,1484777008),(822,5766,4,4,NULL,1484777008),(823,5767,4,4,NULL,1484777008),(824,5768,4,4,NULL,1484777008),(825,2291,1,1,NULL,1484802241),(826,2341,1,1,NULL,1484802241),(827,5636,4,1,NULL,1484864770),(828,5637,4,1,NULL,1484864771),(829,5638,4,1,NULL,1484864771),(830,5639,4,1,NULL,1484864771),(831,5640,4,1,NULL,1484864771),(832,5641,4,1,NULL,1484864771),(833,5642,4,1,NULL,1484864771),(834,5643,4,1,NULL,1484864771),(835,5644,4,1,NULL,1484864771),(836,5645,4,1,NULL,1484864771),(837,5646,4,1,NULL,1484864771),(838,5647,4,1,NULL,1484864771),(839,5648,4,1,NULL,1484864771),(840,5649,4,1,NULL,1484864771),(841,5650,4,1,NULL,1484864771),(842,5651,4,1,NULL,1484864771),(843,5652,4,1,NULL,1484864771),(844,5653,4,1,NULL,1484864771),(845,5654,4,1,NULL,1484864771),(846,5655,4,1,NULL,1484864771),(847,5656,4,1,NULL,1484864771),(848,5657,4,1,NULL,1484864771),(849,5658,4,1,NULL,1484864771),(850,5659,4,1,NULL,1484864771),(851,5660,4,1,NULL,1484864771),(852,5661,4,1,NULL,1484864771),(853,5662,4,1,NULL,1484864771),(854,5663,4,1,NULL,1484864771),(855,5664,4,1,NULL,1484864771),(856,5665,4,1,NULL,1484864771),(857,5666,4,1,NULL,1484864771),(858,5667,4,1,NULL,1484864771),(859,5668,4,1,NULL,1484864771),(860,5669,4,1,NULL,1484864771),(861,5670,4,1,NULL,1484864771),(862,5671,4,1,NULL,1484864771),(863,5672,4,1,NULL,1484864771),(864,5673,4,1,NULL,1484864771),(865,5674,4,1,NULL,1484864771),(866,5675,4,1,NULL,1484864771),(867,5676,4,1,NULL,1484864771),(868,5677,4,1,NULL,1484864771),(869,5678,4,1,NULL,1484864771),(870,5679,4,1,NULL,1484864771),(871,5680,4,1,NULL,1484864771),(872,5681,4,1,NULL,1484864771),(873,5682,4,1,NULL,1484864771),(874,5683,4,1,NULL,1484864771),(875,5684,4,1,NULL,1484864771),(876,5685,4,1,NULL,1484864771),(877,5686,4,1,NULL,1484864771),(878,5687,4,1,NULL,1484864771),(879,5688,4,1,NULL,1484864771),(880,5689,4,1,NULL,1484864771),(881,5690,4,1,NULL,1484864771),(882,5691,4,1,NULL,1484864771),(883,5692,4,1,NULL,1484864771),(884,5693,4,1,NULL,1484864771),(885,5694,4,1,NULL,1484864771),(886,5695,4,1,NULL,1484864771),(887,5696,4,1,NULL,1484864771),(888,5697,4,1,NULL,1484864771),(889,5698,4,1,NULL,1484864771),(890,5699,4,1,NULL,1484864771),(891,5700,4,1,NULL,1484864771),(892,5701,4,1,NULL,1484864771),(893,5702,4,1,NULL,1484864771),(894,5703,4,1,NULL,1484864771),(895,5704,4,1,NULL,1484864771),(896,5705,4,1,NULL,1484864771),(897,5706,4,1,NULL,1484864771),(898,5707,4,1,NULL,1484864771),(899,5708,4,1,NULL,1484864771),(900,5709,4,1,NULL,1484864771),(901,5710,4,1,NULL,1484864771),(902,5711,4,1,NULL,1484864771),(903,5712,4,1,NULL,1484864771),(904,5713,4,1,NULL,1484864771),(905,5714,4,1,NULL,1484864771),(906,5715,4,1,NULL,1484864771),(907,5716,4,1,NULL,1484864771),(908,5717,4,1,NULL,1484864771),(909,5718,4,1,NULL,1484864771),(910,5719,4,1,NULL,1484864771),(911,5720,4,1,NULL,1484864771),(912,5721,4,1,NULL,1484864771),(913,5722,4,1,NULL,1484864771),(914,5723,4,1,NULL,1484864771),(915,5724,4,1,NULL,1484864771),(916,5725,4,1,NULL,1484864771),(917,5726,4,1,NULL,1484864771),(918,5727,4,1,NULL,1484864771),(919,5728,4,1,NULL,1484864771),(920,5729,4,1,NULL,1484864771),(921,5730,4,1,NULL,1484864771),(922,5731,4,1,NULL,1484864771),(923,5732,4,1,NULL,1484864771),(924,5733,4,1,NULL,1484864771),(925,5734,4,1,NULL,1484864771),(926,5735,4,1,NULL,1484864771),(927,5736,4,1,NULL,1484864771),(928,5737,4,1,NULL,1484864771),(929,5738,4,1,NULL,1484864771),(930,5739,4,1,NULL,1484864771),(931,5740,4,1,NULL,1484864771),(932,5741,4,1,NULL,1484864771),(933,5742,4,1,NULL,1484864771),(934,5743,4,1,NULL,1484864771),(935,5744,4,1,NULL,1484864771),(936,5745,4,1,NULL,1484864771),(937,5746,4,1,NULL,1484864771),(938,5747,4,1,NULL,1484864771),(939,5748,4,1,NULL,1484864771),(940,5749,4,1,NULL,1484864771),(941,5750,4,1,NULL,1484864771),(942,5751,4,1,NULL,1484864771),(943,5752,4,1,NULL,1484864771),(944,5753,4,1,NULL,1484864771),(945,5754,4,1,NULL,1484864771),(946,5755,4,1,NULL,1484864771),(947,5756,4,1,NULL,1484864771),(948,5757,4,1,NULL,1484864771),(949,5758,4,1,NULL,1484864771),(950,5759,4,1,NULL,1484864771),(951,5760,4,1,NULL,1484864771),(952,5761,4,1,NULL,1484864771),(953,5762,4,1,NULL,1484864771),(954,5763,4,1,NULL,1484864771),(955,5764,4,1,NULL,1484864771),(956,5765,4,1,NULL,1484864771),(957,5766,4,1,NULL,1484864771),(958,5767,4,1,NULL,1484864771),(959,5768,4,1,NULL,1484864771),(960,5636,7,1,NULL,1484864862),(961,5637,7,1,NULL,1484864862),(962,5638,7,1,NULL,1484864862),(963,5639,7,1,NULL,1484864862),(964,5640,7,1,NULL,1484864862),(965,5641,7,1,NULL,1484864862),(966,5642,7,1,NULL,1484864862),(967,5643,7,1,NULL,1484864862),(968,5644,7,1,NULL,1484864862),(969,5645,7,1,NULL,1484864862),(970,5646,7,1,NULL,1484864862),(971,5647,7,1,NULL,1484864862),(972,5648,7,1,NULL,1484864862),(973,5649,7,1,NULL,1484864862),(974,5650,7,1,NULL,1484864862),(975,5651,7,1,NULL,1484864862),(976,5652,7,1,NULL,1484864862),(977,5653,7,1,NULL,1484864862),(978,5654,7,1,NULL,1484864862),(979,5655,7,1,NULL,1484864862),(980,5656,7,1,NULL,1484864862),(981,5657,7,1,NULL,1484864862),(982,5658,7,1,NULL,1484864862),(983,5659,7,1,NULL,1484864862),(984,5660,7,1,NULL,1484864862),(985,5661,7,1,NULL,1484864862),(986,5662,7,1,NULL,1484864862),(987,5663,7,1,NULL,1484864862),(988,5664,7,1,NULL,1484864862),(989,5665,7,1,NULL,1484864862),(990,5666,7,1,NULL,1484864862),(991,5667,7,1,NULL,1484864862),(992,5668,7,1,NULL,1484864862),(993,5669,7,1,NULL,1484864862),(994,5670,7,1,NULL,1484864862),(995,5671,7,1,NULL,1484864862),(996,5672,7,1,NULL,1484864862),(997,5673,7,1,NULL,1484864862),(998,5674,7,1,NULL,1484864862),(999,5675,7,1,NULL,1484864862),(1000,5676,7,1,NULL,1484864862),(1001,5677,7,1,NULL,1484864862),(1002,5678,7,1,NULL,1484864862),(1003,5679,7,1,NULL,1484864862),(1004,5680,7,1,NULL,1484864862),(1005,5681,7,1,NULL,1484864862),(1006,5682,7,1,NULL,1484864862),(1007,5683,7,1,NULL,1484864862),(1008,5684,7,1,NULL,1484864862),(1009,5685,7,1,NULL,1484864862),(1010,5686,7,1,NULL,1484864862),(1011,5687,7,1,NULL,1484864862),(1012,5688,7,1,NULL,1484864862),(1013,5689,7,1,NULL,1484864862),(1014,5690,7,1,NULL,1484864862),(1015,5691,7,1,NULL,1484864862),(1016,5692,7,1,NULL,1484864862),(1017,5693,7,1,NULL,1484864862),(1018,5694,7,1,NULL,1484864862),(1019,5695,7,1,NULL,1484864862),(1020,5696,7,1,NULL,1484864862),(1021,5697,7,1,NULL,1484864862),(1022,5698,7,1,NULL,1484864862),(1023,5699,7,1,NULL,1484864862),(1024,5700,7,1,NULL,1484864862),(1025,5701,7,1,NULL,1484864862),(1026,5702,7,1,NULL,1484864862),(1027,5703,7,1,NULL,1484864862),(1028,5704,7,1,NULL,1484864862),(1029,5705,7,1,NULL,1484864862),(1030,5706,7,1,NULL,1484864862),(1031,5707,7,1,NULL,1484864862),(1032,5708,7,1,NULL,1484864862),(1033,5709,7,1,NULL,1484864862),(1034,5710,7,1,NULL,1484864862),(1035,5711,7,1,NULL,1484864862),(1036,5712,7,1,NULL,1484864862),(1037,5713,7,1,NULL,1484864862),(1038,5714,7,1,NULL,1484864862),(1039,5715,7,1,NULL,1484864862),(1040,5716,7,1,NULL,1484864862),(1041,5717,7,1,NULL,1484864862),(1042,5718,7,1,NULL,1484864862),(1043,5719,7,1,NULL,1484864862),(1044,5720,7,1,NULL,1484864862),(1045,5721,7,1,NULL,1484864862),(1046,5722,7,1,NULL,1484864862),(1047,5723,7,1,NULL,1484864862),(1048,5724,7,1,NULL,1484864862),(1049,5725,7,1,NULL,1484864862),(1050,5726,7,1,NULL,1484864862),(1051,5727,7,1,NULL,1484864862),(1052,5728,7,1,NULL,1484864862),(1053,5729,7,1,NULL,1484864862),(1054,5730,7,1,NULL,1484864862),(1055,5731,7,1,NULL,1484864862),(1056,5732,7,1,NULL,1484864862),(1057,5733,7,1,NULL,1484864862),(1058,5734,7,1,NULL,1484864862),(1059,5735,7,1,NULL,1484864862),(1060,5736,7,1,NULL,1484864862),(1061,5737,7,1,NULL,1484864862),(1062,5738,7,1,NULL,1484864862),(1063,5739,7,1,NULL,1484864862),(1064,5740,7,1,NULL,1484864862),(1065,5741,7,1,NULL,1484864862),(1066,5742,7,1,NULL,1484864862),(1067,5743,7,1,NULL,1484864862),(1068,5744,7,1,NULL,1484864862),(1069,5745,7,1,NULL,1484864862),(1070,5746,7,1,NULL,1484864862),(1071,5747,7,1,NULL,1484864862),(1072,5748,7,1,NULL,1484864862),(1073,5749,7,1,NULL,1484864862),(1074,5750,7,1,NULL,1484864862),(1075,5751,7,1,NULL,1484864862),(1076,5752,7,1,NULL,1484864862),(1077,5753,7,1,NULL,1484864862),(1078,5754,7,1,NULL,1484864862),(1079,5755,7,1,NULL,1484864862),(1080,5756,7,1,NULL,1484864862),(1081,5757,7,1,NULL,1484864862),(1082,5758,7,1,NULL,1484864862),(1083,5759,7,1,NULL,1484864862),(1084,5760,7,1,NULL,1484864862),(1085,5761,7,1,NULL,1484864862),(1086,5762,7,1,NULL,1484864862),(1087,5763,7,1,NULL,1484864862),(1088,5764,7,1,NULL,1484864862),(1089,5765,7,1,NULL,1484864862),(1090,5766,7,1,NULL,1484864862),(1091,5767,7,1,NULL,1484864862),(1092,5768,7,1,NULL,1484864862),(1093,5636,32,1,NULL,1484864885),(1094,5490,2,1,NULL,1484864989),(1095,5491,2,1,NULL,1484864989),(1096,5492,2,1,NULL,1484864989),(1097,5493,2,1,NULL,1484864989),(1098,5494,2,1,NULL,1484864989),(1099,5495,2,1,NULL,1484864989),(1100,5496,2,1,NULL,1484864989),(1101,5497,2,1,NULL,1484864989),(1102,5498,2,1,NULL,1484864989),(1103,5499,2,1,NULL,1484864989),(1104,5500,2,1,NULL,1484864989),(1105,5501,2,1,NULL,1484864989),(1106,5502,2,1,NULL,1484864989),(1107,5503,2,1,NULL,1484864989),(1108,5504,2,1,NULL,1484864989),(1109,5505,2,1,NULL,1484864989),(1110,5506,2,1,NULL,1484864989),(1111,5507,2,1,NULL,1484864989),(1112,5508,2,1,NULL,1484864989),(1113,5509,2,1,NULL,1484864989),(1114,5510,2,1,NULL,1484864989),(1115,5511,2,1,NULL,1484864989),(1116,5512,2,1,NULL,1484864989),(1117,5513,2,1,NULL,1484864989),(1118,5514,2,1,NULL,1484864989),(1119,5515,2,1,NULL,1484864989),(1120,5516,2,1,NULL,1484864989),(1121,5517,2,1,NULL,1484864989),(1122,5518,2,1,NULL,1484864989),(1123,5519,2,1,NULL,1484864989),(1124,5520,2,1,NULL,1484864989),(1125,5521,2,1,NULL,1484864989),(1126,5522,2,1,NULL,1484864989),(1127,5523,2,1,NULL,1484864989),(1128,5524,2,1,NULL,1484864989),(1129,5525,2,1,NULL,1484864989),(1130,5526,2,1,NULL,1484864989),(1131,5527,2,1,NULL,1484864989),(1132,5528,2,1,NULL,1484864989),(1133,5529,2,1,NULL,1484864989),(1134,5530,2,1,NULL,1484864989),(1135,5531,2,1,NULL,1484864989),(1136,5532,2,1,NULL,1484864989),(1137,5533,2,1,NULL,1484864989),(1138,5534,2,1,NULL,1484864989),(1139,5535,2,1,NULL,1484864989),(1140,5536,2,1,NULL,1484864989),(1141,5537,2,1,NULL,1484864989),(1142,5538,2,1,NULL,1484864989),(1143,5539,2,1,NULL,1484864989),(1144,5540,2,1,NULL,1484864989),(1145,5541,2,1,NULL,1484864989),(1146,5542,2,1,NULL,1484864989),(1147,5543,2,1,NULL,1484864989),(1148,5544,2,1,NULL,1484864989),(1149,5545,2,1,NULL,1484864989),(1150,5546,2,1,NULL,1484864989),(1151,5547,2,1,NULL,1484864989),(1152,5548,2,1,NULL,1484864989),(1153,5549,2,1,NULL,1484864989),(1154,5550,2,1,NULL,1484864989),(1155,5551,2,1,NULL,1484864989),(1156,5552,2,1,NULL,1484864989),(1157,5553,2,1,NULL,1484864989),(1158,5554,2,1,NULL,1484864989),(1159,5555,2,1,NULL,1484864989),(1160,5556,2,1,NULL,1484864989),(1161,5557,2,1,NULL,1484864989),(1162,5558,2,1,NULL,1484864989),(1163,5559,2,1,NULL,1484864989),(1164,5560,2,1,NULL,1484864989),(1165,5561,2,1,NULL,1484864989),(1166,5562,2,1,NULL,1484864989),(1167,5563,2,1,NULL,1484864989),(1168,5564,2,1,NULL,1484864989),(1169,5565,2,1,NULL,1484864989),(1170,5566,2,1,NULL,1484864989),(1171,5567,2,1,NULL,1484864989),(1172,5568,2,1,NULL,1484864989),(1173,5569,2,1,NULL,1484864989),(1174,5570,2,1,NULL,1484864990),(1175,5571,2,1,NULL,1484864990),(1176,5572,2,1,NULL,1484864990),(1177,5573,2,1,NULL,1484864990),(1178,5574,2,1,NULL,1484864990),(1179,5575,2,1,NULL,1484864990),(1180,5576,2,1,NULL,1484864990),(1181,5577,2,1,NULL,1484864990),(1182,5578,2,1,NULL,1484864990),(1183,5579,2,1,NULL,1484864990),(1184,5580,2,1,NULL,1484864990),(1185,5581,2,1,NULL,1484864990),(1186,5582,2,1,NULL,1484864990),(1187,5583,2,1,NULL,1484864990),(1188,5584,2,1,NULL,1484864990),(1189,5585,2,1,NULL,1484864990),(1190,5586,2,1,NULL,1484864990),(1191,5587,2,1,NULL,1484864990),(1192,5588,2,1,NULL,1484864990),(1193,5589,2,1,NULL,1484864990),(1194,5590,2,1,NULL,1484864990),(1195,5591,2,1,NULL,1484864990),(1196,5592,2,1,NULL,1484864990),(1197,5593,2,1,NULL,1484864990),(1198,5594,2,1,NULL,1484864990),(1199,5595,2,1,NULL,1484864990),(1200,5596,2,1,NULL,1484864990),(1201,5597,2,1,NULL,1484864990),(1202,5598,2,1,NULL,1484864990),(1203,5599,2,1,NULL,1484864990),(1204,5600,2,1,NULL,1484864990),(1205,5601,2,1,NULL,1484864990),(1206,5602,2,1,NULL,1484864990),(1207,5603,2,1,NULL,1484864990),(1208,5604,2,1,NULL,1484864990),(1209,5605,2,1,NULL,1484864990),(1210,5606,2,1,NULL,1484864990),(1211,5607,2,1,NULL,1484864990),(1212,5608,2,1,NULL,1484864990),(1213,5609,2,1,NULL,1484864990),(1214,5610,2,1,NULL,1484864990),(1215,5611,2,1,NULL,1484864990),(1216,5612,2,1,NULL,1484864990),(1217,5613,2,1,NULL,1484864990),(1218,5614,2,1,NULL,1484864990),(1219,5615,2,1,NULL,1484864990),(1220,5616,2,1,NULL,1484864990),(1221,5617,2,1,NULL,1484864990),(1222,5618,2,1,NULL,1484864990),(1223,5619,2,1,NULL,1484864990),(1224,5620,2,1,NULL,1484864990),(1225,5621,2,1,NULL,1484864990),(1226,5622,2,1,NULL,1484864990),(1227,5623,2,1,NULL,1484864990),(1228,5624,2,1,NULL,1484864990),(1229,5625,2,1,NULL,1484864990),(1230,5626,2,1,NULL,1484864990),(1231,5627,2,1,NULL,1484864990),(1232,5628,2,1,NULL,1484864990),(1233,5629,2,1,NULL,1484864990),(1234,5630,2,1,NULL,1484864990),(1235,5631,2,1,NULL,1484864990),(1236,5632,2,1,NULL,1484864990),(1237,5633,2,1,NULL,1484864990),(1238,5634,2,1,NULL,1484864990),(1239,5635,2,1,NULL,1484864990),(1240,5490,8,1,NULL,1484864994),(1241,5491,8,1,NULL,1484864994),(1242,5492,8,1,NULL,1484864994),(1243,5493,8,1,NULL,1484864994),(1244,5494,8,1,NULL,1484864994),(1245,5495,8,1,NULL,1484864994),(1246,5496,8,1,NULL,1484864994),(1247,5497,8,1,NULL,1484864994),(1248,5498,8,1,NULL,1484864994),(1249,5499,8,1,NULL,1484864994),(1250,5500,8,1,NULL,1484864994),(1251,5501,8,1,NULL,1484864994),(1252,5502,8,1,NULL,1484864994),(1253,5503,8,1,NULL,1484864994),(1254,5504,8,1,NULL,1484864994),(1255,5505,8,1,NULL,1484864994),(1256,5506,8,1,NULL,1484864994),(1257,5507,8,1,NULL,1484864994),(1258,5508,8,1,NULL,1484864994),(1259,5509,8,1,NULL,1484864994),(1260,5510,8,1,NULL,1484864994),(1261,5511,8,1,NULL,1484864994),(1262,5512,8,1,NULL,1484864994),(1263,5513,8,1,NULL,1484864994),(1264,5514,8,1,NULL,1484864994),(1265,5515,8,1,NULL,1484864994),(1266,5516,8,1,NULL,1484864994),(1267,5517,8,1,NULL,1484864994),(1268,5518,8,1,NULL,1484864994),(1269,5519,8,1,NULL,1484864994),(1270,5520,8,1,NULL,1484864994),(1271,5521,8,1,NULL,1484864994),(1272,5522,8,1,NULL,1484864994),(1273,5523,8,1,NULL,1484864994),(1274,5524,8,1,NULL,1484864994),(1275,5525,8,1,NULL,1484864994),(1276,5526,8,1,NULL,1484864994),(1277,5527,8,1,NULL,1484864994),(1278,5528,8,1,NULL,1484864994),(1279,5529,8,1,NULL,1484864994),(1280,5530,8,1,NULL,1484864994),(1281,5531,8,1,NULL,1484864994),(1282,5532,8,1,NULL,1484864994),(1283,5533,8,1,NULL,1484864994),(1284,5534,8,1,NULL,1484864994),(1285,5535,8,1,NULL,1484864994),(1286,5536,8,1,NULL,1484864994),(1287,5537,8,1,NULL,1484864994),(1288,5538,8,1,NULL,1484864994),(1289,5539,8,1,NULL,1484864994),(1290,5540,8,1,NULL,1484864994),(1291,5541,8,1,NULL,1484864994),(1292,5542,8,1,NULL,1484864994),(1293,5543,8,1,NULL,1484864994),(1294,5544,8,1,NULL,1484864994),(1295,5545,8,1,NULL,1484864994),(1296,5546,8,1,NULL,1484864994),(1297,5547,8,1,NULL,1484864994),(1298,5548,8,1,NULL,1484864994),(1299,5549,8,1,NULL,1484864994),(1300,5550,8,1,NULL,1484864994),(1301,5551,8,1,NULL,1484864994),(1302,5552,8,1,NULL,1484864994),(1303,5553,8,1,NULL,1484864994),(1304,5554,8,1,NULL,1484864994),(1305,5555,8,1,NULL,1484864994),(1306,5556,8,1,NULL,1484864994),(1307,5557,8,1,NULL,1484864994),(1308,5558,8,1,NULL,1484864994),(1309,5559,8,1,NULL,1484864994),(1310,5560,8,1,NULL,1484864994),(1311,5561,8,1,NULL,1484864994),(1312,5562,8,1,NULL,1484864994),(1313,5563,8,1,NULL,1484864994),(1314,5564,8,1,NULL,1484864994),(1315,5565,8,1,NULL,1484864994),(1316,5566,8,1,NULL,1484864994),(1317,5567,8,1,NULL,1484864995),(1318,5568,8,1,NULL,1484864995),(1319,5569,8,1,NULL,1484864995),(1320,5570,8,1,NULL,1484864995),(1321,5571,8,1,NULL,1484864995),(1322,5572,8,1,NULL,1484864995),(1323,5573,8,1,NULL,1484864995),(1324,5574,8,1,NULL,1484864995),(1325,5575,8,1,NULL,1484864995),(1326,5576,8,1,NULL,1484864995),(1327,5577,8,1,NULL,1484864995),(1328,5578,8,1,NULL,1484864995),(1329,5579,8,1,NULL,1484864995),(1330,5580,8,1,NULL,1484864995),(1331,5581,8,1,NULL,1484864995),(1332,5582,8,1,NULL,1484864995),(1333,5583,8,1,NULL,1484864995),(1334,5584,8,1,NULL,1484864995),(1335,5585,8,1,NULL,1484864995),(1336,5586,8,1,NULL,1484864995),(1337,5587,8,1,NULL,1484864995),(1338,5588,8,1,NULL,1484864995),(1339,5589,8,1,NULL,1484864995),(1340,5590,8,1,NULL,1484864995),(1341,5591,8,1,NULL,1484864995),(1342,5592,8,1,NULL,1484864995),(1343,5593,8,1,NULL,1484864995),(1344,5594,8,1,NULL,1484864995),(1345,5595,8,1,NULL,1484864995),(1346,5596,8,1,NULL,1484864995),(1347,5597,8,1,NULL,1484864995),(1348,5598,8,1,NULL,1484864995),(1349,5599,8,1,NULL,1484864995),(1350,5600,8,1,NULL,1484864995),(1351,5601,8,1,NULL,1484864995),(1352,5602,8,1,NULL,1484864995),(1353,5603,8,1,NULL,1484864995),(1354,5604,8,1,NULL,1484864995),(1355,5605,8,1,NULL,1484864995),(1356,5606,8,1,NULL,1484864995),(1357,5607,8,1,NULL,1484864995),(1358,5608,8,1,NULL,1484864995),(1359,5609,8,1,NULL,1484864995),(1360,5610,8,1,NULL,1484864995),(1361,5611,8,1,NULL,1484864995),(1362,5612,8,1,NULL,1484864995),(1363,5613,8,1,NULL,1484864995),(1364,5614,8,1,NULL,1484864995),(1365,5615,8,1,NULL,1484864995),(1366,5616,8,1,NULL,1484864995),(1367,5617,8,1,NULL,1484864995),(1368,5618,8,1,NULL,1484864995),(1369,5619,8,1,NULL,1484864995),(1370,5620,8,1,NULL,1484864995),(1371,5621,8,1,NULL,1484864995),(1372,5622,8,1,NULL,1484864995),(1373,5623,8,1,NULL,1484864995),(1374,5624,8,1,NULL,1484864995),(1375,5625,8,1,NULL,1484864995),(1376,5626,8,1,NULL,1484864995),(1377,5627,8,1,NULL,1484864995),(1378,5628,8,1,NULL,1484864995),(1379,5629,8,1,NULL,1484864995),(1380,5630,8,1,NULL,1484864995),(1381,5631,8,1,NULL,1484864995),(1382,5632,8,1,NULL,1484864995),(1383,5633,8,1,NULL,1484864995),(1384,5634,8,1,NULL,1484864995),(1385,5635,8,1,NULL,1484864995),(1386,5490,27,1,NULL,1484865029),(1387,5490,33,1,NULL,1484865143),(1388,5490,33,1,NULL,1484865143),(1389,5490,33,1,NULL,1484865143),(1390,5769,2,1,NULL,1486138231),(1391,4273,29,1,NULL,1500678765),(1392,4483,7,1,NULL,1500678881),(1393,4484,7,1,NULL,1500678881),(1394,4485,7,1,NULL,1500678881),(1395,4486,7,1,NULL,1500678881),(1396,4487,7,1,NULL,1500678881),(1397,4488,7,1,NULL,1500678881),(1398,4489,7,1,NULL,1500678881),(1399,4490,7,1,NULL,1500678881),(1400,4491,7,1,NULL,1500678881),(1401,4492,7,1,NULL,1500678881),(1402,4493,7,1,NULL,1500678881),(1403,4494,7,1,NULL,1500678881),(1404,4495,7,1,NULL,1500678881),(1405,4496,7,1,NULL,1500678881),(1406,4497,7,1,NULL,1500678881),(1407,4498,7,1,NULL,1500678881),(1408,4499,7,1,NULL,1500678881),(1409,4500,7,1,NULL,1500678881),(1410,4501,7,1,NULL,1500678881),(1411,4502,7,1,NULL,1500678881),(1412,4503,7,1,NULL,1500678881),(1413,4504,7,1,NULL,1500678881),(1414,4505,7,1,NULL,1500678881),(1415,4506,7,1,NULL,1500678881),(1416,4507,7,1,NULL,1500678881),(1417,4508,7,1,NULL,1500678881),(1418,4509,7,1,NULL,1500678881),(1419,4510,7,1,NULL,1500678881),(1420,4511,7,1,NULL,1500678881),(1421,4512,7,1,NULL,1500678881),(1422,4513,7,1,NULL,1500678881),(1423,4514,7,1,NULL,1500678881),(1424,4515,7,1,NULL,1500678881),(1425,4516,7,1,NULL,1500678881),(1426,4517,7,1,NULL,1500678881),(1427,4518,7,1,NULL,1500678881),(1428,4519,7,1,NULL,1500678881),(1429,4520,7,1,NULL,1500678881),(1430,4521,7,1,NULL,1500678881),(1431,4522,7,1,NULL,1500678881),(1432,4523,7,1,NULL,1500678881),(1433,4524,7,1,NULL,1500678881),(1434,4525,7,1,NULL,1500678881),(1435,4526,7,1,NULL,1500678881),(1436,4527,7,1,NULL,1500678881),(1437,4528,7,1,NULL,1500678881),(1438,4529,7,1,NULL,1500678881),(1439,4530,7,1,NULL,1500678881),(1440,4531,7,1,NULL,1500678881),(1441,4532,7,1,NULL,1500678881),(1442,4533,7,1,NULL,1500678881),(1443,4534,7,1,NULL,1500678881),(1444,4535,7,1,NULL,1500678881),(1445,4536,7,1,NULL,1500678881),(1446,4537,7,1,NULL,1500678881),(1447,4538,7,1,NULL,1500678881),(1448,4539,7,1,NULL,1500678881),(1449,4540,7,1,NULL,1500678881),(1450,4541,7,1,NULL,1500678881),(1451,4542,7,1,NULL,1500678881),(1452,4543,7,1,NULL,1500678881),(1453,4544,7,1,NULL,1500678881),(1454,4545,7,1,NULL,1500678881),(1455,4546,7,1,NULL,1500678881),(1456,4547,7,1,NULL,1500678881),(1457,4548,7,1,NULL,1500678881),(1458,4549,7,1,NULL,1500678881),(1459,4550,7,1,NULL,1500678881),(1460,4551,7,1,NULL,1500678881),(1461,4552,7,1,NULL,1500678881),(1462,4553,7,1,NULL,1500678881),(1463,4554,7,1,NULL,1500678881),(1464,4555,7,1,NULL,1500678881),(1465,4556,7,1,NULL,1500678881),(1466,4557,7,1,NULL,1500678881),(1467,4558,7,1,NULL,1500678881),(1468,4559,7,1,NULL,1500678881),(1469,4560,7,1,NULL,1500678881),(1470,4561,7,1,NULL,1500678881),(1471,4562,7,1,NULL,1500678881),(1472,4563,7,1,NULL,1500678881),(1473,4564,7,1,NULL,1500678881),(1474,4565,7,1,NULL,1500678881),(1475,4566,7,1,NULL,1500678881),(1476,4567,7,1,NULL,1500678881),(1477,4568,7,1,NULL,1500678881),(1478,4569,7,1,NULL,1500678881),(1479,4570,7,1,NULL,1500678881),(1480,4571,7,1,NULL,1500678881),(1481,4572,7,1,NULL,1500678881),(1482,4573,7,1,NULL,1500678881),(1483,4574,7,1,NULL,1500678881),(1484,4575,7,1,NULL,1500678881),(1485,4576,7,1,NULL,1500678881),(1486,4577,7,1,NULL,1500678881),(1487,4578,7,1,NULL,1500678881),(1488,4579,7,1,NULL,1500678881),(1489,4489,26,1,NULL,1500678894);

--
-- Table structure for table `im_reportes_respuestas`
--

CREATE TABLE `im_reportes_respuestas` (
  `codigo` bigint(20) NOT NULL AUTO_INCREMENT,
  `codigo_problema` bigint(20) DEFAULT NULL,
  `codigo_usuario` int(11) DEFAULT NULL,
  `tipo` tinyint(4) DEFAULT NULL,
  `descripcion` text,
  `archivo` text,
  `fecha_creacion` int(11) DEFAULT NULL,
  `codigo_estatus` int(11) DEFAULT NULL,
  `fecha_visita` int(11) DEFAULT NULL,
  PRIMARY KEY (`codigo`),
  KEY `codigo_problema` (`codigo_problema`),
  KEY `codigo_usuario` (`codigo_usuario`),
  CONSTRAINT `im_reportes_respuestas_ibfk_1` FOREIGN KEY (`codigo_problema`) REFERENCES `im_reportes_problemas` (`codigo`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `im_reportes_respuestas_ibfk_2` FOREIGN KEY (`codigo_usuario`) REFERENCES `im_usuarios` (`codigo`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `im_reportes_respuestas`
--

INSERT INTO `im_reportes_respuestas` VALUES (8,1,1,NULL,'Asignado al contratista: Carlos Moreno',NULL,1473715678,NULL,NULL),(9,1,1,2,'Ya fue reparado y se program&amp;oacute; la inspecci&amp;oacute;n final.',NULL,1473715863,23,1474056000),(10,5,1,NULL,'Asignado al contratista: Ebanister&iacute;a Moderna',NULL,1473716961,NULL,NULL),(11,5,1,1,'Ya fue reparado. Falta coordinar la cita para inspecci&amp;oacute;n final con el cliente para su aprobaci&amp;oacute;n.',NULL,1473717079,26,NULL),(12,7,1,NULL,'Asignado al contratista: Carlos Moreno',NULL,1473797684,NULL,NULL),(13,7,1,3,'Revisar cableado.',NULL,1473797881,10,1473969600),(14,9,1,NULL,'Asignado al contratista: Ebanister&iacute;a Moderna',NULL,1473799642,NULL,NULL),(15,9,1,2,'Revisar todos los marcos.',NULL,1473799833,10,1473883200),(16,9,1,2,'Estar muy atento con este cliente est&amp;aacute; muy molesto.',NULL,1473799994,10,1473883200),(17,9,1,3,'Ya fue reparado',NULL,1473800036,25,1473883200),(18,9,1,3,'Se revisaron todos los marcos.',NULL,1473800744,31,NULL),(19,2982,1,NULL,'Asignado al contratista: Carlos Moreno',NULL,1476740550,NULL,NULL),(20,3622,1,NULL,'Asignado al contratista: Carlos Moreno',NULL,1478547190,NULL,NULL),(21,4157,1,2,'Por llamar al cliente',NULL,1478659913,11,NULL),(22,4150,1,2,'No aplica',NULL,1478659955,32,NULL),(23,4157,1,2,'Ya se coloc&amp;oacute;',NULL,1478660011,26,NULL),(24,7,1,2,'Se acordo la visita',NULL,1478660930,20,1473969600),(25,6,1,2,'No Aplica',NULL,1478660965,34,NULL),(26,8,1,2,'No Aplica',NULL,1478660973,34,NULL),(27,4251,1,NULL,'Asignado al contratista: Carlos Moreno',NULL,1478893038,NULL,NULL),(28,4251,1,2,'listo',NULL,1478893588,29,NULL),(29,4251,1,2,'huhu',NULL,1478893620,29,NULL),(30,4252,1,2,'ggyyy',NULL,1478893659,29,NULL),(31,4157,1,NULL,'Asignado al contratista: Carlos Moreno',NULL,1479044841,NULL,NULL),(32,4150,1,NULL,'Asignado al contratista: Acabados Especiales',NULL,1479044853,NULL,NULL),(33,5636,1,2,'no corresponde',NULL,1484864885,32,NULL),(34,5490,1,2,'resuelto',NULL,1484865029,27,NULL),(35,5490,1,2,'no',NULL,1484865143,33,NULL),(36,5490,1,2,'no',NULL,1484865143,33,NULL),(37,5490,1,2,'no',NULL,1484865143,33,NULL),(38,4273,1,2,'Aprobado',NULL,1500678765,29,NULL),(39,4489,1,2,'Por aprobar',NULL,1500678894,26,NULL);

--
-- Table structure for table `im_usuarios_casas_tmp`
--

CREATE TABLE `im_usuarios_casas_tmp` (
  `codigo_usuario` int(11) DEFAULT NULL,
  `codigo_proyecto` int(11) DEFAULT NULL,
  `codigo_modelo` int(11) DEFAULT NULL,
  `num_casa` int(11) DEFAULT NULL,
  `codigo_lote` int(11) DEFAULT NULL,
  `tipo` tinyint(4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;

--
-- Dumping data for table `im_usuarios_casas_tmp`
--


--
-- Table structure for table `im_usuarios_modulos`
--

CREATE TABLE `im_usuarios_modulos` (
  `codigo_usuario` int(11) DEFAULT NULL,
  `codigo_modulo` int(11) DEFAULT NULL,
  KEY `codigo_usuario` (`codigo_usuario`),
  KEY `codigo_modulo` (`codigo_modulo`),
  CONSTRAINT `im_usuarios_modulos_ibfk_1` FOREIGN KEY (`codigo_usuario`) REFERENCES `im_usuarios` (`codigo`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `im_usuarios_modulos_ibfk_2` FOREIGN KEY (`codigo_modulo`) REFERENCES `im_modulos` (`codigo`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `im_usuarios_modulos`
--

INSERT INTO `im_usuarios_modulos` VALUES (1,1),(1,2),(1,3),(1,4),(1,5),(1,6),(1,7),(1,8),(1,9),(1,10),(1,11),(1,12),(1,13),(1,14),(1,15),(1,16),(1,17),(1,18),(2,4),(2,5),(2,3),(2,6),(2,10),(2,11),(2,8),(2,9),(2,13),(2,12),(2,18),(3,5),(3,6),(3,11),(3,18),(4,5),(4,6),(4,11),(5,5),(5,6),(5,11),(6,5),(6,6),(6,11),(2,17),(1,19),(2,19),(6,4),(6,10),(6,18),(5,4),(5,10),(5,18),(4,18),(3,7),(4,7),(5,7),(6,7),(2,2),(2,7),(2,1),(5,12),(6,12),(6,19),(1,21),(5,19),(5,2),(5,3),(5,8),(5,9),(5,13),(5,17),(4,19),(4,21),(4,4),(4,3),(4,10),(4,8),(4,9),(4,13),(4,12),(3,19),(3,21),(3,4),(3,3),(3,10),(3,8),(3,9),(3,13),(3,12),(3,1),(4,1);

--
-- Table structure for table `im_usuarios_proyectos`
--

CREATE TABLE `im_usuarios_proyectos` (
  `codigo_usuario` int(11) DEFAULT NULL,
  `codigo_proyecto` int(11) DEFAULT NULL,
  `fecha_creacion` int(11) DEFAULT NULL,
  KEY `codigo_proyecto` (`codigo_proyecto`),
  KEY `codigo_usuario` (`codigo_usuario`),
  CONSTRAINT `im_usuarios_proyectos_ibfk_1` FOREIGN KEY (`codigo_proyecto`) REFERENCES `im_proyectos` (`codigo`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `im_usuarios_proyectos_ibfk_2` FOREIGN KEY (`codigo_usuario`) REFERENCES `im_usuarios` (`codigo`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `im_usuarios_proyectos`
--

INSERT INTO `im_usuarios_proyectos` VALUES (4,1,1474394242),(3,1,1474394343),(5,1,1474394533);

--
-- Temporary view structure for view `project`
--

/*!50001 DROP VIEW IF EXISTS `project`*/;
/*!50001 CREATE VIEW `project` AS SELECT 
 1 AS `ProjectId`,
 1 AS `Active`,
 1 AS `ChangeDate`,
 1 AS `ChangeBy`,
 1 AS `CompanyId`,
 1 AS `Project`*/;

--
-- Temporary view structure for view `property`
--

/*!50001 DROP VIEW IF EXISTS `property`*/;
/*!50001 CREATE VIEW `property` AS SELECT 
 1 AS `PropertyId`,
 1 AS `PropertyModelId`,
 1 AS `Lot1Id`,
 1 AS `Lot2Id`,
 1 AS `Lot3Id`,
 1 AS `PropertyTypeId`,
 1 AS `Property`,
 1 AS `Number`,
 1 AS `DateDeliver`,
 1 AS `DateScheduled1`,
 1 AS `DateScheduled2`*/;

--
-- Temporary view structure for view `propertymodel`
--

/*!50001 DROP VIEW IF EXISTS `propertymodel`*/;
/*!50001 CREATE VIEW `propertymodel` AS SELECT 
 1 AS `PropertyModelId`,
 1 AS `ProjectId`,
 1 AS `PropertyModel`,
 1 AS `Active`,
 1 AS `ChangeDate`,
 1 AS `ChangeBy`*/;

--
-- Temporary view structure for view `propertymodelarea`
--

/*!50001 DROP VIEW IF EXISTS `propertymodelarea`*/;
/*!50001 CREATE VIEW `propertymodelarea` AS SELECT 
 1 AS `AreaId`,
 1 AS `PropertyModelId`*/;

--
-- Temporary view structure for view `propertyowner`
--

/*!50001 DROP VIEW IF EXISTS `propertyowner`*/;
/*!50001 CREATE VIEW `propertyowner` AS SELECT 
 1 AS `PropertyId`,
 1 AS `ClientId`*/;
/*!50001 DROP VIEW IF EXISTS `user`*/;
/*!50001 CREATE VIEW `user` AS SELECT 
 1 AS `UserId`,
 1 AS `UserTypeId`,
 1 AS `RoleId`,
 1 AS `Username`,
 1 AS `Password`,
 1 AS `IdentificationTypeId`,
 1 AS `Identification`,
 1 AS `Displayname`,
 1 AS `Firstname`,
 1 AS `Lastname`,
 1 AS `Email`*/;

--
-- Temporary view structure for view `usertype`
--

/*!50001 DROP VIEW IF EXISTS `usertype`*/;
/*!50001 CREATE VIEW `usertype` AS SELECT 
 1 AS `UserTypeId`,
 1 AS `UserType`*/;

--
-- Final view structure for view `area`
--

/*!50001 DROP VIEW IF EXISTS `area`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `area` AS select `im_lugares`.`codigo` AS `AreaId`,NULL AS `AreaSuggestedId`,`im_lugares`.`nombre` AS `Area`,`im_lugares`.`activado` AS `Active`,NULL AS `ChangeDate`,1 AS `ChangeBy` from `im_lugares` */;

--
-- Final view structure for view `claim`
--

/*!50001 DROP VIEW IF EXISTS `claim`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `claim` AS select `im_reportes`.`codigo` AS `ClaimId`,`im_reportes`.`tipo` AS `ClaimTypeId`,ifnull(`im_reportes`.`codigo_estatus`,'') AS `ClaimStatusId`,ifnull(`im_reportes`.`codigo_casa`,'') AS `PropertyId`,ifnull(`im_reportes`.`codigo_usuario`,'') AS `EmployeeId`,ifnull(from_unixtime(`im_reportes`.`fecha_visita`),'') AS `DateVisit`,ifnull(from_unixtime(`im_reportes`.`fecha_enviado`),'') AS `DateSent`,ifnull(from_unixtime(`im_reportes`.`fecha_lectura`),'') AS `DateRead`,ifnull(from_unixtime(`im_reportes`.`fecha_lectura_admin`),'') AS `DateReadAdmin`,ifnull(from_unixtime(`im_reportes`.`fecha_creacion`),'') AS `DateStart`,ifnull(`im_reportes`.`sindano_descripcion`,'') AS `DescriptionNoDamage`,ifnull(`im_reportes`.`cancelado_descripcion`,'') AS `DescriptionCanceled`,50 AS `Percentage`,ifnull(`im_reportes`.`paso`,'') AS `Step`,ifnull(`im_reportes`.`enviado`,'') AS `Sent`,`im_reportes`.`activado` AS `Active`,NULL AS `ChangeDate`,1 AS `ChangeBy`,'' AS `DigitalSignature` from `im_reportes` */;

--
-- Final view structure for view `claimstatus`
--

/*!50001 DROP VIEW IF EXISTS `claimstatus`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `claimstatus` AS select 1 AS `ClaimStatusId`,1 AS `ClaimTypeId`,1 AS `ClaimStatus`,1 AS `Percentage`,1 AS `OrderBy` */;

--
-- Final view structure for view `claimtype`
--

/*!50001 DROP VIEW IF EXISTS `claimtype`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `claimtype` AS select 1 AS `ClaimTypeId`,1 AS `ClaimType` */;

--
-- Final view structure for view `client`
--

/*!50001 DROP VIEW IF EXISTS `client`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `client` AS select 1 AS `ClientId`,1 AS `UserId`,1 AS `CompanyId` */;

--
-- Final view structure for view `company`
--

/*!50001 DROP VIEW IF EXISTS `company`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `company` AS select 1 AS `CompanyId`,1 AS `Active`,NULL AS `ChangeDate`,1 AS `ChangeBy`,'La torraca' AS `Company`,'grupolatorraca.com' AS `Domain`,'Description' AS `Description` */;

--
-- Final view structure for view `project`
--

/*!50001 DROP VIEW IF EXISTS `project`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `project` AS select `im_proyectos`.`codigo` AS `ProjectId`,`im_proyectos`.`activado` AS `Active`,NULL AS `ChangeDate`,1 AS `ChangeBy`,1 AS `CompanyId`,`im_proyectos`.`nombre` AS `Project` from `im_proyectos` */;

--
-- Final view structure for view `property`
--

/*!50001 DROP VIEW IF EXISTS `property`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `property` AS select 1 AS `PropertyId`,1 AS `PropertyModelId`,1 AS `Lot1Id`,1 AS `Lot2Id`,1 AS `Lot3Id`,1 AS `PropertyTypeId`,1 AS `Property`,1 AS `Number`,1 AS `DateDeliver`,1 AS `DateScheduled1`,1 AS `DateScheduled2` */;

--
-- Final view structure for view `propertymodel`
--

/*!50001 DROP VIEW IF EXISTS `propertymodel`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `propertymodel` AS select 1 AS `PropertyModelId`,1 AS `ProjectId`,1 AS `PropertyModel`,`im_modelos`.`activado` AS `Active`,NULL AS `ChangeDate`,1 AS `ChangeBy` from `im_modelos` */;

--
-- Final view structure for view `propertymodelarea`
--

/*!50001 DROP VIEW IF EXISTS `propertymodelarea`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `propertymodelarea` AS select `im_modelos_areas_afectadas`.`codigo_lugar` AS `AreaId`,`im_modelos_areas_afectadas`.`codigo_modelo` AS `PropertyModelId` from `im_modelos_areas_afectadas` */;

--
-- Final view structure for view `propertyowner`
--

/*!50001 DROP VIEW IF EXISTS `propertyowner`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `propertyowner` AS select 1 AS `PropertyId`,1 AS `ClientId` */;

--
-- Final view structure for view `user`
--

/*!50001 DROP VIEW IF EXISTS `user`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `user` AS select 1 AS `UserId`,1 AS `UserTypeId`,1 AS `RoleId`,1 AS `Username`,1 AS `Password`,1 AS `IdentificationTypeId`,1 AS `Identification`,1 AS `Displayname`,1 AS `Firstname`,1 AS `Lastname`,1 AS `Email` */;

--
-- Final view structure for view `usertype`
--

/*!50001 DROP VIEW IF EXISTS `usertype`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `usertype` AS select 1 AS `UserTypeId`,1 AS `UserType` */;


CREATE DATABASE  IF NOT EXISTS `seggac` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `seggac`;
--
-- Host: localhost    Database: seggac
-- ------------------------------------------------------


--
-- Table structure for table `ACTIVITY`
--

CREATE TABLE `ACTIVITY` (
  `ACTIVITYID` int(11) NOT NULL AUTO_INCREMENT,
  `ACTIVITYTYPEID` int(11) DEFAULT NULL,
  `ACTIVITYSUGGESTEDID` int(11) DEFAULT NULL,
  `ACTIVITYSTATUSID` int(11) DEFAULT NULL,
  `ACTIVITYPARENT` int(11) DEFAULT NULL,
  `ACTIVITY` varchar(100) DEFAULT NULL,
  `DURATION` int(11) DEFAULT NULL,
  `DESCRIPTION` text,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ACTIVITYID`),
  KEY `FK_REFERENCE_16` (`ACTIVITYTYPEID`),
  KEY `FK_REFERENCE_84` (`ACTIVITYSUGGESTEDID`),
  KEY `FK_REFERENCE_85` (`ACTIVITYSTATUSID`),
  CONSTRAINT `FK_REFERENCE_16` FOREIGN KEY (`ACTIVITYTYPEID`) REFERENCES `ACTIVITYTYPE` (`ACTIVITYTYPEID`),
  CONSTRAINT `FK_REFERENCE_84` FOREIGN KEY (`ACTIVITYSUGGESTEDID`) REFERENCES `ACTIVITYSUGGESTED` (`ACTIVITYSUGGESTEDID`),
  CONSTRAINT `FK_REFERENCE_85` FOREIGN KEY (`ACTIVITYSTATUSID`) REFERENCES `ACTIVITYSTATUS` (`ACTIVITYSTATUSID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ACTIVITY`
--


--
-- Table structure for table `ACTIVITYCLAIMTYPE`
--

CREATE TABLE `ACTIVITYCLAIMTYPE` (
  `ACTIVITYID` int(11) NOT NULL,
  `CLAIMTYPEID` int(11) NOT NULL,
  PRIMARY KEY (`ACTIVITYID`,`CLAIMTYPEID`),
  KEY `FK_REFERENCE_81` (`CLAIMTYPEID`),
  CONSTRAINT `FK_REFERENCE_80` FOREIGN KEY (`ACTIVITYID`) REFERENCES `ACTIVITY` (`ACTIVITYID`),
  CONSTRAINT `FK_REFERENCE_81` FOREIGN KEY (`CLAIMTYPEID`) REFERENCES `CLAIMTYPE` (`CLAIMTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ACTIVITYCLAIMTYPE`
--


--
-- Table structure for table `ACTIVITYCLAIMTYPESUGGESTED`
--

CREATE TABLE `ACTIVITYCLAIMTYPESUGGESTED` (
  `CLAIMTYPEID` int(11) NOT NULL,
  `ACTIVITYSUGGESTEDID` int(11) NOT NULL,
  PRIMARY KEY (`CLAIMTYPEID`,`ACTIVITYSUGGESTEDID`),
  KEY `FK_REFERENCE_83` (`ACTIVITYSUGGESTEDID`),
  CONSTRAINT `FK_REFERENCE_82` FOREIGN KEY (`CLAIMTYPEID`) REFERENCES `CLAIMTYPE` (`CLAIMTYPEID`),
  CONSTRAINT `FK_REFERENCE_83` FOREIGN KEY (`ACTIVITYSUGGESTEDID`) REFERENCES `ACTIVITYSUGGESTED` (`ACTIVITYSUGGESTEDID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ACTIVITYCLAIMTYPESUGGESTED`
--


--
-- Table structure for table `ACTIVITYSTANDARD`
--

CREATE TABLE `ACTIVITYSTANDARD` (
  `ACTIVITYSTANDARDID` int(11) NOT NULL AUTO_INCREMENT,
  `ACTIVITYSTANDARD` varchar(100) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ACTIVITYSTANDARDID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ACTIVITYSTANDARD`
--


--
-- Table structure for table `ACTIVITYSTATUS`
--

CREATE TABLE `ACTIVITYSTATUS` (
  `ACTIVITYSTATUSID` int(11) NOT NULL AUTO_INCREMENT,
  `ACTIVITYSTATUS` varchar(100) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ACTIVITYSTATUSID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ACTIVITYSTATUS`
--


--
-- Table structure for table `ACTIVITYSUGGESTED`
--

CREATE TABLE `ACTIVITYSUGGESTED` (
  `ACTIVITYSUGGESTEDID` int(11) NOT NULL AUTO_INCREMENT,
  `ACTIVITYSTANDARDID` int(11) DEFAULT NULL,
  `ACTIVITYTYPEID` int(11) DEFAULT NULL,
  `ACTIVITYPARENT` int(11) DEFAULT NULL,
  `ACTIVITY` varchar(100) DEFAULT NULL,
  `DURATION` int(11) DEFAULT NULL,
  `DESCRIPTION` text,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ACTIVITYSUGGESTEDID`),
  KEY `FK_REFERENCE_76` (`ACTIVITYSTANDARDID`),
  KEY `FK_REFERENCE_77` (`ACTIVITYTYPEID`),
  CONSTRAINT `FK_REFERENCE_76` FOREIGN KEY (`ACTIVITYSTANDARDID`) REFERENCES `ACTIVITYSTANDARD` (`ACTIVITYSTANDARDID`),
  CONSTRAINT `FK_REFERENCE_77` FOREIGN KEY (`ACTIVITYTYPEID`) REFERENCES `ACTIVITYTYPE` (`ACTIVITYTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ACTIVITYSUGGESTED`
--


--
-- Table structure for table `ACTIVITYTYPE`
--

CREATE TABLE `ACTIVITYTYPE` (
  `ACTIVITYTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `ACTIVITYTYPE` varchar(50) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ACTIVITYTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ACTIVITYTYPE`
--


--
-- Table structure for table `APPOINTMENT`
--

CREATE TABLE `APPOINTMENT` (
  `APPOINTMENTID` int(11) NOT NULL AUTO_INCREMENT,
  `APPOINTMENTTYPEID` int(11) DEFAULT NULL,
  `APPOINTMENTSTATUSID` int(11) DEFAULT NULL,
  `PROPERTYID` int(11) DEFAULT NULL,
  `STARTDATE` datetime DEFAULT NULL,
  `ENDDATE` datetime DEFAULT NULL,
  `ALLDAY` tinyint(4) DEFAULT NULL,
  `SUBJECT` varchar(200) DEFAULT NULL,
  `LOCATION` text,
  `DESCRIPTION` text,
  `REMINDERMINUTES` int(11) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`APPOINTMENTID`),
  KEY `FK_REFERENCE_69` (`APPOINTMENTTYPEID`),
  KEY `FK_REFERENCE_70` (`APPOINTMENTSTATUSID`),
  KEY `FK_REFERENCE_71` (`PROPERTYID`),
  CONSTRAINT `FK_REFERENCE_69` FOREIGN KEY (`APPOINTMENTTYPEID`) REFERENCES `APPOINTMENTTYPE` (`APPOINTMENTTYPEID`),
  CONSTRAINT `FK_REFERENCE_70` FOREIGN KEY (`APPOINTMENTSTATUSID`) REFERENCES `APPOINTMENTSTATUS` (`APPOINTMENTSTATUSID`),
  CONSTRAINT `FK_REFERENCE_71` FOREIGN KEY (`PROPERTYID`) REFERENCES `PROPERTY` (`PROPERTYID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `APPOINTMENT`
--


--
-- Table structure for table `APPOINTMENTPARTICIPANT`
--

CREATE TABLE `APPOINTMENTPARTICIPANT` (
  `APPOINTMENTPARTICIPANTID` int(11) NOT NULL AUTO_INCREMENT,
  `APPOINTMENTID` int(11) DEFAULT NULL,
  `USERID` int(11) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`APPOINTMENTPARTICIPANTID`),
  KEY `FK_REFERENCE_67` (`USERID`),
  KEY `FK_REFERENCE_72` (`APPOINTMENTID`),
  CONSTRAINT `FK_REFERENCE_67` FOREIGN KEY (`USERID`) REFERENCES `USER` (`USERID`),
  CONSTRAINT `FK_REFERENCE_72` FOREIGN KEY (`APPOINTMENTID`) REFERENCES `APPOINTMENT` (`APPOINTMENTID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `APPOINTMENTPARTICIPANT`
--


--
-- Table structure for table `APPOINTMENTSTATUS`
--

CREATE TABLE `APPOINTMENTSTATUS` (
  `APPOINTMENTSTATUSID` int(11) NOT NULL AUTO_INCREMENT,
  `APPOINTMENTSTATUS` varchar(50) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`APPOINTMENTSTATUSID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `APPOINTMENTSTATUS`
--


--
-- Table structure for table `APPOINTMENTTYPE`
--

CREATE TABLE `APPOINTMENTTYPE` (
  `APPOINTMENTTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `APPOINTMENTTYPE` varchar(50) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`APPOINTMENTTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `APPOINTMENTTYPE`
--


--
-- Table structure for table `AREA`
--

CREATE TABLE `AREA` (
  `AREAID` int(11) NOT NULL AUTO_INCREMENT,
  `AREASUGGESTEDID` int(11) DEFAULT NULL,
  `AREA` varchar(100) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`AREAID`),
  KEY `FK_REFERENCE_86` (`AREASUGGESTEDID`),
  CONSTRAINT `FK_REFERENCE_86` FOREIGN KEY (`AREASUGGESTEDID`) REFERENCES `AREASUGGESTED` (`AREASUGGESTEDID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `AREA`
--


--
-- Table structure for table `AREAACTIVITY`
--

CREATE TABLE `AREAACTIVITY` (
  `AREAID` int(11) NOT NULL,
  `ACTIVITYID` int(11) NOT NULL,
  PRIMARY KEY (`AREAID`,`ACTIVITYID`),
  KEY `FK_REFERENCE_64` (`ACTIVITYID`),
  CONSTRAINT `FK_REFERENCE_63` FOREIGN KEY (`AREAID`) REFERENCES `AREA` (`AREAID`),
  CONSTRAINT `FK_REFERENCE_64` FOREIGN KEY (`ACTIVITYID`) REFERENCES `ACTIVITY` (`ACTIVITYID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `AREAACTIVITY`
--


--
-- Table structure for table `AREAACTIVITYSUGGESTED`
--

CREATE TABLE `AREAACTIVITYSUGGESTED` (
  `AREASUGGESTEDID` int(11) NOT NULL,
  `ACTIVITYSUGGESTEDID` int(11) NOT NULL,
  PRIMARY KEY (`AREASUGGESTEDID`,`ACTIVITYSUGGESTEDID`),
  KEY `FK_REFERENCE_88` (`ACTIVITYSUGGESTEDID`),
  CONSTRAINT `FK_REFERENCE_87` FOREIGN KEY (`AREASUGGESTEDID`) REFERENCES `AREASUGGESTED` (`AREASUGGESTEDID`),
  CONSTRAINT `FK_REFERENCE_88` FOREIGN KEY (`ACTIVITYSUGGESTEDID`) REFERENCES `ACTIVITYSUGGESTED` (`ACTIVITYSUGGESTEDID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `AREAACTIVITYSUGGESTED`
--


--
-- Table structure for table `AREASUGGESTED`
--

CREATE TABLE `AREASUGGESTED` (
  `AREASUGGESTEDID` int(11) NOT NULL AUTO_INCREMENT,
  `AREA` varchar(100) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`AREASUGGESTEDID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `AREASUGGESTED`
--


--
-- Table structure for table `CLAIM`
--

CREATE TABLE `CLAIM` (
  `CLAIMID` int(11) NOT NULL AUTO_INCREMENT,
  `CLAIMTYPEID` int(11) DEFAULT NULL,
  `CLAIMSTATUSID` int(11) DEFAULT NULL,
  `PROPERTYID` int(11) DEFAULT NULL,
  `DATEVISIT` datetime DEFAULT NULL,
  `DATESENT` datetime DEFAULT NULL,
  `DATEREAD` datetime DEFAULT NULL,
  `DATEREADADMIN` datetime DEFAULT NULL,
  `DATESTART` datetime DEFAULT NULL,
  `DESCRIPTIONNODAMAGE` varchar(500) DEFAULT NULL,
  `DESCRIPTIONCANCELED` varchar(500) DEFAULT NULL,
  `PERCENTAGE` int(11) DEFAULT NULL,
  `STEP` tinyint(4) DEFAULT NULL,
  `SENT` tinyint(4) DEFAULT NULL,
  `DIGITALSIGNATURE` text,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  `EMPLOYEEID` int(11) DEFAULT NULL,
  PRIMARY KEY (`CLAIMID`),
  KEY `FK_REFERENCE_19` (`CLAIMSTATUSID`),
  KEY `FK_REFERENCE_21` (`PROPERTYID`),
  KEY `FK_REFERENCE_18` (`CLAIMTYPEID`),
  KEY `IDX_503D1C9723D52FEB` (`EMPLOYEEID`),
  CONSTRAINT `FK_503D1C9723D52FEB` FOREIGN KEY (`EMPLOYEEID`) REFERENCES `EMPLOYEE` (`EMPLOYEEID`),
  CONSTRAINT `FK_503D1C9735062500` FOREIGN KEY (`CLAIMTYPEID`) REFERENCES `CLAIMTYPE` (`CLAIMTYPEID`),
  CONSTRAINT `FK_REFERENCE_19` FOREIGN KEY (`CLAIMSTATUSID`) REFERENCES `CLAIMSTATUS` (`CLAIMSTATUSID`),
  CONSTRAINT `FK_REFERENCE_21` FOREIGN KEY (`PROPERTYID`) REFERENCES `PROPERTY` (`PROPERTYID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CLAIM`
--


--
-- Table structure for table `CLAIMSTATUS`
--

CREATE TABLE `CLAIMSTATUS` (
  `CLAIMSTATUSID` int(11) NOT NULL AUTO_INCREMENT,
  `CLAIMSTATUS` varchar(100) DEFAULT NULL,
  `PERCENTAGE` int(11) DEFAULT NULL,
  `ORDERBY` int(11) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`CLAIMSTATUSID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CLAIMSTATUS`
--


--
-- Table structure for table `CLAIMTYPE`
--

CREATE TABLE `CLAIMTYPE` (
  `CLAIMTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `CLAIMTYPE` varchar(50) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`CLAIMTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CLAIMTYPE`
--


--
-- Table structure for table `CLIENT`
--

CREATE TABLE `CLIENT` (
  `CLIENTID` int(11) NOT NULL AUTO_INCREMENT,
  `USERID` int(11) DEFAULT NULL,
  `COMPANYID` int(11) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`CLIENTID`),
  KEY `FK_REFERENCE_53` (`USERID`),
  KEY `FK_REFERENCE_54` (`COMPANYID`),
  CONSTRAINT `FK_REFERENCE_53` FOREIGN KEY (`USERID`) REFERENCES `USER` (`USERID`),
  CONSTRAINT `FK_REFERENCE_54` FOREIGN KEY (`COMPANYID`) REFERENCES `COMPANY` (`COMPANYID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CLIENT`
--


--
-- Table structure for table `COMPANY`
--

CREATE TABLE `COMPANY` (
  `COMPANYID` int(11) NOT NULL AUTO_INCREMENT,
  `COMPANY` varchar(100) DEFAULT NULL,
  `DOMAIN` varchar(100) DEFAULT NULL,
  `DESCRIPTION` text,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`COMPANYID`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COMPANY`
--

INSERT INTO `COMPANY` VALUES (1,'Grupo La Torraca','grupolatorraca.seggac.com','Grupo la Torraca',1,NULL,NULL),(11,'Grupo La torraca2','latorraca2.seggac.com','Esta es una empresa nueva 2',NULL,NULL,NULL),(12,'Grupo La torraca2','latorraca2.seggac.com','Esta es una empresa nueva 2',NULL,NULL,NULL),(13,'Grupo La torraca2','latorraca2.seggac.com','Esta es una empresa nueva 2',NULL,NULL,NULL);

--
-- Table structure for table `COMPANYPARAMETER`
--

CREATE TABLE `COMPANYPARAMETER` (
  `COMPANYPARAMETERID` int(11) NOT NULL AUTO_INCREMENT,
  `COMPANYID` int(11) DEFAULT NULL,
  `PARAMETERNAME` varchar(100) DEFAULT NULL,
  `PARAMETERVALUE` varchar(200) DEFAULT NULL,
  `DESCRIPTION` text,
  `CASE_INSENSITIVE_` tinyint(4) DEFAULT NULL,
  `PROTECTED` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`COMPANYPARAMETERID`),
  KEY `FK_REFERENCE_47` (`COMPANYID`),
  CONSTRAINT `FK_REFERENCE_47` FOREIGN KEY (`COMPANYID`) REFERENCES `COMPANY` (`COMPANYID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `COMPANYPARAMETER`
--


--
-- Table structure for table `CONTRACTOR`
--

CREATE TABLE `CONTRACTOR` (
  `CONTRACTORID` int(11) NOT NULL AUTO_INCREMENT,
  `CONTRACTORTYPEID` int(11) DEFAULT NULL,
  `CONTRACTOR` varchar(250) DEFAULT NULL,
  `DESCRIPTION` text,
  `CONTACT` varchar(100) DEFAULT NULL,
  `PHONE` varchar(50) DEFAULT NULL,
  `CELLPHONE` varchar(50) DEFAULT NULL,
  `RATING` tinyint(4) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`CONTRACTORID`),
  KEY `FK_REFERENCE_36` (`CONTRACTORTYPEID`),
  CONSTRAINT `FK_REFERENCE_36` FOREIGN KEY (`CONTRACTORTYPEID`) REFERENCES `CONTRACTORTYPE` (`CONTRACTORTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CONTRACTOR`
--


--
-- Table structure for table `CONTRACTORACTIVITY`
--

CREATE TABLE `CONTRACTORACTIVITY` (
  `CONTRACTORID` int(11) NOT NULL,
  `ACTIVITYID` int(11) NOT NULL,
  PRIMARY KEY (`CONTRACTORID`,`ACTIVITYID`),
  KEY `FK_REFERENCE_39` (`ACTIVITYID`),
  CONSTRAINT `FK_REFERENCE_38` FOREIGN KEY (`CONTRACTORID`) REFERENCES `CONTRACTOR` (`CONTRACTORID`),
  CONSTRAINT `FK_REFERENCE_39` FOREIGN KEY (`ACTIVITYID`) REFERENCES `ACTIVITY` (`ACTIVITYID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CONTRACTORACTIVITY`
--


--
-- Table structure for table `CONTRACTOREMPLOYEE`
--

CREATE TABLE `CONTRACTOREMPLOYEE` (
  `CONTRACTOREMPLOYEEID` int(11) NOT NULL AUTO_INCREMENT,
  `CONTRACTORID` int(11) DEFAULT NULL,
  `USERID` int(11) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`CONTRACTOREMPLOYEEID`),
  KEY `FK_REFERENCE_42` (`USERID`),
  KEY `FK_REFERENCE_43` (`CONTRACTORID`),
  CONSTRAINT `FK_REFERENCE_42` FOREIGN KEY (`USERID`) REFERENCES `USER` (`USERID`),
  CONSTRAINT `FK_REFERENCE_43` FOREIGN KEY (`CONTRACTORID`) REFERENCES `CONTRACTOR` (`CONTRACTORID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CONTRACTOREMPLOYEE`
--


--
-- Table structure for table `CONTRACTORTYPE`
--

CREATE TABLE `CONTRACTORTYPE` (
  `CONTRACTORTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `CONTRACTORTYPE` varchar(50) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`CONTRACTORTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CONTRACTORTYPE`
--


--
-- Table structure for table `EMPLOYEE`
--

CREATE TABLE `EMPLOYEE` (
  `EMPLOYEEID` int(11) NOT NULL AUTO_INCREMENT,
  `USERID` int(11) DEFAULT NULL,
  `COMPANYID` int(11) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`EMPLOYEEID`),
  KEY `FK_REFERENCE_51` (`USERID`),
  KEY `FK_REFERENCE_52` (`COMPANYID`),
  CONSTRAINT `FK_REFERENCE_51` FOREIGN KEY (`USERID`) REFERENCES `USER` (`USERID`),
  CONSTRAINT `FK_REFERENCE_52` FOREIGN KEY (`COMPANYID`) REFERENCES `COMPANY` (`COMPANYID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `EMPLOYEE`
--


--
-- Table structure for table `FILE`
--

CREATE TABLE `FILE` (
  `FILEID` bigint(20) NOT NULL AUTO_INCREMENT,
  `FILETYPEID` int(11) DEFAULT NULL,
  `PARENTTYPEID` int(11) DEFAULT NULL,
  `PARENTID` bigint(20) DEFAULT NULL,
  `PATH` varchar(100) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`FILEID`),
  KEY `FK_REFERENCE_46` (`FILETYPEID`),
  KEY `FK_REFERENCE_90` (`PARENTTYPEID`),
  CONSTRAINT `FK_REFERENCE_46` FOREIGN KEY (`FILETYPEID`) REFERENCES `FILETYPE` (`FILETYPEID`),
  CONSTRAINT `FK_REFERENCE_90` FOREIGN KEY (`PARENTTYPEID`) REFERENCES `PARENTTYPE` (`PARENTTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `FILE`
--


--
-- Table structure for table `FILETYPE`
--

CREATE TABLE `FILETYPE` (
  `FILETYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `FILETYPE` varchar(100) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`FILETYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `FILETYPE`
--


--
-- Table structure for table `IDENTIFICATIONTYPE`
--

CREATE TABLE `IDENTIFICATIONTYPE` (
  `IDENTIFICATIONTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `IDENTIFICATIONTYPE` varchar(50) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`IDENTIFICATIONTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `IDENTIFICATIONTYPE`
--


--
-- Table structure for table `LOT`
--

CREATE TABLE `LOT` (
  `LOTID` int(11) NOT NULL AUTO_INCREMENT,
  `PROJECTID` int(11) DEFAULT NULL,
  `LOTTYPEID` int(11) DEFAULT NULL,
  `LOT` varchar(50) DEFAULT NULL,
  `AREA` double(15,2) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`LOTID`),
  KEY `FK_REFERENCE_8` (`PROJECTID`),
  KEY `FK_REFERENCE_9` (`LOTTYPEID`),
  CONSTRAINT `FK_REFERENCE_8` FOREIGN KEY (`PROJECTID`) REFERENCES `PROJECT` (`PROJECTID`),
  CONSTRAINT `FK_REFERENCE_9` FOREIGN KEY (`LOTTYPEID`) REFERENCES `LOTTYPE` (`LOTTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `LOT`
--


--
-- Table structure for table `LOTTYPE`
--

CREATE TABLE `LOTTYPE` (
  `LOTTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `LOTTYPE` varchar(50) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`LOTTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `LOTTYPE`
--


--
-- Table structure for table `MODULE`
--

CREATE TABLE `MODULE` (
  `MODULEID` int(11) NOT NULL AUTO_INCREMENT,
  `MODULE` varchar(100) DEFAULT NULL,
  `DESCRIPTION` text,
  `ICON` varchar(50) DEFAULT NULL,
  `FILEPATH` varchar(100) DEFAULT NULL,
  `TABLENAME` varchar(60) DEFAULT NULL,
  `DISPLAY` tinyint(4) DEFAULT NULL,
  `ORDERBY` int(11) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  `MODULETYPEID` int(11) DEFAULT NULL,
  PRIMARY KEY (`MODULEID`),
  KEY `FK_REFERENCE_1` (`MODULETYPEID`),
  CONSTRAINT `FK_FCDCE1AE187665D0` FOREIGN KEY (`MODULETYPEID`) REFERENCES `MODULETYPE` (`MODULETYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `MODULE`
--


--
-- Table structure for table `MODULETYPE`
--

CREATE TABLE `MODULETYPE` (
  `MODULETYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `MODULETYPE` varchar(50) DEFAULT NULL,
  `ORDERBY` int(11) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`MODULETYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `MODULETYPE`
--


--
-- Table structure for table `PARENTTYPE`
--

CREATE TABLE `PARENTTYPE` (
  `PARENTTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `PARENTTYPE` varchar(100) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`PARENTTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PARENTTYPE`
--


--
-- Table structure for table `PROBLEM`
--

CREATE TABLE `PROBLEM` (
  `PROBLEMID` bigint(20) NOT NULL AUTO_INCREMENT,
  `CLAIMID` int(11) DEFAULT NULL,
  `PROBLEMSTATUSID` int(11) DEFAULT NULL,
  `ACTIVITYID` int(11) DEFAULT NULL,
  `AREAID` int(11) DEFAULT NULL,
  `NUMBER` int(11) DEFAULT NULL,
  `DESCRIPTION` text,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`PROBLEMID`),
  KEY `FK_REFERENCE_23` (`CLAIMID`),
  KEY `FK_REFERENCE_59` (`PROBLEMSTATUSID`),
  KEY `FK_REFERENCE_62` (`AREAID`),
  KEY `FK_REFERENCE_73` (`ACTIVITYID`),
  CONSTRAINT `FK_REFERENCE_23` FOREIGN KEY (`CLAIMID`) REFERENCES `CLAIM` (`CLAIMID`),
  CONSTRAINT `FK_REFERENCE_59` FOREIGN KEY (`PROBLEMSTATUSID`) REFERENCES `PROBLEMSTATUS` (`PROBLEMSTATUSID`),
  CONSTRAINT `FK_REFERENCE_62` FOREIGN KEY (`AREAID`) REFERENCES `AREA` (`AREAID`),
  CONSTRAINT `FK_REFERENCE_73` FOREIGN KEY (`ACTIVITYID`) REFERENCES `ACTIVITY` (`ACTIVITYID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PROBLEM`
--


--
-- Table structure for table `PROBLEMCONTRACTOR`
--

CREATE TABLE `PROBLEMCONTRACTOR` (
  `PROBLEMACONTRATISTAID` bigint(20) NOT NULL AUTO_INCREMENT,
  `PROBLEMID` bigint(20) DEFAULT NULL,
  `CONTRATCTORID` int(11) DEFAULT NULL,
  `RATING` tinyint(4) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`PROBLEMACONTRATISTAID`),
  KEY `FK_REFERENCE_35` (`CONTRATCTORID`),
  KEY `FK_REFERENCE_41` (`PROBLEMID`),
  CONSTRAINT `FK_REFERENCE_35` FOREIGN KEY (`CONTRATCTORID`) REFERENCES `CONTRACTOR` (`CONTRACTORID`),
  CONSTRAINT `FK_REFERENCE_41` FOREIGN KEY (`PROBLEMID`) REFERENCES `PROBLEM` (`PROBLEMID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PROBLEMCONTRACTOR`
--


--
-- Table structure for table `PROBLEMSTATUS`
--

CREATE TABLE `PROBLEMSTATUS` (
  `PROBLEMSTATUSID` int(11) NOT NULL AUTO_INCREMENT,
  `PROBLEMSTATUS` varchar(50) DEFAULT NULL,
  `PERCENTAGE` int(11) DEFAULT NULL,
  `ORDERBY` int(11) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`PROBLEMSTATUSID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PROBLEMSTATUS`
--


--
-- Table structure for table `PROBLEM_REVISION`
--

CREATE TABLE `PROBLEM_REVISION` (
  `REVISIONID` bigint(20) NOT NULL AUTO_INCREMENT,
  `PROBLEMID` bigint(20) DEFAULT NULL,
  `ACTIVITYID` int(11) DEFAULT NULL,
  `PROBLEMSTATUSID` int(11) DEFAULT NULL,
  `COMMENT` text,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`REVISIONID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PROBLEM_REVISION`
--


--
-- Table structure for table `PROJECT`
--

CREATE TABLE `PROJECT` (
  `PROJECTID` int(11) NOT NULL AUTO_INCREMENT,
  `COMPANYID` int(11) DEFAULT NULL,
  `PROJECT` varchar(100) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`PROJECTID`),
  KEY `FK_REFERENCE_40` (`COMPANYID`),
  CONSTRAINT `FK_REFERENCE_40` FOREIGN KEY (`COMPANYID`) REFERENCES `COMPANY` (`COMPANYID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PROJECT`
--

INSERT INTO `PROJECT` VALUES (1,1,'South Coast Tower',1,1,NULL),(2,1,'Firenze Tower',1,1,NULL);

--
-- Table structure for table `PROPERTY`
--

CREATE TABLE `PROPERTY` (
  `PROPERTYID` int(11) NOT NULL AUTO_INCREMENT,
  `PROPERTYMODELID` int(11) DEFAULT NULL,
  `LOTID1` int(11) DEFAULT NULL,
  `LOTID2` int(11) DEFAULT NULL,
  `LOTID3` int(11) DEFAULT NULL,
  `PROPERTYTYPEID` int(11) DEFAULT NULL,
  `PROPERTY` varchar(500) DEFAULT NULL,
  `NUMBER` varchar(200) DEFAULT NULL,
  `DATEDELIVER` int(11) DEFAULT NULL,
  `DATESCHEDULED1` int(11) DEFAULT NULL,
  `DATESCHEDULED2` int(11) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`PROPERTYID`),
  KEY `FK_REFERENCE_10` (`PROPERTYMODELID`),
  KEY `FK_REFERENCE_12` (`LOTID1`),
  KEY `FK_REFERENCE_13` (`LOTID2`),
  KEY `FK_REFERENCE_14` (`LOTID3`),
  KEY `FK_REFERENCE_15` (`PROPERTYTYPEID`),
  CONSTRAINT `FK_REFERENCE_10` FOREIGN KEY (`PROPERTYMODELID`) REFERENCES `PROPERTYMODEL` (`PROPERTYMODELID`),
  CONSTRAINT `FK_REFERENCE_12` FOREIGN KEY (`LOTID1`) REFERENCES `LOT` (`LOTID`),
  CONSTRAINT `FK_REFERENCE_13` FOREIGN KEY (`LOTID2`) REFERENCES `LOT` (`LOTID`),
  CONSTRAINT `FK_REFERENCE_14` FOREIGN KEY (`LOTID3`) REFERENCES `LOT` (`LOTID`),
  CONSTRAINT `FK_REFERENCE_15` FOREIGN KEY (`PROPERTYTYPEID`) REFERENCES `PROPERTYTYPE` (`PROPERTYTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PROPERTY`
--


--
-- Table structure for table `PROPERTYACTIVITY`
--

CREATE TABLE `PROPERTYACTIVITY` (
  `PROPERTYACTIVITY` int(11) NOT NULL AUTO_INCREMENT,
  `PROPERTYID` int(11) DEFAULT NULL,
  `ACTIVITYID` int(11) DEFAULT NULL,
  `EXPIRATIONDATE` datetime DEFAULT NULL,
  `COMMENT` text,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`PROPERTYACTIVITY`),
  KEY `FK_REFERENCE_78` (`PROPERTYID`),
  KEY `FK_REFERENCE_79` (`ACTIVITYID`),
  CONSTRAINT `FK_REFERENCE_78` FOREIGN KEY (`PROPERTYID`) REFERENCES `PROPERTY` (`PROPERTYID`),
  CONSTRAINT `FK_REFERENCE_79` FOREIGN KEY (`ACTIVITYID`) REFERENCES `ACTIVITY` (`ACTIVITYID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PROPERTYACTIVITY`
--


--
-- Table structure for table `PROPERTYMODEL`
--

CREATE TABLE `PROPERTYMODEL` (
  `PROPERTYMODELID` int(11) NOT NULL AUTO_INCREMENT,
  `PROJECTID` int(11) DEFAULT NULL,
  `PROPERTYMODEL` varchar(100) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`PROPERTYMODELID`),
  KEY `FK_REFERENCE_7` (`PROJECTID`),
  CONSTRAINT `FK_REFERENCE_7` FOREIGN KEY (`PROJECTID`) REFERENCES `PROJECT` (`PROJECTID`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PROPERTYMODEL`
--

INSERT INTO `PROPERTYMODEL` VALUES (1,1,'A',1,1,NULL),(2,1,'B',1,1,NULL),(3,1,'C',1,1,NULL),(4,1,'D',1,1,NULL),(5,1,'E',1,1,NULL),(6,1,'F',1,1,NULL),(7,2,'A',1,1,NULL),(8,2,'B',1,1,NULL),(9,2,'C',1,1,NULL),(10,2,'D',1,1,NULL),(11,2,'E',1,1,NULL);

--
-- Table structure for table `PROPERTYMODELAREA`
--

CREATE TABLE `PROPERTYMODELAREA` (
  `PROPERTYMODELID` int(11) NOT NULL,
  `AREAID` int(11) NOT NULL,
  PRIMARY KEY (`PROPERTYMODELID`,`AREAID`),
  KEY `FK_REFERENCE_89` (`AREAID`),
  CONSTRAINT `FK_REFERENCE_57` FOREIGN KEY (`PROPERTYMODELID`) REFERENCES `PROPERTYMODEL` (`PROPERTYMODELID`),
  CONSTRAINT `FK_REFERENCE_89` FOREIGN KEY (`AREAID`) REFERENCES `AREA` (`AREAID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PROPERTYMODELAREA`
--


--
-- Table structure for table `PROPERTYOWNER`
--

CREATE TABLE `PROPERTYOWNER` (
  `PROPERTYID` int(11) NOT NULL,
  `CLIENTID` int(11) NOT NULL,
  PRIMARY KEY (`PROPERTYID`,`CLIENTID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PROPERTYOWNER`
--


--
-- Table structure for table `PROPERTYTYPE`
--

CREATE TABLE `PROPERTYTYPE` (
  `PROPERTYTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `PROPERTYTYPE` varchar(50) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`PROPERTYTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PROPERTYTYPE`
--


--
-- Table structure for table `REPLY`
--

CREATE TABLE `REPLY` (
  `REPLYID` bigint(20) NOT NULL AUTO_INCREMENT,
  `PROBLEMID` bigint(20) DEFAULT NULL,
  `REPLYTYPEID` int(11) DEFAULT NULL,
  `EMPLOYEEID` int(11) DEFAULT NULL,
  `DESCRIPTION` text,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`REPLYID`),
  KEY `FK_REFERENCE_31` (`REPLYTYPEID`),
  KEY `FK_REFERENCE_44` (`PROBLEMID`),
  KEY `FK_REFERENCE_61` (`EMPLOYEEID`),
  CONSTRAINT `FK_AFC045023D52FEB` FOREIGN KEY (`EMPLOYEEID`) REFERENCES `EMPLOYEE` (`EMPLOYEEID`),
  CONSTRAINT `FK_REFERENCE_31` FOREIGN KEY (`REPLYTYPEID`) REFERENCES `REPLYTYPE` (`REPLYTYPEID`),
  CONSTRAINT `FK_REFERENCE_44` FOREIGN KEY (`PROBLEMID`) REFERENCES `PROBLEM` (`PROBLEMID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `REPLY`
--


--
-- Table structure for table `REPLYTYPE`
--

CREATE TABLE `REPLYTYPE` (
  `REPLYTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `REPLYTYPE` varchar(50) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`REPLYTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `REPLYTYPE`
--


--
-- Table structure for table `ROLE`
--

CREATE TABLE `ROLE` (
  `ROLEID` int(11) NOT NULL AUTO_INCREMENT,
  `ROLE` varchar(50) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ROLEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ROLE`
--


--
-- Table structure for table `ROLEMODULE`
--

CREATE TABLE `ROLEMODULE` (
  `ROLEID` int(11) NOT NULL,
  `MODULEID` int(11) NOT NULL,
  PRIMARY KEY (`ROLEID`,`MODULEID`),
  KEY `FK_REFERENCE_5` (`MODULEID`),
  CONSTRAINT `FK_REFERENCE_48` FOREIGN KEY (`ROLEID`) REFERENCES `ROLE` (`ROLEID`),
  CONSTRAINT `FK_REFERENCE_5` FOREIGN KEY (`MODULEID`) REFERENCES `MODULE` (`MODULEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ROLEMODULE`
--


--
-- Table structure for table `SYSTEMPARAMETER`
--

CREATE TABLE `SYSTEMPARAMETER` (
  `SYSTEMPARAMETERID` int(11) NOT NULL AUTO_INCREMENT,
  `PARAMETERNAME` varchar(100) DEFAULT NULL,
  `PARAMETERVALUE` varchar(200) DEFAULT NULL,
  `DESCRIPTION` text,
  `CASE_INSENSITIVE_` tinyint(4) DEFAULT NULL,
  `PROTECTED` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`SYSTEMPARAMETERID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `SYSTEMPARAMETER`
--


--
-- Table structure for table `USERTYPE`
--

CREATE TABLE `USERTYPE` (
  `USERTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `USERTYPE` varchar(50) DEFAULT NULL,
  `ACTIVE` tinyint(4) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`USERTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `USERTYPE`
--



CREATE DATABASE  IF NOT EXISTS `seggac_central` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `seggac_central`;
--
-- Host: localhost    Database: seggac_central
-- ------------------------------------------------------


--
-- Table structure for table `ACTIVITYSTANDARD`
--

CREATE TABLE `ACTIVITYSTANDARD` (
  `ACTIVITYSTANDARDID` int(11) NOT NULL AUTO_INCREMENT,
  `ACTIVITYSTANDARD` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ACTIVITYSTANDARDID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ACTIVITYSTANDARD`
--


--
-- Table structure for table `ACTIVITYSTATUS`
--

CREATE TABLE `ACTIVITYSTATUS` (
  `ACTIVITYSTATUSID` int(11) NOT NULL AUTO_INCREMENT,
  `ACTIVITYSTATUS` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ACTIVITYSTATUSID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ACTIVITYSTATUS`
--


--
-- Table structure for table `ACTIVITYSUGGESTED`
--

CREATE TABLE `ACTIVITYSUGGESTED` (
  `ACTIVITYSUGGESTEDID` int(11) NOT NULL AUTO_INCREMENT,
  `ACTIVITYPARENT` int(11) DEFAULT NULL,
  `ACTIVITY` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DURATION` int(11) DEFAULT NULL,
  `DESCRIPTION` text COLLATE utf8_unicode_ci,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  `ACTIVITYSTANDARDID` int(11) DEFAULT NULL,
  `ACTIVITYTYPEID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ACTIVITYSUGGESTEDID`),
  KEY `FK_REFERENCE_76` (`ACTIVITYSTANDARDID`),
  KEY `FK_REFERENCE_77` (`ACTIVITYTYPEID`),
  CONSTRAINT `FK_B3CE88A71621020` FOREIGN KEY (`ACTIVITYTYPEID`) REFERENCES `ACTIVITYTYPE` (`ACTIVITYTYPEID`),
  CONSTRAINT `FK_B3CE88A7EFF0DE2` FOREIGN KEY (`ACTIVITYSTANDARDID`) REFERENCES `ACTIVITYSTANDARD` (`ACTIVITYSTANDARDID`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ACTIVITYSUGGESTED`
--

INSERT INTO `ACTIVITYSUGGESTED` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `ACTIVITYTYPE`
--

CREATE TABLE `ACTIVITYTYPE` (
  `ACTIVITYTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `ACTIVITYTYPE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ACTIVITYTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ACTIVITYTYPE`
--


--
-- Table structure for table `APPOINTMENTSTATUS`
--

CREATE TABLE `APPOINTMENTSTATUS` (
  `APPOINTMENTSTATUSID` int(11) NOT NULL AUTO_INCREMENT,
  `APPOINTMENTSTATUS` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`APPOINTMENTSTATUSID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `APPOINTMENTSTATUS`
--


--
-- Table structure for table `APPOINTMENTTYPE`
--

CREATE TABLE `APPOINTMENTTYPE` (
  `APPOINTMENTTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `APPOINTMENTTYPE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`APPOINTMENTTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `APPOINTMENTTYPE`
--


--
-- Table structure for table `AREASUGGESTED`
--

CREATE TABLE `AREASUGGESTED` (
  `AREASUGGESTEDID` int(11) NOT NULL AUTO_INCREMENT,
  `AREA` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`AREASUGGESTEDID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AREASUGGESTED`
--


--
-- Table structure for table `CLAIMSTATUS`
--

CREATE TABLE `CLAIMSTATUS` (
  `CLAIMSTATUSID` int(11) NOT NULL AUTO_INCREMENT,
  `CLAIMSTATUS` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERCENTAGE` int(11) DEFAULT NULL,
  `ORDERBY` int(11) DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`CLAIMSTATUSID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CLAIMSTATUS`
--

INSERT INTO `CLAIMSTATUS` VALUES (1,'inicio',15,NULL,NULL,NULL,NULL);

--
-- Table structure for table `CLAIMTYPE`
--

CREATE TABLE `CLAIMTYPE` (
  `CLAIMTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `CLAIMTYPE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`CLAIMTYPEID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CLAIMTYPE`
--

INSERT INTO `CLAIMTYPE` VALUES (1,NULL,NULL,NULL,NULL);

--
-- Table structure for table `COMPANY`
--

CREATE TABLE `COMPANY` (
  `COMPANYID` int(11) NOT NULL AUTO_INCREMENT,
  `COMPANY` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DOMAIN` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DESCRIPTION` text COLLATE utf8_unicode_ci,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`COMPANYID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `COMPANY`
--

INSERT INTO `COMPANY` VALUES (1,'Grupo La Torraca','grupolatorraca.com','Grupo La Torraca Descripción',1,1,NULL);

--
-- Table structure for table `COMPANYPARAMETER`
--

CREATE TABLE `COMPANYPARAMETER` (
  `COMPANYPARAMETERID` int(11) NOT NULL AUTO_INCREMENT,
  `PARAMETERNAME` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PARAMETERVALUE` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DESCRIPTION` text COLLATE utf8_unicode_ci,
  `CASE_INSENSITIVE_` tinyint(1) DEFAULT NULL,
  `PROTECTED` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  `COMPANYID` int(11) DEFAULT NULL,
  PRIMARY KEY (`COMPANYPARAMETERID`),
  KEY `FK_REFERENCE_47` (`COMPANYID`),
  CONSTRAINT `FK_6B0D5719F5C6DD6E` FOREIGN KEY (`COMPANYID`) REFERENCES `COMPANY` (`COMPANYID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `COMPANYPARAMETER`
--


--
-- Table structure for table `CONTRACTORTYPE`
--

CREATE TABLE `CONTRACTORTYPE` (
  `CONTRACTORTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `CONTRACTORTYPE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`CONTRACTORTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CONTRACTORTYPE`
--


--
-- Table structure for table `FILETYPE`
--

CREATE TABLE `FILETYPE` (
  `FILETYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `FILETYPE` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`FILETYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `FILETYPE`
--


--
-- Table structure for table `IDENTIFICATIONTYPE`
--

CREATE TABLE `IDENTIFICATIONTYPE` (
  `IDENTIFICATIONTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `IDENTIFICATIONTYPE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`IDENTIFICATIONTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `IDENTIFICATIONTYPE`
--


--
-- Table structure for table `LOTTYPE`
--

CREATE TABLE `LOTTYPE` (
  `LOTTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `LOTTYPE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`LOTTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `LOTTYPE`
--


--
-- Table structure for table `MODULE`
--

CREATE TABLE `MODULE` (
  `MODULEID` int(11) NOT NULL AUTO_INCREMENT,
  `MODULE` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DESCRIPTION` text COLLATE utf8_unicode_ci,
  `ICON` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FILEPATH` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TABLENAME` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DISPLAY` tinyint(1) DEFAULT NULL,
  `ORDERBY` int(11) DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  `MODULETYPEID` int(11) DEFAULT NULL,
  PRIMARY KEY (`MODULEID`),
  KEY `FK_REFERENCE_1` (`MODULETYPEID`),
  CONSTRAINT `FK_8F5166D9187665D0` FOREIGN KEY (`MODULETYPEID`) REFERENCES `MODULETYPE` (`MODULETYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `MODULE`
--


--
-- Table structure for table `MODULETYPE`
--

CREATE TABLE `MODULETYPE` (
  `MODULETYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `MODULETYPE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ORDERBY` int(11) DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`MODULETYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `MODULETYPE`
--


--
-- Table structure for table `PARENTTYPE`
--

CREATE TABLE `PARENTTYPE` (
  `PARENTTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `PARENTTYPE` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`PARENTTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PARENTTYPE`
--


--
-- Table structure for table `PROBLEMSTATUS`
--

CREATE TABLE `PROBLEMSTATUS` (
  `PROBLEMSTATUSID` int(11) NOT NULL AUTO_INCREMENT,
  `PROBLEMSTATUS` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PERCENTAGE` int(11) DEFAULT NULL,
  `ORDERBY` int(11) DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`PROBLEMSTATUSID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PROBLEMSTATUS`
--


--
-- Table structure for table `PROPERTYTYPE`
--

CREATE TABLE `PROPERTYTYPE` (
  `PROPERTYTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `PROPERTYTYPE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`PROPERTYTYPEID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PROPERTYTYPE`
--

INSERT INTO `PROPERTYTYPE` VALUES (1,'Edificio',NULL,NULL,NULL);

--
-- Table structure for table `REPLYTYPE`
--

CREATE TABLE `REPLYTYPE` (
  `REPLYTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `REPLYTYPE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`REPLYTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `REPLYTYPE`
--


--
-- Table structure for table `ROLE`
--

CREATE TABLE `ROLE` (
  `ROLEID` int(11) NOT NULL AUTO_INCREMENT,
  `ROLE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ROLEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ROLE`
--


--
-- Table structure for table `SYSTEMPARAMETER`
--

CREATE TABLE `SYSTEMPARAMETER` (
  `SYSTEMPARAMETERID` int(11) NOT NULL AUTO_INCREMENT,
  `PARAMETERNAME` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PARAMETERVALUE` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DESCRIPTION` text COLLATE utf8_unicode_ci,
  `CASE_INSENSITIVE_` tinyint(1) DEFAULT NULL,
  `PROTECTED` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`SYSTEMPARAMETERID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `SYSTEMPARAMETER`
--


--
-- Table structure for table `USERTYPE`
--

CREATE TABLE `USERTYPE` (
  `USERTYPEID` int(11) NOT NULL AUTO_INCREMENT,
  `USERTYPE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACTIVE` tinyint(1) DEFAULT NULL,
  `CHANGEBY` int(11) DEFAULT NULL,
  `CHANGEDATE` datetime DEFAULT NULL,
  PRIMARY KEY (`USERTYPEID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `USERTYPE`
--



