GNsMJad6

1use xbase_db;
2
3delimiter ;
4
5
6drop table if exists sys_php_session;
7
8create table sys_php_session
9(
10session_id char(32) not null primary key,
11data varchar(4096),
12updated_date int unsigned not null
13) 
14engine = memory;
15
16
17drop table if exists sys_link;
18
19create table sys_link
20(
21link_id int not null auto_increment primary key,
22link_type_id varchar(32) not null,
23caption varchar(64) not null,
24link varchar(256) not null,
25min_role_id tinyint not null,
26icon_link varchar(256),
27key sys_link_link_type_id_idx (link_type_id)
28)
29engine=InnoDB 
30default charset=latin1 collate latin1_swedish_ci;