# Sql120640_5 CREATE TABLE address ( title varchar(50), firstname varchar(50), lastname varchar(50), company varchar(50), structure varchar(50), city varchar(50), zip varchar(10), address varchar(150), country varchar(50), phone varchar(25), fax varchar(25), cellphone varchar(25), email varchar(70), url varchar(70), comment blob, class int, owner varchar(15) DEFAULT "", rights int DEFAULT 0, pid int(11) NOT NULL auto_increment, PRIMARY KEY (pid) ); CREATE TABLE classes ( classkey int NOT NULL NOT NULL auto_increment, classtex varchar(50), PRIMARY KEY (classkey) ); INSERT INTO classes (classkey, classtex) VALUES (1, "Default"); DROP TABLE IF EXISTS uniqids; # # Table structure for table 'uniqids' # CREATE TABLE uniqids ( uid varchar(21) DEFAULT '' NOT NULL, PRIMARY KEY (uid) );