· 8 years ago · Jun 02, 2018, 05:22 AM
1angerfist (19:24:22 26/01/2009)
2--
3-- Table structure for table `benutzerdaten`
4--
5
6CREATE TABLE IF NOT EXISTS `benutzerdaten` (
7 `Id` int(11) NOT NULL auto_increment,
8 `Nickname` varchar(50) NOT NULL default '',
9 `Kennwort` varchar(50) NOT NULL default '',
10 `Email` varchar(50) NOT NULL default '',
11 `Coins` int(11) NOT NULL default '0',
12 `LastLogin` date default NULL,
13 `LastTime` varchar(5) NOT NULL default '',
14 PRIMARY KEY (`Id`)
15) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=101 ;
16
17 angerfist (19:24:23 26/01/2009)
18reicht das?
19
20 angerfist (19:24:32 26/01/2009)
21--
22-- Table structure for table `ccbase`
23--
24
25CREATE TABLE IF NOT EXISTS `ccbase` (
26 `Id` int(11) NOT NULL auto_increment,
27 `Name` varchar(50) NOT NULL default '',
28 `Strasse` varchar(50) NOT NULL default '',
29 `plz` varchar(50) NOT NULL,
30 `Ort` varchar(50) NOT NULL default '',
31 `Land` varchar(50) NOT NULL default '',
32 `CCNummer` varchar(50) NOT NULL default '',
33 `Haltbarkeit` varchar(50) NOT NULL default '',
34 `cvv` varchar(3) NOT NULL default '',
35 PRIMARY KEY (`Id`)
36) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=619 ;
37
38--
39-- Dumping data for table `ccbase`
40--
41
42 angerfist (19:24:39 26/01/2009)
43--
44-- Table structure for table `ccselled`
45--
46
47CREATE TABLE IF NOT EXISTS `ccselled` (
48 `Id` int(11) NOT NULL auto_increment,
49 `Name` varchar(50) NOT NULL default '',
50 `Strasse` varchar(50) NOT NULL default '',
51 `plz` int(12) NOT NULL,
52 `Ort` varchar(50) NOT NULL default '',
53 `Land` varchar(50) NOT NULL default '',
54 `CCNummer` varchar(50) NOT NULL default '',
55 `Haltbarkeit` varchar(50) NOT NULL default '',
56 `cvv` varchar(3) NOT NULL default '',
57 `buyer` int(11) NOT NULL,
58 PRIMARY KEY (`Id`)
59) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=330 ;
60
61--
62-- Dumping data for table `ccselled`
63--
64
65 angerfist (19:24:46 26/01/2009)
66--
67-- Table structure for table `joinuser`
68--
69
70CREATE TABLE IF NOT EXISTS `joinuser` (
71 `Id` int(11) NOT NULL auto_increment,
72 `Nickname` varchar(50) NOT NULL default '',
73 `Kennwort` varchar(50) NOT NULL default '',
74 `Email` varchar(50) NOT NULL default '',
75 `Icq` varchar(12) NOT NULL default '',
76 PRIMARY KEY (`Id`)
77) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=464 ;
78
79--
80-- Dumping data for table `joinuser`
81--
82
83 angerfist (19:24:53 26/01/2009)
84--
85-- Table structure for table `messages`
86--
87
88CREATE TABLE IF NOT EXISTS `messages` (
89 `Id` int(11) NOT NULL auto_increment,
90 `Betreff` varchar(50) NOT NULL default '',
91 `Name` varchar(50) NOT NULL default '',
92 `Email` varchar(50) NOT NULL default '',
93 `Icq` varchar(12) NOT NULL default '',
94 `Message` varchar(254) NOT NULL,
95 PRIMARY KEY (`Id`)
96) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21003 ;
97
98--
99-- Dumping data for table `messages`
100--
101
102 angerfist (19:25:02 26/01/2009)
103--
104-- Table structure for table `news`
105--
106
107CREATE TABLE IF NOT EXISTS `news` (
108 `Id` int(11) NOT NULL auto_increment,
109 `Datum` date default NULL,
110 `Content` varchar(244) NOT NULL default '',
111 PRIMARY KEY (`Id`)
112) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
113
114--
115-- Dumping data for table `news`
116--