Up: A. Der Programmcode Previous: A.11 deldata.php4

A.12 maketable.sql

CREATE TABLE passuser (
   UUID int(10) NOT NULL AUTO_INCREMENT,
   user varchar(15) NOT NULL,
   pwd varchar(15) NOT NULL,
   lastaccess datetime,
   PRIMARY KEY (UUID)
);

CREATE TABLE passdata (
   id int(10) NOT NULL AUTO_INCREMENT,
   UUID int(10) NOT NULL,
   link varchar(20) NOT NULL,
   data text,
   PRIMARY KEY (id)
);