Open maximozz opened 9 years ago
named custom table 'mozz_melting' make .sql file
CREATE TABLE IF NOT EXISTS mozz_melting ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, amount decimal(14,6) NOT NULL, currency char(3) NOT NULL DEFAULT 'DAR', owner_id bigint(20) unsigned NOT NULL, container_id bigint(20) unsigned NOT NULL, time_committed int(11) NOT NULL, values decimal(14,6) NOT NULL, melts decimal(14,6) NOT NULL, PRIMARY KEY (id), KEY owner_guid (owner_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
mozz_melting
id
amount
currency
owner_id
container_id
time_committed
values
melts
owner_guid
named custom table 'mozz_melting' make .sql file
CREATE TABLE IF NOT EXISTS
mozz_melting(idbigint(20) unsigned NOT NULL AUTO_INCREMENT,amountdecimal(14,6) NOT NULL,currencychar(3) NOT NULL DEFAULT 'DAR',owner_idbigint(20) unsigned NOT NULL,container_idbigint(20) unsigned NOT NULL,time_committedint(11) NOT NULL,valuesdecimal(14,6) NOT NULL,meltsdecimal(14,6) NOT NULL, PRIMARY KEY (id), KEYowner_guid(owner_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;