- DROP TABLE IF EXISTS cdb_bankstatus;
- CREATE TABLE cdb_bankstatus (
- id int(10) unsigned NOT NULL auto_increment,
- uid mediumint(8) unsigned NOT NULL default '0',
- username varchar(15) NOT NULL default '',
- bankstatus tinyint(1) NOT NULL default '0',
- isuseps tinyint(1) NOT NULL default '0',
- bankpass int(5) unsigned NOT NULL default '8888',
- savemt int(10) unsigned NOT NULL default '0',
- PRIMARY KEY (id)
- );
- mysql> desc cdb_bankstatus;
- +------------+-----------------------+------+-----+---------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +------------+-----------------------+------+-----+---------+----------------+
- | id | int(10) unsigned | | PRI | NULL | auto_increment |
- | uid | mediumint(8) unsigned | | | 0 | |
- | username | varchar(15) | | | | |
- | bankstatus | tinyint(1) | | | 0 | |
- | isuseps | tinyint(1) | | | 0 | |
- | bankpass | int(5) unsigned | | | 8888 | |
- | savemt | int(10) unsigned | | | 0 | |
- +------------+-----------------------+------+-----+---------+----------------+
- 7 rows in set (0.00 sec)
- 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)
- );
- mysql> desc cdb_banklog;
- +-----------+-----------------------+------+-----+---------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +-----------+-----------------------+------+-----+---------+----------------+
- | id | int(10) unsigned | | PRI | NULL | auto_increment |
- | uid | mediumint(8) unsigned | | | 0 | |
- | username | varchar(15) | | | | |
- | czid | tinyint(2) | | | 0 | |
- | moneynum | int(10) | | | 0 | |
- | begintime | int(10) unsigned | | | 0 | |
- | endtime | int(10) unsigned | | | 0 | |
- | islog | tinyint(1) | | | 0 | |
- | remark | text | YES | | NULL | |
- | czip | varchar(15) | | | 0 | |
- +-----------+-----------------------+------+-----+---------+----------------+
- 10 rows in set (0.00 sec)
复制代码 |