-
Notifications
You must be signed in to change notification settings - Fork 0
/
3.3.1-plugins.sql
34 lines (23 loc) · 1.02 KB
/
3.3.1-plugins.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
CREATE TABLE IF NOT EXISTS userdata_plugins_options (
plugin_id INT NOT NULL,
name VARCHAR(16) NOT NULL,
value VARCHAR(255) NOT NULL,
PRIMARY KEY ( plugin_id, name ),
INDEX (plugin_id),
);
CREATE TABLE IF NOT EXISTS userdata_plugins_fields (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
plugin_id INT NOT NULL,
required TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
public TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
publish TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
f_label VARCHAR(255) DEFAULT NULL,
f_size SMALLINT DEFAULT NULL,
f_type enum('text','checkbox','textarea','header','hidden','select',
'radio','date','file','password','button','image','reset',
'submit','xbutton','advcheckbox','autocomplete',
'hierselect','html','link','static') DEFAULT 'text',
f_values TEXT, -- Yuck, just don't hurt me.
f_default TEXT,
INDEX (plugin_id),
);