Avantfax Install

[Chris Larson]

It was suggested that I run this script as the mysql root user, but received the same error. 

ERROR 1064 (42000) at line 3866: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'increment KEY, 
logdate TIMESTAMP, 
logtext TEXT 
) DEFAULT CHARACTER S' at line 1 



Here are the contents of the create_tables.sql script. 

-- AvantFAX 2.2.6 MySQL structure 

DROP DATABASE IF EXISTS avantfax; 

-- CREATE DATABASE avantfax; 
CREATE DATABASE avantfax DEFAULT CHARACTER SET utf8; 

GRANT ALL PRIVILEGES ON avantfax.* TO 'avantfax'@'localhost' IDENTIFIED BY 'd58fe49';^@ 
FLUSH PRIVILEGES; 
USE avantfax; 

-- Distribution Lists 
CREATE TABLE IF NOT EXISTS DistroList ( 
dl_id INT auto_increment KEY, 
listname VARCHAR(255) NOT NULL, 
listdata TEXT, 
lastmod_date TIMESTAMP, 
lastmod_user INT 
) DEFAULT CHARACTER SET utf8; 

-- MODEMS 
CREATE TABLE IF NOT EXISTS Modems ( 
devid INT auto_increment KEY, 
device VARCHAR(10) NOT NULL, 
alias VARCHAR(40), 
contact VARCHAR(100) 
) DEFAULT CHARACTER SET utf8; 

-- USER INFORMATION 
-- password is md5 hash and always 32 chars 
CREATE TABLE IF NOT EXISTS UserAccount ( 
uid INT auto_increment KEY, 
name VARCHAR(40), 
username VARCHAR(40) NOT NULL, 
password VARCHAR(32) NOT NULL, 
email VARCHAR(99) NOT NULL, 
email_sig TEXT, 
from_company VARCHAR(150), 
from_location VARCHAR(150), 
from_voicenumber VARCHAR(150), 
from_faxnumber VARCHAR(150), 
superuser BOOL DEFAULT FALSE, 
can_del BOOL DEFAULT FALSE, 
last_mod TIMESTAMP, 
last_login TIMESTAMP, 
last_ip VARCHAR(15), 
language VARCHAR(2), 
modemdevs VARCHAR(99), 
didrouting VARCHAR(255), 
faxcats VARCHAR(99), 
pwdexpire DATE, 
pwdcycle INT DEFAULT 0, 
pwd_reuse BOOL DEFAULT FALSE, 
wasreset BOOL DEFAULT FALSE, 
acc_enabled BOOL DEFAULT TRUE, 
deleted BOOL DEFAULT FALSE 
) DEFAULT CHARACTER SET utf8; 

CREATE TABLE IF NOT EXISTS AdminAccount ( 
aid INT auto_increment KEY, 
name VARCHAR(40), 
username VARCHAR(15) NOT NULL, 
password VARCHAR(32) NOT NULL, 
email VARCHAR(99) NOT NULL, 
last_mod TIMESTAMP, 
last_login TIMESTAMP, 
last_ip VARCHAR(15), 
language VARCHAR(2), 
wasreset BOOL DEFAULT FALSE, 
pwdexpire DATE, 
pwdcycle INT DEFAULT 0 
) DEFAULT CHARACTER SET utf8; 

-- store hashes of passwords already used for a user 
CREATE TABLE IF NOT EXISTS UserPasswords ( 
upid INT auto_increment KEY, 
uid INT NOT NULL, 
pwdhash VARCHAR (32) NOT NULL, 
adminpwd BOOL DEFAULT FALSE 
) DEFAULT CHARACTER SET utf8; 

CREATE TABLE IF NOT EXISTS UserRubrica ( 
urid INT auto_increment KEY, 
userid INT NOT NULL, 
name VARCHAR(100), 
email VARCHAR(100) NOT NULL 
) DEFAULT CHARACTER SET utf8; 

-- RUBRICA 
CREATE TABLE IF NOT EXISTS Rubrica ( 
cid INT auto_increment KEY, 
company VARCHAR(255) NOT NULL, 
email VARCHAR(100) 
) DEFAULT CHARACTER SET utf8; 

CREATE TABLE IF NOT EXISTS FaxNum ( 
faxnumid INT auto_increment KEY, 
companyid INT NOT NULL, 
faxnum VARCHAR(20) NOT NULL, 
email VARCHAR(100), 
description VARCHAR(30), 
to_person VARCHAR(150), 
to_location VARCHAR(150), 
to_voicenumber VARCHAR(150), 
faxcatid INT, 
faxfrom INT DEFAULT 0, 
faxto INT DEFAULT 0 
) DEFAULT CHARACTER SET utf8; 

-- DID Routing 
CREATE TABLE IF NOT EXISTS DIDRoute ( 
didr_id INT auto_increment KEY, 
routecode VARCHAR(10) NOT NULL, 
alias VARCHAR(40), 
contact VARCHAR(100) 
) DEFAULT CHARACTER SET utf8; 

-- ARCHIVE 
-- companyid for outgoing faxes 
CREATE TABLE IF NOT EXISTS FaxArchive ( 
fid INT auto_increment KEY, 
faxnumid INT NOT NULL, 
companyid INT, 
faxpath VARCHAR(255) NOT NULL, 
pages INT, 
faxcatid INT, 
didr_id INT, 
description BLOB, 
lastoperation TIMESTAMP, 
lastmoduser INT(10), 
lastmoddate TIMESTAMP, 
archstamp TIMESTAMP, 
modemdev VARCHAR(10), 
userid INT, 
origfaxnum VARCHAR(20), 
inbox BOOL DEFAULT TRUE 
) DEFAULT CHARACTER SET utf8; 

CREATE TABLE IF NOT EXISTS FaxCategory ( 
catid INT auto_increment KEY, 
name VARCHAR(30) 
) DEFAULT CHARACTER SET utf8; 

-- AvantFAX System Log 
CREATE TABLE IF NOT EXISTS SysLog ( 
syslogid INT auto_increment KEY, 
logdate TIMESTAMP, 
logtext TEXT 
) DEFAULT CHARACTER SET utf8; 

INSERT INTO AdminAccount (name, username, password, wasreset, email) VALUES 
('AvantFax Admin', 'afadmin', '5f4dcc3b5aa765d61d8327deb882cf99', TRUE, 'YOUR_EMAIL_ADDRESS'); 
INSERT INTO UserPasswords (uid, pwdhash, adminpwd) VALUES ('0', '5f4dcc3b5aa765d61d8327deb882cf99', TRUE); 

INSERT INTO Rubrica SET company = 'XXXXXXX'; 
INSERT INTO FaxNum SET companyid = 1, faxnum = 'XXXXXXX'; 

SHOW TABLES; 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20071115/d15342d0/attachment.html>