author | Dan |
Thu, 12 Jul 2007 15:00:35 -0400 | |
changeset 3 | c0c445d4a13e |
permissions | -rw-r--r-- |
3
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
1 |
-- Punano installation schema |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
2 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
3 |
CREATE TABLE {{TABLE_PREFIX}}categories ( |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
4 |
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
5 |
cat_name VARCHAR(80) NOT NULL DEFAULT 'New Category', |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
6 |
disp_position INT(10) NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
7 |
PRIMARY KEY (id) |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
8 |
) TYPE=MyISAM; |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
9 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
10 |
CREATE TABLE {{TABLE_PREFIX}}config ( |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
11 |
conf_name VARCHAR(255) NOT NULL DEFAULT '', |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
12 |
conf_value TEXT, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
13 |
PRIMARY KEY (conf_name) |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
14 |
) TYPE=MyISAM; |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
15 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
16 |
CREATE TABLE {{TABLE_PREFIX}}forum_perms ( |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
17 |
group_id INT(10) NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
18 |
forum_id INT(10) NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
19 |
read_forum TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
20 |
post_replies TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
21 |
post_topics TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
22 |
PRIMARY KEY (group_id, forum_id) |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
23 |
) TYPE=MyISAM; |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
24 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
25 |
CREATE TABLE {{TABLE_PREFIX}}forums ( |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
26 |
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
27 |
forum_name VARCHAR(80) NOT NULL DEFAULT 'New forum', |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
28 |
forum_desc TEXT, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
29 |
redirect_url VARCHAR(100), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
30 |
moderators TEXT, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
31 |
num_topics MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
32 |
num_posts MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
33 |
last_post INT(10) UNSIGNED, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
34 |
last_post_id INT(10) UNSIGNED, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
35 |
last_poster VARCHAR(200), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
36 |
sort_by TINYINT(1) NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
37 |
disp_position INT(10) NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
38 |
cat_id INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
39 |
PRIMARY KEY (id) |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
40 |
) TYPE=MyISAM; |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
41 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
42 |
CREATE TABLE {{TABLE_PREFIX}}groups ( |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
43 |
g_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
44 |
g_title VARCHAR(50) NOT NULL DEFAULT '', |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
45 |
g_user_title VARCHAR(50), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
46 |
g_read_board TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
47 |
g_post_replies TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
48 |
g_post_topics TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
49 |
g_post_polls TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
50 |
g_edit_posts TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
51 |
g_delete_posts TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
52 |
g_delete_topics TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
53 |
g_set_title TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
54 |
g_search TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
55 |
g_search_users TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
56 |
g_edit_subjects_interval SMALLINT(6) NOT NULL DEFAULT 300, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
57 |
g_post_flood SMALLINT(6) NOT NULL DEFAULT 30, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
58 |
g_search_flood SMALLINT(6) NOT NULL DEFAULT 30, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
59 |
PRIMARY KEY (g_id) |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
60 |
) TYPE=MyISAM; |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
61 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
62 |
CREATE TABLE {{TABLE_PREFIX}}online ( |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
63 |
user_id INT(10) UNSIGNED NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
64 |
ident VARCHAR(200) NOT NULL DEFAULT '', |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
65 |
logged INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
66 |
idle TINYINT(1) NOT NULL DEFAULT 0 |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
67 |
) TYPE=HEAP; |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
68 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
69 |
CREATE TABLE {{TABLE_PREFIX}}posts ( |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
70 |
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
71 |
poster VARCHAR(200) NOT NULL DEFAULT '', |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
72 |
poster_id INT(10) UNSIGNED NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
73 |
poster_ip VARCHAR(15), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
74 |
poster_email VARCHAR(50), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
75 |
message TEXT, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
76 |
hide_smilies TINYINT(1) NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
77 |
posted INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
78 |
edited INT(10) UNSIGNED, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
79 |
edited_by VARCHAR(200), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
80 |
topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
81 |
PRIMARY KEY (id) |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
82 |
) TYPE=MyISAM; |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
83 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
84 |
CREATE TABLE {{TABLE_PREFIX}}ranks ( |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
85 |
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
86 |
rank VARCHAR(50) NOT NULL DEFAULT '', |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
87 |
min_posts MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
88 |
PRIMARY KEY (id) |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
89 |
) TYPE=MyISAM; |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
90 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
91 |
CREATE TABLE {{TABLE_PREFIX}}reports ( |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
92 |
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
93 |
post_id INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
94 |
topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
95 |
forum_id INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
96 |
reported_by INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
97 |
created INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
98 |
message TEXT, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
99 |
zapped INT(10) UNSIGNED, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
100 |
zapped_by INT(10) UNSIGNED, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
101 |
PRIMARY KEY (id) |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
102 |
) TYPE=MyISAM; |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
103 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
104 |
CREATE TABLE {{TABLE_PREFIX}}search_cache ( |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
105 |
id INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
106 |
ident VARCHAR(200) NOT NULL DEFAULT '', |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
107 |
search_data TEXT, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
108 |
PRIMARY KEY (id) |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
109 |
) TYPE=MyISAM; |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
110 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
111 |
CREATE TABLE {{TABLE_PREFIX}}search_matches ( |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
112 |
post_id INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
113 |
word_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
114 |
subject_match TINYINT(1) NOT NULL DEFAULT 0 |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
115 |
) TYPE=MyISAM; |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
116 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
117 |
CREATE TABLE {{TABLE_PREFIX}}search_words ( |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
118 |
id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
119 |
word VARCHAR(20) BINARY NOT NULL DEFAULT '', |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
120 |
PRIMARY KEY (word), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
121 |
KEY {{TABLE_PREFIX}}search_words_id_idx (id) |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
122 |
) TYPE=MyISAM; |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
123 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
124 |
CREATE TABLE {{TABLE_PREFIX}}subscriptions ( |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
125 |
user_id INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
126 |
topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
127 |
PRIMARY KEY (user_id, topic_id) |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
128 |
) TYPE=MyISAM; |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
129 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
130 |
CREATE TABLE {{TABLE_PREFIX}}topics ( |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
131 |
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
132 |
poster VARCHAR(200) NOT NULL DEFAULT '', |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
133 |
subject VARCHAR(255) NOT NULL DEFAULT '', |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
134 |
posted INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
135 |
last_post INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
136 |
last_post_id INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
137 |
last_poster VARCHAR(200), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
138 |
num_views MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
139 |
num_replies MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
140 |
closed TINYINT(1) NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
141 |
sticky TINYINT(1) NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
142 |
moved_to INT(10) UNSIGNED, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
143 |
forum_id INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
144 |
PRIMARY KEY (id) |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
145 |
) TYPE=MyISAM; |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
146 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
147 |
CREATE TABLE {{TABLE_PREFIX}}users ( |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
148 |
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
149 |
group_id INT(10) UNSIGNED NOT NULL DEFAULT 4, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
150 |
title VARCHAR(50), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
151 |
realname VARCHAR(40), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
152 |
url VARCHAR(100), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
153 |
jabber VARCHAR(75), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
154 |
icq VARCHAR(12), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
155 |
msn VARCHAR(50), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
156 |
aim VARCHAR(30), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
157 |
yahoo VARCHAR(30), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
158 |
location VARCHAR(30), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
159 |
use_avatar TINYINT(1) NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
160 |
signature TEXT, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
161 |
disp_topics TINYINT(3) UNSIGNED, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
162 |
disp_posts TINYINT(3) UNSIGNED, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
163 |
email_setting TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
164 |
save_pass TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
165 |
notify_with_post TINYINT(1) NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
166 |
show_smilies TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
167 |
show_img TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
168 |
show_img_sig TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
169 |
show_avatars TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
170 |
show_sig TINYINT(1) NOT NULL DEFAULT 1, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
171 |
timezone FLOAT NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
172 |
language VARCHAR(25) NOT NULL DEFAULT 'English', |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
173 |
style VARCHAR(25) NOT NULL DEFAULT 'Oxygen', |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
174 |
num_posts INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
175 |
last_post INT(10) UNSIGNED, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
176 |
registered INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
177 |
registration_ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0', |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
178 |
last_visit INT(10) UNSIGNED NOT NULL DEFAULT 0, |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
179 |
admin_note VARCHAR(30), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
180 |
activate_string VARCHAR(50), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
181 |
activate_key VARCHAR(8), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
182 |
PRIMARY KEY (id) |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
183 |
) TYPE=MyISAM; |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
184 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
185 |
ALTER TABLE {{TABLE_PREFIX}}online ADD UNIQUE INDEX {{TABLE_PREFIX}}online_user_id_ident_idx(user_id,ident); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
186 |
ALTER TABLE {{TABLE_PREFIX}}online ADD INDEX {{TABLE_PREFIX}}online_user_id_idx(user_id); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
187 |
ALTER TABLE {{TABLE_PREFIX}}posts ADD INDEX {{TABLE_PREFIX}}posts_topic_id_idx(topic_id); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
188 |
ALTER TABLE {{TABLE_PREFIX}}posts ADD INDEX {{TABLE_PREFIX}}posts_multi_idx(poster_id, topic_id); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
189 |
ALTER TABLE {{TABLE_PREFIX}}reports ADD INDEX {{TABLE_PREFIX}}reports_zapped_idx(zapped); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
190 |
ALTER TABLE {{TABLE_PREFIX}}search_matches ADD INDEX {{TABLE_PREFIX}}search_matches_word_id_idx(word_id); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
191 |
ALTER TABLE {{TABLE_PREFIX}}search_matches ADD INDEX {{TABLE_PREFIX}}search_matches_post_id_idx(post_id); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
192 |
ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_forum_id_idx(forum_id); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
193 |
ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_moved_to_idx(moved_to); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
194 |
ALTER TABLE {{TABLE_PREFIX}}users ADD INDEX {{TABLE_PREFIX}}users_registered_idx(registered); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
195 |
ALTER TABLE {{TABLE_PREFIX}}search_cache ADD INDEX {{TABLE_PREFIX}}search_cache_ident_idx(ident(8)); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
196 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
197 |
INSERT INTO {{TABLE_PREFIX}}groups (g_title, g_user_title, g_read_board, g_post_replies, g_post_topics, g_post_polls, g_edit_posts, g_delete_posts, g_delete_topics, g_set_title, g_search, g_search_users, g_edit_subjects_interval, g_post_flood, g_search_flood) VALUES('Administrators', 'Administrator', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
198 |
INSERT INTO {{TABLE_PREFIX}}groups (g_title, g_user_title, g_read_board, g_post_replies, g_post_topics, g_post_polls, g_edit_posts, g_delete_posts, g_delete_topics, g_set_title, g_search, g_search_users, g_edit_subjects_interval, g_post_flood, g_search_flood) VALUES('Moderators', 'Moderator', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
199 |
INSERT INTO {{TABLE_PREFIX}}groups (g_title, g_user_title, g_read_board, g_post_replies, g_post_topics, g_post_polls, g_edit_posts, g_delete_posts, g_delete_topics, g_set_title, g_search, g_search_users, g_edit_subjects_interval, g_post_flood, g_search_flood) VALUES('Guest', NULL, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
200 |
INSERT INTO {{TABLE_PREFIX}}groups (g_title, g_user_title, g_read_board, g_post_replies, g_post_topics, g_post_polls, g_edit_posts, g_delete_posts, g_delete_topics, g_set_title, g_search, g_search_users, g_edit_subjects_interval, g_post_flood, g_search_flood) VALUES('Members', NULL, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 300, 60, 30); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
201 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
202 |
INSERT INTO {{TABLE_PREFIX}}users (id, group_id) VALUES(1, 3); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
203 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
204 |
INSERT INTO {{TABLE_PREFIX}}config VALUES |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
205 |
('o_cur_version', '{{PUN_VERSION}}'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
206 |
('o_board_title', 'My PunBB forum'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
207 |
('o_board_desc', 'Unfortunately no one can be told what PunBB is - you have to see it for yourself.'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
208 |
('o_server_timezone', '0'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
209 |
('o_time_format', 'H:i:s'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
210 |
('o_date_format', 'Y-m-d'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
211 |
('o_timeout_visit', '600'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
212 |
('o_timeout_online', '300'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
213 |
('o_redirect_delay', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
214 |
('o_show_version', '0'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
215 |
('o_show_user_info', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
216 |
('o_show_post_count', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
217 |
('o_smilies', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
218 |
('o_smilies_sig', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
219 |
('o_make_links', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
220 |
('o_default_lang', 'English'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
221 |
('o_default_style', 'Oxygen'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
222 |
('o_default_user_group', '4'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
223 |
('o_topic_review', '15'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
224 |
('o_disp_topics_default', '30'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
225 |
('o_disp_posts_default', '25'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
226 |
('o_indent_num_spaces', '4'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
227 |
('o_quickpost', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
228 |
('o_users_online', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
229 |
('o_censoring', '0'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
230 |
('o_ranks', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
231 |
('o_show_dot', '0'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
232 |
('o_quickjump', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
233 |
('o_gzip', '0'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
234 |
('o_additional_navlinks', ''), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
235 |
('o_report_method', '0'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
236 |
('o_regs_report', '0'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
237 |
('o_mailing_list', '{{ENANO_ADMIN_EMAIL}}'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
238 |
('o_avatars', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
239 |
('o_avatars_dir', 'img/avatars'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
240 |
('o_avatars_width', '60'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
241 |
('o_avatars_height', '60'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
242 |
('o_avatars_size', '10240'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
243 |
('o_search_all_forums', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
244 |
('o_base_url', ''), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
245 |
('o_admin_email', '{{ENANO_ADMIN_EMAIL}}'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
246 |
('o_webmaster_email', '{{ENANO_ADMIN_EMAIL}}'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
247 |
('o_subscriptions', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
248 |
('o_smtp_host', NULL), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
249 |
('o_smtp_user', NULL), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
250 |
('o_smtp_pass', NULL), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
251 |
('o_regs_allow', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
252 |
('o_regs_verify', '0'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
253 |
('o_announcement', '0'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
254 |
('o_announcement_message', 'Enter your announcement here.'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
255 |
('o_rules', '0'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
256 |
('o_rules_message', 'Enter your rules here.'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
257 |
('o_maintenance', '0'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
258 |
('o_maintenance_message', 'The forums are temporarily down for maintenance. Please try again in a few minutes.<br />\\n<br />\\n--Administrator'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
259 |
('p_mod_edit_users', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
260 |
('p_mod_rename_users', '0'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
261 |
('p_mod_change_passwords', '0'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
262 |
('p_mod_ban_users', '0'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
263 |
('p_message_bbcode', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
264 |
('p_message_img_tag', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
265 |
('p_message_all_caps', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
266 |
('p_subject_all_caps', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
267 |
('p_sig_all_caps', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
268 |
('p_sig_bbcode', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
269 |
('p_sig_img_tag', '0'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
270 |
('p_sig_length', '400'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
271 |
('p_sig_lines', '4'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
272 |
('p_allow_banned_email', '1'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
273 |
('p_allow_dupe_email', '0'), |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
274 |
('p_force_guest_email', '1'); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
275 |
|
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
276 |
INSERT INTO {{TABLE_PREFIX}}categories (cat_name, disp_position) VALUES('Test category', 1); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
277 |
INSERT INTO {{TABLE_PREFIX}}forums (forum_name, forum_desc, num_topics, num_posts, last_post, last_post_id, last_poster, disp_position, cat_id) VALUES('Test forum', 'This is just a test forum', 1, 1, UNIX_TIMESTAMP(), 1, 'PunBB', 1, 1); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
278 |
INSERT INTO {{TABLE_PREFIX}}topics (poster, subject, posted, last_post, last_post_id, last_poster, forum_id) VALUES('PunBB', 'Test post', UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 1, 'PunBB', 1); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
279 |
INSERT INTO {{TABLE_PREFIX}}posts (poster, poster_id, poster_ip, message, posted, topic_id) VALUES('PunBB', 2, '127.0.0.1', 'If you are looking at this (which I guess you are), the install of PunBB appears to have worked! Now log in and head over to the administration control panel to configure your forum.', UNIX_TIMESTAMP(), 1); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
280 |
INSERT INTO {{TABLE_PREFIX}}ranks (rank, min_posts) VALUES('New member', 0), ('Member', 10); |
c0c445d4a13e
Got some basic security in there, admin panel works now, and most admin panel forms work (used regex mass search + replace)
Dan
parents:
diff
changeset
|
281 |