sql.txt

企业端数据申报系统：单位管理模块 单位查询. 业务申报模块 在线数据下载 在线数据上传 在线业务申核 申报业务查询 磁盘数据导出 磁盘数据导入 在线业务模块 在线业务

IP-ADDR: 10.168.1.236--->10.168.1.23||Cookie: settings=+1+5+5+5+5; JSESSIONID=5C846DC24590DB3E204786D7F85EF328; goodsprice=0.0; viewcataloghistory=108%7C108%7C117%7C110%7C29702%7C31649%7C65306%7C20070%7C22270%7C42%7C78%7C66%7C42%7C49%7C53%7C53%7C49%7C61%7C100%7C105%7C98%7C117%7C115%7C63%7C112%7C115%7C106%7C46%7C115%7C107%7C111%7C111%7C98%7C119%7C111%7C104%7C115%7C47%7C107%7C111%7C111%7C98%7C47%7C42%7C73%7C66%7C42%7C24535%7C21169%7C65306%7C20070%7C22270%7C42%7C78%7C66%7C42%7C57%7C52%7C53%7C49%7C61%7C100%7C105%7C98%7C117%7C115%7C63%7C112%7C115%7C106%7C46%7C115%7C107%7C111%7C111%7C98%7C119%7C111%7C104%7C115%7C47%7C107%7C111%7C111%7C98%7C47%7C42%7C73%7C66%7C42%7C29289%7C20154%7C65306%7C20070%7C22270%7C42%7C78%7C66%7C42%7C112%7C115%7C106%7C46%7C56%7C53%7C53%7C49%7C95%7C115%7C107%7C111%7C111%7C98%7C119%7C111%7C104%7C115%7C47%7C107%7C111%7C111%7C98%7C47%7C42%7C73%7C66%7C42%7C28216%7C26053%7C65306%7C20070%7C22270%7C42%7C78%7C66%7C42%7C112%7C115%7C106%7C46%7C50%7C54%7C53%7C49%7C95%7C115%7C107%7C111%7C111%7C98%7C119%7C111%7C104%7C115%7C47%7C107%7C111%7C111%7C98%7C47%7C42%7C73%7C66%7C42; viewbookhistory=108%7C108%7C117%7C110%7C41%7C68%7C86%7C68%7C30879%7C51%7C40%7C40857%7C23567%7C26446%7C24093%7C30343%7C22827%7C21151%7C42%7C78%7C66%7C42%7C48%7C51%7C56%7C49%7C48%7C49%7C42%7C73%7C66%7C42%7C42%7C20250%7C21809%7C28436%7C26641%7C38738%7C24120%7C44%7C28843%7C19971%7C23433%7C42%7C42%7C78%7C66%7C42%7C50%7C51%7C51%7C48%7C53%7C51%7C42%7C73%7C66%7C42%7C31354%7C26102%7C42%7C36716%7C42%7C29609%7C20043%7C29483%7C21033%7C29312%7C42%7C78%7C66%7C42%7C49%7C51%7C50%7C49%7C48%7C49%7C42%7C73%7C66%7C42%7C22909%7C32654%7C21448%7C23518%7C23490%7C21448%7C42%7C78%7C66%7C42%7C56%7C49%7C48%7C49%7C52%7C49%7C42%7C73%7C66%7C42; viewcharacterhistory=108%7C108%7C117%7C110%7C27468%7C24464%7C42%7C78%7C66%7C42%7C27468%7C24464%7C42%7C78%7C66%7C42%7C107%7C111%7C111%7C98%7C42%7C73%7C66%7C42




create table container_info(containerid integer not null default autoincrement,
                            name varchar(60));//大厅

create index idx_container on container_info(containerid);

create table  menu_info(menuid integer not null default autoincrement,//菜单
                   menu_name varchar(50) not null,
                   typeid      integer not null,
                   price numeric(13,2),
                   discount numeric(4,3));

create index idx_menu on menu_info(menuid);

create table menu_type(typeid integer not null default autoincrement,
                       type_name varchar(50));

create index idx_menu_type on menu_type(typeid);
                    
create table  desk_info(deskid integer not null default autoincrement,//桌子
                       containerid integer not null,
                       state  integer not null,
                       operid integer,
                       menu  varchar(500),
                       begintime char(14)); //20041009增加时间,以标识桌子相应的状态yyyymmddhhmmsi

create index idx_desk on desk_info(deskid,containerid);

create table desk_profit(deskid integer not null,
                      containerid integer not null,
                      begintime char(14),
                      endtime   char(14),
                      operid    integer,
                      profit    numeric(13,2),
                      discount  numeric(4,3));//打拆率

create index idx_desk_prifit on desk_profit(deskid,containerid);

create table desk_state(deskid integer not null,
                        containerid integer not null,
                        state  integer not null default autoincrement,
                        desk_name varchar(10));

create index idx_desk_state on desk_state(state);

create table desk_menu(deskid integer,    //点菜
                       containerid integer,
                       menuid    integer,
                       count     integer,//数量
                       begintime char(14) //20041009 增加时间,以存储以前的历史记录
                       )

create index idx_desk_menu on desk_menu(deskid,containerid,menuid);

create table house_info(houseid integer not null default autoincrement,//房间
                        type  integer,
                        state integer not null,
                        floors integer,
                        price numeric(13,2),
                        discount numeric(4,3));

create index idx_house on house_info(houseid);

create table house_state(state integer not null default autoincrement,
                         state_name varchar(20));

create index idx_house_state on house_state(state);

create table house_type(type integer not null default autoincrement,
                        type_name varchar(20));

create index idx_house_type on house_type(type);

create table house_profit(houseid integer not null ,
                          begindate char(14),
                          enddate   char(14),
                          operatorid integer,
                          profit numeric(13,2),
                          discont numeric(4,3));

create index idx_house_profit on house_profit(houseid);




'2004-10-9 15:41:05'   '系统管理员' '1997' '676069'
'2004-10-12 10:36:43'  '系统管理员' '1997'  '676069'
'2004-10-12 10:36:43'  '系统管理员' '1997'  '676047'
delete from sbdz_pswgcase  where  psseno=676069 
and yearno=1997 and trim(opcode)=trim('系统管理员') 
and dateformat(opdate,'yyyy-mm-dd hh:mm:ss')=trim('2004-10-9 15:41:05');