-- 
-- NOTE: This file is given for refrence purposes only 
-- Please install the database using the admin/install.php script.
---
--- ################################################################
-- Table structure for table `banners`
-- 

CREATE TABLE "banners" (
  "banner_id" int(11) NOT NULL auto_increment,
  "grid_width" int(11) NOT NULL default '0',
  "grid_height" int(11) NOT NULL default '0',
  "days_expire" mediumint(9) default '0',
  "price_per_block" float NOT NULL default '0',
  "name" varchar(255) NOT NULL default '',
  "currency" char(3) NOT NULL default 'USD',
  "publish_date" datetime default NULL,
  "max_orders" int(11) NOT NULL default '0',
  PRIMARY KEY  ("banner_id")
) AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `banners`
-- 

INSERT INTO `banners` VALUES (1, 100, 100, 0, 100, 'Million Pixels. (1000x1000)', 'USD', '0000-00-00 00:00:00', 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `blocks`
-- 

CREATE TABLE "blocks" (
  "block_id" int(11) NOT NULL default '0',
  "user_id" int(11) default NULL,
  "status" set('reserved','sold','free','ordered','nfs') NOT NULL default '',
  "x" int(11) NOT NULL default '0',
  "y" int(11) NOT NULL default '0',
  "image_data" text NOT NULL,
  "url" varchar(255) NOT NULL default '',
  "alt_text" text NOT NULL,
  "file_name" varchar(255) NOT NULL default '',
  "mime_type" varchar(100) NOT NULL default '',
  "approved" set('Y','N') NOT NULL default '',
  "published" set('Y','N') NOT NULL default '',
  "currency" char(3) NOT NULL default 'USD',
  "order_id" int(11) NOT NULL default '0',
  "price" float default NULL,
  "banner_id" int(11) NOT NULL default '1',
  "click_count" int(11) NOT NULL default '0',
  PRIMARY KEY  ("block_id","banner_id")
);

-- 
-- Dumping data for table `blocks`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `clicks`
-- 

CREATE TABLE "clicks" (
  "banner_id" int(11) NOT NULL default '0',
  "block_id" int(11) NOT NULL default '0',
  "user_id" int(11) NOT NULL default '0',
  "date" date NOT NULL default '0000-00-00',
  "clicks" int(11) NOT NULL default '0',
  PRIMARY KEY  ("banner_id","block_id","date")
);

-- 
-- Dumping data for table `clicks`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `config`
-- 

CREATE TABLE "config" (
  "key" varchar(255) NOT NULL default '',
  "val" varchar(255) NOT NULL default '',
  PRIMARY KEY  ("key")
);

-- 
-- Dumping data for table `config`
-- 

INSERT INTO `config` VALUES ('EXPIRE_RUNNING', 'NO');
INSERT INTO `config` VALUES ('LAST_EXPIRE_RUN', '1139580725');
INSERT INTO `config` VALUES ('SELECT_RUNNING', 'NO');

-- --------------------------------------------------------

-- 
-- Table structure for table `currencies`
-- 

CREATE TABLE "currencies" (
  "code" char(3) NOT NULL default '',
  "name" varchar(50) NOT NULL default '',
  "rate" decimal(10,4) NOT NULL default '1.0000',
  "is_default" set('Y','N') NOT NULL default 'N',
  "sign" varchar(8) NOT NULL default '',
  "decimal_places" smallint(6) NOT NULL default '0',
  "decimal_point" char(3) NOT NULL default '',
  "thousands_sep" char(3) NOT NULL default '',
  PRIMARY KEY  ("code")
);

-- 
-- Dumping data for table `currencies`
-- 

INSERT INTO `currencies` VALUES ('AUD', 'Australian Dollar', 1.3630, 'N', '$', 2, '.', ',');
INSERT INTO `currencies` VALUES ('CAD', 'Canadian Dollar', 1.1888, 'N', '$', 2, '.', ',');
INSERT INTO `currencies` VALUES ('EUR', 'Euro', 0.8498, 'N', '€', 2, '.', ',');
INSERT INTO `currencies` VALUES ('GBP', 'British Pound', 0.5739, 'N', '£', 2, '.', ',');
INSERT INTO `currencies` VALUES ('JPY', 'Japanese Yen', 117.2750, 'N', '¥', 0, '.', ',');
INSERT INTO `currencies` VALUES ('USD', 'U.S. Dollar', 1.0000, 'Y', '$', 2, '.', ',');

-- --------------------------------------------------------

-- 
-- Table structure for table `lang`
-- 

CREATE TABLE "lang" (
  "lang_code" char(2) NOT NULL default '',
  "lang_filename" varchar(32) NOT NULL default '',
  "lang_image" varchar(32) NOT NULL default '',
  "is_active" set('Y','N') NOT NULL default '',
  "name" varchar(32) NOT NULL default '',
  "charset" varchar(32) NOT NULL default '',
  "image_data" text NOT NULL,
  "mime_type" varchar(255) NOT NULL default '',
  "is_default" char(1) NOT NULL default 'N',
  PRIMARY KEY  ("lang_code")
);

-- 
-- Dumping data for table `lang`
-- 

INSERT INTO `lang` VALUES ('EN', 'english.php', 'english.gif', 'Y', 'English', '', 'R0lGODlhGQARAMQAAAURdBYscgNNfrUOEMkMBdAqE9UTMtItONNUO9w4SdxmaNuObhYuh0Y5lCxVlFJcpqN2ouhfjLCrrOeRmeHKr/Wy3Lje4dPW3PDTz9/q0vXm1ffP7MLt5/f0+AAAAAAAACwAAAAAGQARAAAF02AAMIDDkOgwEF3gukCZIICI1jhFDRmOS4dF50aMVSqEjehFIWQ2kJLUMRoxCCsNzDFBZDCuh1RMpQY6HZYIiOlIYqKy9JZIqHeZTqMWnvoZCgosCkIXDoeIAGJkfmgEB3UHkgp1dYuKVWJXWCsEnp4qAwUcpBwWphapFhoanJ+vKxOysxMRgbcDHRlfeboZF2mvwp+5Eh07YC9naMzNzLmKuggTDy8G19jZ2NAiFB0LBxYuC+TlC7Syai8QGU0TAs7xaNxLDLoDdsPDuS98ABXfQgAAOw==', 'image/gif', 'Y');

-- --------------------------------------------------------

-- 
-- Table structure for table `mail_queue`
-- 

CREATE TABLE "mail_queue" (
  "mail_id" int(11) NOT NULL auto_increment,
  "mail_date" datetime NOT NULL default '0000-00-00 00:00:00',
  "to_address" varchar(128) NOT NULL default '',
  "to_name" varchar(128) NOT NULL default '',
  "from_address" varchar(128) NOT NULL default '',
  "from_name" varchar(128) NOT NULL default '',
  "subject" varchar(255) NOT NULL default '',
  "message" text NOT NULL,
  "html_message" text NOT NULL,
  "attachments" set('Y','N') NOT NULL default '',
  "status" set('queued','sent','error') NOT NULL default '',
  "error_msg" varchar(255) NOT NULL default '',
  "retry_count" smallint(6) NOT NULL default '0',
  "template_id" int(11) NOT NULL default '0',
  "att1_name" varchar(128) NOT NULL default '',
  "att2_name" varchar(128) NOT NULL default '',
  "att3_name" varchar(128) NOT NULL default '',
  "date_stamp" datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  ("mail_id")
) AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `mail_queue`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `orders`
-- 

CREATE TABLE "orders" (
  "user_id" int(11) NOT NULL default '0',
  "order_id" int(11) NOT NULL auto_increment,
  "blocks" text NOT NULL,
  "status" set('pending','completed','cancelled','confirmed','new','expired','deleted') NOT NULL default '',
  "order_date" datetime NOT NULL default '0000-00-00 00:00:00',
  "price" float NOT NULL default '0',
  "quantity" int(11) NOT NULL default '0',
  "banner_id" int(11) NOT NULL default '1',
  "currency" char(3) NOT NULL default 'USD',
  "days_expire" int(11) NOT NULL default '0',
  "date_published" datetime default NULL,
  "date_stamp" datetime default NULL,
  "package_id" int(11) NOT NULL default '0',
  "expiry_notice_sent" set('Y','N') NOT NULL default '',
  PRIMARY KEY  ("order_id")
) AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `orders`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `packages`
-- 

CREATE TABLE "packages" (
  "banner_id" int(11) NOT NULL default '0',
  "days_expire" int(11) NOT NULL default '0',
  "price" float NOT NULL default '0',
  "currency" char(3) NOT NULL default '',
  "package_id" int(11) NOT NULL auto_increment,
  "is_default" set('Y','N') default NULL,
  PRIMARY KEY  ("package_id")
) AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `packages`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `prices`
-- 

CREATE TABLE "prices" (
  "price_id" int(11) NOT NULL auto_increment,
  "banner_id" int(11) NOT NULL default '0',
  "row_from" int(11) NOT NULL default '0',
  "row_to" int(11) NOT NULL default '0',
  "block_id_from" int(11) NOT NULL default '0',
  "block_id_to" int(11) NOT NULL default '0',
  "price" float NOT NULL default '0',
  "currency" char(3) NOT NULL default '',
  "color" varchar(50) NOT NULL default '',
  "col_from" int(11) default NULL,
  "col_to" int(11) default NULL,
  PRIMARY KEY  ("price_id")
) AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `prices`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `transactions`
-- 

CREATE TABLE "transactions" (
  "transaction_id" int(11) NOT NULL auto_increment,
  "date" datetime NOT NULL default '0000-00-00 00:00:00',
  "order_id" int(11) NOT NULL default '0',
  "type" varchar(32) NOT NULL default '',
  "amount" float NOT NULL default '0',
  "currency" char(3) NOT NULL default '',
  "txn_id" varchar(128) NOT NULL default '',
  "reason" varchar(64) NOT NULL default '',
  "origin" varchar(32) NOT NULL default '',
  PRIMARY KEY  ("transaction_id")
) AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `transactions`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `users`
-- 

CREATE TABLE "users" (
  "ID" int(11) NOT NULL auto_increment,
  "IP" varchar(50) NOT NULL default '',
  "SignupDate" datetime NOT NULL default '0000-00-00 00:00:00',
  "FirstName" varchar(50) NOT NULL default '',
  "LastName" varchar(50) NOT NULL default '',
  "Rank" int(11) NOT NULL default '1',
  "Username" varchar(50) NOT NULL default '',
  "Password" varchar(50) NOT NULL default '',
  "Email" varchar(255) NOT NULL default '',
  "Newsletter" int(11) NOT NULL default '1',
  "Notification1" int(11) NOT NULL default '0',
  "Notification2" int(11) NOT NULL default '0',
  "Aboutme" longtext NOT NULL,
  "Validated" int(11) NOT NULL default '0',
  "CompName" varchar(255) NOT NULL default '',
  "login_date" datetime NOT NULL default '0000-00-00 00:00:00',
  "logout_date" datetime NOT NULL default '0000-00-00 00:00:00',
  "login_count" int(11) NOT NULL default '0',
  "last_request_time" datetime NOT NULL default '0000-00-00 00:00:00',
  "click_count" int(11) NOT NULL default '0',
  PRIMARY KEY  ("ID"),
  UNIQUE KEY "Username" ("Username")
) AUTO_INCREMENT=1 ;