| commit | author | age | ||
| 87a4a6 | 1 | # phpMyAdmin MySQL-Dump |
| T | 2 | # version 2.4.0-rc1 |
| 3 | # http://www.phpmyadmin.net/ (download page) | |
| 4 | # | |
| 5 | # Host: localhost | |
| 6 | # Erstellungszeit: 24. Februar 2006 um 10:32 | |
| 7 | # Server Version: 4.0.23 | |
| 8 | # PHP-Version: 5.0.3 | |
| 9 | # Datenbank: `ispconfig3` | |
| 10 | # -------------------------------------------------------- | |
| 11 | ||
| 12 | # | |
| 13 | # Tabellenstruktur für Tabelle `mail_blacklist` | |
| 14 | # | |
| 15 | ||
| 16 | DROP TABLE IF EXISTS mail_blacklist; | |
| 17 | CREATE TABLE mail_blacklist ( | |
| 18 | blacklist_id int(11) NOT NULL auto_increment, | |
| 19 | sys_userid int(11) NOT NULL default '0', | |
| 20 | sys_groupid int(11) NOT NULL default '0', | |
| 21 | sys_perm_user varchar(5) NOT NULL default '', | |
| 22 | sys_perm_group varchar(5) NOT NULL default '', | |
| 23 | sys_perm_other varchar(5) NOT NULL default '', | |
| 24 | server_id int(11) NOT NULL default '0', | |
| 25 | address varchar(200) NOT NULL default '', | |
| 26 | recipient varchar(200) NOT NULL default '', | |
| 27 | active enum('0','1') NOT NULL default '1', | |
| 28 | PRIMARY KEY (blacklist_id), | |
| 29 | KEY server_id (server_id,address,recipient) | |
| 30 | ) TYPE=MyISAM; | |
| 31 | ||
| 32 | # | |
| 33 | # Daten für Tabelle `mail_blacklist` | |
| 34 | # | |
| 35 | ||
| 36 | INSERT INTO mail_blacklist VALUES (2, 1, 0, 'riud', 'riud', '', 1, 'till@test.int', 'till@test.int', '0'); | |
| 37 | # -------------------------------------------------------- | |
| 38 | ||
| 39 | # | |
| 40 | # Tabellenstruktur für Tabelle `mail_box` | |
| 41 | # | |
| 42 | ||
| 43 | DROP TABLE IF EXISTS mail_box; | |
| 44 | CREATE TABLE mail_box ( | |
| 45 | mailbox_id int(11) NOT NULL auto_increment, | |
| 46 | sys_userid int(11) NOT NULL default '0', | |
| 47 | sys_groupid int(11) NOT NULL default '0', | |
| 48 | sys_perm_user varchar(5) NOT NULL default '', | |
| 49 | sys_perm_group varchar(5) NOT NULL default '', | |
| 50 | sys_perm_other varchar(5) NOT NULL default '', | |
| 51 | server_id int(11) NOT NULL default '0', | |
| 52 | email varchar(255) NOT NULL default '', | |
| 53 | cryptpwd varchar(128) NOT NULL default '', | |
| 54 | clearpwd varchar(128) NOT NULL default '', | |
| 55 | name varchar(128) NOT NULL default '', | |
| 56 | uid int(10) unsigned NOT NULL default '0', | |
| 57 | gid int(10) unsigned NOT NULL default '0', | |
| 58 | maildir varchar(255) NOT NULL default '', | |
| 59 | quota varchar(255) NOT NULL default '', | |
| 60 | autoresponder enum('0','1') NOT NULL default '0', | |
| 61 | autoresponder_text tinytext NOT NULL, | |
| 62 | active enum('0','1') NOT NULL default '1', | |
| 63 | PRIMARY KEY (mailbox_id), | |
| 64 | KEY server_id (server_id,email) | |
| 65 | ) TYPE=MyISAM; | |
| 66 | ||
| 67 | # | |
| 68 | # Daten für Tabelle `mail_box` | |
| 69 | # | |
| 70 | ||
| 71 | INSERT INTO mail_box VALUES (1, 1, 0, 'riud', 'riud', '', 1, 'tt@test.int', '$1$tRlfKeOB$iHJgCn8mH8x/dh/XWy6v0/', '', '', 0, 0, '/var/spool/mail/till', '100', '0', '', '1'); | |
| 72 | INSERT INTO mail_box VALUES (2, 1, 0, 'riud', 'riud', '', 1, 'moin@test.int', '$1$Ee/.7y3.$wZ4BLXs/Pa80ka9X4ikN8.', '', '', 0, 0, '/var/spool/mail/test.int/moin', '10', '0', '', '1'); | |
| 73 | # -------------------------------------------------------- | |
| 74 | ||
| 75 | # | |
| 76 | # Tabellenstruktur für Tabelle `mail_domain` | |
| 77 | # | |
| 78 | ||
| 79 | DROP TABLE IF EXISTS mail_domain; | |
| 80 | CREATE TABLE mail_domain ( | |
| 81 | domain_id int(11) NOT NULL auto_increment, | |
| 82 | sys_userid int(11) NOT NULL default '0', | |
| 83 | sys_groupid int(11) NOT NULL default '0', | |
| 84 | sys_perm_user varchar(5) NOT NULL default '', | |
| 85 | sys_perm_group varchar(5) NOT NULL default '', | |
| 86 | sys_perm_other varchar(5) NOT NULL default '', | |
| 87 | server_id int(11) NOT NULL default '0', | |
| 88 | domain varchar(255) NOT NULL default '', | |
| 89 | type enum('local','relay','alias') NOT NULL default 'local', | |
| 90 | destination varchar(255) NOT NULL default '', | |
| 91 | active tinyint(4) NOT NULL default '1', | |
| 92 | PRIMARY KEY (domain_id), | |
| 93 | KEY server_id (server_id,domain,type) | |
| 94 | ) TYPE=MyISAM; | |
| 95 | ||
| 96 | # | |
| 97 | # Daten für Tabelle `mail_domain` | |
| 98 | # | |
| 99 | ||
| 100 | INSERT INTO mail_domain VALUES (1, 1, 0, 'riud', 'riud', '', 1, 'test.int', 'local', '', 1); | |
| 101 | INSERT INTO mail_domain VALUES (2, 1, 0, 'riud', 'riud', '', 1, 'test2.int', 'alias', 'test.int', 1); | |
| 102 | # -------------------------------------------------------- | |
| 103 | ||
| 104 | # | |
| 105 | # Tabellenstruktur für Tabelle `mail_domain_catchall` | |
| 106 | # | |
| 107 | ||
| 108 | DROP TABLE IF EXISTS mail_domain_catchall; | |
| 109 | CREATE TABLE mail_domain_catchall ( | |
| 110 | domain_catchall_id int(11) NOT NULL auto_increment, | |
| 111 | sys_userid int(11) NOT NULL default '0', | |
| 112 | sys_groupid int(11) NOT NULL default '0', | |
| 113 | sys_perm_user varchar(5) NOT NULL default '', | |
| 114 | sys_perm_group varchar(5) NOT NULL default '', | |
| 115 | sys_perm_other varchar(5) NOT NULL default '', | |
| 116 | server_id int(11) NOT NULL default '0', | |
| 117 | domain varchar(255) NOT NULL default '', | |
| 118 | destination varchar(255) NOT NULL default '', | |
| 119 | active enum('0','1') NOT NULL default '1', | |
| 120 | PRIMARY KEY (domain_catchall_id), | |
| 121 | KEY server_id (server_id,domain) | |
| 122 | ) TYPE=MyISAM; | |
| 123 | ||
| 124 | # | |
| 125 | # Daten für Tabelle `mail_domain_catchall` | |
| 126 | # | |
| 127 | ||
| 128 | INSERT INTO mail_domain_catchall VALUES (1, 1, 1, 'riud', 'riud', '', 1, 'test.int', 'till@test.int', '1'); | |
| 129 | # -------------------------------------------------------- | |
| 130 | ||
| 131 | # | |
| 132 | # Tabellenstruktur für Tabelle `mail_greylist` | |
| 133 | # | |
| 134 | ||
| 135 | DROP TABLE IF EXISTS mail_greylist; | |
| 136 | CREATE TABLE mail_greylist ( | |
| 137 | greylist_id int(11) NOT NULL auto_increment, | |
| 138 | relay_ip varchar(64) default NULL, | |
| 139 | from_domain varchar(255) default NULL, | |
| 140 | block_expires datetime NOT NULL default '0000-00-00 00:00:00', | |
| 141 | record_expires datetime NOT NULL default '0000-00-00 00:00:00', | |
| 142 | origin_type enum('MANUAL','AUTO') NOT NULL default 'AUTO', | |
| 143 | create_time datetime NOT NULL default '0000-00-00 00:00:00', | |
| 144 | PRIMARY KEY (greylist_id) | |
| 145 | ) TYPE=MyISAM; | |
| 146 | ||
| 147 | # | |
| 148 | # Daten für Tabelle `mail_greylist` | |
| 149 | # | |
| 150 | ||
| 151 | # -------------------------------------------------------- | |
| 152 | ||
| 153 | # | |
| 154 | # Tabellenstruktur für Tabelle `mail_mailman_domain` | |
| 155 | # | |
| 156 | ||
| 157 | DROP TABLE IF EXISTS mail_mailman_domain; | |
| 158 | CREATE TABLE mail_mailman_domain ( | |
| 159 | mailman_id int(11) NOT NULL auto_increment, | |
| 160 | server_id int(11) NOT NULL default '0', | |
| 161 | domain varchar(255) NOT NULL default '', | |
| 162 | mm_home varchar(255) NOT NULL default '', | |
| 163 | mm_wrap varchar(255) NOT NULL default '', | |
| 164 | mm_user varchar(50) NOT NULL default '', | |
| 165 | mm_group varchar(50) NOT NULL default '', | |
| 166 | PRIMARY KEY (mailman_id,server_id,domain) | |
| 167 | ) TYPE=MyISAM; | |
| 168 | ||
| 169 | # | |
| 170 | # Daten für Tabelle `mail_mailman_domain` | |
| 171 | # | |
| 172 | ||
| 173 | # -------------------------------------------------------- | |
| 174 | ||
| 175 | # | |
| 176 | # Tabellenstruktur für Tabelle `mail_redirect` | |
| 177 | # | |
| 178 | ||
| 179 | DROP TABLE IF EXISTS mail_redirect; | |
| 180 | CREATE TABLE mail_redirect ( | |
| 181 | redirect_id int(11) NOT NULL auto_increment, | |
| 182 | sys_userid int(11) NOT NULL default '0', | |
| 183 | sys_groupid int(11) NOT NULL default '0', | |
| 184 | sys_perm_user varchar(5) NOT NULL default '', | |
| 185 | sys_perm_group varchar(5) NOT NULL default '', | |
| 186 | sys_perm_other varchar(5) NOT NULL default '', | |
| 187 | server_id int(11) NOT NULL default '0', | |
| 188 | email varchar(255) NOT NULL default '', | |
| 189 | destination varchar(255) NOT NULL default '', | |
| 190 | type enum('alias','forward') NOT NULL default 'alias', | |
| 191 | active enum('0','1') NOT NULL default '1', | |
| 192 | PRIMARY KEY (redirect_id), | |
| 193 | KEY server_id (server_id,email) | |
| 194 | ) TYPE=MyISAM; | |
| 195 | ||
| 196 | # | |
| 197 | # Daten für Tabelle `mail_redirect` | |
| 198 | # | |
| 199 | ||
| 200 | INSERT INTO mail_redirect VALUES (1, 1, 0, 'riud', 'riud', '', 1, 'tom@test.int', 'tt@test.int', 'alias', '1'); | |
| 201 | # -------------------------------------------------------- | |
| 202 | ||
| 203 | # | |
| 204 | # Tabellenstruktur für Tabelle `mail_spamfilter` | |
| 205 | # | |
| 206 | ||
| 207 | DROP TABLE IF EXISTS mail_spamfilter; | |
| 208 | CREATE TABLE mail_spamfilter ( | |
| 209 | spamfilter_id int(11) NOT NULL auto_increment, | |
| 210 | sys_userid int(11) NOT NULL default '0', | |
| 211 | sys_groupid int(11) NOT NULL default '0', | |
| 212 | sys_perm_user varchar(5) NOT NULL default '', | |
| 213 | sys_perm_group varchar(5) NOT NULL default '', | |
| 214 | sys_perm_other varchar(5) NOT NULL default '', | |
| 215 | server_id int(11) NOT NULL default '0', | |
| 216 | email varchar(255) NOT NULL default '', | |
| 217 | spam_rewrite_score_int int(11) NOT NULL default '0', | |
| 218 | spam_delete_score_int int(11) NOT NULL default '0', | |
| 219 | spam_redirect_score_int int(11) NOT NULL default '0', | |
| 220 | spam_rewrite_subject varchar(50) NOT NULL default '***SPAM***', | |
| 221 | spam_redirect_maildir varchar(255) NOT NULL default '', | |
| 222 | spam_redirect_maildir_purge int(11) NOT NULL default '7', | |
| 223 | active enum('0','1') NOT NULL default '1', | |
| 224 | PRIMARY KEY (spamfilter_id), | |
| 225 | KEY server_id (server_id,email) | |
| 226 | ) TYPE=MyISAM; | |
| 227 | ||
| 228 | # | |
| 229 | # Daten für Tabelle `mail_spamfilter` | |
| 230 | # | |
| 231 | ||
| 232 | INSERT INTO mail_spamfilter VALUES (1, 0, 0, '', '', '', 1, 'till@test.int', 100, 100, 1, '***SPAM mag ich nicht***', '/var/spool/mail/spam', 0, '1'); | |
| 233 | INSERT INTO mail_spamfilter VALUES (2, 1, 0, 'riud', 'riud', '', 1, 'till2@test.int', 500, 1500, 700, '***SPAM***', '/var/spool/mail/till', 14, '1'); | |
| 234 | # -------------------------------------------------------- | |
| 235 | ||
| 236 | # | |
| 237 | # Tabellenstruktur für Tabelle `mail_transport` | |
| 238 | # | |
| 239 | ||
| 240 | DROP TABLE IF EXISTS mail_transport; | |
| 241 | CREATE TABLE mail_transport ( | |
| 242 | whitelist_id int(11) NOT NULL auto_increment, | |
| 243 | sys_userid int(11) NOT NULL default '0', | |
| 244 | sys_groupid int(11) NOT NULL default '0', | |
| 245 | sys_perm_user varchar(5) NOT NULL default '', | |
| 246 | sys_perm_group varchar(5) NOT NULL default '', | |
| 247 | sys_perm_other varchar(5) NOT NULL default '', | |
| 248 | server_id int(11) NOT NULL default '0', | |
| 249 | domain varchar(255) NOT NULL default '', | |
| 250 | destination varchar(255) NOT NULL default '', | |
| 251 | active enum('0','1') NOT NULL default '1', | |
| 252 | PRIMARY KEY (whitelist_id), | |
| 253 | KEY server_id (server_id,destination), | |
| 254 | KEY server_id_2 (server_id,domain) | |
| 255 | ) TYPE=MyISAM; | |
| 256 | ||
| 257 | # | |
| 258 | # Daten für Tabelle `mail_transport` | |
| 259 | # | |
| 260 | ||
| 261 | # -------------------------------------------------------- | |
| 262 | ||
| 263 | # | |
| 264 | # Tabellenstruktur für Tabelle `mail_whitelist` | |
| 265 | # | |
| 266 | ||
| 267 | DROP TABLE IF EXISTS mail_whitelist; | |
| 268 | CREATE TABLE mail_whitelist ( | |
| 269 | whitelist_id int(11) NOT NULL auto_increment, | |
| 270 | sys_userid int(11) NOT NULL default '0', | |
| 271 | sys_groupid int(11) NOT NULL default '0', | |
| 272 | sys_perm_user varchar(5) NOT NULL default '', | |
| 273 | sys_perm_group varchar(5) NOT NULL default '', | |
| 274 | sys_perm_other varchar(5) NOT NULL default '', | |
| 275 | server_id int(11) NOT NULL default '0', | |
| 276 | address varchar(255) NOT NULL default '', | |
| 277 | recipient varchar(255) NOT NULL default '', | |
| 278 | active enum('0','1') NOT NULL default '1', | |
| 279 | PRIMARY KEY (whitelist_id), | |
| 280 | KEY server_id (server_id,address) | |
| 281 | ) TYPE=MyISAM; | |
| 282 | ||
| 283 | # | |
| 284 | # Daten für Tabelle `mail_whitelist` | |
| 285 | # | |
| 286 | ||
| 287 | # -------------------------------------------------------- | |
| 288 | ||
| 289 | # | |
| 290 | # Tabellenstruktur für Tabelle `reseller` | |
| 291 | # | |
| 292 | ||
| 293 | DROP TABLE IF EXISTS reseller; | |
| 294 | CREATE TABLE reseller ( | |
| 295 | reseller_id bigint(20) NOT NULL auto_increment, | |
| 296 | sys_userid int(11) NOT NULL default '0', | |
| 297 | sys_groupid int(11) NOT NULL default '0', | |
| 298 | sys_perm_user varchar(5) NOT NULL default '', | |
| 299 | sys_perm_group varchar(5) NOT NULL default '', | |
| 300 | sys_perm_other varchar(5) NOT NULL default '', | |
| 301 | company varchar(255) NOT NULL default '', | |
| 302 | title varchar(255) NOT NULL default '', | |
| 303 | firstname varchar(255) NOT NULL default '', | |
| 304 | surname varchar(255) NOT NULL default '', | |
| 305 | street varchar(255) NOT NULL default '', | |
| 306 | zip varchar(255) NOT NULL default '', | |
| 307 | city varchar(255) NOT NULL default '', | |
| 308 | country varchar(255) NOT NULL default '', | |
| 309 | telephone varchar(255) NOT NULL default '', | |
| 310 | mobile varchar(255) NOT NULL default '', | |
| 311 | fax varchar(255) NOT NULL default '', | |
| 312 | email varchar(255) NOT NULL default '', | |
| 313 | internet varchar(255) NOT NULL default '', | |
| 314 | icq varchar(255) NOT NULL default '', | |
| 315 | notes text NOT NULL, | |
| 316 | limit_client int(11) NOT NULL default '-1', | |
| 317 | limit_domain int(11) NOT NULL default '-1', | |
| 318 | limit_subdomain int(11) NOT NULL default '-1', | |
| 319 | limit_mailbox int(11) NOT NULL default '-1', | |
| 320 | limit_mailalias int(11) NOT NULL default '-1', | |
| 321 | limit_webquota int(11) NOT NULL default '-1', | |
| 322 | limit_mailquota int(11) NOT NULL default '-1', | |
| 323 | limit_database int(11) NOT NULL default '-1', | |
| 324 | ip_address text NOT NULL, | |
| 325 | PRIMARY KEY (reseller_id) | |
| 326 | ) TYPE=MyISAM; | |
| 327 | ||
| 328 | # | |
| 329 | # Daten für Tabelle `reseller` | |
| 330 | # | |
| 331 | ||
| 332 | # -------------------------------------------------------- | |
| 333 | ||
| 334 | # | |
| 335 | # Tabellenstruktur für Tabelle `rr` | |
| 336 | # | |
| 337 | ||
| 338 | DROP TABLE IF EXISTS rr; | |
| 339 | CREATE TABLE rr ( | |
| 340 | id int(10) unsigned NOT NULL auto_increment, | |
| 341 | zone int(10) unsigned NOT NULL default '0', | |
| 342 | name varchar(64) NOT NULL default '', | |
| 343 | type enum('A','AAAA','ALIAS','CNAME','HINFO','MX','NS','PTR','RP','SRV','TXT') default NULL, | |
| 344 | data varchar(128) NOT NULL default '', | |
| 345 | aux int(10) unsigned NOT NULL default '0', | |
| 346 | ttl int(10) unsigned NOT NULL default '86400', | |
| 347 | sys_userid int(11) NOT NULL default '0', | |
| 348 | sys_groupid int(11) NOT NULL default '0', | |
| 349 | sys_perm_user varchar(5) NOT NULL default '', | |
| 350 | sys_perm_group varchar(5) NOT NULL default '', | |
| 351 | sys_perm_other varchar(5) NOT NULL default '', | |
| 352 | PRIMARY KEY (id), | |
| 353 | UNIQUE KEY rr (zone,name,type,data) | |
| 354 | ) TYPE=MyISAM; | |
| 355 | ||
| 356 | # | |
| 357 | # Daten für Tabelle `rr` | |
| 358 | # | |
| 359 | ||
| 360 | INSERT INTO rr VALUES (1, 2, '1', 'PTR', 'www.ensign.de.', 0, 86400, 1, 0, 'riud', 'riud', ''); | |
| 361 | INSERT INTO rr VALUES (2, 1, 'www', 'A', '192.168.0.1', 0, 86400, 1, 0, 'riud', 'riud', ''); | |
| 362 | INSERT INTO rr VALUES (3, 1, 'ensign.de', 'A', '192.168.0.1', 0, 86400, 1, 0, 'riud', 'riud', ''); | |
| 363 | # -------------------------------------------------------- | |
| 364 | ||
| 365 | # | |
| 366 | # Tabellenstruktur für Tabelle `server` | |
| 367 | # | |
| 368 | ||
| 369 | DROP TABLE IF EXISTS server; | |
| 370 | CREATE TABLE server ( | |
| 371 | server_id bigint(20) NOT NULL auto_increment, | |
| 372 | sys_userid int(11) NOT NULL default '0', | |
| 373 | sys_groupid int(11) NOT NULL default '0', | |
| 374 | sys_perm_user varchar(5) NOT NULL default '', | |
| 375 | sys_perm_group varchar(5) NOT NULL default '', | |
| 376 | sys_perm_other varchar(5) NOT NULL default '', | |
| 377 | server_name varchar(255) NOT NULL default '', | |
| 378 | mail_server tinyint(4) NOT NULL default '0', | |
| 379 | web_server tinyint(4) NOT NULL default '0', | |
| 380 | dns_server tinyint(4) NOT NULL default '0', | |
| 381 | file_server tinyint(4) NOT NULL default '0', | |
| 382 | db_server tinyint(4) NOT NULL default '0', | |
| 383 | vserver_server tinyint(4) NOT NULL default '0', | |
| 384 | config text NOT NULL, | |
| 385 | update tinyint(4) NOT NULL default '0', | |
| 386 | active tinyint(4) NOT NULL default '1', | |
| 387 | PRIMARY KEY (server_id) | |
| 388 | ) TYPE=MyISAM; | |
| 389 | ||
| 390 | # | |
| 391 | # Daten für Tabelle `server` | |
| 392 | # | |
| 393 | ||
| 394 | INSERT INTO server VALUES (1, 1, 1, 'riud', 'riud', '', 'Server 1', 1, 0, 0, 0, 0, 0, '[global]\r\nwebserver=apache\r\nmailserver=exim\r\ndnsserver=mydns\r\n\r\n[mail]\r\nmodule=exim_mysql\r\nmaildir_path=/var/spool/mail/[domain]/[localpart]\r\nmailuser_uid=0\r\nmailuser_gid=0', 0, 1); | |
| 395 | # -------------------------------------------------------- | |
| 396 | ||
| 397 | # | |
| 398 | # Tabellenstruktur für Tabelle `soa` | |
| 399 | # | |
| 400 | ||
| 401 | DROP TABLE IF EXISTS soa; | |
| 402 | CREATE TABLE soa ( | |
| 403 | id int(10) unsigned NOT NULL auto_increment, | |
| 404 | origin varchar(255) NOT NULL default '', | |
| 405 | ns varchar(255) NOT NULL default '', | |
| 406 | mbox varchar(255) NOT NULL default '', | |
| 407 | serial int(10) unsigned NOT NULL default '1', | |
| 408 | refresh int(10) unsigned NOT NULL default '28800', | |
| 409 | retry int(10) unsigned NOT NULL default '7200', | |
| 410 | expire int(10) unsigned NOT NULL default '604800', | |
| 411 | minimum int(10) unsigned NOT NULL default '86400', | |
| 412 | ttl int(10) unsigned NOT NULL default '86400', | |
| 413 | active enum('Y','N') NOT NULL default 'Y', | |
| 414 | xfer varchar(255) NOT NULL default '', | |
| 415 | sys_userid int(11) NOT NULL default '0', | |
| 416 | sys_groupid int(11) NOT NULL default '0', | |
| 417 | sys_perm_user varchar(5) NOT NULL default '', | |
| 418 | sys_perm_group varchar(5) NOT NULL default '', | |
| 419 | sys_perm_other varchar(5) NOT NULL default '', | |
| 420 | PRIMARY KEY (id), | |
| 421 | UNIQUE KEY origin (origin), | |
| 422 | KEY active (active) | |
| 423 | ) TYPE=MyISAM; | |
| 424 | ||
| 425 | # | |
| 426 | # Daten für Tabelle `soa` | |
| 427 | # | |
| 428 | ||
| 429 | INSERT INTO soa VALUES (1, 'ensign.de.', 'ns1.example.com.', 'admin.example.com.', 2006012103, 28800, 7200, 604800, 86400, 86400, 'Y', '', 1, 0, 'riud', 'riud', ''); | |
| 430 | INSERT INTO soa VALUES (2, '0.168.192.in-addr.arpa.', 'ns1.example.com.', 'admin.example.com.', 2006012101, 28800, 7200, 604800, 86400, 86400, 'Y', '', 1, 0, 'riud', 'riud', ''); | |
| 431 | # -------------------------------------------------------- | |
| 432 | ||
| 433 | # | |
| 434 | # Tabellenstruktur für Tabelle `sys_datalog` | |
| 435 | # | |
| 436 | ||
| 437 | DROP TABLE IF EXISTS sys_datalog; | |
| 438 | CREATE TABLE sys_datalog ( | |
| 439 | datalog_id bigint(20) NOT NULL auto_increment, | |
| 440 | dbtable varchar(255) NOT NULL default '', | |
| 441 | dbidx varchar(255) NOT NULL default '', | |
| 442 | server_id int(11) NOT NULL default '0', | |
| 443 | action char(1) NOT NULL default '', | |
| 444 | tstamp bigint(20) NOT NULL default '0', | |
| 445 | user varchar(255) NOT NULL default '', | |
| 446 | data text NOT NULL, | |
| 447 | PRIMARY KEY (datalog_id) | |
| 448 | ) TYPE=MyISAM; | |
| 449 | ||
| 450 | # | |
| 451 | # Daten für Tabelle `sys_datalog` | |
| 452 | # | |
| 453 | ||
| 454 | # -------------------------------------------------------- | |
| 455 | ||
| 456 | # | |
| 457 | # Tabellenstruktur für Tabelle `sys_dbsync` | |
| 458 | # | |
| 459 | ||
| 460 | DROP TABLE IF EXISTS sys_dbsync; | |
| 461 | CREATE TABLE sys_dbsync ( | |
| 462 | id bigint(20) NOT NULL auto_increment, | |
| 463 | jobname varchar(255) NOT NULL default '', | |
| 464 | sync_interval_minutes int(11) NOT NULL default '0', | |
| 465 | db_type varchar(255) NOT NULL default '', | |
| 466 | db_host varchar(255) NOT NULL default '', | |
| 467 | db_name varchar(255) NOT NULL default '', | |
| 468 | db_username varchar(255) NOT NULL default '', | |
| 469 | db_password varchar(255) NOT NULL default '', | |
| 470 | db_tables varchar(255) NOT NULL default 'admin,forms', | |
| 471 | empty_datalog int(11) NOT NULL default '0', | |
| 472 | sync_datalog_external int(11) NOT NULL default '0', | |
| 473 | active int(11) NOT NULL default '1', | |
| 474 | last_datalog_id bigint(20) NOT NULL default '0', | |
| 475 | PRIMARY KEY (id), | |
| 476 | KEY last_datalog_id (last_datalog_id) | |
| 477 | ) TYPE=MyISAM; | |
| 478 | ||
| 479 | # | |
| 480 | # Daten für Tabelle `sys_dbsync` | |
| 481 | # | |
| 482 | ||
| 483 | # -------------------------------------------------------- | |
| 484 | ||
| 485 | # | |
| 486 | # Tabellenstruktur für Tabelle `sys_filesync` | |
| 487 | # | |
| 488 | ||
| 489 | DROP TABLE IF EXISTS sys_filesync; | |
| 490 | CREATE TABLE sys_filesync ( | |
| 491 | id bigint(20) NOT NULL auto_increment, | |
| 492 | jobname varchar(255) NOT NULL default '', | |
| 493 | sync_interval_minutes int(11) NOT NULL default '0', | |
| 494 | ftp_host varchar(255) NOT NULL default '', | |
| 495 | ftp_path varchar(255) NOT NULL default '', | |
| 496 | ftp_username varchar(255) NOT NULL default '', | |
| 497 | ftp_password varchar(255) NOT NULL default '', | |
| 498 | local_path varchar(255) NOT NULL default '', | |
| 499 | wput_options varchar(255) NOT NULL default '--timestamping --reupload --dont-continue', | |
| 500 | active int(11) NOT NULL default '1', | |
| 501 | PRIMARY KEY (id) | |
| 502 | ) TYPE=MyISAM; | |
| 503 | ||
| 504 | # | |
| 505 | # Daten für Tabelle `sys_filesync` | |
| 506 | # | |
| 507 | ||
| 508 | # -------------------------------------------------------- | |
| 509 | ||
| 510 | # | |
| 511 | # Tabellenstruktur für Tabelle `sys_group` | |
| 512 | # | |
| 513 | ||
| 514 | DROP TABLE IF EXISTS sys_group; | |
| 515 | CREATE TABLE sys_group ( | |
| 516 | groupid int(11) NOT NULL auto_increment, | |
| 517 | name varchar(255) NOT NULL default '', | |
| 518 | description text NOT NULL, | |
| 519 | PRIMARY KEY (groupid) | |
| 520 | ) TYPE=MyISAM; | |
| 521 | ||
| 522 | # | |
| 523 | # Daten für Tabelle `sys_group` | |
| 524 | # | |
| 525 | ||
| 526 | INSERT INTO sys_group VALUES (1, 'admin', 'Administrators group'); | |
| 527 | INSERT INTO sys_group VALUES (2, 'user', 'Users Group'); | |
| 528 | # -------------------------------------------------------- | |
| 529 | ||
| 530 | # | |
| 531 | # Tabellenstruktur für Tabelle `sys_user` | |
| 532 | # | |
| 533 | ||
| 534 | DROP TABLE IF EXISTS sys_user; | |
| 535 | CREATE TABLE sys_user ( | |
| 536 | userid int(11) NOT NULL auto_increment, | |
| 537 | sys_userid int(11) NOT NULL default '0', | |
| 538 | sys_groupid int(11) NOT NULL default '0', | |
| 539 | sys_perm_user varchar(5) NOT NULL default '', | |
| 540 | sys_perm_group varchar(5) NOT NULL default '', | |
| 541 | sys_perm_other varchar(5) NOT NULL default '', | |
| 542 | username varchar(100) NOT NULL default '', | |
| 543 | passwort varchar(100) NOT NULL default '', | |
| 544 | modules varchar(255) NOT NULL default '', | |
| 545 | startmodule varchar(255) NOT NULL default '', | |
| 546 | app_theme varchar(100) NOT NULL default 'default', | |
| 547 | typ varchar(20) NOT NULL default 'user', | |
| 548 | active tinyint(4) NOT NULL default '1', | |
| 549 | name varchar(100) NOT NULL default '', | |
| 550 | vorname varchar(100) NOT NULL default '', | |
| 551 | unternehmen varchar(100) NOT NULL default '', | |
| 552 | strasse varchar(100) NOT NULL default '', | |
| 553 | ort varchar(100) NOT NULL default '', | |
| 554 | plz varchar(10) NOT NULL default '', | |
| 555 | land varchar(50) NOT NULL default '', | |
| 556 | email varchar(100) NOT NULL default '', | |
| 557 | url varchar(255) NOT NULL default '', | |
| 558 | telefon varchar(100) NOT NULL default '', | |
| 559 | fax varchar(100) NOT NULL default '', | |
| 560 | language varchar(10) NOT NULL default 'de', | |
| 561 | groups varchar(255) NOT NULL default '', | |
| 562 | default_group int(11) NOT NULL default '0', | |
| 563 | PRIMARY KEY (userid) | |
| 564 | ) TYPE=MyISAM; | |
| 565 | ||
| 566 | # | |
| 567 | # Daten für Tabelle `sys_user` | |
| 568 | # | |
| 569 | ||
| 570 | INSERT INTO sys_user VALUES (1, 1, 0, 'riud', 'riud', '', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin,designer,mail,dns', 'admin', 'default', 'admin', 1, '', 'Administrator', '', '', '', '', '', '', '', '', '', 'en', '1,2', 0); | |
| 571 | ||
