hi4UqLTW

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : localhost_3306
5Source Server Version : 50508
6Source Host           : localhost:3306
7Source Database       : imashop
8
9Target Server Type    : MYSQL
10Target Server Version : 50508
11File Encoding         : 65001
12
13Date: 2011-04-18 17:11:45
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `shop_categories`
20-- ----------------------------
21DROP TABLE IF EXISTS `shop_categories`;
22CREATE TABLE `shop_categories` (
23  `id` int(8) NOT NULL AUTO_INCREMENT,
24  `name` varchar(255) DEFAULT NULL,
25  `description` text,
26  `parent` int(3) DEFAULT NULL,
27  PRIMARY KEY (`id`)
28) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
29
30-- ----------------------------
31-- Records of shop_categories
32-- ----------------------------
33INSERT INTO `shop_categories` VALUES ('1', 'Porn', null, null);
34INSERT INTO `shop_categories` VALUES ('2', 'for', null, null);
35INSERT INTO `shop_categories` VALUES ('3', 'free', null, null);
36
37-- ----------------------------
38-- Table structure for `shop_item_cat`
39-- ----------------------------
40DROP TABLE IF EXISTS `shop_item_cat`;
41CREATE TABLE `shop_item_cat` (
42  `id` int(5) NOT NULL AUTO_INCREMENT,
43  `name` varchar(255) DEFAULT NULL,
44  `description` text,
45  `order` int(3) DEFAULT NULL,
46  PRIMARY KEY (`id`)
47) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
48
49-- ----------------------------
50-- Records of shop_item_cat
51-- ----------------------------
52INSERT INTO `shop_item_cat` VALUES ('1', 'Kihloggas', 'Frische Kilogga von mir', '1');
53INSERT INTO `shop_item_cat` VALUES ('2', 'Pehpal', 'Pehpall accs neu', '2');
54INSERT INTO `shop_item_cat` VALUES ('3', 'PHP lol', 'LOLOLOL', '3');
55
56-- ----------------------------
57-- Table structure for `shop_news`
58-- ----------------------------
59DROP TABLE IF EXISTS `shop_news`;
60CREATE TABLE `shop_news` (
61  `id` int(5) NOT NULL AUTO_INCREMENT,
62  `title` varchar(255) DEFAULT NULL,
63  `date` int(20) DEFAULT NULL,
64  `category` int(3) DEFAULT NULL,
65  `author` varchar(255) DEFAULT NULL,
66  `text` text,
67  `image` varchar(255) DEFAULT NULL,
68  `desc` text,
69  PRIMARY KEY (`id`)
70) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
71
72-- ----------------------------
73-- Records of shop_news
74-- ----------------------------
75INSERT INTO `shop_news` VALUES ('1', 'Testnews 1 shizzle hizzle<script>alert(1);</script>', '1353423', '1', 'Imadj', 'Das ist die erste Testnews die überhaupt existieeeeeert!\r\n\r\n\r\nyaaaaaaaay', 'images/img3.jpg', 'tgsdgffdg');