16sql 11err 33ms topnew 15:25:07 Mon 08 Oct
## this script contains 3 parts ## 1 create user and database ## 2 create benson bank tables ## 3 insert initial data into the tables ## part 1 -- create user and database ## you can use your existing
1 row(s) affected : 0ms taken
insert into mysql.user(Host,User,Password) values('localhost','topnew',password('geo'))
Error Code : 1062
Duplicate entry 'localhost-topnew' for key 1
flush privileges
0 row(s) affected : 0ms taken
GRANT SELECT, INSERT, UPDATE, DELETE ON topnew.* TO 'topnew'@'localhost'
0 row(s) affected : 0ms taken
flush privileges
0 row(s) affected : 5ms taken
## part 2 -- create benson bank tables use topnew
0 row(s) affected : 0ms taken
CREATE TABLE `bsb_account` ( `pid` smallint(5) unsigned NOT NULL default '0', `name` varchar(50) NOT NULL default '', `password` varchar(32) NOT NULL default '', `sid` varchar(32) NOT NULL default '',
Error Code : 1105
MyISAM table 'bsb_account' is in use (most likely by a MERGE table). Try FLUSH TABLES.
CREATE TABLE `bsb_cashbook` ( `his_id` int(10) unsigned NOT NULL auto_increment, `pid` smallint(5) unsigned NOT NULL default '0', `created` timestamp NOT NULL default CURRENT_TIMESTAMP, `cat_id` small
Error Code : 1105
MyISAM table 'bsb_cashbook' is in use (most likely by a MERGE table). Try FLUSH TABLES.
CREATE TABLE `bsb_category` ( `pid` smallint(5) unsigned NOT NULL default '0', `cat_id` smallint(5) unsigned NOT NULL default '0', `category` varchar(20) NOT NULL default '', PRIMARY KEY (`pid`,`cat_
Error Code : 1105
MyISAM table 'bsb_category' is in use (most likely by a MERGE table). Try FLUSH TABLES.
CREATE TABLE `bsb_ccy` ( `ccy` char(3) NOT NULL default '', `ccy_cn` varchar(20) NOT NULL default '', PRIMARY KEY (`ccy`) )
Error Code : 1105
MyISAM table 'bsb_ccy' is in use (most likely by a MERGE table). Try FLUSH TABLES.
CREATE TABLE `bsb_future` ( `his_id` int(10) unsigned NOT NULL default '0', `remark` varchar(50) NOT NULL default '', `dateto` date NOT NULL default '0000-00-00', `rate_y` float(5,3) NOT NULL default
Error Code : 1105
MyISAM table 'bsb_future' is in use (most likely by a MERGE table). Try FLUSH TABLES.
## part 3 -- insert initial data INSERT INTO `bsb_account` VALUES('1','五角牛','','','','2007-08-28','','0','CNY','AUD,CNY,HKD,USD', '1','-1','1','3'),('2','Topnew Geo','','','','2007-08-28','','0',
Error Code : 1062
Duplicate entry '1' for key 1
INSERT INTO `bsb_cashbook` VALUES('1','100','2007-08-01 00:00:00','101','','CNY','100.00'),('2','100','2007-08-01 00:00:00','30101','','CNY','-100.00'),('3','100','2007-08-10 00:00:00','30101','','CNY
Error Code : 1062
Duplicate entry '1' for key 1
INSERT INTO `bsb_category` VALUES('1','1','总收入'),('1','2','总支出'),('1','3','总资金'),('1','101','工资'), ('1','102','收益'),('1','201','伙食'),('1','202','房租'),('1','203','交��
Error Code : 1062
Duplicate entry '1-1' for key 1
INSERT INTO `bsb_ccy` VALUES('AUD','澳大利亚元'),('CAD','加拿大元'),('CHF','瑞士法郎'),('CNY','人民币'), ('DKK','丹麦克朗'),('EUR','欧元'),('GBP','英镑'),('HKD','港币'),('JPY'
Error Code : 1062
Duplicate entry 'AUD' for key 1
INSERT INTO `bsb_future` VALUES('17','','2008-05-01','8.800');
Error Code : 1062
Duplicate entry '17' for key 1
