/editor/install.php
PHP | 90 lines | 2 code | 1 blank | 87 comment | 0 complexity | 047d9644c7efee0b8ed24d61a99d020d MD5 | raw file
- <?php
-
- #####################
- # #
- # Database Installation #
- # #
- #####################
- /*
- require_once("config.php");
- require_once('functions.php');
-
-
-
- ################# ADD USERS #################
-
- // USERS
- mysql_query("CREATE TABLE users (
- id BIGINT(20) NOT NULL AUTO_INCREMENT,
- tabs_limit VARCHAR(3),
- user_active VARCHAR(1),
- fb_id BIGINT(20),
- name VARCHAR(200),
- first_name VARCHAR(200),
- last_name VARCHAR(200),
- link VARCHAR(200),
- username VARCHAR(200),
- hometown VARCHAR(50),
- location VARCHAR(50),
- gender VARCHAR(6),
- email VARCHAR(50),
- timezone VARCHAR(2),
- locale VARCHAR(10),
- verified TINYINT(1) NOT NULL DEFAULT '0',
- updated_time VARCHAR(30),
- PRIMARY KEY (id)
- ) ".MYENGINE.", ".MYCHARSET.";");
-
- // ADD ADMIN - ENTER FACEBOOK INFO
- mysql_query("INSERT INTO users VALUES ( 0,
- '".TABS_PER_PAGE."',
- '1',
- '848520331',
- 'Muhammad Nouman',
- 'Muhammad',
- 'Nouman',
- 'http://www.facebook.com/Nouman11',
- 'Nouman11',
- 'Lahore, Pakistan',
- 'Lahore, Pakistan',
- 'male',
- 'nouman915@gmail.com',
- '5',
- 'en_US',
- '1',
- '2012-02-07T18:17:53+0000'
- );") or exit( mysql_error() );
-
-
-
- ################# ADD PAGES #################
-
- // PAGES
- mysql_query("CREATE TABLE pages (
- id BIGINT(20) NOT NULL AUTO_INCREMENT,
- user_id BIGINT(20),
- fan_page_id BIGINT(20),
- app_id BIGINT(20),
- parent_id BIGINT(20) NOT NULL DEFAULT '0',
- type VARCHAR(20),
- name VARCHAR(200),
- content_nonfans LONGTEXT,
- content_fans LONGTEXT,
- content_contest_fans LONGTEXT,
- content_contest_form LONGTEXT,
- content_contest_ugc_form LONGTEXT,
- content_contest_ugc_gallery LONGTEXT,
- content_contest_thank LONGTEXT,
- contest TINYINT(1) NOT NULL DEFAULT '0',
- ugc TINYINT(1) NOT NULL DEFAULT '0',
- saved TINYINT(1) NOT NULL DEFAULT '0',
- published TINYINT(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (id)
- ) ".MYENGINE.", ".MYCHARSET.";");
-
-
- echo "Database has been successfully installed!";
-
- */
- // документ UTF-8
- ?>