PageRenderTime 97ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 0ms

/editor/install.php

https://bitbucket.org/3tierlogic/3tl.tabbuilder
PHP | 90 lines | 2 code | 1 blank | 87 comment | 0 complexity | 047d9644c7efee0b8ed24d61a99d020d MD5 | raw file
  1. <?php
  2. #####################
  3. # #
  4. # Database Installation #
  5. # #
  6. #####################
  7. /*
  8. require_once("config.php");
  9. require_once('functions.php');
  10. ################# ADD USERS #################
  11. // USERS
  12. mysql_query("CREATE TABLE users (
  13. id BIGINT(20) NOT NULL AUTO_INCREMENT,
  14. tabs_limit VARCHAR(3),
  15. user_active VARCHAR(1),
  16. fb_id BIGINT(20),
  17. name VARCHAR(200),
  18. first_name VARCHAR(200),
  19. last_name VARCHAR(200),
  20. link VARCHAR(200),
  21. username VARCHAR(200),
  22. hometown VARCHAR(50),
  23. location VARCHAR(50),
  24. gender VARCHAR(6),
  25. email VARCHAR(50),
  26. timezone VARCHAR(2),
  27. locale VARCHAR(10),
  28. verified TINYINT(1) NOT NULL DEFAULT '0',
  29. updated_time VARCHAR(30),
  30. PRIMARY KEY (id)
  31. ) ".MYENGINE.", ".MYCHARSET.";");
  32. // ADD ADMIN - ENTER FACEBOOK INFO
  33. mysql_query("INSERT INTO users VALUES ( 0,
  34. '".TABS_PER_PAGE."',
  35. '1',
  36. '848520331',
  37. 'Muhammad Nouman',
  38. 'Muhammad',
  39. 'Nouman',
  40. 'http://www.facebook.com/Nouman11',
  41. 'Nouman11',
  42. 'Lahore, Pakistan',
  43. 'Lahore, Pakistan',
  44. 'male',
  45. 'nouman915@gmail.com',
  46. '5',
  47. 'en_US',
  48. '1',
  49. '2012-02-07T18:17:53+0000'
  50. );") or exit( mysql_error() );
  51. ################# ADD PAGES #################
  52. // PAGES
  53. mysql_query("CREATE TABLE pages (
  54. id BIGINT(20) NOT NULL AUTO_INCREMENT,
  55. user_id BIGINT(20),
  56. fan_page_id BIGINT(20),
  57. app_id BIGINT(20),
  58. parent_id BIGINT(20) NOT NULL DEFAULT '0',
  59. type VARCHAR(20),
  60. name VARCHAR(200),
  61. content_nonfans LONGTEXT,
  62. content_fans LONGTEXT,
  63. content_contest_fans LONGTEXT,
  64. content_contest_form LONGTEXT,
  65. content_contest_ugc_form LONGTEXT,
  66. content_contest_ugc_gallery LONGTEXT,
  67. content_contest_thank LONGTEXT,
  68. contest TINYINT(1) NOT NULL DEFAULT '0',
  69. ugc TINYINT(1) NOT NULL DEFAULT '0',
  70. saved TINYINT(1) NOT NULL DEFAULT '0',
  71. published TINYINT(1) NOT NULL DEFAULT '0',
  72. PRIMARY KEY (id)
  73. ) ".MYENGINE.", ".MYCHARSET.";");
  74. echo "Database has been successfully installed!";
  75. */
  76. // документ UTF-8
  77. ?>