pCVmsSp5

1-- MySqlBackup.NET 2.0.11
2-- Dump Time: 2018-03-10 21:51:57
3-- --------------------------------------
4-- Server version 5.7.19 MySQL Community Server (GPL)
5
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES latin1 */;
11/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
12/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
15
16
17-- 
18-- Definition of project
19-- 
20
21DROP TABLE IF EXISTS `project`;
22CREATE TABLE IF NOT EXISTS `project` (
23  `id` int(100) NOT NULL AUTO_INCREMENT,
24  `nev` text NOT NULL,
25  `lakcim` text NOT NULL,
26  `taroloid` int(100) NOT NULL,
27  `status` text NOT NULL,
28  `gyujtesido` text NOT NULL,
29  `fizetesido` text NOT NULL,
30  `up` int(1) NOT NULL DEFAULT '0',
31  PRIMARY KEY (`id`)
32) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
33
34-- 
35-- Dumping data for table project
36-- 
37
38/*!40000 ALTER TABLE `project` DISABLE KEYS */;
39INSERT INTO `project`(`id`,`nev`,`lakcim`,`taroloid`,`status`,`gyujtesido`,`fizetesido`,`up`) VALUES
40(1,'asd','asd',1,'asd','2017.01.01 01:01','2017.01.01 01:01',1),
41(2,'asd2','asd2',2,'asd2','2018.02.02 02:02','2018.02.02 02:02',0),
42(3,'asd','asd',1,'asd','2017.01.01 01:01','2017.01.01 01:01',1),
43(4,'asd2','asd2',2,'asd2','2018.02.02 02:02','2018.02.02 02:02',0);
44/*!40000 ALTER TABLE `project` ENABLE KEYS */;
45
46
47/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
48/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
49/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
50/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
51/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
52/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
53/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
54
55
56-- Dump completed on 2018-03-10 21:51:58
57-- Total time: 0:0:0:0:93 (d:h:m:s:ms)