1 2 3 4 5 6 7 8
|
create table user2 ("usernr" int not null default 0 ,"name" varchar(50) not null default '' ,"login" varchar(50) not null default '' ,"initials" varchar(10) not null default '' ,"department" varchar(50) not null default '' ,"ord1" varchar(50) not null default '' ,"replyaddr" varchar(75) not null default '' ,"grpnr" int not null default 0 ,"nextpwd" datetime not null default '1900-01-01' ,"forcepwd" int not null default 0 ,"days" int not null default 0 ,"rates" int not null default 0 ,"forcereg" int not null default 0 ,"register" int not null default 0 ,"mpehotel" int not null default 0 ,"password" varchar(50) not null default '' )
3,'eyteste','eguida','SUPP','','','teste teste ',2,'2009-04-25 00:00:00.000',0,30,0,1,31,31,'2500421808'
create table usergrnr ("mpehotel" int not null default 0 ,"kdnr" int not null default 0 )
1,170 |
Partager