Advertisement
Snoop-Dogg

PhpStatus SQL File

Dec 10th, 2020
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.17 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.5.4.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Dec 11, 2020 at 04:25 AM
  7. -- Server version: 5.7.11
  8. -- PHP Version: 5.6.40
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8mb4 */;
  18.  
  19. --
  20. -- Database: `phpstatus`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Table structure for table `<db_prefix>_groups`
  27. --
  28.  
  29. CREATE TABLE `<db_prefix>_groups` (
  30. `id` tinyint(3) NOT NULL,
  31. `groupid` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  32. `name` varchar(20) COLLATE utf8_unicode_ci NOT NULL
  33. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  34.  
  35. -- --------------------------------------------------------
  36.  
  37. --
  38. -- Table structure for table `<prefix>_admin`
  39. --
  40.  
  41. CREATE TABLE `<prefix>_admin` (
  42. `id` int(11) NOT NULL,
  43. `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  44. `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  45. `user_level` tinyint(3) UNSIGNED DEFAULT '1'
  46. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='_admin Table';
  47.  
  48. -- --------------------------------------------------------
  49.  
  50. --
  51. -- Table structure for table `<prefix>_config`
  52. --
  53.  
  54. CREATE TABLE `<prefix>_config` (
  55. `id` int(11) NOT NULL,
  56. `site_title` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  57. `domain` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  58. `script_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  59. `default_lang` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'eng',
  60. `default_theme` varchar(50) COLLATE utf8_unicode_ci NOT NULL
  61. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='_config Table';
  62.  
  63. -- --------------------------------------------------------
  64.  
  65. --
  66. -- Table structure for table `<prefix>_lang`
  67. --
  68.  
  69. CREATE TABLE `<prefix>_lang` (
  70. `id` tinyint(3) NOT NULL,
  71. `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL
  72. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='_lang Table';
  73.  
  74. -- --------------------------------------------------------
  75.  
  76. --
  77. -- Table structure for table `<prefix>_ports`
  78. --
  79.  
  80. CREATE TABLE `<prefix>_ports` (
  81. `id` tinyint(3) NOT NULL,
  82. `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL
  83. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='_ports Table';
  84.  
  85. -- --------------------------------------------------------
  86.  
  87. --
  88. -- Table structure for table `<prefix>_themes`
  89. --
  90.  
  91. CREATE TABLE `<prefix>_themes` (
  92. `id` int(11) NOT NULL,
  93. `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL
  94. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='_themes Table';
  95.  
  96. --
  97. -- Indexes for dumped tables
  98. --
  99.  
  100. --
  101. -- Indexes for table `<db_prefix>_groups`
  102. --
  103. ALTER TABLE `<db_prefix>_groups`
  104. ADD PRIMARY KEY (`id`);
  105.  
  106. --
  107. -- Indexes for table `<prefix>_admin`
  108. --
  109. ALTER TABLE `<prefix>_admin`
  110. ADD PRIMARY KEY (`id`);
  111.  
  112. --
  113. -- Indexes for table `<prefix>_config`
  114. --
  115. ALTER TABLE `<prefix>_config`
  116. ADD PRIMARY KEY (`id`);
  117.  
  118. --
  119. -- Indexes for table `<prefix>_lang`
  120. --
  121. ALTER TABLE `<prefix>_lang`
  122. ADD PRIMARY KEY (`id`);
  123.  
  124. --
  125. -- Indexes for table `<prefix>_ports`
  126. --
  127. ALTER TABLE `<prefix>_ports`
  128. ADD PRIMARY KEY (`id`);
  129.  
  130. --
  131. -- Indexes for table `<prefix>_themes`
  132. --
  133. ALTER TABLE `<prefix>_themes`
  134. ADD PRIMARY KEY (`id`);
  135.  
  136. --
  137. -- AUTO_INCREMENT for dumped tables
  138. --
  139.  
  140. --
  141. -- AUTO_INCREMENT for table `<prefix>_admin`
  142. --
  143. ALTER TABLE `<prefix>_admin`
  144. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  145. --
  146. -- AUTO_INCREMENT for table `<prefix>_config`
  147. --
  148. ALTER TABLE `<prefix>_config`
  149. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  150. --
  151. -- AUTO_INCREMENT for table `<prefix>_themes`
  152. --
  153. ALTER TABLE `<prefix>_themes`
  154. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  155. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  156. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  157. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  158.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement