C   %# , #&')*)-0-(0%()(C   (((((((((((((((((((((((((((((((((((((((((((((((((((" @@hC}!Ѱ<" 9iׂIIIHk+?c?*Y!du)bT9вU$8GI.澬DSq q}.d8FهKaKdrFh.]y4 JЛ]KBE$$ $ PR΀G]ui$$'! "#031C/Td=SQ?62Ccj{ ̏dچ/cV`Wz͈{Y`dhL ]OBlomrn s-ڗEZN_1%bHϣV7):ӷ)}~(;!b15K[Evϻ>q.% O(c#x$'+`٥vv(M"vB.a T~ϕhy(6nݱl1yNɓxA R8rqv1.cS+_&@ uM5Ĉ XmeLXqy#9]c}ɄLdeJ몓I1T dCaM$T,X bʭ!%F5X1x#!q\F2&RqCol~̱.0ϦLd`. m{Y~k{C}bv;UcN(ouh6 &Y587E$-']n,@TD\+RyUU^Q,f>1qfU Fڥ>IfNUwu#OMMQ6 N*_ k rS`1:!F'<+ b?O2 !Q12A "3a#$?,7!`yǮ(16w a F#?*"sv>Ⱥfv͑s]GnS ȥpG ыEg)Zx rYq] @f_܃pչEڎّC Ŝ*/ hOSvو\5Uy|oHm2CSBW)5{TW=o*R Aks=Cre?i /ں$beo`ޮGHy;fNAl8.\S"aúFYvNk-*`vkʈ2fEEWa, fF^#;[9^~Y$:0#W3Z*IZڹkn--9=G;7F)m{TɆ=Ȭ55Baڞ5M#m5Ʀm8+Hh$}:&eQ[;i]С::o$<~5RB?s35rOֿwP/̅(Z6R>)N4!ʊwz-rw+ykq1bKhƸ4NӐXQ_})+e15nq?[^9<z3Fsi8')9p){RPZ+*p(aYV6lg9;duNt@3sTwzaŇGTbH(#*zc9Kb1tÊ Z?giDHRB^MvOLD,'dqCP$ΔU֟֊=sF$JދZ?NANWP, ¦򙈉&;xdupiIpd;Dž!ֿѮAb%u}j-p>I[Nbi G';4wm]H]#LӘNNRs.]en -8ePsQ;țEݫ7g_LWEZ:/IagnܤiٹŷTH~ia֎~KV A-2m]F"m9-Z bǰ״ @~4Nxčtl>u#rgѐ3;M9<J1vfL8׋1PHgPXv{O}nKQ؋7bX4<`Y7siV)s:{rOhz @4VWB&ɡob܋F4>ysfXWSNO$,.u:ԫgyao4$hD#ٸf^kh7#1Z֥&*v-;bޭQhowy]ه.+7Mⴻ JYgfi3qK C3¹? 5Z.N^Z wKF͂7ރ۞wjTJ.qŠ\Sv1UR욽&NpЖ``уm`vn#z4>eV`'h'jAҔ-4:Hn]9h<nU6m2cE1/Y%I~ʏ|VBƟ@;%M9M}1Dd%gO] у&rf7uܲ(!1AQaq0 ?!*@)JeGj{['v+)(/д%젍ZkkLuRmj.c@Z VJdjh62AO a;oBu H=nKW8Bɰu?бأm,sr|8˨iqI2tZۄJPXEzޔj~]UMuzv!N&1YzJՠ\po'ሸC؊YTD"HM5Ъi߯aFA)ڮzE@hg֝81jk\M38ܢ  s7N}ޭGNBcL pk;Jδ3eiUgAYW]\>GyگQ=fKA;Ta`eM+Q Lň]GM<ĦjHNMx}aX{̣S ԅnMASr ( (Lzo9.;ӳf `Ӕ٢3 IW\9~_saa\ԊWܭX:ӆ38ty*NqPBIYjE>DP!R%-4'皺;~J!7mXhP!曭$\AYj.lC4+jDdgC0-*|`ZD+лC")s8KqpqMs4 7\U`.[Ey8AH!/,(:M -T䓥~ O4-Ԓn}HDN7K$_Ԕ䚞`RhB_aX?4Vŗ@هua;{PcT+7YBo?r-ͩ{ĎA ˼nM286G1V˜Jв"lV55C]h̊A%  'pԂՐ9=d=e{'<3_ :^~4(n-Cs5m![jmIqU~Tw8`pH8uД l maP0 9yCMF1G糞.U~FC{!e(Y:P7~;LN^{1r\ԬG(0dÏOqKZ⑼T{ 2sKdՏ?mMQ=67iH+9d=;QؤH8nLbDyS%({bCupt#C$A"H{jqᶯ:n=EhH`!mMA?v6+MԿ⟚q KiD*Q5CZ2|]:Xd+t:o@M :32b[\5=ֵ7])|tϺwBńe!`:I,9:j@/a 8+v6&{Ǹ@MviA 6T'whs E}xG&'g J~1qff&q˘-vYm /i1 I6u,)#,΁l}*&`$ͬe%w3xѤXcD执g峕5B/|$=%8 a 2.l c@G \/x[өq]v5?N|!\,>{"r/?&!1QAa ᑱ?ĊD肭 nv@yޝ (I…U - bmE>,1v!d& &檔5D&0PԔ͒@Z:†E" Q`”>PH:~OP3W@hMkU \OR5ʄ,f|r}јxo)"+hQK/0`5{M~ '!1AQaq0 ??k#^~G#V,#Z1'ܤ~pO%OO\q`~ }EŰ5 輸dux\$s[{T2t`Bgq4Z]b 㛪3,(@bApr)9:@|b!rg:N^Ʌ x_\pm7I0?>^kw|.K[sF@]Gn*L yO leP.p֍jS=ʨןQF"5zʼnk*8u" Fg cSyVƇNؐ(48hVAӎ^^ jyB p"y]ļlU(7U`3pCGF'&ygozXν: P"@G@x[o&MJ$F.hi w;}/^͇qnmN/TQއO1\,}bQ #¯^S!)X#GPȏt c^\' }iIZa)z4͊Ξy48,f#KP!Jx|wʆ#Z< ~Krp&qH/;R沽+ER~0vV#ʀTS(-ڝBybCDb8~= Yͧ]@nMk2%;%,r6LR腻?^;KŇ=ք =`ɥ/z&I{#JMC}H9^UJ,P pSGd69Ϭu%"ˢP K"k)=9 ㇌,OliXzh " R ^sNkQ >63( PQPy3$f+W՛=4ǁ`*^ EbKt6^!籷ȭK{/;Lpx;aOلz[.NP4]GcTv~sg'LED]j'G]6rYUPw*OİՋi'8۴#gXx+=eU6Rc"u2~?ny;u3'6f b߬M$*k&?6 *^1nێz)Ra}1ٯ%EY2QEp$ EqSt#+x *hUIXM?'//a'G q@0( } G#Ȣp 9;/& `B&$yt(*zxӔS?Kȏ3{p b  ۍ-z܈֦6?<ǬPNG 更 6/h0Ziuae*M'A xvq.>F oN{Q{gDLu=|O xNdq8(EUu,O tDJ ;GeCV YZ T4{(Ӳ'ctfwcjre޳m #7,6BE4QP.P(&^{9H-mo qg1=>p)/"p0!4m‚S6úFNh D )XdT FؤZ⸚kHc8v I `ԁ i4)t*çLe_>ruGEQgǔctō0l6vd GG8v^|#JyZPSO YCuAߐ"xOfHF@KV!少Eҕ]h [).q*0I<8^6}p^thoigiDKp,23I5쓄OY6s7QsOw^wJ/A➰0g(ՄyKԇQS?HwX=ҞX~Q='p?7 @g~G}rgT? JFIF  H H (ICC_PROFILE   0 mntrRGB XYZ acsp   - desc trXYZ d gXYZ x bXYZ  rTRC  (gTRC  (bTRC  (wtpt  cprt  بV7eudakt!Q ,*RGPQNČzŬb 5666p z"c83''Mq6Gitql@90.ۚAcN|li:9蠃p/^ZnLx84v;[#$ nh'c32o8Ɛ5KAv*_?nX?pyֆ̈́#z23F0Oe> {Gu.V (C'h/o%>x1X r:(>}{ycX8b]U:dOMsVAp'Z3'3E-ybj:>jOvUw#2cl~@gFCjțbz ^:-tdfj{XTh8aUM^+dAl"(KK m1$$ XKKqržoqg V FF#pG~:]֦!!Ң:pC+ AzӬ].t`='h_/} @L\,x㌼z԰+J-v+Y['8' % X q=[4Sj~4ݢ#dʂēRL5kX؊>l:t\baBA\Q38( ө:&$ 'L#d{qH>*5;jDo ˷YmԈ*[9*5tUf%3= GUW\'AR_W4_P պ -|4RFJZv0d[ˠzJ|PU8;鯌 'VcL,κ>*eb)f,0"j1 1v՘;bJ++COz7%>NU,=z\cEVK>Ic7} .jHn;^觱GHI HVǂO:ߊ{mSV?K|@ AiAT`2j 1~K8’$ ~]=9ឦG *9EMּm5Xf9Qĸ}i D%+t+;F: v:-&h_rD|! Ә;Zl븂':C&ҀaeKkm6 uT".}J&\ hciB2B+T7t?EPþЌmAF\lc2ЊABmE,cն\QJ]d5 `O Y@8?lx#KiI&Ri1fR2f1N%_g*TӨ??N:}+לɀh٭qL,ʈBrcuBmz ̢TV^ 뙏8' ufUX3㓏>NG:/;Hp饕B1K /%iɫ VQ%:_ -1oL?Roa\i^F|W*Na)P X#y㯨z+Cح\вjirm*dWҡQbBȨi'%NEb?'[h=`OiU϶u nR}GW4fVJmiR~J|l%m'%"LW V27NsXb?_={s}ij4Ý=SNjxFV"ԎI(E)]ӝЖm[4 m`5-7Wf󪥎bZKa#Vb%KY5T$y`46̼p C7HM'l{Oi +Pw~j,S5T4(FԨ;A`*HJTPgt(6/cg5U1@Qb8Y!rBzOQKF+6v%=~XDPpWc_-:߈#c坣CW1:^Q 06Ӭq@ Dj$ UW$?9F\cSM5=2>hב\,()JBk; J#j徻W(p=oQD #UMhU*Fc ?N=nF5Ӑ12w05Z뀩4ڣ霅uC1y%nJ8Ԑ*crR 9W=H9,A׻,.ZFb QEGVNs, q';OMmbtNVqOw*֙kPѬ؈XJIӯEWok+R{%j; Yx 7&&,LԜYbw"lI(*`۹F AS- #$413)Qpڤ3RxOJ$cP]viuq {kyN.- B,@󪳪ڸAor%X0UNb9 򍕑7)*233|Rnb@q|EUý$!7&["XOy ~ƓtADhP]mG파9p=ԜZ]ӭሎOeyq !bI GU:5~FoL ST[е$]$g*w]!;m@ޠ&IUڬ{҄բ-.SmҒ` vU"oL;'5s"W)@äL1i}^Y5$+Pv0o HU @ȓsQM)?M\4Q $2;g WJ/NwFJGD: y όMfW!QUZ%azҳDK_XhM^rԝ^!d'<#ﴛO{/F?+$ Y' wg'$ljGAH7l4xѶc}I*esg~;ͤt@B2iB'9C a8fTR: %NO@ m3sv w .@濾 ,FYrT0mUW_v>>d[A6ڊx:YTLHvӺ!nSD}>[mET0_,'C]pjVᅷPDZ[-V0`>}ܟpmֻ2O6O*ݹXHSN(J /+1՟#(P*gEO#w&j6?;ڡ)+U]l\/{莄*I/9<'$'#'yt/&-\\WPL`/p9qa'e¨E] fAAEYnGtm,ϮwXT>AaN#FjŵjQFdq^<H?yJ܃2*3 T4ЧH**W;(ꭽ¾Pf=eyA4FJ6{e]JqOCf#3SJf iMM\ iT$rG8$9>2:M)Q#NKe&"E8.z<mHk?#t˒A]; G0H:f!i! j{1m}o7u;$99Ӱ\ncz:zALq޶wyKT<4X,'!Y;Ͱ6q GM~_~܂}t>(zl}:r L9 fe}.-R*<`c6oܛ=prҽGB)nQ%)s*&i΍%—Zb{m[NNkbwBw Q*dF HP iܛ; aV68j}\eIGI'͔B;yA :^bn-m#@S6ˎr ;~cmƻgU:X6G%[gc{]c4)fpsgY˅>*"1}2<175)]V5)kdkM~`΂:{4nGPTTb   뎱϶w FFᓂG8>zF_H9_rDl:ҶH5Z!Bj.yk}erb:SOT]!ǎ?n:HεZsyztn[7NZ#UQO$.J#]Cr#YX9c<'$z 9 .$$PnDSn 2u5X g\ ?|Aᬰⶵ >>bE)Cb-ruMc׺*,\)`^m ge\k.۫8گoK1gWMpU޻zI=EErz:#6--/Wm\z8מ0x tA_c?Ծc^MژIMyO>l0ċ}t7[\ʲ9̜m_a[姯rְjP\kx1'CdmvF70e+m-]a?ݝKuSMUm 8f Yb!)2Z.UD \~:ܽ8zR̪Kcbs&ߦ1$, w\gc3F$iU#<`:I4{w.2aQ$EXNo?Gm NN rE$#Jn҉!AH'zePzRog8u(tJP߁Z.pÐ͢Aռ65Xsyvm 6RW7W;|0 >OүG@ٳ<>omԼ()kZJlK,F 4)snOQ{u㌏= Ao,ծ?eKBzG 6e6 f|CU _4C[j͕M8,%emM8\ cv COwTGi _94BDf%'ns8MPc&-y"8R_j 3a+z+N 9QlDQ40E VۋrH2I_YO',:뿉WNHvﵐ0B}na*E zUbN#0e"f.Q H5"-HVn=+ # Eiy- v8=g`o[ 鼛2.D^QeB ؅qϿRC~ B+Jۍ8 4*ӖΝ1R BI\ 1[0 I9y)Y " 7]6qg\ vP  s= Ѭ֕)פE< c`ϷU9W,: ?y1hsU(T ge/룮JA]|4aZVAIeIhBI!l$3![qHnw\7R{oM/ִ>5& gwjFE dc@K:V&W/k+=Yk[ @fU5zzmFȖH,[ n-dc wd[z"g4ϘRr0`B8_; #$^Zo5KZYKj GY%s"!a[9I2TF-w#a]˒Itٮei_FpVЧ૱W3eCi7 "}HApG>h֝5i T٧- '`dX1AF$$ޙ_Z]ڷTC Uy JGO} >A"5a> ZUR -Z\9 jrWݖQRݳ*ļ]$ڵXq=/w z\II#{ӭl^;F_R쵎[ָ[gKKͰoQ )W녕іs*kuzŨQde`WU_KLE~"g r<2GyއL(-VY -Z(IU0 |\;8C mhl:̄DkYHOk|:*DY tsس |zrO;񍃌sT31=jwyШ^nZHm_G̮0W󿓹S;_$mٛIDV=f-H}U]HA*vԶ3\Wh*I#$@6x^OZC&JU 16 XD*if&BDGFYYP[KLX uX .Z hq Ghb8M#Mqt\c> aT 00=㎨ʕGQԪR,ĜI9zӦJO3Rn`C5܊@QO1N.ؔ"I\YÖĐHdL\}IP~jm$ y; :ZGZVJv =&*UF#``R`*S+p\=) ҭ9k̮Ršx0'**ԑLkɺk+zJb#:|MZ ?j$ݼ &X)$6FY6ѕ/; J*nlC*ų_ ԕ{_6:\47ڷs4RmĊ=z *ʪXT[]5Bl#a-˙bv8@H|Rwe9A%5&M%Z02TN)&&GfM 儀oŒM;=.//k~ E"a9/3y,>lj>ZXy&εYP&h gec<``]!}i'c KQulFIʓ_\T58(+cJq~ [dgmm/`Xڙhtkq ו$"c[PVY[uɜ&#몵"ȾqC"ÜȔ!<Mj8u-dx*gϫtTLdKlaWڭ\~|7u`h(w֋cL=˼=FvcGs}зUBSМ;FI;Q$8+V|[CS쮙1%YP Q% LVVK+&,cIb]Vyi ~h?yF4"5As-F ݆x55P&E:W@f;}Gy^]U ITki 1 d﫠*cNh' cؗYnsL:b?H :kM~@8#Iqɔ~:f]P*i]H'fjhxTҗ1O:^t$1]UXz&tODT>(^s&3#N_/x-䬦? ~vU-W$4'ӎvRG|jySW?u4(1 G[ِ22jʎhrmoյشgRͮ%ϟѬ9 oR  n-&F-@hgY_qN;"2 !KJ  šA^, "aG8`=14=5Mqk>U@UT :RgjrKF.O$I9'=i}._ Default page
  • Your IP: 216.73.216.142
  • Server IP: 1.201.172.194
  • Server: Linux hyjg 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64
  • Server Software: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/8.2.20
  • PHP Version: 8.2.20
  • Buat File | Buat Folder
  • Dir : ~/home/gj/html/gj/hanool/
  • Edit File: database.sql
     
     
     
    '); -- -------------------------------------------------------- -- -- Table structure for table `pxp_store` -- CREATE TABLE `pxp_store` ( `id` int(11) NOT NULL, `user_id` int(11) UNSIGNED DEFAULT NULL, `title` varchar(250) DEFAULT '', `category` int(11) UNSIGNED DEFAULT NULL, `price` int(11) UNSIGNED DEFAULT NULL, `license` varchar(50) DEFAULT '', `tags` text, `small_file` varchar(250) DEFAULT '', `full_file` varchar(255) DEFAULT '', `sells` int(11) UNSIGNED DEFAULT '0', `views` int(11) UNSIGNED DEFAULT '0', `downloads` int(11) UNSIGNED DEFAULT '0', `created_date` int(11) UNSIGNED NOT NULL, `license_options` text ) ENGINE=InnoDB COMMENT='moc.mujug|4e34f9ee|sresui' DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `pxp_story` -- CREATE TABLE `pxp_story` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL DEFAULT '0', `caption` varchar(500) NOT NULL DEFAULT '', `time` varchar(50) NOT NULL DEFAULT '0', `media_file` varchar(3000) NOT NULL DEFAULT '', `type` enum('1','2') NOT NULL DEFAULT '1', `duration` varchar(50) NOT NULL DEFAULT '0' ) ENGINE=InnoDB COMMENT='moc.mujug|4e34f9ee|sresui' DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `pxp_story_views` -- CREATE TABLE `pxp_story_views` ( `id` int(11) NOT NULL, `story_id` int(11) NOT NULL DEFAULT '0', `user_id` int(11) NOT NULL DEFAULT '0', `time` varchar(50) NOT NULL DEFAULT '' ) ENGINE=InnoDB COMMENT='moc.mujug|4e34f9ee|sresui' DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `pxp_subscribers` -- CREATE TABLE `pxp_subscribers` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL DEFAULT '0', `subscriber_id` int(11) NOT NULL DEFAULT '0', `time` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB COMMENT='moc.mujug|4e34f9ee|sresui' DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `pxp_transactions` -- CREATE TABLE `pxp_transactions` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL DEFAULT '0', `post_id` int(11) NOT NULL DEFAULT '0', `subscription_id` int(11) NOT NULL DEFAULT '0', `amount` varchar(50) NOT NULL DEFAULT '0', `admin_com` varchar(50) NOT NULL DEFAULT '0', `type` varchar(100) NOT NULL DEFAULT '', `item_store_id` int(11) UNSIGNED DEFAULT '0', `item_license` varchar(200) CHARACTER SET utf8mb4 NOT NULL DEFAULT '', `time` varchar(100) NOT NULL DEFAULT '' ) ENGINE=InnoDB COMMENT='moc.mujug|4e34f9ee|sresui' DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `pxp_userads` -- CREATE TABLE `pxp_userads` ( `id` int(11) NOT NULL, `name` varchar(100) NOT NULL DEFAULT '', `url` varchar(3000) CHARACTER SET utf8mb4 NOT NULL DEFAULT '', `headline` varchar(200) NOT NULL DEFAULT '', `description` text, `location` varchar(1000) NOT NULL DEFAULT 'us', `audience` longtext, `ad_media` varchar(3000) CHARACTER SET utf8mb4 NOT NULL DEFAULT '', `gender` varchar(15) CHARACTER SET utf8 COLLATE utf8_danish_ci NOT NULL DEFAULT 'all', `bidding` varchar(15) CHARACTER SET utf8mb4 NOT NULL DEFAULT '', `clicks` int(15) NOT NULL DEFAULT '0', `views` int(15) NOT NULL DEFAULT '0', `posted` varchar(15) NOT NULL DEFAULT '', `status` int(1) NOT NULL DEFAULT '1', `appears` varchar(10) NOT NULL DEFAULT 'post', `user_id` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB COMMENT='moc.mujug|4e34f9ee|sresui' DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `pxp_users` -- CREATE TABLE `pxp_users` ( `user_id` int(11) NOT NULL, `username` varchar(32) CHARACTER SET latin1 NOT NULL DEFAULT '', `email` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '', `ip_address` varchar(150) CHARACTER SET utf8 NOT NULL DEFAULT '', `password` varchar(61) CHARACTER SET latin1 NOT NULL DEFAULT '', `fname` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `lname` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `gender` varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT 'male', `email_code` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '', `language` varchar(22) CHARACTER SET latin1 NOT NULL DEFAULT 'english', `avatar` varchar(1000) CHARACTER SET latin1 NOT NULL DEFAULT 'media/img/d-avatar.jpg', `cover` varchar(3000) CHARACTER SET utf8 NOT NULL DEFAULT 'media/img/d-cover.jpg', `country_id` int(11) NOT NULL DEFAULT '0', `about` text COLLATE utf8_unicode_ci, `google` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '', `facebook` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '', `twitter` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '', `website` varchar(300) CHARACTER SET utf8 NOT NULL DEFAULT '', `active` int(11) NOT NULL DEFAULT '0', `admin` int(11) NOT NULL DEFAULT '0', `verified` int(11) NOT NULL DEFAULT '0', `last_seen` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `registered` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '0000/0', `time` int(11) NOT NULL DEFAULT '0', `is_pro` int(11) NOT NULL DEFAULT '0', `posts` int(11) NOT NULL DEFAULT '0', `p_privacy` enum('2','1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '2', `c_privacy` enum('1','2') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1', `n_on_like` enum('1','0') CHARACTER SET utf8 NOT NULL DEFAULT '1', `n_on_mention` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1', `n_on_comment` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1', `n_on_follow` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1', `n_on_comment_like` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1', `n_on_comment_reply` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1', `startup_avatar` int(11) NOT NULL DEFAULT '0', `startup_info` int(11) NOT NULL DEFAULT '0', `startup_follow` int(11) NOT NULL DEFAULT '0', `src` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `login_token` char(32) COLLATE utf8_unicode_ci DEFAULT '', `search_engines` enum('0','1') CHARACTER SET utf8 NOT NULL DEFAULT '1', `show_subscribers` int(2) NOT NULL DEFAULT '0', `mode` varchar(11) CHARACTER SET utf8 NOT NULL DEFAULT 'day', `device_id` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '', `balance` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '0', `wallet` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '0.00', `conversation_id` varchar(250) CHARACTER SET utf8mb4 DEFAULT '', `referrer` int(11) NOT NULL DEFAULT '0', `profile` int(11) NOT NULL DEFAULT '1', `business_account` int(11) NOT NULL DEFAULT '0', `paypal_email` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '', `b_name` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '', `b_email` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '', `b_phone` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '', `b_site` varchar(300) CHARACTER SET utf8 NOT NULL DEFAULT '', `b_site_action` varchar(11) CHARACTER SET utf8 NOT NULL DEFAULT '', `uploads` int(11) UNSIGNED DEFAULT '0', `address` varchar(200) CHARACTER SET utf8mb4 DEFAULT '', `city` varchar(50) CHARACTER SET utf8mb4 DEFAULT '', `state` varchar(50) CHARACTER SET utf8mb4 DEFAULT '', `zip` int(11) UNSIGNED DEFAULT '0', `phone_number` varchar(50) CHARACTER SET utf8mb4 DEFAULT '', `StripeSessionId` varchar(200) CHARACTER SET utf8 NOT NULL DEFAULT '', `paystack_ref` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '', `securionpay_key` int(30) NOT NULL DEFAULT '0', `coinbase_hash` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '', `coinbase_code` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '', `subscribe_price` int(11) NOT NULL DEFAULT '0', `two_factor` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB COMMENT='moc.mujug|4e34f9ee|sresui' DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `pxp_user_reports` -- CREATE TABLE `pxp_user_reports` ( `id` int(11) NOT NULL, `user_id` int(15) NOT NULL DEFAULT '0', `profile_id` int(15) NOT NULL DEFAULT '0', `type` int(5) NOT NULL DEFAULT '0', `time` varchar(50) NOT NULL DEFAULT '0' ) ENGINE=InnoDB COMMENT='moc.mujug|4e34f9ee|sresui' DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `pxp_verification_requests` -- CREATE TABLE `pxp_verification_requests` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL DEFAULT '0', `name` varchar(50) NOT NULL DEFAULT '', `passport` text, `photo` text, `message` varchar(200) NOT NULL DEFAULT '', `status` int(11) NOT NULL DEFAULT '0', `time` int(50) NOT NULL DEFAULT '0' ) ENGINE=InnoDB COMMENT='moc.mujug|4e34f9ee|sresui' DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `pxp_withdrawal_requests` -- CREATE TABLE `pxp_withdrawal_requests` ( `id` int(20) NOT NULL, `user_id` int(11) NOT NULL DEFAULT '0', `email` varchar(200) NOT NULL DEFAULT '', `amount` varchar(100) NOT NULL DEFAULT '0', `currency` varchar(20) NOT NULL DEFAULT '', `iban` varchar(250) NOT NULL DEFAULT '', `country` varchar(100) NOT NULL DEFAULT '', `full_name` varchar(150) NOT NULL DEFAULT '', `swift_code` varchar(200) NOT NULL DEFAULT '', `address` varchar(600) NOT NULL DEFAULT '', `type` varchar(100) NOT NULL DEFAULT '', `transfer_info` varchar(600) NOT NULL DEFAULT '', `requested` varchar(100) NOT NULL DEFAULT '', `status` int(5) NOT NULL DEFAULT '0' ) ENGINE=InnoDB COMMENT='moc.mujug|4e34f9ee|sresui' DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `videocalles` -- CREATE TABLE `videocalles` ( `id` int(11) NOT NULL, `access_token` text, `access_token_2` text, `from_id` int(11) NOT NULL DEFAULT '0', `to_id` int(11) NOT NULL DEFAULT '0', `room_name` varchar(50) NOT NULL DEFAULT '', `active` int(11) NOT NULL DEFAULT '0', `called` int(11) NOT NULL DEFAULT '0', `time` int(11) NOT NULL DEFAULT '0', `declined` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB COMMENT='moc.mujug|4e34f9ee|sresui' DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `live_sub_users` -- ALTER TABLE `live_sub_users` ADD PRIMARY KEY (`id`), ADD KEY `time` (`time`), ADD KEY `is_watching` (`is_watching`), ADD KEY `post_id` (`post_id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `pending_payments` -- ALTER TABLE `pending_payments` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `payment_data` (`payment_data`), ADD KEY `method_name` (`method_name`), ADD KEY `time` (`time`); -- -- Indexes for table `pxp_activities` -- ALTER TABLE `pxp_activities` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pxp_agoravideocall` -- ALTER TABLE `pxp_agoravideocall` ADD PRIMARY KEY (`id`), ADD KEY `from_id` (`from_id`), ADD KEY `to_id` (`to_id`), ADD KEY `type` (`type`), ADD KEY `room_name` (`room_name`), ADD KEY `time` (`time`), ADD KEY `status` (`status`); -- -- Indexes for table `pxp_audiocalls` -- ALTER TABLE `pxp_audiocalls` ADD PRIMARY KEY (`id`), ADD KEY `to_id` (`to_id`), ADD KEY `from_id` (`from_id`), ADD KEY `call_id` (`call_id`), ADD KEY `called` (`called`), ADD KEY `declined` (`declined`); -- -- Indexes for table `pxp_bank_receipts` -- ALTER TABLE `pxp_bank_receipts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pxp_blacklist` -- ALTER TABLE `pxp_blacklist` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pxp_blocks` -- ALTER TABLE `pxp_blocks` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `profile_id` (`profile_id`); -- -- Indexes for table `pxp_blog` -- ALTER TABLE `pxp_blog` ADD PRIMARY KEY (`id`), ADD KEY `title` (`title`), ADD KEY `category` (`category`); -- -- Indexes for table `pxp_blog_comments` -- ALTER TABLE `pxp_blog_comments` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `post_id` (`post_id`); -- -- Indexes for table `pxp_blog_likes` -- ALTER TABLE `pxp_blog_likes` ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`post_id`), ADD KEY `user_id` (`user_id`), ADD KEY `type` (`type`); -- -- Indexes for table `pxp_business_requests` -- ALTER TABLE `pxp_business_requests` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pxp_chats` -- ALTER TABLE `pxp_chats` ADD PRIMARY KEY (`id`), ADD KEY `from_id` (`from_id`), ADD KEY `to_id` (`to_id`), ADD KEY `time` (`time`); -- -- Indexes for table `pxp_comments_likes` -- ALTER TABLE `pxp_comments_likes` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `comment_id` (`comment_id`); -- -- Indexes for table `pxp_comments_reply` -- ALTER TABLE `pxp_comments_reply` ADD PRIMARY KEY (`id`), ADD KEY `comment_id` (`comment_id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `pxp_comments_reply_likes` -- ALTER TABLE `pxp_comments_reply_likes` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `reply_id` (`reply_id`); -- -- Indexes for table `pxp_config` -- ALTER TABLE `pxp_config` ADD PRIMARY KEY (`id`), ADD KEY `name` (`name`); -- -- Indexes for table `pxp_connectivities` -- ALTER TABLE `pxp_connectivities` ADD PRIMARY KEY (`id`), ADD KEY `follower_id` (`follower_id`), ADD KEY `following_id` (`following_id`), ADD KEY `active` (`active`); -- -- Indexes for table `pxp_funding` -- ALTER TABLE `pxp_funding` ADD PRIMARY KEY (`id`), ADD KEY `hashed_id` (`hashed_id`); -- -- Indexes for table `pxp_funding_raise` -- ALTER TABLE `pxp_funding_raise` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `funding_id` (`funding_id`); -- -- Indexes for table `pxp_fund_reports` -- ALTER TABLE `pxp_fund_reports` ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`fund_id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `pxp_hashtags` -- ALTER TABLE `pxp_hashtags` ADD PRIMARY KEY (`id`), ADD KEY `hash` (`hash`), ADD KEY `tag` (`tag`), ADD KEY `last_trend_time` (`last_trend_time`); -- -- Indexes for table `pxp_langs` -- ALTER TABLE `pxp_langs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `idx_name` (`lang_key`); -- -- Indexes for table `pxp_media_files` -- ALTER TABLE `pxp_media_files` ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`post_id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `pxp_messages` -- ALTER TABLE `pxp_messages` ADD PRIMARY KEY (`id`), ADD KEY `seen` (`seen`), ADD KEY `from_id` (`from_id`), ADD KEY `to_id` (`to_id`), ADD KEY `reply_id` (`reply_id`), ADD KEY `story_id` (`story_id`); -- -- Indexes for table `pxp_notifications` -- ALTER TABLE `pxp_notifications` ADD PRIMARY KEY (`id`), ADD KEY `recipient_id` (`recipient_id`), ADD KEY `type` (`type`), ADD KEY `notifier_id` (`notifier_id`), ADD KEY `admin` (`admin`); -- -- Indexes for table `pxp_payments` -- ALTER TABLE `pxp_payments` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `pxp_posts` -- ALTER TABLE `pxp_posts` ADD PRIMARY KEY (`post_id`), ADD KEY `user_id` (`user_id`), ADD KEY `registered` (`registered`), ADD KEY `video_type` (`video_type`), ADD KEY `price` (`price`), ADD KEY `parent_id` (`parent_id`), ADD KEY `agora_token` (`agora_token`); -- -- Indexes for table `pxp_post_comments` -- ALTER TABLE `pxp_post_comments` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `post_id` (`post_id`); -- -- Indexes for table `pxp_post_likes` -- ALTER TABLE `pxp_post_likes` ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`post_id`), ADD KEY `user_id` (`user_id`), ADD KEY `type` (`type`); -- -- Indexes for table `pxp_post_reports` -- ALTER TABLE `pxp_post_reports` ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`post_id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `pxp_saved_posts` -- ALTER TABLE `pxp_saved_posts` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `post_id` (`post_id`); -- -- Indexes for table `pxp_sessions` -- ALTER TABLE `pxp_sessions` ADD PRIMARY KEY (`id`), ADD KEY `session_id` (`session_id`), ADD KEY `user_id` (`user_id`), ADD KEY `platform` (`platform`), ADD KEY `time` (`time`); -- -- Indexes for table `pxp_static_pages` -- ALTER TABLE `pxp_static_pages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pxp_store` -- ALTER TABLE `pxp_store` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pxp_story` -- ALTER TABLE `pxp_story` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `time` (`time`); -- -- Indexes for table `pxp_story_views` -- ALTER TABLE `pxp_story_views` ADD PRIMARY KEY (`id`), ADD KEY `story_id` (`story_id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `pxp_subscribers` -- ALTER TABLE `pxp_subscribers` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `subscriber_id` (`subscriber_id`), ADD KEY `time` (`time`); -- -- Indexes for table `pxp_transactions` -- ALTER TABLE `pxp_transactions` ADD PRIMARY KEY (`id`), ADD KEY `admin_com` (`admin_com`), ADD KEY `amount` (`amount`), ADD KEY `post_id` (`post_id`), ADD KEY `subscription_id` (`subscription_id`); -- -- Indexes for table `pxp_userads` -- ALTER TABLE `pxp_userads` ADD PRIMARY KEY (`id`), ADD KEY `appears` (`appears`), ADD KEY `user_id` (`user_id`), ADD KEY `location` (`location`(255)), ADD KEY `gender` (`gender`), ADD KEY `status` (`status`); -- -- Indexes for table `pxp_users` -- ALTER TABLE `pxp_users` ADD PRIMARY KEY (`user_id`), ADD KEY `username` (`username`), ADD KEY `email` (`email`), ADD KEY `password` (`password`), ADD KEY `last_active` (`last_seen`), ADD KEY `admin` (`admin`), ADD KEY `active` (`active`), ADD KEY `registered` (`registered`), ADD KEY `p_privacy` (`p_privacy`), ADD KEY `c_privacy` (`c_privacy`), ADD KEY `n_on_like` (`n_on_like`), ADD KEY `n_on_mention` (`n_on_mention`), ADD KEY `n_on_comment` (`n_on_comment`), ADD KEY `n_on_follow` (`n_on_follow`), ADD KEY `src` (`src`), ADD KEY `n_on_comment_like` (`n_on_comment_like`), ADD KEY `n_on_comment_reply` (`n_on_comment_reply`), ADD KEY `time` (`time`), ADD KEY `StripeSessionId` (`StripeSessionId`), ADD KEY `paystack_ref` (`paystack_ref`), ADD KEY `securionpay_key` (`securionpay_key`), ADD KEY `coinbase_hash` (`coinbase_hash`), ADD KEY `coinbase_code` (`coinbase_code`), ADD KEY `subscribe_price` (`subscribe_price`), ADD KEY `show_subscribers` (`show_subscribers`), ADD KEY `two_factor` (`two_factor`); -- -- Indexes for table `pxp_user_reports` -- ALTER TABLE `pxp_user_reports` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `profile_id` (`profile_id`), ADD KEY `type` (`type`); -- -- Indexes for table `pxp_verification_requests` -- ALTER TABLE `pxp_verification_requests` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pxp_withdrawal_requests` -- ALTER TABLE `pxp_withdrawal_requests` ADD PRIMARY KEY (`id`), ADD KEY `iban` (`iban`), ADD KEY `country` (`country`), ADD KEY `full_name` (`full_name`), ADD KEY `swift_code` (`swift_code`), ADD KEY `address` (`address`), ADD KEY `type` (`type`), ADD KEY `transfer_info` (`transfer_info`); -- -- Indexes for table `videocalles` -- ALTER TABLE `videocalles` ADD PRIMARY KEY (`id`), ADD KEY `to_id` (`to_id`), ADD KEY `from_id` (`from_id`), ADD KEY `called` (`called`), ADD KEY `declined` (`declined`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `live_sub_users` -- ALTER TABLE `live_sub_users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pending_payments` -- ALTER TABLE `pending_payments` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_activities` -- ALTER TABLE `pxp_activities` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_agoravideocall` -- ALTER TABLE `pxp_agoravideocall` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_audiocalls` -- ALTER TABLE `pxp_audiocalls` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_bank_receipts` -- ALTER TABLE `pxp_bank_receipts` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_blacklist` -- ALTER TABLE `pxp_blacklist` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_blocks` -- ALTER TABLE `pxp_blocks` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_blog` -- ALTER TABLE `pxp_blog` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_blog_comments` -- ALTER TABLE `pxp_blog_comments` MODIFY `id` int(30) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_blog_likes` -- ALTER TABLE `pxp_blog_likes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_business_requests` -- ALTER TABLE `pxp_business_requests` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_chats` -- ALTER TABLE `pxp_chats` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_comments_likes` -- ALTER TABLE `pxp_comments_likes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_comments_reply` -- ALTER TABLE `pxp_comments_reply` MODIFY `id` int(30) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_comments_reply_likes` -- ALTER TABLE `pxp_comments_reply_likes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_config` -- ALTER TABLE `pxp_config` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=311; -- -- AUTO_INCREMENT for table `pxp_connectivities` -- ALTER TABLE `pxp_connectivities` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_funding` -- ALTER TABLE `pxp_funding` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_funding_raise` -- ALTER TABLE `pxp_funding_raise` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_fund_reports` -- ALTER TABLE `pxp_fund_reports` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_hashtags` -- ALTER TABLE `pxp_hashtags` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_langs` -- ALTER TABLE `pxp_langs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=725; -- -- AUTO_INCREMENT for table `pxp_media_files` -- ALTER TABLE `pxp_media_files` MODIFY `id` int(30) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_messages` -- ALTER TABLE `pxp_messages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_notifications` -- ALTER TABLE `pxp_notifications` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_payments` -- ALTER TABLE `pxp_payments` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_posts` -- ALTER TABLE `pxp_posts` MODIFY `post_id` int(30) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_post_comments` -- ALTER TABLE `pxp_post_comments` MODIFY `id` int(30) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_post_likes` -- ALTER TABLE `pxp_post_likes` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_post_reports` -- ALTER TABLE `pxp_post_reports` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_saved_posts` -- ALTER TABLE `pxp_saved_posts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_sessions` -- ALTER TABLE `pxp_sessions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_static_pages` -- ALTER TABLE `pxp_static_pages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `pxp_store` -- ALTER TABLE `pxp_store` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_story` -- ALTER TABLE `pxp_story` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_story_views` -- ALTER TABLE `pxp_story_views` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_subscribers` -- ALTER TABLE `pxp_subscribers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_transactions` -- ALTER TABLE `pxp_transactions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_userads` -- ALTER TABLE `pxp_userads` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_users` -- ALTER TABLE `pxp_users` MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_user_reports` -- ALTER TABLE `pxp_user_reports` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_verification_requests` -- ALTER TABLE `pxp_verification_requests` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `pxp_withdrawal_requests` -- ALTER TABLE `pxp_withdrawal_requests` MODIFY `id` int(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `videocalles` -- ALTER TABLE `videocalles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- Constraints for dumped tables -- -- -- Constraints for table `pxp_blog_comments` -- ALTER TABLE `pxp_blog_comments` ADD CONSTRAINT `pxp_blog_comments_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `pxp_blog` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_blog_likes` -- ALTER TABLE `pxp_blog_likes` ADD CONSTRAINT `pxp_blog_likes_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `pxp_blog` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `pxp_blog_likes_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_connectivities` -- ALTER TABLE `pxp_connectivities` ADD CONSTRAINT `pxp_connectivities_ibfk_1` FOREIGN KEY (`follower_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `pxp_connectivities_ibfk_2` FOREIGN KEY (`following_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_fund_reports` -- ALTER TABLE `pxp_fund_reports` ADD CONSTRAINT `pxp_fund_reports_ibfk_1` FOREIGN KEY (`fund_id`) REFERENCES `pxp_funding` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `pxp_fund_reports_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_media_files` -- ALTER TABLE `pxp_media_files` ADD CONSTRAINT `pxp_media_files_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `pxp_posts` (`post_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_notifications` -- ALTER TABLE `pxp_notifications` ADD CONSTRAINT `pxp_notifications_ibfk_1` FOREIGN KEY (`notifier_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `pxp_notifications_ibfk_2` FOREIGN KEY (`recipient_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_posts` -- ALTER TABLE `pxp_posts` ADD CONSTRAINT `pxp_posts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_post_comments` -- ALTER TABLE `pxp_post_comments` ADD CONSTRAINT `pxp_post_comments_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `pxp_posts` (`post_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_post_likes` -- ALTER TABLE `pxp_post_likes` ADD CONSTRAINT `pxp_post_likes_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `pxp_posts` (`post_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `pxp_post_likes_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_post_reports` -- ALTER TABLE `pxp_post_reports` ADD CONSTRAINT `pxp_post_reports_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `pxp_posts` (`post_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `pxp_post_reports_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_saved_posts` -- ALTER TABLE `pxp_saved_posts` ADD CONSTRAINT `pxp_saved_posts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `pxp_saved_posts_ibfk_2` FOREIGN KEY (`post_id`) REFERENCES `pxp_posts` (`post_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_sessions` -- ALTER TABLE `pxp_sessions` ADD CONSTRAINT `pxp_sessions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_story` -- ALTER TABLE `pxp_story` ADD CONSTRAINT `pxp_story_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `pxp_users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `pxp_story_views` -- ALTER TABLE `pxp_story_views` ADD CONSTRAINT `pxp_story_views_ibfk_1` FOREIGN KEY (`story_id`) REFERENCES `pxp_story` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;