PHP Classes

File: server/db.mysql.sql

Recommend this page to a friend!
  Classes of Oliver Lillie   PADL (PHP Application Distribution License System)   server/db.mysql.sql   Download  
File: server/db.mysql.sql
Role: Auxiliary data
Content type: text/plain
Description: License Server SQL
Class: PADL (PHP Application Distribution License System)
Generate PHP application license keys
Author: By
Last change: DB Update
Date: 18 years ago
Size: 2,442 bytes
 

Contents

Class file image Download
# CocoaMySQL dump # Version 0.5 # http://cocoamysql.sourceforge.net # # Host: localhost (MySQL 4.0.21 Complete MySQL by Server Logistics) # Database: audit # Generation Time: 2005-06-20 23:03:50 +0100 # ************************************************************ # Dump of table licenses # ------------------------------------------------------------ DROP TABLE IF EXISTS `licenses`; CREATE TABLE `licenses` ( `LICENSE_ID` int(11) NOT NULL auto_increment, `USER_ID` int(11) default NULL, `FLAGGED` tinyint(1) default NULL, `STATUS` varchar(255) default NULL, `START_DATE` int(11) default NULL, `DATE_SPAN` int(11) default NULL, `EXPIRY_DATE` int(11) default NULL, `NOTES` text, `COST` int(11) default NULL, `PAID` tinyint(1) default NULL, `REQUEST_KEY` text, `TEMP_KEY` text, `LICENSE_KEY` text, `PAYMENT_NEXT_DUE` int(11) default NULL, `DATA` text, `MAC` varchar(255) default NULL, `PATH` text, `IP` int(11) default NULL, PRIMARY KEY (`LICENSE_ID`) ) TYPE=MyISAM; # Dump of table remote_log # ------------------------------------------------------------ DROP TABLE IF EXISTS `remote_log`; CREATE TABLE `remote_log` ( `ID` int(11) NOT NULL auto_increment, `FLAGGED` tinyint(1) default NULL, `TIMESTAMP` int(20) NOT NULL default '0', `LICENSE_ID` int(10) NOT NULL default '0', `MESSAGE` varchar(255) NOT NULL default '', `SERVER` text NOT NULL, `IP` varchar(22) NOT NULL default '', `NOTES` text, PRIMARY KEY (`ID`) ) TYPE=MyISAM; # Dump of table users # ------------------------------------------------------------ DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `ID` int(11) NOT NULL auto_increment, `FLAGGED` tinyint(1) default NULL, `USERNAME` varchar(255) default NULL, `EMAIL` varchar(255) default NULL, `QUESTION` text, `ANSWER` varchar(255) default NULL, `FIRSTNAME` varchar(255) default NULL, `LASTNAME` varchar(255) default NULL, `COMPANY` varchar(255) default NULL, `ADDRESS_1` varchar(255) default NULL, `ADDRESS_2` varchar(255) default NULL, `ADDRESS_3` varchar(255) default NULL, `COUNTY` varchar(255) default NULL, `POSTCODE` varchar(255) default NULL, `COUNTRY` varchar(255) default NULL, `NOTES` text, `RESELLER` tinyint(1) default NULL, `STATUS` varchar(255) default NULL, `HISTORY` text, PRIMARY KEY (`ID`) ) TYPE=MyISAM;