Serpent.sql

-- Create syntax for TABLE 'extension'
CREATE TABLE `extension` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `extension_name` text NOT NULL,
  `extension_slug` varchar(200) NOT NULL,
  `extension_type` text NOT NULL,
  `repo_name` varchar(200) DEFAULT NULL,
  `revision` int(11) DEFAULT '0',
  `count` int(11) DEFAULT NULL,
  `description` longtext,
  `version` varchar(10) NOT NULL,
  `author_id` bigint(20) NOT NULL,
  `website` varchar(250) NOT NULL,
  `added_on` int(11) DEFAULT NULL,
  `modified_on` int(11) DEFAULT NULL,
  `active` int(1) DEFAULT '1',
  PRIMARY KEY (`id`,`extension_slug`,`author_id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;

-- Create syntax for TABLE 'hide_extensions'
CREATE TABLE `hide_extensions` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `extension` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

-- Create syntax for TABLE 'options'
CREATE TABLE `options` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(64) NOT NULL DEFAULT '',
  `value` longtext NOT NULL,
  `autoload` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=utf8;

-- Create syntax for TABLE 'sessions'
CREATE TABLE `sessions` (
  `name` varchar(25) NOT NULL,
  `cookie` varchar(25) NOT NULL,
  `value` text NOT NULL,
  `expire` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Create syntax for TABLE 'term_relationships'
CREATE TABLE `term_relationships` (
  `page_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`page_id`,`term_id`),
  KEY `term_id` (`term_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Create syntax for TABLE 'term_taxonomy'
CREATE TABLE `term_taxonomy` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `taxonomy` varchar(32) NOT NULL DEFAULT '',
  `description` longtext NOT NULL,
  `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `count` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  KEY `taxonomy` (`taxonomy`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Create syntax for TABLE 'terms'
CREATE TABLE `terms` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL DEFAULT '',
  `slug` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Create syntax for TABLE 'users'
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(100) NOT NULL DEFAULT '',
  `username` varchar(60) NOT NULL DEFAULT '',
  `password` varchar(64) NOT NULL DEFAULT '',
  `type` varchar(25) DEFAULT NULL,
  `data` text,
  `registered` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '0',
  `confirm_key` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;