firebird.sql

来自「一个公关系统的后台程序」· SQL 代码 · 共 29 行

-- MySQL dump 9.08
--
-- Host: server01    Database: firebird_ktv
---------------------------------------------------------
-- Server version	4.0.14-standard

--
-- Table structure for table 'bill'
--

CREATE TABLE bill (
  bill_id bigint(50) NOT NULL auto_increment,
  roomprice decimal(11,2) NOT NULL default '0.00',
  roompriceunit varchar(30) NOT NULL default '',
  costroom decimal(32,2) NOT NULL default '0.00',
  costother decimal(32,2) default '0.00',
  costother2 decimal(32,2) default '0.00',
  costtemp decimal(11,2) NOT NULL default '0.00',
  costagio decimal(11,2) NOT NULL default '0.00',
  timeclose varchar(19) NOT NULL default '0000-00-00 00:00',
  room_id int(16) NOT NULL default '0',
  operator_id int(16) NOT NULL default '0',
  paytype varchar(20) NOT NULL default '',
  memo varchar(100) default NULL,
  timeopen varchar(19) NOT NULL default '0000-00-00 00:00',
  timeacuu int(11) NOT NULL default '0',
  costtotal decimal(32,2) NOT NULL default '0.00',
  PRIMARY KEY  (bill_id)
) TYPE=MyISAM COMMENT='??