Subversion Repositories cheapmusic

Rev

Rev 38 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 38 Rev 41
Line 286... Line 286...
286 
  `mediaBook` char(1) DEFAULT 'N',
 286 
  `mediaBook` char(1) DEFAULT 'N',
287 
  `lowBook` decimal(12,2) DEFAULT '0.00',
 287 
  `lowBook` decimal(12,2) DEFAULT '0.00',
288 
  `userId` int(11) DEFAULT NULL,
 288 
  `userId` int(11) DEFAULT NULL,
289 
  PRIMARY KEY (`id`),
 289 
  PRIMARY KEY (`id`),
290 
  KEY `userId` (`userId`)
 290 
  KEY `userId` (`userId`)
291 
) ENGINE=InnoDB AUTO_INCREMENT=1169 DEFAULT CHARSET=utf8;
 291 
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
292 
/*!40101 SET character_set_client = @saved_cs_client */;
 292 
/*!40101 SET character_set_client = @saved_cs_client */;
293 
 
 293 
 
294 
--
 294 
--
295 
-- Table structure for table `sessions`
 295 
-- Table structure for table `sessions`
296 
--
 296 
--
Line 320... Line 320...
320 
  `sessId` varchar(32) NOT NULL,
 320 
  `sessId` varchar(32) NOT NULL,
321 
  `access` int(10) unsigned DEFAULT NULL,
 321 
  `access` int(10) unsigned DEFAULT NULL,
322 
  `url` text,
 322 
  `url` text,
323 
  `userId` int(11) DEFAULT NULL,
 323 
  `userId` int(11) DEFAULT NULL,
324 
  PRIMARY KEY (`id`)
 324 
  PRIMARY KEY (`id`)
325 
) ENGINE=InnoDB AUTO_INCREMENT=322 DEFAULT CHARSET=utf8;
 325 
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
326 
/*!40101 SET character_set_client = @saved_cs_client */;
 326 
/*!40101 SET character_set_client = @saved_cs_client */;
327 
 
 327 
 
328 
--
 328 
--
329 
-- Table structure for table `users`
 329 
-- Table structure for table `users`
330 
--
 330 
--
Line 352... Line 352...
352 
  `status` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1' COMMENT '1=Active | 0=Inactive',
 352 
  `status` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1' COMMENT '1=Active | 0=Inactive',
353 
  PRIMARY KEY (`id`),
 353 
  PRIMARY KEY (`id`),
354 
  KEY `email` (`email`),
 354 
  KEY `email` (`email`),
355 
  KEY `forgot_pass_identity` (`forgot_pass_identity`),
 355 
  KEY `forgot_pass_identity` (`forgot_pass_identity`),
356 
  KEY `activation_code` (`activation_code`)
 356 
  KEY `activation_code` (`activation_code`)
357 
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 357 
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
358 
/*!40101 SET character_set_client = @saved_cs_client */;
 358 
/*!40101 SET character_set_client = @saved_cs_client */;
359 
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 359 
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
360 
 
 360 
 
361 
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
 361 
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
362 
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
 362 
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;