CallSite Server Installation
 
 

Section: II. C. 2

Default Database Tables

Table structure for table 'Ads':

# Table structure for table 'Ads'
# CREATE TABLE Ads (
Ad_ID bigint(15) DEFAULT '0' NOT NULL auto_increment,
Ad_type tinyint(4) DEFAULT '0' NOT NULL,
Image_url varchar(255) DEFAULT '0' NOT NULL,
Link_url varchar(255) DEFAULT '0' NOT NULL,
Disp_time tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (Ad_ID),
KEY Ad_type (Ad_type)
);

 

Dumping data for table 'Ads' :

# Dumping data for table 'Ads'
#
LOCK TABLES Ads WRITE;
INSERT INTO Ads VALUES (NULL,1,'http://www.netdive.com/wemessage/applet/images/adds/ss.gif','http://www.netdive.com/indexss.htm',5),
(NULL,1,'http://www.netdive.com/wemessage/applet/images/adds/cs.gif','http://www.netdive.com/indexcs.htm',8),
(NULL,1,'http://www.netdive.com/wemessage/applet/images/adds/ea.gif','http://www.netdive.com/indexea.htm',5),
(NULL,2,'http://www.netdive.com/wemessage/applet/images/adds/netdive-sq.gif','http://www.netdive.com',0),
(NULL,2,'http://www.netdive.com/wemessage/applet/images/adds/wemessage-sq.gif','http://www.wemessage.com',0),
(NULL,2,'http://www.netdive.com/wemessage/applet/images/adds/eaudo-sq.gif','http://www.netdive.com/indexea.htm',0);
UNLOCK TABLES;

 

Table structure for table 'Chat_Servers' :

#Table structure for table 'Chat_Servers'
#
CREATE TABLE Chat_Servers (
Server_ID int(10) DEFAULT '0' NOT NULL auto_increment,
Server_address text NOT NULL,
PRIMARY KEY (Server_ID)
);

 

Table structure for table 'Html_Panels' :

#Table structure for table 'Html_Panels'
# CREATE TABLE Html_Panels (
Panel_ID int(10) DEFAULT '0' NOT NULL auto_increment,
Title varchar(255) DEFAULT '0' NOT NULL,
Page_url varchar(255) DEFAULT '0' NOT NULL,
Edit_url varchar(255) DEFAULT '0' NOT NULL,
PRIMARY KEY (Panel_ID),
UNIQUE Title (Title)
);

 

Table structure for table 'Scroll_Texts' :

#Table structure for table 'Scroll_Texts'
#
CREATE TABLE Scroll_Texts (
Scroll_ID bigint(14) DEFAULT '0' NOT NULL auto_increment,
ScrollText varchar(255) DEFAULT '' NOT NULL,
ScrollText_url varchar(255) DEFAULT '' NOT NULL,
ScrollText_color varchar(15) DEFAULT '' NOT NULL,
PRIMARY KEY (Scroll_ID)
);

 

Dumping data for table 'Scroll_Texts' :

# Dumping data for table 'Scroll_Texts'
#
LOCK TABLES Scroll_Texts WRITE;
INSERT INTO Scroll_Texts VALUES
(NULL,'Visit the NetDIVE website now - NetDIVE, enabling e-business success','http://www.netdive.com','255:0:0'),
(NULL,'WeMessage, the ultimate instant messenger','http://www.netdive.com/indexwm.htm','0:50:100'),
(NULL,'SiteSticky, build your online community','http://www.netdive.com/indexss.htm','0:100:100');
UNLOCK TABLES;

 

Table structure for table 'Users' :

#Table structure for table 'Users'
#
CREATE TABLE Users (
User_ID int(10) DEFAULT '0' NOT NULL auto_increment,
Nickname varchar(50) DEFAULT '' NOT NULL,
Password varchar(20) DEFAULT '' NOT NULL,
Admin tinyint(4) DEFAULT '0' NOT NULL,
AcceptVoice tinyint(4) DEFAULT '1' NOT NULL,
AcceptPlugins tinyint(4) DEFAULT '1' NOT NULL,
Sound tinyint(4) DEFAULT '1' NOT NULL,
Away tinyint(4) DEFAULT '0' NOT NULL,
Avatar varchar(255) DEFAULT '' NOT NULL,
Invisible tinyint(4) DEFAULT '0' NOT NULL,
First varchar(30) DEFAULT '' NOT NULL,
Last varchar(30) DEFAULT '' NOT NULL,
Email varchar(60) DEFAULT '' NOT NULL,
Homepage varchar(80) DEFAULT '' NOT NULL,
Age tinyint(4) DEFAULT '0' NOT NULL,
Gender tinyint(4) DEFAULT '0' NOT NULL,
Comments varchar(255) DEFAULT '' NOT NULL,
Register_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
Notify_list text,
Bookmarks text,
Ignore_list text,
BlockProfile tinyint(4) DEFAULT '0' NOT NULL,
Company varchar(40) DEFAULT 'NA' NOT NULL,
Addr1 varchar(100) DEFAULT '' NOT NULL,
Addr2 varchar(100) DEFAULT '' NOT NULL,
City varchar(40) DEFAULT 'NA' NOT NULL,
State varchar(40) DEFAULT 'NA' NOT NULL,
Country varchar(50) DEFAULT 'NA' NOT NULL,
Phone varchar(100) DEFAULT 'NA' NOT NULL,
Searchable tinyint(4) DEFAULT '1' NOT NULL,
PRIMARY KEY (User_ID),
UNIQUE Nickname (Nickname)
);