YLJzGaFy

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : 85.114.128.100 - HABLUX
5Source Server Version : 50517
6Source Host           : 127.0.0.1:14001
7Source Database       : hablux
8
9Target Server Type    : MYSQL
10Target Server Version : 50517
11File Encoding         : 65001
12
13Date: 2011-11-20 02:18:50
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `adventskalender`
20-- ----------------------------
21DROP TABLE IF EXISTS `adventskalender`;
22CREATE TABLE `adventskalender` (
23  `id` int(11) NOT NULL,
24  `user_id` int(11) NOT NULL,
25  `tag` int(11) NOT NULL,
26  PRIMARY KEY (`id`)
27) ENGINE=InnoDB DEFAULT CHARSET=latin1;
28
29-- ----------------------------
30-- Records of adventskalender
31-- ----------------------------
32
33-- ----------------------------
34-- Table structure for `adventskalender_gifts`
35-- ----------------------------
36DROP TABLE IF EXISTS `adventskalender_gifts`;
37CREATE TABLE `adventskalender_gifts` (
38  `id` int(11) NOT NULL,
39  `typ` enum('item','vip_punkte','pixel','taler','badge') NOT NULL,
40  `value` varchar(255) NOT NULL,
41  `tag` int(11) NOT NULL,
42  PRIMARY KEY (`id`)
43) ENGINE=InnoDB DEFAULT CHARSET=latin1;
44
45-- ----------------------------
46-- Records of adventskalender_gifts
47-- ----------------------------
48INSERT INTO `adventskalender_gifts` VALUES ('0', 'pixel', '5000', '1');
49INSERT INTO `adventskalender_gifts` VALUES ('1', 'taler', '1500', '2');
50INSERT INTO `adventskalender_gifts` VALUES ('3', 'badge', 'EINBADGE', '3');
51INSERT INTO `adventskalender_gifts` VALUES ('4', 'pixel', '250', '4');
52INSERT INTO `adventskalender_gifts` VALUES ('5', 'item', 'ITEMID', '5');
53INSERT INTO `adventskalender_gifts` VALUES ('6', 'item', '1168', '6');