· 5 years ago · Sep 22, 2020, 12:52 AM
1-- phpMyAdmin SQL Dump
2-- version 2.9.1.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost:3306
6-- Generation Time: Oct 12, 2008 at 06:21 PM
7-- Server version: 5.0.67
8-- PHP Version: 5.2.5 (x64)
9--
10-- Database: `pso_server`
11--
12
13-- --------------------------------------------------------
14
15--
16-- Table structure for table `account_data`
17--
18
19DROP TABLE IF EXISTS `account_data`;
20CREATE TABLE `account_data` (
21 `username` varchar(18) collate latin1_general_ci NOT NULL default '',
22 `password` varchar(33) collate latin1_general_ci NOT NULL default '',
23 `email` varchar(255) collate latin1_general_ci NOT NULL default '',
24 `regtime` int(11) unsigned NOT NULL default '0',
25 `lastip` varchar(16) collate latin1_general_ci NOT NULL default '',
26 `lasthwinfo` tinyblob,
27 `guildcard` int(11) NOT NULL auto_increment,
28 `isgm` tinyint(2) NOT NULL default '0',
29 `isbanned` tinyint(2) NOT NULL default '0',
30 `islogged` tinyint(2) NOT NULL default '0',
31 `isactive` tinyint(2) NOT NULL default '0',
32 `teamid` int(11) NOT NULL default '-1',
33 `privlevel` mediumint(9) NOT NULL default '0',
34 `lastchar` tinyblob,
35 PRIMARY KEY (`guildcard`)
36) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
37
38-- --------------------------------------------------------
39
40--
41-- Table structure for table `bank_data`
42--
43
44DROP TABLE IF EXISTS `bank_data`;
45CREATE TABLE `bank_data` (
46 `guildcard` int(11) NOT NULL default '0',
47 `data` blob NOT NULL
48) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
49
50-- --------------------------------------------------------
51
52--
53-- Table structure for table `character_data`
54--
55
56DROP TABLE IF EXISTS `character_data`;
57CREATE TABLE `character_data` (
58 `guildcard` int(11) NOT NULL default '0',
59 `slot` tinyint(4) NOT NULL default '0',
60 `data` blob NOT NULL,
61 `header` tinyblob NOT NULL
62) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
63
64-- --------------------------------------------------------
65
66--
67-- Table structure for table `guild_data`
68--
69
70DROP TABLE IF EXISTS `guild_data`;
71CREATE TABLE `guild_data` (
72 `accountid` int(11) NOT NULL default '0',
73 `friendid` int(11) NOT NULL default '0',
74 `friendname` tinyblob NOT NULL,
75 `friendtext` blob NOT NULL,
76 `reserved` smallint(6) NOT NULL default '257',
77 `sectionid` smallint(6) NOT NULL default '0',
78 `class` smallint(6) NOT NULL default '0',
79 `comment` tinyblob NOT NULL,
80 `priority` smallint(6) NOT NULL default '0'
81) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
82
83-- --------------------------------------------------------
84
85--
86-- Table structure for table `hw_bans`
87--
88
89DROP TABLE IF EXISTS `hw_bans`;
90CREATE TABLE `hw_bans` (
91 `guildcard` int(11) NOT NULL,
92 `hwinfo` tinyblob NOT NULL
93) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
94
95-- --------------------------------------------------------
96
97--
98-- Table structure for table `ip_bans`
99--
100
101DROP TABLE IF EXISTS `ip_bans`;
102CREATE TABLE `ip_bans` (
103 `ipinfo` varchar(16) collate latin1_general_ci NOT NULL default ''
104) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
105
106-- --------------------------------------------------------
107
108--
109-- Table structure for table `key_data`
110--
111
112DROP TABLE IF EXISTS `key_data`;
113CREATE TABLE `key_data` (
114 `guildcard` int(11) NOT NULL default '0',
115 `controls` blob NOT NULL,
116 PRIMARY KEY (`guildcard`)
117) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
118
119-- --------------------------------------------------------
120
121--
122-- Table structure for table `security_data`
123--
124
125DROP TABLE IF EXISTS `security_data`;
126CREATE TABLE `security_data` (
127 `guildcard` int(11) NOT NULL default '0',
128 `thirtytwo` int(11) NOT NULL default '0',
129 `sixtyfour` tinyblob NOT NULL,
130 `slotnum` tinyint(4) NOT NULL default '-1',
131 `isgm` int(11) NOT NULL default '0'
132) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
133
134-- --------------------------------------------------------
135
136--
137-- Table structure for table `ship_data`
138--
139
140DROP TABLE IF EXISTS `ship_data`;
141CREATE TABLE `ship_data` (
142 `rc4key` tinyblob NOT NULL,
143 `idx` int(11) NOT NULL auto_increment,
144 PRIMARY KEY (`idx`)
145) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
146
147-- --------------------------------------------------------
148
149--
150-- Table structure for table `team_data`
151--
152
153DROP TABLE IF EXISTS `team_data`;
154CREATE TABLE `team_data` (
155 `name` tinyblob NOT NULL,
156 `owner` int(11) NOT NULL default '0',
157 `flag` blob NOT NULL,
158 `teamid` int(11) NOT NULL auto_increment,
159 PRIMARY KEY (`teamid`)
160) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
161