CREATE TABLE xpc_authors (
aid varchar(30) NOT NULL,
name varchar(50),
url varchar(60),
email varchar(60),
pwd varchar(13),
counter int(11) DEFAULT '0' NOT NULL,
_read tinyint(2) DEFAULT '0' NOT NULL,
_edit tinyint(2) DEFAULT '0' NOT NULL,
_delete tinyint(2) DEFAULT '0' NOT NULL,
_create tinyint(2) DEFAULT '0' NOT NULL,
master tinyint(2) DEFAULT '1' NOT NULL,
PRIMARY KEY (aid)
);
# -----------------------------------------------------
---
#
# Table structure for table 'xpc_backups'
#
CREATE TABLE xpc_backups (
lid int(11) DEFAULT '0' NOT NULL,
cid int(11) DEFAULT '0' NOT NULL,
sid int(11) DEFAULT '0' NOT NULL,
title varchar(100) NOT NULL,
url varchar(100) NOT NULL,
description blob NOT NULL,
date datetime,
name varchar(60) NOT NULL,
email varchar(60) NOT NULL,
hits int(11) DEFAULT '0' NOT NULL,
version decimal(3,1) DEFAULT '0.0',
changelog varchar(225) NOT NULL,
tstamp timestamp(14),
pagemode enum('HTML','PHP','BODY') DEFAULT 'HTML'
NOT NULL,
state int(11) DEFAULT '0' NOT NULL,
tpl varchar(100) NOT NULL,
aid int(11) DEFAULT '0' NOT NULL
);
# -----------------------------------------------------
---
#
# Table structure for table 'xpc_links_directories'
#
CREATE TABLE xpc_links_directories (
cid int(11) NOT NULL auto_increment,
title varchar(50) NOT NULL,
cdescription text NOT NULL,
state int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (cid)
);
# -----------------------------------------------------
---
#
# Table structure for table 'xpc_links_links'
#
CREATE TABLE xpc_links_links (
lid int(11) NOT NULL auto_increment,
cid int(11) DEFAULT '0' NOT NULL,
sid int(11) DEFAULT '0' NOT NULL,
title varchar(100) NOT NULL,
url varchar(100) NOT NULL,
description blob NOT NULL,
date datetime,
name varchar(60) NOT NULL,
email varchar(60) NOT NULL,
hits int(11) DEFAULT '0' NOT NULL,
version decimal(3,1) DEFAULT '0.0',
changelog varchar(225) NOT NULL,
tstamp timestamp(14),
pagemode enum('HTML','PHP','BODY') DEFAULT 'HTML'
NOT NULL,
state int(11) DEFAULT '0' NOT NULL,
tpl varchar(100) NOT NULL,
PRIMARY KEY (lid)
);
# -----------------------------------------------------
---
#
# Table structure for table 'xpc_links_subdirectories'
#
CREATE TABLE xpc_links_subdirectories (
sid int(11) NOT NULL auto_increment,
cid int(11) DEFAULT '0' NOT NULL,
title varchar(50) NOT NULL,
state int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (sid)
);
# -----------------------------------------------------
---
#
# Table structure for table 'xpc_secure'
#
CREATE TABLE xpc_secure (
id int(10) unsigned NOT NULL auto_increment,
lid int(11) DEFAULT '0' NOT NULL,
aid varchar(100) NOT NULL,
url varchar(225),
_read tinyint(1) unsigned DEFAULT '0' NOT NULL,
_write tinyint(1) unsigned DEFAULT '0' NOT NULL,
_admin tinyint(1) unsigned DEFAULT '0' NOT NULL,
_create tinyint(1) unsigned DEFAULT '0' NOT NULL,
state int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
UNIQUE lid (lid),
KEY aid (aid),
KEY url (url)
);
Logged In: YES
user_id=235543
The xpc prefix in front of all tables is $prefix variable
that is dependent on the attached domain config file of the
specific XPC instance that is running.