UMIL installing DB question?

Discuss phpBB 3.0.x in general.
Forum rules
Please post any phpBB 3.1.x related topics in the phpBB 3.1.x discussion forum.
Blue Blood
New member
New member
Posts: 4
Joined: 17 Jul 2011, 06:37
Real name: Jeremy
Location: Louisville, Kentucky U§A

UMIL installing DB question?

Postby Blue Blood » 17 Jul 2011, 06:39

How do I add this table to a UMIL install.php

I know how to do the actual table & columns, but I can't figure to how to do the INSERT INTO

Can anyone help PLEASE!!

Thanks!!!

Code: Select all

$versions = array(
   '0.1.0'   => array(
      // add terms_privacy table
      'table_add' => array(
         array('phpbb_terms_privacy', array(
            'COLUMNS'      => array(
               'terms_privacy_draft'            => array('TEXT_UNI', ''),
               'terms_privacy_draft_uid'         => array('VCHAR:8', ''),
               'terms_privacy_draft_bitfield'      => array('VCHAR:255', ''),
               'terms_privacy_draft_options'      => array('UINT:11', 7),
               'terms_text'                  => array('TEXT_UNI', ''),
               'trems_text_uid'               => array('VCHAR:8', ''),,
               'trems_text_bitfield'            => array('VCHAR:255', ''),
               'trems_text_options'            => array('UINT:11', 7),
               'privacy_text'                  => array('TEXT_UNI', ''),
               'privacy_text_uid'               => array('VCHAR:8', ''),
               'privacy_text_bit'               => array('VCHAR:255', ''),
               'privacy_text_opt'               => array('UINT:11', 7),
               'terms_title'                  => array('VCHAR:255', ''),
               'privacy_title'                  => array('VCHAR:255', ''),
         ),
      ),
   ),
);



Code: Select all

DROP TABLE IF EXISTS `phpbb_terms_privacy`;
CREATE TABLE IF NOT EXISTS `phpbb_terms_privacy` (
  `terms_privacy_draft` text COLLATE utf8_bin NOT NULL,
  `terms_privacy_draft_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
  `terms_privacy_draft_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `terms_privacy_draft_options` int(11) unsigned NOT NULL DEFAULT '7',
  `terms_text` text COLLATE utf8_bin NOT NULL,
  `trems_text_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
  `trems_text_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `trems_text_options` int(11) unsigned NOT NULL DEFAULT '7',
  `privacy_text` text COLLATE utf8_bin NOT NULL,
  `privacy_text_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
  `privacy_text_bit` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `privacy_text_opt` int(11) unsigned NOT NULL DEFAULT '7',
  `terms_title` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `privacy_title` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Code: Select all

INSERT INTO `phpbb_terms_privacy` (`terms_privacy_draft`, `terms_privacy_draft_uid`, `terms_privacy_draft_bitfield`, `terms_privacy_draft_options`, `terms_text`, `terms_text_uid`, `terms_text_bitfield`, `terms_text_options`, `privacy_text`, `privacy_text_uid`, `privacy_text_bit`, `privacy_text_opt`, `terms_title`, `privacy_title`) VALUES
(0x5b636f6c6f723d7265643a34396a6c346438375d5b623a34396a6c346438375d4242205465726d732026205072697661637920494e204143502044726166745b2f623a34396a6c346438375d5b2f636f6c6f723a34396a6c346438375d2063616e206265207365656e20686572652121203c212d2d20733a6d72677265656e3a202d2d3e3c696d67207372633d227b534d494c4945535f504154487d2f69636f6e5f6d72677265656e2e6769662220616c743d223a6d72677265656e3a22207469746c653d224d722e20477265656e22202f3e3c212d2d20733a6d72677265656e3a202d2d3e, '49jl4d87', 'Qg==', 7, 0x5b636f6c6f723d7265643a3375346761736b365d5b623a3375346761736b365d205465726d73206f66207573655b2f623a3375346761736b365d5b2f636f6c6f723a3375346761736b365d2063616e206265207365656e20686572652121203c212d2d20733a6d72677265656e3a202d2d3e3c696d67207372633d227b534d494c4945535f504154487d2f69636f6e5f6d72677265656e2e6769662220616c743d223a6d72677265656e3a22207469746c653d224d722e20477265656e22202f3e3c212d2d20733a6d72677265656e3a202d2d3e, '3u4gask6', 'Qg==', 7, 0x5b636f6c6f723d677265656e3a3365686d656634665d5b623a3365686d656634665d5072697661637920706f6c6963795b2f623a3365686d656634665d5b2f636f6c6f723a3365686d656634665d2063616e206265207365656e20686572652121203c212d2d20733a77696e6b3a202d2d3e3c696d67207372633d227b534d494c4945535f504154487d2f69636f6e5f655f77696e6b2e6769662220616c743d223a77696e6b3a22207469746c653d2257696e6b22202f3e3c212d2d20733a77696e6b3a202d2d3e, '3ehmef4f', 'Qg==', 7, 'Terms of use', 'Privacy policy');

Blue Blood
New member
New member
Posts: 4
Joined: 17 Jul 2011, 06:37
Real name: Jeremy
Location: Louisville, Kentucky U§A

Re: UMIL installing DB question?

Postby Blue Blood » 21 Jul 2011, 04:01

SOLVED
Thanks Anyway!! :)

User avatar
tumba25
Past Contributor
Past Contributor
Posts: 1058
Joined: 24 Oct 2007, 13:10
Real name: Jari Kanerva
Location: Kokkola, Finland.

Re: UMIL installing DB question?

Postby tumba25 » 21 Jul 2011, 10:49

What was the answer?


Return to “phpBB 3.0.x "Olympus" discussion”

Who is online

Users browsing this forum: CommonCrawl [Bot] and 3 guests