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:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:
354:
355:
356:
357:
358:
359:
360:
361:
362:
363:
364:
365:
366:
367:
368:
369:
370:
371:
372:
373:
374:
375:
376:
377:
378:
379:
380:
381:
382:
383:
384:
385:
386:
387:
388:
389:
390:
391:
392:
393:
394:
395:
396:
397:
398:
399:
400:
401:
402:
403:
404:
405:
406:
407:
408:
409:
410:
411:
412:
413:
414:
415:
416:
417:
418:
419:
420:
421:
422:
423:
424:
425:
426:
427:
428:
429:
430:
431:
432:
433:
434:
435:
436:
437:
438:
439:
440:
441:
442:
443:
444:
445:
446:
447:
448:
449:
450:
451:
452:
453:
454:
455:
456:
457:
458:
459:
460:
461:
462:
463:
464:
465:
466:
467:
468:
469:
470:
471:
472:
473:
474:
475:
476:
477:
478:
479:
480:
481:
482:
483:
484:
485:
486:
487:
488:
489:
490:
491:
492:
493:
494:
495:
496:
497:
498:
499:
500:
501:
502:
503:
504:
505:
506:
507:
508:
509:
510:
511:
512:
513:
514:
515:
516:
517:
518:
519:
520:
521:
522:
523:
524:
525:
526:
527:
528:
529:
530:
531:
532:
533:
534:
535:
536:
537:
538:
539:
540:
541:
542:
543:
544:
545:
546:
547:
548:
549:
550:
551:
552:
553:
554:
555:
556:
557:
558:
559:
560:
561:
562:
563:
564:
565:
566:
567:
568:
569:
570:
571:
572:
573:
574:
575:
576:
577:
578:
579:
580:
581:
582:
583:
584:
585:
586:
587:
588:
589:
590:
591:
592:
593:
594:
595:
596:
597:
598:
599:
600:
601:
602:
603:
604:
605:
606:
607:
608:
609:
610:
611:
612:
613:
614:
615:
616:
617:
618:
619:
620:
621:
622:
623:
624:
625:
626:
627:
628:
629:
630:
631:
632:
633:
634:
635:
636:
637:
638:
639:
640:
641:
642:
643:
644:
645:
646:
647:
648:
649:
650:
651:
652:
653:
654:
655:
656:
657:
658:
659:
660:
661:
662:
663:
664:
665:
666:
667:
668:
669:
670:
671:
672:
673:
674:
675:
676:
677:
678:
679:
680:
681:
682:
683:
684:
685:
686:
687:
688:
689:
690:
691:
692:
693:
694:
695:
696:
697:
698:
699:
700:
701:
702:
703:
704:
705:
706:
707:
708:
709:
710:
711:
712:
713:
714:
715:
716:
717:
718:
719:
720:
721:
722:
723:
724:
725:
726:
727:
728:
729:
730:
731:
732:
733:
734:
735:
736:
737:
738:
739:
740:
741:
742:
743:
744:
745:
746:
747:
748:
749:
750:
751:
752:
753:
754:
755:
756:
757:
758:
759:
760:
761:
762:
763:
764:
765:
766:
767:
768:
769:
770:
771:
772:
773:
774:
775:
776:
777:
778:
779:
780:
781:
782:
783:
784:
785:
786:
787:
788:
789:
790:
791:
792:
793:
794:
795:
796:
797:
798:
799:
800:
801:
802:
803:
804:
805:
806:
807:
808:
809:
810:
811:
812:
813:
814:
815:
816:
817:
818:
819:
820:
821:
822:
823:
824:
825:
826:
827:
828:
829:
830:
831:
832:
833:
834:
835:
836:
837:
838:
839:
840:
841:
842:
843:
844:
845:
846:
847:
848:
849:
850:
851:
852:
853:
854:
855:
856:
857:
858:
859:
860:
861:
862:
863:
864:
865:
866:
867:
868:
869:
870:
871:
872:
873:
874:
875:
876:
877:
878:
879:
880:
881:
882:
883:
884:
885:
886:
887:
888:
889:
890:
891:
892:
893:
894:
895:
896:
897:
898:
899:
900:
901:
902:
903:
904:
905:
906:
907:
908:
909:
910:
911:
912:
913:
914:
915:
916:
917:
918:
919:
920:
921:
922:
923:
924:
925:
926:
927:
928:
929:
930:
931:
932:
933:
934:
935:
936:
937:
938:
939:
940:
941:
942:
943:
944:
945:
946:
947:
948:
949:
950:
951:
952:
953:
954:
955:
956:
957:
958:
959:
960:
961:
962:
963:
964:
965:
966:
967:
968:
969:
970:
971:
972:
973:
974:
975:
976:
977:
978:
979:
980:
981:
982:
983:
984:
985:
986:
987:
988:
989:
990:
991:
992:
993:
994:
995:
996:
997:
998:
999:
1000:
1001:
1002:
1003:
1004:
1005:
1006:
1007:
1008:
1009:
1010:
1011:
1012:
1013:
1014:
1015:
1016:
1017:
1018:
1019:
1020:
1021:
1022:
1023:
1024:
1025:
1026:
1027:
1028:
1029:
1030:
1031:
1032:
1033:
1034:
1035:
1036:
1037:
1038:
1039:
1040:
1041:
1042:
1043:
1044:
1045:
1046:
1047:
1048:
1049:
1050:
1051:
1052:
1053:
1054:
1055:
1056:
1057:
1058:
1059:
1060:
1061:
1062:
1063:
1064:
1065:
1066:
1067:
1068:
1069:
1070:
1071:
1072:
1073:
1074:
1075:
1076:
1077:
1078:
1079:
1080:
1081:
1082:
1083:
1084:
1085:
1086:
1087:
1088:
1089:
1090:
1091:
1092:
1093:
1094:
1095:
1096:
1097:
1098:
1099:
1100:
1101:
1102:
1103:
1104:
1105:
1106:
1107:
1108:
1109:
1110:
1111:
1112:
1113:
1114:
1115:
1116:
1117:
1118:
1119:
1120:
1121:
1122:
1123:
1124:
1125:
1126:
1127:
1128:
1129:
1130:
1131:
1132:
1133:
1134:
1135:
1136:
1137:
1138:
1139:
1140:
1141:
1142:
1143:
1144:
1145:
1146:
1147:
1148:
1149:
1150:
1151:
1152:
1153:
1154:
1155:
1156:
1157:
1158:
1159:
1160:
1161:
1162:
1163:
1164:
1165:
1166:
1167:
1168:
1169:
1170:
1171:
1172:
1173:
1174:
1175:
1176:
1177:
1178:
1179:
1180:
1181:
1182:
1183:
1184:
1185:
1186:
1187:
1188:
1189:
1190:
1191:
1192:
1193:
1194:
1195:
1196:
1197:
1198:
1199:
1200:
1201:
1202:
1203:
1204:
1205:
1206:
1207:
1208:
1209:
1210:
1211:
1212:
1213:
1214:
1215:
1216:
1217:
1218:
1219:
1220:
1221:
1222:
1223:
1224:
1225:
1226:
1227:
1228:
1229:
1230:
1231:
1232:
1233:
1234:
1235:
1236:
1237:
1238:
1239:
1240:
1241:
1242:
1243:
1244:
1245:
1246:
1247:
1248:
1249:
1250:
1251:
1252:
1253:
1254:
1255:
1256:
1257:
1258:
1259:
1260:
1261:
1262:
1263:
1264:
1265:
1266:
1267:
1268:
1269:
1270:
1271:
1272:
1273:
1274:
1275:
1276:
1277:
1278:
1279:
1280:
1281:
1282:
1283:
1284:
1285:
1286:
1287:
1288:
1289:
1290:
1291:
1292:
1293:
1294:
1295:
1296:
1297:
1298:
1299:
1300:
1301:
1302:
1303:
1304:
1305:
1306:
1307:
1308:
1309:
1310:
1311:
1312:
1313:
1314:
1315:
1316:
1317:
1318:
1319:
1320:
1321:
1322:
1323:
1324:
1325:
1326:
1327:
1328:
1329:
1330:
1331:
1332:
1333:
1334:
1335:
1336:
1337:
1338:
1339:
1340:
1341:
1342:
1343:
1344:
1345:
1346:
1347:
1348:
1349:
1350:
1351:
1352:
1353:
1354:
1355:
1356:
1357:
1358:
1359:
1360:
1361:
1362:
1363:
1364:
1365:
1366:
1367:
1368:
1369:
1370:
1371:
1372:
1373:
1374:
1375:
1376:
1377:
1378:
1379:
1380:
1381:
1382:
1383:
1384:
1385:
1386:
1387:
1388:
1389:
1390:
1391:
1392:
1393:
1394:
1395:
1396:
1397:
1398:
1399:
1400:
1401:
1402:
1403:
1404:
1405:
1406:
1407:
1408:
1409:
1410:
1411:
1412:
1413:
1414:
1415:
1416:
1417:
1418:
1419:
1420:
1421:
1422:
1423:
1424:
1425:
1426:
1427:
1428:
1429:
1430:
1431:
1432:
1433:
1434:
1435:
1436:
1437:
1438:
1439:
1440:
1441:
1442:
1443:
1444:
1445:
1446:
1447:
1448:
1449:
1450:
1451:
1452:
1453:
1454:
1455:
1456:
1457:
1458:
1459:
1460:
1461:
1462:
1463:
1464:
1465:
1466:
1467:
1468:
1469:
1470:
1471:
1472:
1473:
1474:
1475:
1476:
1477:
1478:
1479:
1480:
1481:
1482:
1483:
1484:
1485:
1486:
1487:
1488:
1489:
1490:
1491:
1492:
1493:
1494:
1495:
1496:
1497:
1498:
1499:
1500:
1501:
1502:
1503:
1504:
1505:
1506:
1507:
1508:
1509:
1510:
1511:
1512:
1513:
1514:
1515:
1516:
1517:
1518:
1519:
1520:
1521:
1522:
1523:
1524:
1525:
1526:
1527:
1528:
1529:
1530:
1531:
1532:
1533:
1534:
1535:
1536:
1537:
1538:
1539:
1540:
1541:
1542:
1543:
1544:
1545:
1546:
1547:
1548:
1549:
1550:
1551:
1552:
1553:
1554:
1555:
1556:
1557:
1558:
1559:
1560:
1561:
1562:
1563:
1564:
1565:
1566:
1567:
1568:
1569:
1570:
1571:
1572:
1573:
1574:
1575:
1576:
1577:
1578:
1579:
1580:
1581:
1582:
1583:
1584:
1585:
1586:
1587:
1588:
1589:
1590:
1591:
1592:
1593:
1594:
1595:
1596:
1597:
1598:
1599:
1600:
1601:
1602:
1603:
1604:
1605:
1606:
1607:
1608:
1609:
1610:
1611:
1612:
1613:
1614:
1615:
1616:
1617:
1618:
1619:
1620:
1621:
1622:
1623:
1624:
1625:
1626:
1627:
1628:
1629:
1630:
1631:
1632:
1633:
1634:
1635:
1636:
|
-- Status:0:0::usr_web6_1:php:1.21
-- Dump by MySQLDumper 1.21 (http://www.mysqldumper.de/board/)
-- Dump created on 2006-02-27 18:01
-- This file only contains the structure of the database without data \n\n
--
-- Create Table `bb1_access`
--
DROP TABLE IF EXISTS `bb1_access`;
CREATE TABLE `bb1_access` (
`boardid` int(11) unsigned NOT NULL default '0',
`userid` int(11) unsigned NOT NULL default '0',
`can_view_board` tinyint(1) NOT NULL default '-1',
`can_enter_board` tinyint(1) NOT NULL default '-1',
`can_read_thread` tinyint(1) NOT NULL default '-1',
`can_start_topic` tinyint(1) NOT NULL default '-1',
`can_reply_topic` tinyint(1) NOT NULL default '-1',
`can_post_poll` tinyint(1) NOT NULL default '-1',
`can_upload_attachments` tinyint(1) NOT NULL default '-1',
`can_download_attachments` tinyint(1) NOT NULL default '-1',
`can_post_without_moderation` tinyint(1) NOT NULL default '-1',
`can_close_own_topic` tinyint(1) NOT NULL default '-1',
`can_use_search` tinyint(1) NOT NULL default '-1',
`can_vote_poll` tinyint(1) NOT NULL default '-1',
`can_rate_thread` tinyint(1) NOT NULL default '-1',
`can_del_own_post` tinyint(1) NOT NULL default '-1',
`can_edit_own_post` tinyint(1) NOT NULL default '-1',
`can_del_own_topic` tinyint(1) NOT NULL default '-1',
`can_edit_own_topic` tinyint(1) NOT NULL default '-1',
`can_move_own_topic` tinyint(1) NOT NULL default '-1',
`can_use_post_html` tinyint(1) NOT NULL default '-1',
`can_use_post_bbcode` tinyint(1) NOT NULL default '-1',
`can_use_post_smilies` tinyint(1) NOT NULL default '-1',
`can_use_post_icons` tinyint(1) NOT NULL default '-1',
`can_use_post_images` tinyint(1) NOT NULL default '-1',
PRIMARY KEY (`userid`,`boardid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_acpmenuitemgroups`
--
DROP TABLE IF EXISTS `bb1_acpmenuitemgroups`;
CREATE TABLE `bb1_acpmenuitemgroups` (
`itemgroupid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`condition` text NOT NULL,
`conditiontype` enum('OR','AND') NOT NULL default 'OR',
`showorder` smallint(5) unsigned NOT NULL default '0',
`acpmode` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`itemgroupid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_acpmenuitemgroupscount`
--
DROP TABLE IF EXISTS `bb1_acpmenuitemgroupscount`;
CREATE TABLE `bb1_acpmenuitemgroupscount` (
`userid` int(11) unsigned NOT NULL default '0',
`itemgroupid` smallint(5) unsigned NOT NULL default '0',
`count` int(11) unsigned NOT NULL default '0',
`lastaccesstime` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`itemgroupid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_acpmenuitems`
--
DROP TABLE IF EXISTS `bb1_acpmenuitems`;
CREATE TABLE `bb1_acpmenuitems` (
`itemid` smallint(5) unsigned NOT NULL auto_increment,
`itemgroupid` smallint(5) unsigned NOT NULL default '0',
`link` varchar(255) NOT NULL default '',
`languageitem` varchar(255) NOT NULL default '',
`linkformat` varchar(20) NOT NULL default '',
`condition` varchar(255) NOT NULL default '',
`conditiontype` enum('OR','AND') NOT NULL default 'OR',
`showorder` smallint(5) unsigned NOT NULL default '0',
`acpmode` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`itemid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_acpmenuitemscount`
--
DROP TABLE IF EXISTS `bb1_acpmenuitemscount`;
CREATE TABLE `bb1_acpmenuitemscount` (
`userid` int(11) unsigned NOT NULL default '0',
`itemid` smallint(5) unsigned NOT NULL default '0',
`count` int(11) unsigned NOT NULL default '0',
`lastaccesstime` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`itemid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_adminsessions`
--
DROP TABLE IF EXISTS `bb1_adminsessions`;
CREATE TABLE `bb1_adminsessions` (
`sessionhash` varchar(32) NOT NULL default '',
`userid` int(11) unsigned NOT NULL default '0',
`ipaddress` varchar(16) NOT NULL default '',
`useragent` varchar(100) NOT NULL default '',
`starttime` int(11) unsigned NOT NULL default '0',
`lastactivity` int(11) unsigned NOT NULL default '0',
`authentificationcode` varchar(32) NOT NULL default '',
PRIMARY KEY (`sessionhash`)
) TYPE=MyISAM;
--
-- Create Table `bb1_announcements`
--
DROP TABLE IF EXISTS `bb1_announcements`;
CREATE TABLE `bb1_announcements` (
`boardid` int(11) NOT NULL default '0',
`threadid` int(11) NOT NULL default '0',
PRIMARY KEY (`boardid`,`threadid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_applications`
--
DROP TABLE IF EXISTS `bb1_applications`;
CREATE TABLE `bb1_applications` (
`applicationid` int(11) unsigned NOT NULL auto_increment,
`userid` int(11) unsigned NOT NULL default '0',
`groupid` int(11) unsigned NOT NULL default '0',
`sendtime` int(11) unsigned NOT NULL default '0',
`reason` text NOT NULL,
`reply` text NOT NULL,
`status` tinyint(1) NOT NULL default '0',
`groupleaderid` int(11) unsigned NOT NULL default '0',
`notifyperemail` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`applicationid`),
UNIQUE KEY `userid` (`userid`,`groupid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_attachments`
--
DROP TABLE IF EXISTS `bb1_attachments`;
CREATE TABLE `bb1_attachments` (
`attachmentid` int(11) unsigned NOT NULL auto_increment,
`postid` int(11) unsigned NOT NULL default '0',
`privatemessageid` int(11) unsigned NOT NULL default '0',
`userid` int(11) unsigned NOT NULL default '0',
`attachmentname` varchar(250) NOT NULL default '',
`attachmentextension` varchar(7) NOT NULL default '',
`attachmentsize` int(11) unsigned NOT NULL default '0',
`thumbnailextension` varchar(7) NOT NULL default '',
`thumbnailsize` int(11) unsigned NOT NULL default '0',
`counter` int(11) unsigned NOT NULL default '0',
`idhash` varchar(32) NOT NULL default '',
`uploadtime` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`attachmentid`),
KEY `postid` (`postid`),
KEY `privatemessageid` (`privatemessageid`),
KEY `userid` (`userid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_avatars`
--
DROP TABLE IF EXISTS `bb1_avatars`;
CREATE TABLE `bb1_avatars` (
`avatarid` int(11) unsigned NOT NULL auto_increment,
`avatarname` varchar(250) NOT NULL default '',
`avatarextension` varchar(7) NOT NULL default '',
`width` smallint(5) unsigned NOT NULL default '0',
`height` smallint(5) unsigned NOT NULL default '0',
`groupid` int(11) unsigned NOT NULL default '0',
`needposts` mediumint(7) unsigned NOT NULL default '0',
`userid` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`avatarid`),
KEY `userid` (`userid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_bbcodes`
--
DROP TABLE IF EXISTS `bb1_bbcodes`;
CREATE TABLE `bb1_bbcodes` (
`bbcodeid` int(11) unsigned NOT NULL auto_increment,
`bbcodetag` varchar(250) NOT NULL default '',
`bbcodereplacement` text NOT NULL,
`bbcodeexample` varchar(250) NOT NULL default '',
`bbcodeexplanation` text NOT NULL,
`params` tinyint(1) unsigned NOT NULL default '1',
`multiuse` tinyint(3) unsigned NOT NULL default '1',
`pattern1` varchar(100) NOT NULL default '',
`pattern2` varchar(100) NOT NULL default '',
`pattern3` varchar(100) NOT NULL default '',
`eval_replacement` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`bbcodeid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_bc_bann`
--
DROP TABLE IF EXISTS `bb1_bc_bann`;
CREATE TABLE `bb1_bc_bann` (
`userid` int(11) NOT NULL default '0',
`zeit_bis` int(11) NOT NULL default '0',
`von_userid` int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Create Table `bb1_bc_config`
--
DROP TABLE IF EXISTS `bb1_bc_config`;
CREATE TABLE `bb1_bc_config` (
`id` int(11) unsigned NOT NULL auto_increment,
`class_text` varchar(10) NOT NULL default '',
`class_online` varchar(10) NOT NULL default '',
`class_eingabe` varchar(10) NOT NULL default '',
`stream` int(1) NOT NULL default '0',
`stream_refresh` int(3) NOT NULL default '0',
`reload_chat` int(11) NOT NULL default '0',
`chat_an_aus` int(1) NOT NULL default '0',
`reload_online` int(11) NOT NULL default '0',
`user_reset` int(4) NOT NULL default '0',
`limit_zeilen` int(11) NOT NULL default '0',
`zeit_anzeige` int(1) NOT NULL default '0',
`logs` int(3) NOT NULL default '0',
`logs2` int(1) NOT NULL default '3',
`flood` int(2) NOT NULL default '0',
`raumthema` int(1) NOT NULL default '0',
`first_room_name` varchar(50) NOT NULL default '',
`first_room_thema` varchar(255) NOT NULL default '',
`online_host` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
--
-- Create Table `bb1_bc_gag`
--
DROP TABLE IF EXISTS `bb1_bc_gag`;
CREATE TABLE `bb1_bc_gag` (
`userid` int(11) NOT NULL default '0',
`gag_time` int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Create Table `bb1_bc_gag_raum`
--
DROP TABLE IF EXISTS `bb1_bc_gag_raum`;
CREATE TABLE `bb1_bc_gag_raum` (
`userid` int(11) NOT NULL default '0',
`gag_raum` int(11) NOT NULL default '0',
`gag_raum_time` int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Create Table `bb1_bc_raum`
--
DROP TABLE IF EXISTS `bb1_bc_raum`;
CREATE TABLE `bb1_bc_raum` (
`raumid` int(11) unsigned NOT NULL auto_increment,
`raumname` varchar(50) NOT NULL default '',
`raum_fest` int(1) NOT NULL default '0',
`darf_rein` varchar(50) NOT NULL default '',
`thema` varchar(255) NOT NULL default '',
`erstellt_von` int(11) NOT NULL default '0',
`geschlossen` int(1) NOT NULL default '0',
`sort` int(5) NOT NULL default '2',
PRIMARY KEY (`raumid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_bc_raum_ban`
--
DROP TABLE IF EXISTS `bb1_bc_raum_ban`;
CREATE TABLE `bb1_bc_raum_ban` (
`userid` int(11) NOT NULL default '0',
`zeit_bis` int(11) NOT NULL default '0',
`raum` int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Create Table `bb1_bc_text`
--
DROP TABLE IF EXISTS `bb1_bc_text`;
CREATE TABLE `bb1_bc_text` (
`msgid` int(11) unsigned NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`msg` text NOT NULL,
`zeit` int(11) NOT NULL default '0',
`an_user` int(11) NOT NULL default '0',
`raum` int(11) NOT NULL default '0',
`farbe` varchar(7) NOT NULL default '',
PRIMARY KEY (`msgid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_bc_useronline`
--
DROP TABLE IF EXISTS `bb1_bc_useronline`;
CREATE TABLE `bb1_bc_useronline` (
`userid` int(11) NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`erst_zeit` int(11) NOT NULL default '0',
`aktuel_zeit` int(11) NOT NULL default '0',
`raum` int(11) NOT NULL default '0',
`away` int(1) NOT NULL default '0',
`bould` int(1) NOT NULL default '0',
`kursiv` int(1) NOT NULL default '0',
`unterstrich` int(1) NOT NULL default '0',
`ignorlist` varchar(50) NOT NULL default '0',
`darf_ignoriert_werden` int(1) NOT NULL default '1',
`farbe` varchar(7) NOT NULL default '',
`no_ban_gag` int(1) NOT NULL default '1',
`kick` int(1) NOT NULL default '0',
`no_kick` int(1) NOT NULL default '0',
`format` varchar(255) NOT NULL default '',
`smilie` int(1) NOT NULL default '1'
) TYPE=MyISAM;
--
-- Create Table `bb1_boards`
--
DROP TABLE IF EXISTS `bb1_boards`;
CREATE TABLE `bb1_boards` (
`boardid` int(11) unsigned NOT NULL auto_increment,
`styleid` int(11) unsigned NOT NULL default '0',
`parentid` int(11) unsigned NOT NULL default '0',
`parentlist` text NOT NULL,
`childlist` text NOT NULL,
`boardorder` mediumint(7) unsigned NOT NULL default '1',
`title` varchar(250) NOT NULL default '',
`password` varchar(25) NOT NULL default '',
`description` text NOT NULL,
`prefixuse` tinyint(1) NOT NULL default '0',
`prefixrequired` tinyint(1) NOT NULL default '0',
`prefix` text NOT NULL,
`threadtemplateuse` tinyint(1) NOT NULL default '0',
`threadtemplate` text NOT NULL,
`posttemplateuse` tinyint(1) NOT NULL default '0',
`posttemplate` text NOT NULL,
`threadcount` int(11) unsigned NOT NULL default '0',
`postcount` int(11) unsigned NOT NULL default '0',
`lastthreadid` int(11) unsigned NOT NULL default '0',
`lastposttime` int(11) unsigned NOT NULL default '0',
`lastposterid` int(11) unsigned NOT NULL default '0',
`lastposter` varchar(50) NOT NULL default '0',
`allowratings` tinyint(1) NOT NULL default '1',
`daysprune` smallint(5) unsigned NOT NULL default '0',
`sortfield` varchar(20) NOT NULL default '',
`sortorder` varchar(5) NOT NULL default '',
`threadsperpage` smallint(5) unsigned NOT NULL default '0',
`postsperpage` smallint(5) unsigned NOT NULL default '0',
`postorder` tinyint(1) NOT NULL default '0',
`countuserposts` tinyint(1) NOT NULL default '1',
`hotthread_reply` smallint(5) unsigned NOT NULL default '0',
`hotthread_view` smallint(5) unsigned NOT NULL default '0',
`moderatenew` tinyint(2) NOT NULL default '0',
`enforcestyle` tinyint(1) NOT NULL default '0',
`closed` tinyint(1) NOT NULL default '0',
`isboard` tinyint(1) NOT NULL default '0',
`invisible` tinyint(1) NOT NULL default '0',
`showinarchive` tinyint(1) NOT NULL default '1',
`externalurl` varchar(255) NOT NULL default '',
PRIMARY KEY (`boardid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_boardvisit`
--
DROP TABLE IF EXISTS `bb1_boardvisit`;
CREATE TABLE `bb1_boardvisit` (
`boardid` int(11) unsigned NOT NULL default '0',
`userid` int(11) unsigned NOT NULL default '0',
`lastvisit` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`boardid`,`userid`),
KEY `userid` (`userid`,`lastvisit`)
) TYPE=MyISAM;
--
-- Create Table `bb1_club_locator`
--
DROP TABLE IF EXISTS `bb1_club_locator`;
CREATE TABLE `bb1_club_locator` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`x` int(11) NOT NULL default '0',
`y` int(11) NOT NULL default '0',
`location` varchar(255) NOT NULL default '',
`postal` varchar(5) NOT NULL default '',
`beschreibung` text NOT NULL,
`url` text NOT NULL,
`kurz` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
--
-- Create Table `bb1_counter`
--
DROP TABLE IF EXISTS `bb1_counter`;
CREATE TABLE `bb1_counter` (
`id` int(11) NOT NULL auto_increment,
`datum` varchar(14) NOT NULL default '',
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
--
-- Create Table `bb1_designelements`
--
DROP TABLE IF EXISTS `bb1_designelements`;
CREATE TABLE `bb1_designelements` (
`elementid` int(11) unsigned NOT NULL auto_increment,
`designpackid` int(11) unsigned NOT NULL default '0',
`element` varchar(250) NOT NULL default '',
`value` text NOT NULL,
PRIMARY KEY (`elementid`),
UNIQUE KEY `subvariablepackid` (`designpackid`,`element`)
) TYPE=MyISAM;
--
-- Create Table `bb1_designpacks`
--
DROP TABLE IF EXISTS `bb1_designpacks`;
CREATE TABLE `bb1_designpacks` (
`designpackid` int(11) unsigned NOT NULL auto_increment,
`designpackname` varchar(100) NOT NULL default '',
PRIMARY KEY (`designpackid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_events`
--
DROP TABLE IF EXISTS `bb1_events`;
CREATE TABLE `bb1_events` (
`eventid` int(11) unsigned NOT NULL auto_increment,
`userid` int(11) unsigned NOT NULL default '0',
`groupid` int(11) unsigned NOT NULL default '0',
`subject` varchar(250) NOT NULL default '',
`event` mediumtext NOT NULL,
`eventdate` date NOT NULL default '0000-00-00',
`public` tinyint(1) NOT NULL default '0',
`allowsmilies` tinyint(1) NOT NULL default '1',
`allowhtml` tinyint(1) NOT NULL default '0',
`allowbbcode` tinyint(1) NOT NULL default '1',
`allowimages` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`eventid`),
KEY `groupid` (`groupid`),
KEY `userid` (`userid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_folders`
--
DROP TABLE IF EXISTS `bb1_folders`;
CREATE TABLE `bb1_folders` (
`folderid` int(11) unsigned NOT NULL auto_increment,
`userid` int(11) unsigned NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
PRIMARY KEY (`folderid`),
KEY `userid` (`userid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_groupcombinations`
--
DROP TABLE IF EXISTS `bb1_groupcombinations`;
CREATE TABLE `bb1_groupcombinations` (
`groupcombinationid` int(11) unsigned NOT NULL auto_increment,
`groupids` text NOT NULL,
`data` longtext NOT NULL,
PRIMARY KEY (`groupcombinationid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_groupleaders`
--
DROP TABLE IF EXISTS `bb1_groupleaders`;
CREATE TABLE `bb1_groupleaders` (
`userid` int(11) unsigned NOT NULL default '0',
`groupid` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`groupid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_groups`
--
DROP TABLE IF EXISTS `bb1_groups`;
CREATE TABLE `bb1_groups` (
`groupid` int(11) unsigned NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`grouptype` tinyint(1) NOT NULL default '0',
`useronlinemarking` varchar(255) NOT NULL default '%s',
`priority` tinyint(1) NOT NULL default '0',
`securitylevel` smallint(5) unsigned NOT NULL default '0',
`ai_posts` smallint(5) NOT NULL default '-1',
`ai_days` smallint(5) NOT NULL default '-1',
`showonteam` tinyint(1) NOT NULL default '0',
`showorder` smallint(5) NOT NULL default '0',
`description` text NOT NULL,
PRIMARY KEY (`groupid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_groupvalues`
--
DROP TABLE IF EXISTS `bb1_groupvalues`;
CREATE TABLE `bb1_groupvalues` (
`groupid` int(11) unsigned NOT NULL default '0',
`variableid` int(11) unsigned NOT NULL default '0',
`value` text NOT NULL,
PRIMARY KEY (`groupid`,`variableid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_groupvariablegroups`
--
DROP TABLE IF EXISTS `bb1_groupvariablegroups`;
CREATE TABLE `bb1_groupvariablegroups` (
`variablegroupid` int(11) unsigned NOT NULL auto_increment,
`parentvariablegroupid` int(11) unsigned NOT NULL default '0',
`title` varchar(50) NOT NULL default '',
`showorder` smallint(5) unsigned NOT NULL default '0',
`securitylevel` smallint(5) unsigned NOT NULL default '0',
`acpmode` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`variablegroupid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_groupvariables`
--
DROP TABLE IF EXISTS `bb1_groupvariables`;
CREATE TABLE `bb1_groupvariables` (
`variableid` int(11) unsigned NOT NULL auto_increment,
`variablename` varchar(50) NOT NULL default '',
`type` varchar(15) NOT NULL default '',
`defaultvalue` text NOT NULL,
`variablegroupid` int(11) unsigned NOT NULL default '0',
`showorder` mediumint(7) unsigned NOT NULL default '0',
`acpmode` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`variableid`),
UNIQUE KEY `variablename` (`variablename`)
) TYPE=MyISAM;
--
-- Create Table `bb1_hm_portal_box2group`
--
DROP TABLE IF EXISTS `bb1_hm_portal_box2group`;
CREATE TABLE `bb1_hm_portal_box2group` (
`boxid` int(11) unsigned NOT NULL default '0',
`groupid` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`boxid`,`groupid`),
UNIQUE KEY `groupid` (`groupid`,`boxid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_hm_portal_boxen`
--
DROP TABLE IF EXISTS `bb1_hm_portal_boxen`;
CREATE TABLE `bb1_hm_portal_boxen` (
`h_activ_admin` tinyint(4) NOT NULL default '1',
`h_boxid` int(4) NOT NULL auto_increment,
`h_boxincl` tinytext NOT NULL,
`h_boxtitel` tinytext NOT NULL,
`h_userbox_spalte` tinytext NOT NULL,
`h_userbox_reihe` int(4) NOT NULL default '0',
`h_boxinhalt` text NOT NULL,
`h_boxeditable` tinyint(4) NOT NULL default '0',
`h_boxdesc` tinytext NOT NULL,
PRIMARY KEY (`h_boxid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_hm_portal_spec`
--
DROP TABLE IF EXISTS `bb1_hm_portal_spec`;
CREATE TABLE `bb1_hm_portal_spec` (
`id` int(11) NOT NULL auto_increment,
`boxlinks` tinyint(4) NOT NULL default '22',
`boxrechts` tinyint(4) NOT NULL default '22',
`boxinnen` tinyint(4) NOT NULL default '56',
`f_injektor` tinyint(4) NOT NULL default '0',
`injektorurl` text NOT NULL,
`injektorheight` smallint(4) NOT NULL default '500',
`f_ank` tinyint(4) NOT NULL default '0',
`f_autopoll` tinyint(4) NOT NULL default '0',
`autopollid` int(4) NOT NULL default '1',
`pev1` tinyint(4) NOT NULL default '0',
`pev2` tinyint(4) NOT NULL default '0',
`pev3` tinyint(4) NOT NULL default '0',
`newsboardid` int(11) NOT NULL default '1',
`a_newsboard` tinyint(4) NOT NULL default '1',
`a_lt` tinyint(4) NOT NULL default '0',
`a_alt` tinyint(4) NOT NULL default '0',
`a_tt` tinyint(4) NOT NULL default '10',
`ttdays` mediumint(11) NOT NULL default '3',
`a_wwd` tinyint(4) NOT NULL default '10',
`excllist` text NOT NULL,
`pollid` mediumint(8) NOT NULL default '1',
`f_boxtail` tinyint(4) NOT NULL default '1',
`f_gzipoff` tinyint(4) NOT NULL default '0',
`version` text NOT NULL,
`a_nb1` tinyint(4) NOT NULL default '5',
`a_nb2` tinyint(4) NOT NULL default '5',
`a_nb3` tinyint(4) NOT NULL default '1',
`a_nb4` tinyint(4) NOT NULL default '1',
`a_nb5` tinyint(4) NOT NULL default '1',
`a_nb6` tinyint(4) NOT NULL default '5',
`a_nb7` tinyint(4) NOT NULL default '5',
`a_blt` tinyint(4) NOT NULL default '5',
`boardlist` tinytext NOT NULL,
`a_bbb` tinyint(4) NOT NULL default '5',
`bbooklink` tinytext NOT NULL,
`a_auc` tinyint(4) NOT NULL default '3',
`clip_news` int(8) NOT NULL default '300',
`clip_alt` int(8) NOT NULL default '200',
`a_database` tinyint(4) NOT NULL default '5',
`clip_menu` tinyint(4) NOT NULL default '30',
`a_newusers` tinyint(4) NOT NULL default '5',
`a_topposters` tinyint(4) NOT NULL default '10',
`bbookprefix` varchar(20) NOT NULL default '',
`f_showimg` tinyint(4) NOT NULL default '1',
`nb1url` text NOT NULL,
`nb2url` text NOT NULL,
`ankid` int(11) NOT NULL default '0',
`menudepth` tinyint(4) NOT NULL default '5',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
--
-- Create Table `bb1_hm_portal_user`
--
DROP TABLE IF EXISTS `bb1_hm_portal_user`;
CREATE TABLE `bb1_hm_portal_user` (
`h_userid` int(4) NOT NULL default '0',
`h_activ` tinyint(4) NOT NULL default '1',
`h_boxid` int(4) NOT NULL default '0',
KEY `h_userid` (`h_userid`),
KEY `h_boxid` (`h_boxid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_icons`
--
DROP TABLE IF EXISTS `bb1_icons`;
CREATE TABLE `bb1_icons` (
`iconid` int(11) unsigned NOT NULL auto_increment,
`iconpath` varchar(250) NOT NULL default '',
`icontitle` varchar(250) NOT NULL default '',
`iconorder` mediumint(7) unsigned NOT NULL default '0',
PRIMARY KEY (`iconid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_info_db_data`
--
DROP TABLE IF EXISTS `bb1_info_db_data`;
CREATE TABLE `bb1_info_db_data` (
`db_d_id` int(11) NOT NULL auto_increment,
`db_data_id` int(11) NOT NULL default '0',
`db_data_subkatid` tinyint(4) NOT NULL default '0',
`db_data_name` text NOT NULL,
`db_data_desc` text NOT NULL,
`db_data_nr` text NOT NULL,
`db_data_ext` tinyint(4) NOT NULL default '0',
`db_data_path` text NOT NULL,
`db_data_kb` int(11) NOT NULL default '0',
`db_data_downs` int(11) NOT NULL default '0',
`db_uploader` tinytext NOT NULL,
`db_uploaderid` int(11) NOT NULL default '0',
`db_update` int(11) NOT NULL default '0',
`db_proof_ok` tinyint(4) NOT NULL default '1',
`db_dtime` int(11) NOT NULL default '0',
`db_ntime` int(11) NOT NULL default '0',
`db_danz` int(11) NOT NULL default '0',
`db_dist` int(11) NOT NULL default '0',
KEY `db_d_id` (`db_d_id`)
) TYPE=MyISAM;
--
-- Create Table `bb1_info_db_id`
--
DROP TABLE IF EXISTS `bb1_info_db_id`;
CREATE TABLE `bb1_info_db_id` (
`db_id` int(11) NOT NULL auto_increment,
`db_katid` tinyint(4) NOT NULL default '0',
`db_sub_katid` tinyint(4) NOT NULL default '0',
`db_parent_id` tinyint(4) NOT NULL default '0',
`db_order` tinyint(4) NOT NULL default '0',
`db_katname` text NOT NULL,
`db_subkatname` text NOT NULL,
`db_desc` text NOT NULL,
`db_count` int(11) NOT NULL default '0',
`db_up_date` int(11) NOT NULL default '0',
`db_maxup` int(11) NOT NULL default '250',
`db_whocan` text NOT NULL,
`db_whoedit` text NOT NULL,
`db_whodown` text NOT NULL,
`db_wholink` text NOT NULL,
`db_proof` tinyint(4) NOT NULL default '1',
`db_end` text NOT NULL,
`db_dend` text NOT NULL,
`db_dtime` int(11) NOT NULL default '0',
`db_ntime` int(11) NOT NULL default '0',
`db_danz` int(11) NOT NULL default '0',
`db_dist` int(11) NOT NULL default '0',
`db_erlgrp` text NOT NULL,
`db_erlt` tinyint(1) NOT NULL default '0',
KEY `db_id` (`db_id`)
) TYPE=MyISAM;
--
-- Create Table `bb1_languagecats`
--
DROP TABLE IF EXISTS `bb1_languagecats`;
CREATE TABLE `bb1_languagecats` (
`catid` int(11) NOT NULL auto_increment,
`catname` varchar(100) NOT NULL default '',
PRIMARY KEY (`catid`),
UNIQUE KEY `catname` (`catname`)
) TYPE=MyISAM;
--
-- Create Table `bb1_languagepacks`
--
DROP TABLE IF EXISTS `bb1_languagepacks`;
CREATE TABLE `bb1_languagepacks` (
`languagepackid` smallint(5) NOT NULL default '0',
`languagepackname` varchar(100) NOT NULL default '',
`languagecode` varchar(10) NOT NULL default '',
PRIMARY KEY (`languagepackid`),
KEY `languagecode` (`languagecode`)
) TYPE=MyISAM;
--
-- Create Table `bb1_languages`
--
DROP TABLE IF EXISTS `bb1_languages`;
CREATE TABLE `bb1_languages` (
`itemid` int(11) NOT NULL auto_increment,
`itemname` varchar(100) NOT NULL default '',
`languagepackid` smallint(5) NOT NULL default '0',
`catid` int(11) NOT NULL default '0',
`item` mediumtext NOT NULL,
`showorder` mediumint(7) unsigned NOT NULL default '0',
PRIMARY KEY (`itemid`),
UNIQUE KEY `languagepackid` (`languagepackid`,`itemname`),
KEY `languagepackid_2` (`languagepackid`,`catid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_mailqueue`
--
DROP TABLE IF EXISTS `bb1_mailqueue`;
CREATE TABLE `bb1_mailqueue` (
`mailid` int(11) unsigned NOT NULL default '0',
`userid` int(11) unsigned NOT NULL default '0',
`email` varchar(150) NOT NULL default '',
`username` varchar(50) NOT NULL default '',
PRIMARY KEY (`mailid`,`userid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_mails`
--
DROP TABLE IF EXISTS `bb1_mails`;
CREATE TABLE `bb1_mails` (
`mailid` int(11) unsigned NOT NULL auto_increment,
`subject` varchar(50) NOT NULL default '',
`message` mediumtext NOT NULL,
`sender` varchar(50) NOT NULL default '',
`otherheaders` varchar(255) NOT NULL default '',
`userid` int(11) unsigned NOT NULL default '0',
`sendtime` int(11) unsigned NOT NULL default '0',
`recipients` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`mailid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_moderators`
--
DROP TABLE IF EXISTS `bb1_moderators`;
CREATE TABLE `bb1_moderators` (
`userid` int(11) unsigned NOT NULL default '0',
`boardid` int(11) unsigned NOT NULL default '0',
`notify_newpost` tinyint(1) NOT NULL default '0',
`notify_newthread` tinyint(1) NOT NULL default '0',
`m_can_thread_close` tinyint(1) NOT NULL default '-1',
`m_can_thread_move` tinyint(1) NOT NULL default '-1',
`m_can_thread_edit` tinyint(1) NOT NULL default '-1',
`m_can_post_del` tinyint(1) NOT NULL default '-1',
`m_can_thread_del` tinyint(1) NOT NULL default '-1',
`m_can_thread_merge` tinyint(1) NOT NULL default '-1',
`m_can_thread_cut` tinyint(1) NOT NULL default '-1',
`m_can_thread_top` tinyint(1) NOT NULL default '-1',
`m_can_add_poll` tinyint(1) NOT NULL default '-1',
`m_can_post_edit` tinyint(1) NOT NULL default '-1',
`m_can_announce` tinyint(1) NOT NULL default '-1',
`m_can_edit_poll` tinyint(1) NOT NULL default '-1',
PRIMARY KEY (`boardid`,`userid`),
KEY `userid` (`userid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_optiongroups`
--
DROP TABLE IF EXISTS `bb1_optiongroups`;
CREATE TABLE `bb1_optiongroups` (
`optiongroupid` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`showorder` mediumint(7) unsigned NOT NULL default '0',
`acpmode` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`optiongroupid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_options`
--
DROP TABLE IF EXISTS `bb1_options`;
CREATE TABLE `bb1_options` (
`optionid` int(11) unsigned NOT NULL auto_increment,
`optiongroupid` int(11) unsigned NOT NULL default '0',
`varname` varchar(250) NOT NULL default '',
`value` text NOT NULL,
`optioncode` text NOT NULL,
`showorder` mediumint(7) unsigned NOT NULL default '0',
`acpmode` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`optionid`),
KEY `optiongroupid` (`optiongroupid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_permissions`
--
DROP TABLE IF EXISTS `bb1_permissions`;
CREATE TABLE `bb1_permissions` (
`boardid` int(11) unsigned NOT NULL default '0',
`groupid` int(11) unsigned NOT NULL default '0',
`can_view_board` tinyint(1) NOT NULL default '-1',
`can_enter_board` tinyint(1) NOT NULL default '-1',
`can_read_thread` tinyint(1) NOT NULL default '-1',
`can_start_topic` tinyint(1) NOT NULL default '-1',
`can_reply_topic` tinyint(1) NOT NULL default '-1',
`can_reply_own_topic` tinyint(1) NOT NULL default '-1',
`can_post_poll` tinyint(1) NOT NULL default '-1',
`can_upload_attachments` tinyint(1) NOT NULL default '-1',
`can_download_attachments` tinyint(1) NOT NULL default '-1',
`can_post_without_moderation` tinyint(1) NOT NULL default '-1',
`can_close_own_topic` tinyint(1) NOT NULL default '-1',
`can_use_search` tinyint(1) NOT NULL default '-1',
`can_vote_poll` tinyint(1) NOT NULL default '-1',
`can_rate_thread` tinyint(1) NOT NULL default '-1',
`can_del_own_post` tinyint(1) NOT NULL default '-1',
`can_edit_own_post` tinyint(1) NOT NULL default '-1',
`can_del_own_topic` tinyint(1) NOT NULL default '-1',
`can_edit_own_topic` tinyint(1) NOT NULL default '-1',
`can_move_own_topic` tinyint(1) NOT NULL default '-1',
`can_use_post_html` tinyint(1) NOT NULL default '-1',
`can_use_post_bbcode` tinyint(1) NOT NULL default '-1',
`can_use_post_smilies` tinyint(1) NOT NULL default '-1',
`can_use_post_icons` tinyint(1) NOT NULL default '-1',
`can_use_post_images` tinyint(1) NOT NULL default '-1',
`can_use_prefix` tinyint(1) NOT NULL default '-1',
PRIMARY KEY (`boardid`,`groupid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_polloptions`
--
DROP TABLE IF EXISTS `bb1_polloptions`;
CREATE TABLE `bb1_polloptions` (
`polloptionid` int(11) unsigned NOT NULL auto_increment,
`pollid` int(11) unsigned NOT NULL default '0',
`polloption` varchar(250) NOT NULL default '',
`votes` mediumint(7) unsigned NOT NULL default '0',
`showorder` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`polloptionid`),
KEY `pollid` (`pollid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_polls`
--
DROP TABLE IF EXISTS `bb1_polls`;
CREATE TABLE `bb1_polls` (
`pollid` int(11) unsigned NOT NULL auto_increment,
`threadid` int(11) unsigned NOT NULL default '0',
`question` varchar(100) NOT NULL default '',
`starttime` int(11) unsigned NOT NULL default '0',
`choicecount` tinyint(3) unsigned NOT NULL default '0',
`timeout` mediumint(7) unsigned NOT NULL default '0',
`idhash` varchar(32) NOT NULL default '',
PRIMARY KEY (`pollid`),
KEY `threadid` (`threadid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_postcache`
--
DROP TABLE IF EXISTS `bb1_postcache`;
CREATE TABLE `bb1_postcache` (
`postid` int(11) unsigned NOT NULL auto_increment,
`threadid` int(11) unsigned NOT NULL default '0',
`cache` mediumtext NOT NULL,
PRIMARY KEY (`postid`),
KEY `threadid` (`threadid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_posts`
--
DROP TABLE IF EXISTS `bb1_posts`;
CREATE TABLE `bb1_posts` (
`postid` int(11) unsigned NOT NULL auto_increment,
`parentpostid` int(11) unsigned NOT NULL default '0',
`threadid` int(11) unsigned NOT NULL default '0',
`userid` int(11) unsigned NOT NULL default '0',
`username` varchar(50) NOT NULL default '0',
`iconid` int(11) unsigned NOT NULL default '0',
`posttopic` varchar(100) NOT NULL default '',
`posttime` int(11) unsigned NOT NULL default '0',
`message` mediumtext NOT NULL,
`attachments` int(11) unsigned NOT NULL default '0',
`edittime` int(11) unsigned NOT NULL default '0',
`editorid` int(11) unsigned NOT NULL default '0',
`editor` varchar(50) NOT NULL default '',
`editcount` mediumint(7) unsigned NOT NULL default '0',
`allowsmilies` tinyint(1) NOT NULL default '1',
`allowhtml` tinyint(1) NOT NULL default '0',
`allowbbcode` tinyint(1) NOT NULL default '1',
`allowimages` tinyint(1) NOT NULL default '1',
`showsignature` tinyint(1) NOT NULL default '0',
`ipaddress` varchar(15) NOT NULL default '',
`visible` tinyint(1) NOT NULL default '0',
`reindex` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`postid`),
KEY `iconid` (`iconid`),
KEY `userid` (`userid`,`visible`),
KEY `attachments` (`attachments`),
KEY `threadid` (`threadid`,`visible`),
KEY `threadid_2` (`threadid`,`userid`),
KEY `parentpostid` (`parentpostid`),
KEY `visible` (`visible`,`posttime`),
KEY `reindex` (`reindex`)
) TYPE=MyISAM;
--
-- Create Table `bb1_privatemessage`
--
DROP TABLE IF EXISTS `bb1_privatemessage`;
CREATE TABLE `bb1_privatemessage` (
`privatemessageid` int(11) unsigned NOT NULL auto_increment,
`senderid` int(11) unsigned NOT NULL default '0',
`recipientlist` mediumtext NOT NULL,
`recipientcount` int(11) unsigned NOT NULL default '0',
`subject` varchar(250) NOT NULL default '',
`message` mediumtext NOT NULL,
`sendtime` int(11) unsigned NOT NULL default '0',
`allowsmilies` tinyint(1) NOT NULL default '1',
`allowhtml` tinyint(1) NOT NULL default '0',
`allowbbcode` tinyint(1) NOT NULL default '1',
`allowimages` tinyint(1) NOT NULL default '1',
`showsignature` tinyint(1) NOT NULL default '0',
`iconid` int(11) unsigned NOT NULL default '0',
`inoutbox` tinyint(1) NOT NULL default '0',
`tracking` tinyint(1) NOT NULL default '0',
`attachments` int(11) unsigned NOT NULL default '0',
`pmhash` varchar(32) NOT NULL default '',
PRIMARY KEY (`privatemessageid`),
KEY `iconid` (`iconid`),
KEY `senderid` (`senderid`,`inoutbox`),
KEY `pmhash` (`pmhash`,`sendtime`)
) TYPE=MyISAM;
--
-- Create Table `bb1_privatemessagereceipts`
--
DROP TABLE IF EXISTS `bb1_privatemessagereceipts`;
CREATE TABLE `bb1_privatemessagereceipts` (
`privatemessageid` int(11) unsigned NOT NULL default '0',
`recipientid` int(11) unsigned NOT NULL default '0',
`recipient` varchar(50) NOT NULL default '',
`blindcopy` tinyint(1) NOT NULL default '0',
`folderid` int(11) unsigned NOT NULL default '0',
`deletepm` tinyint(1) NOT NULL default '0',
`view` int(11) unsigned NOT NULL default '0',
`reply` tinyint(1) NOT NULL default '0',
`forward` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`privatemessageid`,`recipientid`),
KEY `recipientid` (`recipientid`,`deletepm`,`folderid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_profilefields`
--
DROP TABLE IF EXISTS `bb1_profilefields`;
CREATE TABLE `bb1_profilefields` (
`profilefieldid` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`description` text NOT NULL,
`required` tinyint(1) NOT NULL default '0',
`showinthread` tinyint(1) NOT NULL default '0',
`hidden` tinyint(1) NOT NULL default '0',
`fieldtype` varchar(40) NOT NULL default 'text',
`fieldoptions` text NOT NULL,
`maxlength` smallint(5) unsigned NOT NULL default '250',
`fieldsize` tinyint(3) unsigned NOT NULL default '25',
`choicecount` tinyint(1) NOT NULL default '0',
`fieldorder` mediumint(7) unsigned NOT NULL default '0',
PRIMARY KEY (`profilefieldid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_ranks`
--
DROP TABLE IF EXISTS `bb1_ranks`;
CREATE TABLE `bb1_ranks` (
`rankid` int(11) unsigned NOT NULL auto_increment,
`groupid` int(11) unsigned NOT NULL default '1',
`gender` tinyint(1) NOT NULL default '0',
`needposts` mediumint(7) unsigned NOT NULL default '0',
`ranktitle` varchar(70) NOT NULL default '',
`rankimages` text NOT NULL,
PRIMARY KEY (`rankid`),
KEY `groupid` (`groupid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_register_keys`
--
DROP TABLE IF EXISTS `bb1_register_keys`;
CREATE TABLE `bb1_register_keys` (
`key_number` int(11) NOT NULL auto_increment,
`key_string` varchar(6) NOT NULL default '',
`key_date` int(11) NOT NULL default '0',
PRIMARY KEY (`key_number`)
) TYPE=MyISAM;
--
-- Create Table `bb1_searchs`
--
DROP TABLE IF EXISTS `bb1_searchs`;
CREATE TABLE `bb1_searchs` (
`searchid` int(11) unsigned NOT NULL auto_increment,
`searchhash` varchar(32) NOT NULL default '',
`searchstring` varchar(250) NOT NULL default '',
`searchuserid` int(11) unsigned NOT NULL default '0',
`postids` mediumtext NOT NULL,
`showposts` tinyint(1) NOT NULL default '0',
`sortby` varchar(25) NOT NULL default '0',
`sortorder` varchar(4) NOT NULL default '0',
`searchtime` int(11) unsigned NOT NULL default '0',
`userid` int(11) unsigned NOT NULL default '0',
`ipaddress` varchar(16) NOT NULL default '',
PRIMARY KEY (`searchid`),
KEY `searchhash` (`searchhash`)
) TYPE=MyISAM;
--
-- Create Table `bb1_sessions`
--
DROP TABLE IF EXISTS `bb1_sessions`;
CREATE TABLE `bb1_sessions` (
`sessionhash` varchar(32) NOT NULL default '',
`userid` int(11) unsigned NOT NULL default '0',
`ipaddress` varchar(16) NOT NULL default '',
`useragent` varchar(100) NOT NULL default '',
`lastactivity` int(11) unsigned NOT NULL default '0',
`request_uri` varchar(250) NOT NULL default '',
`styleid` int(11) unsigned NOT NULL default '0',
`langid` int(11) NOT NULL default '0',
`boardid` int(11) unsigned NOT NULL default '0',
`threadid` int(11) unsigned NOT NULL default '0',
`authentificationcode` varchar(32) NOT NULL default '',
PRIMARY KEY (`sessionhash`),
KEY `userid` (`userid`),
KEY `boardid` (`boardid`)
) TYPE=HEAP;
--
-- Create Table `bb1_smilies`
--
DROP TABLE IF EXISTS `bb1_smilies`;
CREATE TABLE `bb1_smilies` (
`smilieid` int(11) unsigned NOT NULL auto_increment,
`smiliepath` varchar(250) NOT NULL default '{imagefolder}/',
`smilietitle` varchar(250) NOT NULL default '',
`smiliecode` varchar(250) NOT NULL default '',
`smilieorder` mediumint(7) unsigned NOT NULL default '0',
PRIMARY KEY (`smilieid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_stats`
--
DROP TABLE IF EXISTS `bb1_stats`;
CREATE TABLE `bb1_stats` (
`threadcount` int(11) unsigned NOT NULL default '0',
`postcount` int(11) unsigned NOT NULL default '0',
`usercount` int(11) unsigned NOT NULL default '0',
`lastuserid` int(11) unsigned NOT NULL default '0'
) TYPE=MyISAM;
--
-- Create Table `bb1_styles`
--
DROP TABLE IF EXISTS `bb1_styles`;
CREATE TABLE `bb1_styles` (
`styleid` int(11) unsigned NOT NULL default '0',
`stylename` varchar(100) NOT NULL default '',
`templatepackid` int(11) unsigned NOT NULL default '0',
`designpackid` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`styleid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_subscribeboards`
--
DROP TABLE IF EXISTS `bb1_subscribeboards`;
CREATE TABLE `bb1_subscribeboards` (
`userid` int(11) unsigned NOT NULL default '0',
`boardid` int(11) unsigned NOT NULL default '0',
`emailnotify` tinyint(1) NOT NULL default '0',
`countemails` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`boardid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_subscribethreads`
--
DROP TABLE IF EXISTS `bb1_subscribethreads`;
CREATE TABLE `bb1_subscribethreads` (
`userid` int(11) unsigned NOT NULL default '0',
`threadid` int(11) unsigned NOT NULL default '0',
`emailnotify` tinyint(1) NOT NULL default '0',
`countemails` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`threadid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_templatepacks`
--
DROP TABLE IF EXISTS `bb1_templatepacks`;
CREATE TABLE `bb1_templatepacks` (
`templatepackid` int(11) unsigned NOT NULL auto_increment,
`templatepackname` varchar(100) NOT NULL default '',
`templatefolder` varchar(250) NOT NULL default '',
`parentid` int(11) unsigned NOT NULL default '0',
`templatestructure` mediumtext NOT NULL,
PRIMARY KEY (`templatepackid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_templates`
--
DROP TABLE IF EXISTS `bb1_templates`;
CREATE TABLE `bb1_templates` (
`templateid` int(11) unsigned NOT NULL auto_increment,
`templatepackid` int(11) unsigned NOT NULL default '0',
`templatename` varchar(100) NOT NULL default '',
`template` mediumtext NOT NULL,
`recompile` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`templateid`),
UNIQUE KEY `templatepackid` (`templatepackid`,`templatename`)
) TYPE=MyISAM;
--
-- Create Table `bb1_threads`
--
DROP TABLE IF EXISTS `bb1_threads`;
CREATE TABLE `bb1_threads` (
`threadid` int(11) unsigned NOT NULL auto_increment,
`boardid` int(11) unsigned NOT NULL default '0',
`prefix` varchar(250) NOT NULL default '',
`topic` varchar(250) NOT NULL default '',
`iconid` int(11) unsigned NOT NULL default '0',
`starttime` int(11) unsigned NOT NULL default '0',
`starterid` int(11) unsigned NOT NULL default '0',
`starter` varchar(50) NOT NULL default '',
`lastposttime` int(11) unsigned NOT NULL default '0',
`lastposterid` int(11) unsigned NOT NULL default '0',
`lastposter` varchar(50) NOT NULL default '',
`replycount` mediumint(7) unsigned NOT NULL default '0',
`views` mediumint(7) unsigned NOT NULL default '0',
`closed` tinyint(1) NOT NULL default '0',
`voted` smallint(5) unsigned NOT NULL default '0',
`votepoints` mediumint(7) unsigned NOT NULL default '0',
`attachments` smallint(5) unsigned NOT NULL default '0',
`pollid` int(11) unsigned NOT NULL default '0',
`important` tinyint(1) NOT NULL default '0',
`visible` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`threadid`),
KEY `iconid` (`iconid`),
KEY `boardid` (`boardid`,`visible`,`important`,`lastposttime`),
KEY `visible` (`visible`,`lastposttime`,`closed`)
) TYPE=MyISAM;
--
-- Create Table `bb1_threadvisit`
--
DROP TABLE IF EXISTS `bb1_threadvisit`;
CREATE TABLE `bb1_threadvisit` (
`threadid` int(11) unsigned NOT NULL default '0',
`userid` int(11) unsigned NOT NULL default '0',
`lastvisit` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`threadid`,`userid`),
KEY `userid` (`userid`,`lastvisit`)
) TYPE=MyISAM;
--
-- Create Table `bb1_user2groups`
--
DROP TABLE IF EXISTS `bb1_user2groups`;
CREATE TABLE `bb1_user2groups` (
`userid` int(11) unsigned NOT NULL default '0',
`groupid` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`groupid`),
UNIQUE KEY `groupid` (`groupid`,`userid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_userfields`
--
DROP TABLE IF EXISTS `bb1_userfields`;
CREATE TABLE `bb1_userfields` (
`userid` int(11) unsigned NOT NULL default '0',
`field1` varchar(250) NOT NULL default '',
`field2` varchar(250) NOT NULL default '',
`field3` varchar(250) NOT NULL default '',
`field4` varchar(250) NOT NULL default '',
PRIMARY KEY (`userid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_users`
--
DROP TABLE IF EXISTS `bb1_users`;
CREATE TABLE `bb1_users` (
`userid` int(11) unsigned NOT NULL auto_increment,
`username` varchar(50) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
`sha1_password` varchar(40) NOT NULL default '',
`email` varchar(150) NOT NULL default '',
`userposts` mediumint(7) unsigned NOT NULL default '0',
`groupcombinationid` int(11) unsigned NOT NULL default '0',
`rankid` int(11) unsigned NOT NULL default '0',
`title` varchar(50) NOT NULL default '',
`regdate` int(11) unsigned NOT NULL default '0',
`lastvisit` int(11) unsigned NOT NULL default '0',
`lastactivity` int(11) unsigned NOT NULL default '0',
`usertext` text NOT NULL,
`signature` text NOT NULL,
`disablesignature` tinyint(1) NOT NULL default '0',
`icq` varchar(30) NOT NULL default '',
`aim` varchar(30) NOT NULL default '',
`yim` varchar(30) NOT NULL default '',
`msn` varchar(30) NOT NULL default '',
`homepage` varchar(250) NOT NULL default '',
`birthday` date NOT NULL default '0000-00-00',
`avatarid` int(11) unsigned NOT NULL default '0',
`gender` tinyint(1) NOT NULL default '0',
`showemail` tinyint(1) NOT NULL default '0',
`admincanemail` tinyint(1) NOT NULL default '1',
`usercanemail` tinyint(1) NOT NULL default '1',
`invisible` tinyint(1) NOT NULL default '0',
`usecookies` tinyint(1) NOT NULL default '1',
`styleid` int(11) unsigned NOT NULL default '0',
`langid` int(11) NOT NULL default '0',
`activation` int(11) unsigned NOT NULL default '0',
`blocked` tinyint(1) NOT NULL default '0',
`daysprune` smallint(5) unsigned NOT NULL default '0',
`timezoneoffset` char(3) NOT NULL default '',
`startweek` tinyint(1) NOT NULL default '0',
`dateformat` varchar(10) NOT NULL default '',
`timeformat` varchar(10) NOT NULL default '',
`emailnotify` tinyint(1) NOT NULL default '0',
`notificationperpm` tinyint(1) NOT NULL default '0',
`buddylist` text NOT NULL,
`ignorelist` text NOT NULL,
`receivepm` tinyint(1) NOT NULL default '1',
`emailonpm` tinyint(1) NOT NULL default '0',
`pmpopup` tinyint(1) NOT NULL default '0',
`umaxposts` smallint(5) unsigned NOT NULL default '0',
`showsignatures` tinyint(1) NOT NULL default '1',
`showavatars` tinyint(1) NOT NULL default '1',
`showimages` tinyint(1) NOT NULL default '1',
`ratingcount` smallint(5) unsigned NOT NULL default '0',
`ratingpoints` mediumint(7) unsigned NOT NULL default '0',
`threadview` tinyint(1) NOT NULL default '0',
`useuseraccess` tinyint(1) NOT NULL default '0',
`isgroupleader` tinyint(1) NOT NULL default '0',
`rankgroupid` int(11) NOT NULL default '0',
`useronlinegroupid` int(11) NOT NULL default '0',
`allowsigsmilies` tinyint(1) NOT NULL default '1',
`allowsightml` tinyint(1) NOT NULL default '0',
`allowsigbbcode` tinyint(1) NOT NULL default '1',
`allowsigimages` tinyint(1) NOT NULL default '1',
`emailonapplication` tinyint(1) NOT NULL default '0',
`acpmode` tinyint(3) NOT NULL default '1',
`acppersonalmenu` tinyint(1) NOT NULL default '0',
`acpmenumarkfirst` tinyint(3) NOT NULL default '0',
`acpmenuhidelast` tinyint(3) NOT NULL default '0',
`usewysiwyg` tinyint(1) unsigned NOT NULL default '0',
`pmtotalcount` int(11) unsigned NOT NULL default '0',
`pminboxcount` int(11) unsigned NOT NULL default '0',
`pmnewcount` int(11) unsigned NOT NULL default '0',
`pmunreadcount` int(11) unsigned NOT NULL default '0',
`reg_ipaddress` varchar(15) NOT NULL default '',
PRIMARY KEY (`userid`),
KEY `username` (`username`),
KEY `rankid` (`rankid`),
KEY `avatarid` (`avatarid`),
KEY `activation` (`activation`),
KEY `groupcombinationid` (`groupcombinationid`),
KEY `reg_ipaddress` (`reg_ipaddress`)
) TYPE=MyISAM;
--
-- Create Table `bb1_votes`
--
DROP TABLE IF EXISTS `bb1_votes`;
CREATE TABLE `bb1_votes` (
`id` int(11) unsigned NOT NULL default '0',
`votemode` tinyint(1) NOT NULL default '0',
`userid` int(11) unsigned NOT NULL default '0',
`ipaddress` varchar(15) NOT NULL default '',
KEY `id` (`id`,`votemode`,`userid`),
KEY `id_2` (`id`,`votemode`,`ipaddress`)
) TYPE=MyISAM;
--
-- Create Table `bb1_wordlist`
--
DROP TABLE IF EXISTS `bb1_wordlist`;
CREATE TABLE `bb1_wordlist` (
`wordid` int(11) unsigned NOT NULL auto_increment,
`word` varchar(50) NOT NULL default '',
PRIMARY KEY (`wordid`),
UNIQUE KEY `word` (`word`)
) TYPE=MyISAM;
--
-- Create Table `bb1_wordmatch`
--
DROP TABLE IF EXISTS `bb1_wordmatch`;
CREATE TABLE `bb1_wordmatch` (
`wordid` int(11) unsigned NOT NULL default '0',
`postid` int(11) unsigned NOT NULL default '0',
`intopic` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`wordid`,`postid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_xy_shoutbox`
--
DROP TABLE IF EXISTS `bb1_xy_shoutbox`;
CREATE TABLE `bb1_xy_shoutbox` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`comment` text NOT NULL,
`date` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
--
-- Create Table `bb1_xy_shoutbox_ban`
--
DROP TABLE IF EXISTS `bb1_xy_shoutbox_ban`;
CREATE TABLE `bb1_xy_shoutbox_ban` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`why` text NOT NULL,
`date` int(11) NOT NULL default '0',
`banned_by` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `userid` (`userid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_xy_shoutbox_commands`
--
DROP TABLE IF EXISTS `bb1_xy_shoutbox_commands`;
CREATE TABLE `bb1_xy_shoutbox_commands` (
`commandid` int(11) NOT NULL auto_increment,
`command` varchar(255) NOT NULL default '',
`r_command` text NOT NULL,
`commandcount` tinyint(4) NOT NULL default '0',
`describ` varchar(255) NOT NULL default '',
`use` tinytext NOT NULL,
PRIMARY KEY (`commandid`)
) TYPE=MyISAM;
--
-- Create Table `bb1_xy_shoutbox_swears`
--
DROP TABLE IF EXISTS `bb1_xy_shoutbox_swears`;
CREATE TABLE `bb1_xy_shoutbox_swears` (
`id` int(11) NOT NULL auto_increment,
`orig` varchar(255) NOT NULL default '',
`rplace` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
|