#Sql120640_5 # File: createdb.sql # Script Name: vList Lite 1.1 # Author: Vincent Ryan Ong # Email: support@beanbug.net # # Description: # vList Lite is a simple mailing list management system. The script lets # visitors of your site join your mailing list. As list administrator, # you have the option to send Text or HTML messages to everyone in the list. # Just like the other vScripts collection, this script includes a flexible # design, subscribers, and message sending administration. Members can also # unsubscribe through an unsubscribe form. # # This script is a freeware but if you want to give donations, # please send your checks (coz cash will probably be stolen in the # post office) them to: # # Vincent Ryan Ong # Rm. 440 Wellington Bldg. # 655 Condesa St. Binondo, Manila # Philippines, 1006 # # Table structure for table `listdesign` # CREATE TABLE listdesign ( id tinyint(4) NOT NULL auto_increment, sAlignment varchar(6) NOT NULL default '', sWidth int(11) NOT NULL default '0', sWidthMeasure varchar(7) NOT NULL default '', sBorderSize int(11) NOT NULL default '0', sBorderColor varchar(6) NOT NULL default '', hTitle varchar(30) NOT NULL default '', hBold char(1) NOT NULL default '', hAlignment varchar(6) NOT NULL default '', hBackColor varchar(6) NOT NULL default '', hFont varchar(40) NOT NULL default '', hFontColor varchar(6) NOT NULL default '', hFontSize tinyint(4) NOT NULL default '0', bAlignment varchar(6) NOT NULL default '', bBackColor varchar(6) NOT NULL default '', bBold char(1) NOT NULL default '', bText varchar(200) NOT NULL default '', bFont varchar(40) NOT NULL default '', bFontColor varchar(6) NOT NULL default '', bFontSize tinyint(4) NOT NULL default '0', fMaxChar smallint(6) NOT NULL default '0', fFieldLength smallint(6) NOT NULL default '0', fButtonText varchar(15) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; # # Dumping data for table `listdesign` # INSERT INTO listdesign VALUES ('1', 'center', 30, '%', 1, '000000', 'Quick Join', 'y', 'center', 'CCCCCC', 'Verdana', '000000', '2', 'left', 'FFFFFF', 'n', 'graziella.gazzoni@fastwebnet.it', 'Verdana', '000000', '2', 50, 35, 'Subscribe'); # -------------------------------------------------------- # # Table structure for table `listsubscribers` # CREATE TABLE listsubscribers ( id bigint(20) NOT NULL auto_increment, email varchar(60) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; # # Dumping data for table `listsubscribers` #