
Hybrid Cloud Application Architecture
F5
®
Deployment Guide 52
--username varchar(25) not null,
username varchar(80) not null,
password varchar(25) not null,
constraint pk_signon primary key (username)
)
REPLICATE
;
create table account (
userid varchar(80) not null,
email varchar(80) not null,
firstname varchar(80) not null,
lastname varchar(80) not null,
status varchar(2) ,
addr1 varchar(80) not null,
addr2 varchar(40) ,
city varchar(80) not null,
state varchar(80) not null,
zip varchar(20) not null,
country varchar(20) not null,
phone varchar(80) not null,
constraint pk_account primary key (userid)
)
REPLICATE
;
create table profile (
userid varchar(80) not null,
langpref varchar(80) not null,
favcategory varchar(30),
mylistopt smallint,
banneropt smallint,
constraint pk_profile primary key (userid)
)
REPLICATE
;
create table bannerdata (
favcategory varchar(80) not null,
bannername varchar(255) ,
constraint pk_bannerdata primary key (favcategory)
)
REPLICATE;
Commenti su questo manuale