-- MySQL dump 10.13 Distrib 5.7.27, for Linux (x86_64) -- -- Host: localhost Database: usia_gen -- ------------------------------------------------------ -- Server version 5.7.27 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `usia_gen` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `usia_gen` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `usia_gen`; -- -- Table structure for table `generators` -- DROP TABLE IF EXISTS `generators`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `generators` ( `id` int(11) NOT NULL, `name` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `generators` -- LOCK TABLES `generators` WRITE; /*!40000 ALTER TABLE `generators` DISABLE KEYS */; /*!40000 ALTER TABLE `generators` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `news` -- DROP TABLE IF EXISTS `news`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `news` ( `id` int(11) NOT NULL, `message` mediumtext CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `writer` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `date` datetime NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `news` -- LOCK TABLES `news` WRITE; /*!40000 ALTER TABLE `news` DISABLE KEYS */; INSERT INTO `news` VALUES (1,'Coder: Dank#9236','admin','2018-12-25 22:38:38'); /*!40000 ALTER TABLE `news` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `packages` -- DROP TABLE IF EXISTS `packages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `packages` ( `id` int(11) NOT NULL, `name` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `price` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `length` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `accounts` int(11) NOT NULL, `generator` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `packages` -- LOCK TABLES `packages` WRITE; /*!40000 ALTER TABLE `packages` DISABLE KEYS */; /*!40000 ALTER TABLE `packages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings` ( `website` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `paypal` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `footer` varchar(1000) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '© 24/7 | HackForums', `favicon` varchar(1000) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'img/favicon.png' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings` -- LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; INSERT INTO `settings` VALUES ('Name','Adress@mail.com','© Name',''),('Name','Adress@mail.com','© Name',''); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `statistics` -- DROP TABLE IF EXISTS `statistics`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `statistics` ( `id` int(11) NOT NULL, `username` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `generated` int(11) NOT NULL, `date` date NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `statistics` -- LOCK TABLES `statistics` WRITE; /*!40000 ALTER TABLE `statistics` DISABLE KEYS */; /*!40000 ALTER TABLE `statistics` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subscriptions` -- DROP TABLE IF EXISTS `subscriptions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `subscriptions` ( `id` int(11) NOT NULL, `username` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `date` date NOT NULL, `price` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `payment` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `package` int(11) NOT NULL, `expires` date NOT NULL, `txn_id` varchar(1000) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `active` int(1) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `subscriptions` -- LOCK TABLES `subscriptions` WRITE; /*!40000 ALTER TABLE `subscriptions` DISABLE KEYS */; /*!40000 ALTER TABLE `subscriptions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `support` -- DROP TABLE IF EXISTS `support`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `support` ( `id` int(11) NOT NULL, `from` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `to` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `subject` varchar(1000) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `message` mediumtext CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `date` date NOT NULL, `read` int(11) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `support` -- LOCK TABLES `support` WRITE; /*!40000 ALTER TABLE `support` DISABLE KEYS */; /*!40000 ALTER TABLE `support` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` int(11) DEFAULT NULL, `username` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `password` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `email` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `rank` int(1) NOT NULL DEFAULT '1', `ip` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `date` date DEFAULT NULL, `status` int(1) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'admin','usia332525!','admin@usia.cc',5,'127.0.0.1','2018-12-25',1); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping events for database 'usia_gen' -- -- -- Dumping routines for database 'usia_gen' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2019-08-17 4:16:35