· 9 years ago · Oct 24, 2016, 05:08 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : 1
5Source Server Version : 50550
6Source Host : 192.168.0.103:3306
7Source Database : seemod
8
9Target Server Type : MYSQL
10Target Server Version : 50550
11File Encoding : 65001
12
13Date: 2016-10-24 19:07:17
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for datas
20-- ----------------------------
21DROP TABLE IF EXISTS `datas`;
22CREATE TABLE `datas` (
23 `id` int(11) NOT NULL AUTO_INCREMENT,
24 `szorzo` varchar(3) COLLATE utf8_hungarian_ci NOT NULL,
25 `reg` varchar(11) COLLATE utf8_hungarian_ci NOT NULL,
26 `asd` int(11) NOT NULL,
27 `asd2` int(11) NOT NULL,
28 PRIMARY KEY (`id`)
29) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
30
31-- ----------------------------
32-- Table structure for idea
33-- ----------------------------
34DROP TABLE IF EXISTS `idea`;
35CREATE TABLE `idea` (
36 `id` int(11) NOT NULL AUTO_INCREMENT,
37 `name` varchar(50) COLLATE utf8_hungarian_ci NOT NULL,
38 `date` varchar(25) COLLATE utf8_hungarian_ci NOT NULL,
39 `title` text COLLATE utf8_hungarian_ci NOT NULL,
40 `adate` varchar(25) COLLATE utf8_hungarian_ci DEFAULT NULL,
41 `aname` varchar(25) COLLATE utf8_hungarian_ci DEFAULT NULL,
42 `descr` text COLLATE utf8_hungarian_ci NOT NULL,
43 PRIMARY KEY (`id`)
44) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
45
46-- ----------------------------
47-- Table structure for inakt
48-- ----------------------------
49DROP TABLE IF EXISTS `inakt`;
50CREATE TABLE `inakt` (
51 `id` int(11) NOT NULL AUTO_INCREMENT,
52 `name` varchar(50) COLLATE utf8_hungarian_ci NOT NULL,
53 `date` varchar(25) COLLATE utf8_hungarian_ci NOT NULL,
54 `tol` text COLLATE utf8_hungarian_ci NOT NULL,
55 `state` int(11) NOT NULL,
56 `adate` varchar(25) COLLATE utf8_hungarian_ci DEFAULT NULL,
57 `aname` varchar(25) COLLATE utf8_hungarian_ci DEFAULT NULL,
58 `megj` text COLLATE utf8_hungarian_ci NOT NULL,
59 PRIMARY KEY (`id`)
60) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
61
62-- ----------------------------
63-- Table structure for log
64-- ----------------------------
65DROP TABLE IF EXISTS `log`;
66CREATE TABLE `log` (
67 `id` int(11) NOT NULL AUTO_INCREMENT,
68 `name` varchar(40) COLLATE utf8_hungarian_ci NOT NULL,
69 `todo` text COLLATE utf8_hungarian_ci NOT NULL,
70 `st` varchar(30) COLLATE utf8_hungarian_ci NOT NULL,
71 `date` varchar(20) COLLATE utf8_hungarian_ci NOT NULL,
72 PRIMARY KEY (`id`)
73) ENGINE=MyISAM AUTO_INCREMENT=734 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
74
75-- ----------------------------
76-- Table structure for nevc
77-- ----------------------------
78DROP TABLE IF EXISTS `nevc`;
79CREATE TABLE `nevc` (
80 `id` int(11) NOT NULL AUTO_INCREMENT,
81 `name` varchar(50) COLLATE utf8_hungarian_ci NOT NULL,
82 `date` varchar(25) COLLATE utf8_hungarian_ci NOT NULL,
83 `new` text COLLATE utf8_hungarian_ci NOT NULL,
84 `state` int(11) NOT NULL,
85 `adate` varchar(25) COLLATE utf8_hungarian_ci DEFAULT NULL,
86 `aname` varchar(25) COLLATE utf8_hungarian_ci DEFAULT NULL,
87 `megj` text COLLATE utf8_hungarian_ci NOT NULL,
88 PRIMARY KEY (`id`)
89) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
90
91-- ----------------------------
92-- Table structure for news
93-- ----------------------------
94DROP TABLE IF EXISTS `news`;
95CREATE TABLE `news` (
96 `id` int(11) NOT NULL AUTO_INCREMENT,
97 `title` varchar(50) COLLATE utf8_hungarian_ci NOT NULL,
98 `message` text COLLATE utf8_hungarian_ci NOT NULL,
99 `date` varchar(30) COLLATE utf8_hungarian_ci NOT NULL,
100 `owner` varchar(40) COLLATE utf8_hungarian_ci NOT NULL,
101 PRIMARY KEY (`id`)
102) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
103
104-- ----------------------------
105-- Table structure for temeto
106-- ----------------------------
107DROP TABLE IF EXISTS `temeto`;
108CREATE TABLE `temeto` (
109 `id` int(11) NOT NULL AUTO_INCREMENT,
110 `name` varchar(50) COLLATE utf8_hungarian_ci NOT NULL,
111 `date` varchar(25) COLLATE utf8_hungarian_ci NOT NULL,
112 `rang` text COLLATE utf8_hungarian_ci NOT NULL,
113 `descr` text COLLATE utf8_hungarian_ci NOT NULL,
114 PRIMARY KEY (`id`)
115) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
116
117-- ----------------------------
118-- Table structure for time
119-- ----------------------------
120DROP TABLE IF EXISTS `time`;
121CREATE TABLE `time` (
122 `id` int(11) NOT NULL AUTO_INCREMENT,
123 `userid` int(11) NOT NULL,
124 `tol` text COLLATE utf8_hungarian_ci NOT NULL,
125 `vege` text COLLATE utf8_hungarian_ci NOT NULL,
126 `date` varchar(12) COLLATE utf8_hungarian_ci NOT NULL,
127 `megj` text COLLATE utf8_hungarian_ci NOT NULL,
128 PRIMARY KEY (`id`)
129) ENGINE=MyISAM AUTO_INCREMENT=510 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
130
131-- ----------------------------
132-- Table structure for users
133-- ----------------------------
134DROP TABLE IF EXISTS `users`;
135CREATE TABLE `users` (
136 `id` int(11) NOT NULL AUTO_INCREMENT,
137 `username` varchar(40) COLLATE utf8_hungarian_ci NOT NULL,
138 `ig` varchar(40) COLLATE utf8_hungarian_ci NOT NULL,
139 `irl` text COLLATE utf8_hungarian_ci NOT NULL,
140 `fb` varchar(50) COLLATE utf8_hungarian_ci NOT NULL DEFAULT 'nincs',
141 `password` text COLLATE utf8_hungarian_ci NOT NULL,
142 `state` int(4) NOT NULL,
143 `regdate` varchar(20) COLLATE utf8_hungarian_ci NOT NULL,
144 `logdate` varchar(20) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
145 `rang` varchar(40) COLLATE utf8_hungarian_ci NOT NULL,
146 `email` varchar(30) COLLATE utf8_hungarian_ci NOT NULL,
147 `time` float NOT NULL,
148 PRIMARY KEY (`id`)
149) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;