create_tables.twig

CREATE TABLE `{{ prefix }}users` (
  `id` bigint(15) NOT NULL auto_increment,
  `username` varchar(180) default NULL,
  `email` varchar(180) default NULL,
  `full_name` varchar(180) default NULL,
  `bio` varchar(180) default NULL,
  `url` varchar(180) default NULL,
  `points` int(9) default '0',
  `invites` int(9) default '2',
  `password` varchar(180) default NULL,
  `date_added` datetime default NULL,
  `date_joined` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE `{{ prefix }}users_password_reset` (
  `user_id` bigint(15) unsigned NOT NULL,
  `reset_code` char(32) DEFAULT NULL,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE `{{ prefix }}items` (
  `id` int(10) NOT NULL auto_increment,
  `user_id` bigint(15) NOT NULL default '0',
  `title` varchar(140) default NULL,
  `content` text default NULL,
  `image` varchar(140) default NULL,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE `{{ prefix }}invites` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` bigint(15) NOT NULL,
  `email` varchar(50) default '',
  `code` varchar(11) default NULL,
  `result` int(1) default '0',
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE `{{ prefix }}log` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` bigint(15) NOT NULL default '0',
  `object_type` varchar(50) default NULL,
  `object_id` varchar(50) default NULL,
  `action` varchar(50) NOT NULL default '',
  `params` varchar(50) default NULL,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE `{{ prefix }}comments` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` bigint(15) NOT NULL default '0',
  `item_id` int(11) NOT NULL default '0',
  `content` text NOT NULL,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE `{{ prefix }}likes` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` bigint(15) NOT NULL default '0',
  `item_id` int(11) NOT NULL default '0',
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE `{{ prefix }}friends` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(15) NOT NULL DEFAULT '0',
  `friend_user_id` bigint(15) NOT NULL DEFAULT '0',
  `status` tinyint(1) DEFAULT '0',
  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_updated` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;