SQL query:
SQL查询:
CREATE TABLE bonus(
bonusid INT( 10 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
empid INT( 10 ) DEFAULT '0' NOT NULL ,
datebonus DATE DEFAULT '0000-00-00' NOT NULL ,
bonuspayment VARCHAR( 200 ) NOT NULL ,
note TEXT NOT NULL ,
PRIMARY KEY ( bonusid )
);
CREATE TABLE bonus(
bonus