Skip to content

Instantly share code, notes, and snippets.

@michaelcullum
Created February 5, 2012 23:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save michaelcullum/1748481 to your computer and use it in GitHub Desktop.
Save michaelcullum/1748481 to your computer and use it in GitHub Desktop.
install
array(BLOG_CMNTS_TABLE, array(
'COLUMNS' => array(
'cmnt_id' => array('UINT', NULL, 'auto_increment'),
'cmnt_blog_id' => array('UINT', 0),
'cmnt_poster_id' => array('UINT', 0),
'cmnt_approved' => array('UINT', 0),
'cmnt_text' => array('TEXT_UNI', ''),
'cmnt_posted_time' => array('TIMESTAMP', 0),
'cmnt_last_edited' => array('TIMESTAMP', 0),
'bbcode_bitfield' => array('VCHAR:255', ''),
'bbcode_uid' => array('VCHAR:8', ''),
'enable_bbcode' => array('TINT:1', 1),
'enable_smilies' => array('TINT:1', 1),
'enable_magic_url' => array('TINT:1', 1),
),
'PRIMARY_KEY' => 'cmnt_id',
),
),
'table_insert' => array(
array(BLOG_CMNTS_TABLE, array(
array(
'cat_id' => 1,
'cat_title' => 'News',
'cat_desc' => 'Site news will be posted here',
),
)),
),
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment