· 6 years ago · Jul 14, 2019, 05:54 PM
1void CreateBankTables()
2{
3 string sql = "CREATE TABLE IF NOT EXISTS `bankvault` ( "+
4 " autoid int(11) NOT NULL auto_increment, "+
5 " userid int(11) NOT NULL default '0', "+
6 " playerid int(11) NOT NULL default '0', "+
7 " furniture_tag varchar(30), "+
8 " resref varchar(16), "+
9 " identified varchar(1), "+
10 " stacked varchar(1), "+
11 " container_id varchar(30), "+
12 " in_container varchar(1), "+
13 " resourcecount varchar(5), "+
14 " pickpocketable varchar(1), "+
15 " stolen varchar(1), "+
16 " trueowner text, "+
17 " trueowner_name text, "+
18 " thief text, "+
19 " thief_name text, "+
20 " last_updated_dt TIMESTAMP DEFAULT 'NOW()' NOT NULL, "+
21 " PRIMARY KEY (autoid) "+
22 " ) ENGINE=MyISAM DEFAULT CHARSET=latin1; ";
23 SQLExecDirect(sql);
24
25 sql = "CREATE TABLE IF NOT EXISTS `bank` ( "+
26 " autoid int(11) NOT NULL auto_increment, "+
27 " userid int(11) NOT NULL default '0', "+
28 " gold varchar(12), "+
29 " last_updated_dt TIMESTAMP DEFAULT 'NOW()' NOT NULL, "+
30 " PRIMARY KEY (autoid) "+
31 " ) ENGINE=MyISAM DEFAULT CHARSET=latin1; ";
32 SQLExecDirect(sql);