prewikka.sql
1 |
-- phpMyAdmin SQL Dump
|
---|---|
2 |
-- version 4.6.6deb4
|
3 |
-- https://www.phpmyadmin.net/
|
4 |
--
|
5 |
-- Host: localhost:3306
|
6 |
-- Generation Time: Aug 04, 2018 at 03:22 PM
|
7 |
-- Server version: 5.7.20-0ubuntu0.17.04.1
|
8 |
-- PHP Version: 7.0.22-0ubuntu0.17.04.1
|
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: `prewikka`
|
21 |
--
|
22 |
|
23 |
-- --------------------------------------------------------
|
24 |
|
25 |
--
|
26 |
-- Table structure for table `Prewikka_Module_Changed`
|
27 |
--
|
28 |
|
29 |
CREATE TABLE `Prewikka_Module_Changed` ( |
30 |
`time` datetime NOT NULL |
31 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
32 |
|
33 |
--
|
34 |
-- Dumping data for table `users`
|
35 |
--
|
36 |
|
37 |
INSERT INTO `Prewikka_Module_Changed` (`time`) VALUES |
38 |
(current_timestamp); |
39 |
|
40 |
-- --------------------------------------------------------
|
41 |
|
42 |
--
|
43 |
-- Table structure for table `Prewikka_Module_Registry`
|
44 |
--
|
45 |
|
46 |
CREATE TABLE `Prewikka_Module_Registry` ( |
47 |
`module` varchar(255) NOT NULL, |
48 |
`enabled` tinyint(4) DEFAULT '1', |
49 |
`branch` varchar(16) DEFAULT NULL, |
50 |
`version` varchar(16) DEFAULT NULL |
51 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
52 |
|
53 |
-- --------------------------------------------------------
|
54 |
|
55 |
--
|
56 |
-- Table structure for table `Prewikka_Session`
|
57 |
--
|
58 |
|
59 |
CREATE TABLE `Prewikka_Session` ( |
60 |
`sessionid` varchar(48) NOT NULL, |
61 |
`userid` varchar(32) NOT NULL, |
62 |
`login` varchar(255) NOT NULL, |
63 |
`time` datetime NOT NULL |
64 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
65 |
|
66 |
-- --------------------------------------------------------
|
67 |
|
68 |
--
|
69 |
-- Table structure for table `Prewikka_User_Configuration`
|
70 |
--
|
71 |
|
72 |
CREATE TABLE `Prewikka_User_Configuration` ( |
73 |
`userid` varchar(255) NOT NULL, |
74 |
`config` text NULL |
75 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
76 |
|
77 |
-- --------------------------------------------------------
|
78 |
|
79 |
--
|
80 |
-- Table structure for table `Prewikka_Crontab`
|
81 |
--
|
82 |
|
83 |
CREATE TABLE `Prewikka_Crontab` ( |
84 |
`id` bigint UNSIGNED NOT NULL, |
85 |
`name` varchar(255) NOT NULL, |
86 |
`userid` varchar(32) NULL, |
87 |
`schedule` varchar(32) NULL, |
88 |
`ext_type` varchar(255) NULL, |
89 |
`ext_id` integer NULL, |
90 |
`base` datetime NOT NULL, |
91 |
`enabled` tinyint default 1, |
92 |
`runcnt` integer default 0, |
93 |
`error` text NULL |
94 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
95 |
|
96 |
-- --------------------------------------------------------
|
97 |
|
98 |
--
|
99 |
-- Table structure for table `Prewikka_History_Query`
|
100 |
--
|
101 |
|
102 |
CREATE TABLE `Prewikka_History_Query` ( |
103 |
`userid` varchar(32) NOT NULL, |
104 |
`formid` varchar(255) NOT NULL, |
105 |
`query` text NOT NULL, |
106 |
`query_hash` varchar(32) NOT NULL, |
107 |
`timestamp` datetime NOT NULL |
108 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
109 |
|
110 |
--
|
111 |
-- Indexes for dumped tables
|
112 |
--
|
113 |
|
114 |
--
|
115 |
-- Indexes for table `Prewikka_Module_Registry`
|
116 |
--
|
117 |
ALTER TABLE `Prewikka_Module_Registry`
|
118 |
ADD PRIMARY KEY (`module`); |
119 |
|
120 |
--
|
121 |
-- Indexes for table `Prewikka_Session`
|
122 |
--
|
123 |
ALTER TABLE `Prewikka_Session`
|
124 |
ADD PRIMARY KEY (`sessionid`); |
125 |
|
126 |
--
|
127 |
-- Indexes for table `Prewikka_User_Configuration`
|
128 |
--
|
129 |
ALTER TABLE `Prewikka_User_Configuration`
|
130 |
ADD PRIMARY KEY (`userid`); |
131 |
|
132 |
--
|
133 |
-- Indexes for table `Prewikka_Crontab`
|
134 |
--
|
135 |
ALTER TABLE `Prewikka_Crontab`
|
136 |
ADD PRIMARY KEY (`id`); |
137 |
|
138 |
--
|
139 |
-- Indexes for table `Prewikka_History_Query`
|
140 |
--
|
141 |
ALTER TABLE `Prewikka_History_Query`
|
142 |
ADD PRIMARY KEY (`userid`, `formid`, `query_hash`); |
143 |
|
144 |
--
|
145 |
-- AUTO_INCREMENT for dumped tables
|
146 |
--
|
147 |
|
148 |
--
|
149 |
-- AUTO_INCREMENT for table `Prewikka_Crontab`
|
150 |
--
|
151 |
ALTER TABLE `Prewikka_Crontab`
|
152 |
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; |
153 |
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
154 |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
155 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|