create table employee(id int NOT NULL PRIMARY KEY,
name varchar(128),
owner varchar(128),
active int default 1, last_modified
timestamp DEFAULT timestamp)
-- 录入数据
insertinto employee(id, name, owner,
active ) values (1, ´小桥´, ´zhou1´, 1)
insert into employee(id, name, owner,
active ) values (2, ´流水´, ´zhou2´, 1)
insert into employee(id, name, owner,
active ) values (3, ´人家´, ´zhou1´, 1)
commit
go
-- 加入脚本版本及脚本
call ml_add_table_script( ´version1´,
´employee´, ´upload_insert´, ´insert into
employee(id, name) values (?,?)´ )
go
call ml_add_table_script( ´version1´,
´employee´, ´upload_update´, ´update employee
set name=? where id = ?´ )
go
call ml_add_table_script( ´version1´,
´employee´, ´upload_delete´, ´delete from
employee where id = ?´ )
go
call ml_add_table_script( ´version1´,
´employee´, ´download_cursor´,´select id,
name from employee where last_modified > ?
and owner = ? and active = 1´ )
go
call ml_add_table_script( ´version1´,
´employee´, ´download_delete_cursor´,
´select id from employee where last_modified>?
and (owner !=? or active = 0)´ )
go |