Location: PHPKode > scripts > Free Regional Directory Script > free-regional-directory-script/include/regional_tables.php
<?php
/**
# ################################################################################
# Project:   Regional Directory Script
#
# **********************************************************************
# Copyright (C) 2007 NetCreated, Inc. (http://www.netcreated.com/)
#
# This software is for use only to those who have purchased a license.
# A license must be purchased for EACH installation of the software.
#
# By using the software you agree to the terms:
#
#    - You may not redistribute, sell or otherwise share this software
#      in whole or in part without the consent of the the ownership
#      of PHP Link Directory. Please contact hide@address.com
#      if you need more information.
#
#    - You agree to retain a link back to http://www.regionaldirectory.org/
#      on all pages of your directory if you purchased the $10 version
#      of the software. You must pay a total of $60 to remove the link back.
#
#
#  In some cases, license holders may be required to agree to changes
#  in the software license before receiving updates to the software.
# **********************************************************************
#
#  For questions, help, comments, discussion, etc., please join the
#  Forum http://www.phplinkdirectory.com/forum/forumdisplay.php?f=16
#
#  @link           http://www.regionaldirectory.org/
#  @copyright      2004-2007 NetCreated, Inc. (http://www.netcreated.com/)
#  @projectManager David DuVal <hide@address.com>
#  @package        Regional Directory
#  @version        2.1.2
# ################################################################################
*/



 $tables['config'] = array (
   'name'   => TABLE_PREFIX.'CONFIG'                ,
   'fields' => array (
      'ID'    => 'C(255) KEY'                       ,
      'VALUE' => 'C(255) NULL'
   ),
   'data' => array (
      array ('ID' => 'SITE_NAME'                , 'VALUE' => 'Site Name'                  ),
      array ('ID' => 'SITE_URL'                 , 'VALUE' => 'http://www.yourdomain.com/' ),
      array ('ID' => 'SITE_DESC'                , 'VALUE' => 'Site description'           ),
      array ('ID' => 'LINKS_PER_PAGE'           , 'VALUE' => '20'                         ),
      array ('ID' => 'MAILS_PER_PAGE'           , 'VALUE' => '20'                         ),
      array ('ID' => 'VISUAL_CONFIRM'           , 'VALUE' => '1'                          ),
      array ('ID' => 'REQUIRE_RECIPROCAL'       , 'VALUE' => '0'                          ),
      array ('ID' => 'ALLOW_MULTIPLE'           , 'VALUE' => '1'                          ),
	  array ('ID' => 'REGS_PER_ROW'             , 'VALUE' => '2'                          ),
      array ('ID' => 'CATS_PER_ROW'             , 'VALUE' => '2'                          ),
      array ('ID' => 'ENABLE_REWRITE'           , 'VALUE' => '0'                          ),
      array ('ID' => 'VERSION'                  , 'VALUE' => CURRENT_VERSION              ),
      array ('ID' => 'RECPR_NOFOLLOW'           , 'VALUE' => '1'                          ),
      array ('ID' => 'EMAIL_METHOD'             , 'VALUE' => 'mail'                       ),
      array ('ID' => 'EMAIL_SERVER'             , 'VALUE' => 'localhost'                  ),
      array ('ID' => 'EMAIL_USER'               , 'VALUE' => ''                           ),
      array ('ID' => 'EMAIL_PASS'               , 'VALUE' => ''                           ),
      array ('ID' => 'EMAIL_SENDMAIL'           , 'VALUE' => '/usr/bin/sendmail'          ),
      array ('ID' => 'REGS_PREVIEW'             , 'VALUE' => '3'                          ),
	  array ('ID' => 'CATS_PREVIEW'             , 'VALUE' => '3'                          ),
      array ('ID' => 'CATS_COUNT'               , 'VALUE' => '1'                          ),
      array ('ID' => 'DIRECTORY_TITLE'          , 'VALUE' => 'Directory'                  ),
      array ('ID' => 'ENABLE_RSS'               , 'VALUE' => '1'                          ),
      array ('ID' => 'ENABLE_PAGERANK'          , 'VALUE' => '1'                          ),
      array ('ID' => 'DEBUG'                    , 'VALUE' => '0'                          ),
      array ('ID' => 'SHOW_PAGERANK'            , 'VALUE' => '1'                          ),
      array ('ID' => 'DEFAULT_SORT'             , 'VALUE' => 'P'                          ),
      array ('ID' => 'ENABLE_NEWS'              , 'VALUE' => '1'                          ),
      array ('ID' => 'ADMIN_LANG'               , 'VALUE' => 'en'                         ),
      array ('ID' => 'FRONTEND_LANG'            , 'VALUE' => 'en'                         ),
      array ('ID' => 'LINKS_TOP'                , 'VALUE' => '20'                         ),
      array ('ID' => 'NTF_SUBMIT_TPL'           , 'VALUE' => ''                           ),
      array ('ID' => 'NTF_APPROVE_TPL'          , 'VALUE' => ''                           ),
      array ('ID' => 'NTF_REJECT_TPL'           , 'VALUE' => ''                           ),
      array ('ID' => 'NTF_PAYMENT_TPL'          , 'VALUE' => ''                           ),
      array ('ID' => 'FTR_ENABLE'               , 'VALUE' => '0'                          ),
      array ('ID' => 'FTR_MAX_LINKS'            , 'VALUE' => '5'                          ),
      array ('ID' => 'PAY_ENABLE'               , 'VALUE' => '0'                          ),
      array ('ID' => 'PAY_UM'                   , 'VALUE' => '0'                          ),
      array ('ID' => 'PAY_NORMAL'               , 'VALUE' => '0'                          ),
      array ('ID' => 'PAY_FEATURED'             , 'VALUE' => '0'                          ),
      array ('ID' => 'PAY_RECPR'                , 'VALUE' => '0'                          ),
      array ('ID' => 'PAY_AUTO_ACCEPT'          , 'VALUE' => ''                           ),
      array ('ID' => 'PAY_ENABLE_FREE'          , 'VALUE' => '0'                          ),
      array ('ID' => 'PAYPAL_ENABLE'            , 'VALUE' => '0'                          ),
      array ('ID' => 'PAYPAL_ACCOUNT'           , 'VALUE' => ''                           ),
      # Pager Mod
      array ('ID' => 'PAGER_LPP'                , 'VALUE' => '20'                         ),
      array ('ID' => 'PAGER_GROUPINGS'          , 'VALUE' => '20'                         ),
      # Links open in blank window
      array ('ID' => 'ENABLE_BLANK'             , 'VALUE' => '0'                          ),
   )
 );

 $tables['link'] = array (
   'name'   => TABLE_PREFIX.'LINK'                  ,
   'fields' => array (
      'ID'                 	=> 'I KEY AUTO'          ,
      'TITLE'              	=> 'C(255) NOTNULL'      ,
      'DESCRIPTION'        	=> 'X2 NULL'             ,
      'URL'                	=> 'C(255) NOTNULL'      ,
      'CATEGORY_ID'        	=> 'I NOTNULL'           ,
	  'REGIONAL_CATEGORY_ID'=> 'I NOTNULL'           ,
      'RECPR_URL'          	=> 'C(255) NULL'         ,
      'RECPR_REQUIRED'     	=> 'L NOTNULL DEFAULT 0' ,
      'STATUS'             	=> 'I NOTNULL DEFAULT 0' ,
      'VALID'              	=> 'L NOTNULL DEFAULT 0' ,
      'RECPR_VALID'        	=> 'L NOTNULL DEFAULT 0' ,
      'OWNER_ID'           	=> 'I NULL'              ,
      'OWNER_NAME'         	=> 'C(255) NULL'         ,
      'OWNER_EMAIL'        	=> 'C(255) NULL'         ,
      'OWNER_NOTIF'        	=> 'I NOTNULL DEFAULT 0' ,
      'DATE_MODIFIED'      	=> 'T DEFDATE'           ,
      'DATE_ADDED'         	=> 'T DEFDATE'           ,
      'HITS'               	=> 'I NOTNULL DEFAULT 0' ,
      'LAST_CHECKED'       	=> 'T'                   ,
      'RECPR_LAST_CHECKED' 	=> 'T'                   ,
      'PAGERANK'           	=> 'I NOTNULL DEFAULT -1',
      'RECPR_PAGERANK'     	=> 'I NOTNULL DEFAULT -1',
      'FEATURED_MAIN'      	=> 'I NOTNULL DEFAULT 0' ,
      'FEATURED'           	=> 'I NOTNULL DEFAULT 0' ,
      'EXPIRY_DATE'        	=> 'T'                   ,
      'NOFOLLOW'           	=> 'L NOTNULL DEFAULT 0' ,
      'PAYED'              	=> 'I NOTNULL DEFAULT -1',
	  'LINK_TYPE'          	=> 'I NOTNULL DEFAULT 0' ,
	  'IPADDRESS'          	=> 'C(15) NULL'
   ),
   'indexes' => array (
      'TITLE'              => 'TITLE'                               ,
      'DESCRIPTION'        => array ('DESCRIPTION'     , 'FULLTEXT'),
      'URL'                => 'URL'                                 ,
      'CATEGORY_ID'        => 'CATEGORY_ID'                         ,
      'STATUS_CATEGORY_ID' => 'STATUS, CATEGORY_ID'                 ,
      'HITS'               => 'HITS'                                ,
      'FEATURED'           => 'FEATURED'                            ,
      'EXPIRY_DATE'        => 'EXPIRY_DATE'
   )
 );

 $tables['regional_category'] = array (
   'name'   => TABLE_PREFIX.'REGIONAL_CATEGORY'              ,
   'fields' => array (
      'ID'               => 'I KEY AUTO'            ,
      'TITLE'            => 'C(255) NOTNULL'        ,
      'TITLE_URL'        => 'C(255) NULL'           ,
      'DESCRIPTION'      => 'X2 NULL'               ,
      'PARENT_ID'        => 'I NOTNULL'             ,
      'STATUS'           => 'I NOTNULL DEFAULT 1'   ,
      'DATE_ADDED'       => 'T DEFDATE'             ,
      'HITS'             => 'I NOTNULL DEFAULT 0'   ,
      'SYMBOLIC'         => 'I NOTNULL DEFAULT 0'   ,
      'SYMBOLIC_ID'      => 'I NOTNULL DEFAULT 0'
   ),
   'indexes' => array (
      'TITLE'            => 'TITLE'                               ,
      'TITLE_URL'        => 'TITLE_URL'                           ,
      'DESCRIPTION'      => array ('DESCRIPTION'     , 'FULLTEXT'),
      'PARENT_ID'        => 'PARENT_ID'                           ,
      'STATUS'           => 'STATUS'                              ,
      'HITS'             => 'HITS'
   )
 );
?>
Return current item: Free Regional Directory Script