Teknik is a suite of services with attractive and functional interfaces. https://www.teknik.io/
Você não pode selecionar mais de 25 tópicos Os tópicos devem começar com uma letra ou um número, podem incluir traços ('-') e podem ter até 35 caracteres.

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.0.0
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Sep 29, 2014 at 09:52 AM
  7. -- Server version: 5.6.11-log
  8. -- PHP Version: 5.4.15
  9. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  10. SET time_zone = "+00:00";
  11. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  12. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  13. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  14. /*!40101 SET NAMES utf8 */;
  15. --
  16. -- Database: `teknik`
  17. --
  18. -- --------------------------------------------------------
  19. --
  20. -- Table structure for table `blog`
  21. --
  22. CREATE TABLE IF NOT EXISTS `blog` (
  23. `id` int(11) NOT NULL AUTO_INCREMENT,
  24. `user_id` int(11) NOT NULL,
  25. `author_id` int(11) NOT NULL,
  26. `date_posted` datetime NOT NULL,
  27. `title` varchar(140) NOT NULL,
  28. `tags` varchar(500) NOT NULL,
  29. `post` longtext NOT NULL,
  30. PRIMARY KEY (`id`)
  31. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  32. -- --------------------------------------------------------
  33. --
  34. -- Table structure for table `comments`
  35. --
  36. CREATE TABLE IF NOT EXISTS `comments` (
  37. `id` int(11) NOT NULL AUTO_INCREMENT,
  38. `service` varchar(50) NOT NULL,
  39. `reply_id` int(11) NOT NULL,
  40. `user_id` int(11) NOT NULL,
  41. `title` varchar(140) NOT NULL,
  42. `post` text NOT NULL,
  43. `date_posted` datetime NOT NULL,
  44. PRIMARY KEY (`id`)
  45. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  46. -- --------------------------------------------------------
  47. --
  48. -- Table structure for table `history`
  49. --
  50. CREATE TABLE IF NOT EXISTS `history` (
  51. `id` int(11) NOT NULL AUTO_INCREMENT,
  52. `event_date` datetime DEFAULT CURRENT_TIMESTAMP,
  53. `title` varchar(140) DEFAULT NULL,
  54. `description` varchar(500) DEFAULT NULL,
  55. PRIMARY KEY (`id`)
  56. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  57. -- --------------------------------------------------------
  58. --
  59. -- Table structure for table `irc`
  60. --
  61. CREATE TABLE IF NOT EXISTS `irc` (
  62. `id` int(11) NOT NULL AUTO_INCREMENT,
  63. `cur_nicks` int(11) DEFAULT NULL,
  64. `max_nicks` int(11) DEFAULT NULL,
  65. `topic` text,
  66. `check_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  67. PRIMARY KEY (`id`)
  68. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  69. -- --------------------------------------------------------
  70. --
  71. -- Table structure for table `paste`
  72. --
  73. CREATE TABLE IF NOT EXISTS `paste` (
  74. `pid` int(11) NOT NULL AUTO_INCREMENT,
  75. `title` varchar(30) DEFAULT NULL,
  76. `posted` datetime DEFAULT NULL,
  77. `code` longtext CHARACTER SET utf8,
  78. `parent_pid` int(11) DEFAULT '0',
  79. `format` varchar(16) DEFAULT NULL,
  80. `codefmt` mediumtext CHARACTER SET utf8,
  81. `codecss` longtext,
  82. `expires` datetime DEFAULT NULL,
  83. `expiry_flag` enum('d','m','f') NOT NULL DEFAULT 'f',
  84. `password` varchar(250) DEFAULT NULL,
  85. `user_id` int(11) NOT NULL,
  86. PRIMARY KEY (`pid`)
  87. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
  88. -- --------------------------------------------------------
  89. --
  90. -- Table structure for table `podcast`
  91. --
  92. CREATE TABLE IF NOT EXISTS `podcast` (
  93. `id` int(11) NOT NULL AUTO_INCREMENT,
  94. `date_posted` datetime NOT NULL,
  95. `title` varchar(140) NOT NULL,
  96. `tags` varchar(500) NOT NULL,
  97. `file_name` varchar(140) NOT NULL,
  98. `description` longtext NOT NULL,
  99. PRIMARY KEY (`id`)
  100. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  101. -- --------------------------------------------------------
  102. --
  103. -- Table structure for table `ricehalla`
  104. --
  105. CREATE TABLE IF NOT EXISTS `ricehalla` (
  106. `id` int(11) NOT NULL AUTO_INCREMENT,
  107. `url` varchar(50) NOT NULL,
  108. `user_id` int(11) NOT NULL,
  109. `date_added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  110. `tags` varchar(140) DEFAULT NULL,
  111. PRIMARY KEY (`id`)
  112. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  113. -- --------------------------------------------------------
  114. --
  115. -- Table structure for table `sessions`
  116. --
  117. CREATE TABLE IF NOT EXISTS `sessions` (
  118. `id` int(11) NOT NULL AUTO_INCREMENT,
  119. `user_id` int(11) NOT NULL,
  120. `identifier` varchar(200) NOT NULL,
  121. `token` varchar(200) NOT NULL,
  122. `timeout` datetime NOT NULL,
  123. PRIMARY KEY (`id`)
  124. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  125. -- --------------------------------------------------------
  126. --
  127. -- Table structure for table `support`
  128. --
  129. CREATE TABLE IF NOT EXISTS `support` (
  130. `id` int(11) NOT NULL AUTO_INCREMENT,
  131. `name` varchar(50) NOT NULL,
  132. `email` varchar(50) NOT NULL,
  133. `subject` varchar(20) NOT NULL,
  134. `message` text NOT NULL,
  135. `date_added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  136. PRIMARY KEY (`id`)
  137. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  138. -- --------------------------------------------------------
  139. --
  140. -- Table structure for table `takedowns`
  141. --
  142. CREATE TABLE IF NOT EXISTS `takedowns` (
  143. `id` int(11) NOT NULL AUTO_INCREMENT,
  144. `date_requested` date NOT NULL,
  145. `requester` varchar(50) NOT NULL,
  146. `reason` mediumtext NOT NULL,
  147. `action` varchar(200) NOT NULL,
  148. PRIMARY KEY (`id`)
  149. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  150. -- --------------------------------------------------------
  151. --
  152. -- Table structure for table `transactions`
  153. --
  154. CREATE TABLE IF NOT EXISTS `transactions` (
  155. `id` int(11) NOT NULL AUTO_INCREMENT,
  156. `amount` double NOT NULL,
  157. `currency` varchar(20) NOT NULL,
  158. `trans_type` varchar(50) NOT NULL,
  159. `sender` varchar(100) NOT NULL,
  160. `recipient` varchar(100) NOT NULL,
  161. `reason` varchar(10000) NOT NULL,
  162. `date_posted` date NOT NULL,
  163. PRIMARY KEY (`id`)
  164. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  165. -- --------------------------------------------------------
  166. --
  167. -- Table structure for table `uploads`
  168. --
  169. CREATE TABLE IF NOT EXISTS `uploads` (
  170. `id` int(11) NOT NULL AUTO_INCREMENT,
  171. `filename` varchar(20) NOT NULL,
  172. `url` varchar(20) NOT NULL,
  173. `type` varchar(200) NOT NULL,
  174. `user_id` int(11) NOT NULL,
  175. `upload_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  176. `filesize` int(50) NOT NULL,
  177. `hash` varchar(32) NOT NULL,
  178. `cipher` varchar(20) NOT NULL DEFAULT 'tripleDES',
  179. `delete_key` varchar(64) DEFAULT NULL,
  180. PRIMARY KEY (`id`)
  181. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
  182. -- --------------------------------------------------------
  183. --
  184. -- Table structure for table `users`
  185. --
  186. CREATE TABLE IF NOT EXISTS `users` (
  187. `id` int(11) NOT NULL AUTO_INCREMENT,
  188. `username` varchar(50) CHARACTER SET utf8 NOT NULL,
  189. `password` varchar(100) NOT NULL,
  190. `group_name` varchar(50) NOT NULL DEFAULT 'Member',
  191. `site_admin` int(2) NOT NULL DEFAULT '0',
  192. `join_date` datetime NOT NULL,
  193. `last_seen` datetime NOT NULL,
  194. `public_key` text,
  195. `theme` varchar(20) NOT NULL DEFAULT 'default',
  196. `about` text CHARACTER SET utf8,
  197. `website` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
  198. `minecraft_user` varchar(50) DEFAULT NULL,
  199. `quote` varchar(140) CHARACTER SET utf8 DEFAULT NULL,
  200. `blog_title` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  201. `blog_desc` varchar(140) CHARACTER SET utf8 DEFAULT NULL,
  202. PRIMARY KEY (`id`),
  203. UNIQUE KEY `username` (`username`)
  204. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
  205. -- --------------------------------------------------------
  206. --
  207. -- Table structure for table `votes`
  208. --
  209. CREATE TABLE IF NOT EXISTS `votes` (
  210. `id` int(11) NOT NULL AUTO_INCREMENT,
  211. `table_name` varchar(50) NOT NULL,
  212. `row_id` int(11) NOT NULL,
  213. `user_id` int(11) NOT NULL,
  214. `points` int(10) NOT NULL,
  215. PRIMARY KEY (`id`)
  216. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  217. -- --------------------------------------------------------
  218. --
  219. -- Table structure for table `walls`
  220. --
  221. CREATE TABLE IF NOT EXISTS `walls` (
  222. `id` int(11) NOT NULL AUTO_INCREMENT,
  223. `user_id` int(11) NOT NULL,
  224. `title` varchar(200) NOT NULL,
  225. `src` varchar(200) NOT NULL,
  226. `thumb` varchar(200) NOT NULL,
  227. `date_added` datetime NOT NULL,
  228. PRIMARY KEY (`id`)
  229. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  230. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  231. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  232. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;