· 8 years ago · Nov 30, 2017, 06:42 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : localhost
5Source Server Version : 100109
6Source Host : localhost:3306
7Source Database : iheartanime
8
9Target Server Type : MYSQL
10Target Server Version : 100109
11File Encoding : 65001
12
13Date: 2017-11-30 19:40:05
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for animelist
20-- ----------------------------
21DROP TABLE IF EXISTS `animelist`;
22CREATE TABLE `animelist` (
23 `id` int(9) NOT NULL AUTO_INCREMENT,
24 `title` varchar(255) NOT NULL DEFAULT 'Undefined',
25 `description` varchar(255) NOT NULL DEFAULT 'No comment.',
26 `airdate` datetime DEFAULT NULL,
27 `genre` varchar(255) NOT NULL DEFAULT 'Unlisted',
28 `englishname` varchar(255) NOT NULL DEFAULT 'Undefined',
29 `uploaddate` datetime DEFAULT NULL,
30 `uploadby` int(9) NOT NULL DEFAULT '0',
31 `episodes` int(9) NOT NULL DEFAULT '0',
32 `episodesuploaded` int(9) NOT NULL DEFAULT '0',
33 `status` varchar(255) NOT NULL DEFAULT 'Undefined',
34 `searchname` varchar(255) NOT NULL,
35 PRIMARY KEY (`id`),
36 FULLTEXT KEY `AnimeTitle` (`title`),
37 FULLTEXT KEY `Anime Title` (`searchname`)
38) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
39
40-- ----------------------------
41-- Records of animelist
42-- ----------------------------
43INSERT INTO `animelist` VALUES ('1', 'One Piece', 'No comment.', '1999-10-20 00:00:00', 'Action,Adventure,Comedy,Drama,Fantasy,Shounen,Super Power', 'One Piece', '2017-03-22 16:28:38', '0', '0', '0', 'ONGOING', 'o n e p i e c e');
44INSERT INTO `animelist` VALUES ('2', 'Bleach', 'No comment.', '1999-10-20 00:00:00', 'Unlisted', 'Bleach', '2017-03-22 17:29:44', '0', '0', '0', 'COMPLETE', '');
45
46-- ----------------------------
47-- Table structure for episodelist
48-- ----------------------------
49DROP TABLE IF EXISTS `episodelist`;
50CREATE TABLE `episodelist` (
51 `animeid` int(9) NOT NULL,
52 `episodenum` int(9) NOT NULL DEFAULT '0',
53 `episodelink` text,
54 PRIMARY KEY (`animeid`)
55) ENGINE=InnoDB DEFAULT CHARSET=latin1;
56
57-- ----------------------------
58-- Records of episodelist
59-- ----------------------------
60
61-- ----------------------------
62-- Table structure for imgcache
63-- ----------------------------
64DROP TABLE IF EXISTS `imgcache`;
65CREATE TABLE `imgcache` (
66 `animeid` int(9) NOT NULL,
67 `src` text NOT NULL,
68 PRIMARY KEY (`animeid`)
69) ENGINE=InnoDB DEFAULT CHARSET=latin1;
70
71-- ----------------------------
72-- Records of imgcache
73-- ----------------------------
74INSERT INTO `imgcache` VALUES ('1', '/upload/animecovers/op.jpg');
75INSERT INTO `imgcache` VALUES ('2', '/upload/animecovers/bleach.jpg');
76
77-- ----------------------------
78-- Table structure for users
79-- ----------------------------
80DROP TABLE IF EXISTS `users`;
81CREATE TABLE `users` (
82 `id` int(9) NOT NULL AUTO_INCREMENT,
83 `name` varchar(255) NOT NULL,
84 `password` varchar(255) NOT NULL,
85 `email` varchar(255) NOT NULL,
86 PRIMARY KEY (`id`)
87) ENGINE=InnoDB DEFAULT CHARSET=latin1;
88
89-- ----------------------------
90-- Records of users
91-- ----------------------------
92
93-- ----------------------------
94-- Table structure for views
95-- ----------------------------
96DROP TABLE IF EXISTS `views`;
97CREATE TABLE `views` (
98 `animeid` int(9) NOT NULL,
99 `amount` int(9) NOT NULL DEFAULT '0',
100 PRIMARY KEY (`animeid`)
101) ENGINE=InnoDB DEFAULT CHARSET=latin1;
102
103-- ----------------------------
104-- Records of views
105-- ----------------------------
106INSERT INTO `views` VALUES ('1', '0');
107INSERT INTO `views` VALUES ('2', '0');