- ALTER TABLE `cdb_members` ADD `money` INT(10) DEFAULT '100' NOT NULL, ADD `bank` INT(10) DEFAULT '0' NOT NULL, ADD `savemt` INT(10) DEFAULT '0' NOT NULL, ADD `bankstatus` tinyint(1) DEFAULT '0' NOT NULL, ADD `bankmimi` INT(10) DEFAULT '0' NOT NULL, ADD `bankpass` int(5) DEFAULT '8888' NOT NULL, ADD `savemimi` INT(10) DEFAULT '0' NOT NULL;
复制代码
- DROP TABLE IF EXISTS cdb_banklog;
- CREATE TABLE cdb_banklog (
- id int(10) unsigned NOT NULL auto_increment,
- uid mediumint(8) unsigned NOT NULL default '0',
- username varchar(15) NOT NULL default '',
- czid tinyint(2) NOT NULL default '0',
- moneynum int(10) NOT NULL default '0',
- begintime int(10) unsigned NOT NULL default '0',
- endtime int(10) unsigned NOT NULL default '0',
- islog tinyint(1) NOT NULL default '0',
- remark text,
- czip varchar(15) NOT NULL default '0',
- PRIMARY KEY (id)
- );
复制代码 |