← Back
Editing: omeka.sql
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `omeka32` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]collections` -- CREATE TABLE `[[dbprefix]]collections` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `public` tinyint(4) NOT NULL, `featured` tinyint(4) NOT NULL, `added` timestamp NOT NULL DEFAULT '2000-01-01 05:00:00', `modified` timestamp NOT NULL DEFAULT '2000-01-01 05:00:00', `owner_id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `public` (`public`), KEY `featured` (`featured`), KEY `owner_id` (`owner_id`), KEY `added` (`added`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]elements` -- CREATE TABLE `[[dbprefix]]elements` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `element_set_id` int(10) unsigned NOT NULL, `order` int(10) unsigned DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci, `comment` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`), UNIQUE KEY `name_element_set_id` (`element_set_id`,`name`), UNIQUE KEY `order_element_set_id` (`element_set_id`,`order`), KEY `element_set_id` (`element_set_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=52 ; -- -- Dumping data for table `[[dbprefix]]elements` -- INSERT INTO `[[dbprefix]]elements` VALUES (1, 3, NULL, 'Text', 'Any textual data included in the document', NULL), (2, 3, NULL, 'Interviewer', 'The person(s) performing the interview', NULL), (3, 3, NULL, 'Interviewee', 'The person(s) being interviewed', NULL), (4, 3, NULL, 'Location', 'The location of the interview', NULL), (5, 3, NULL, 'Transcription', 'Any written text transcribed from a sound', NULL), (6, 3, NULL, 'Local URL', 'The URL of the local directory containing all assets of the website', NULL), (7, 3, NULL, 'Original Format', 'The type of object, such as painting, sculpture, paper, photo, and additional data', NULL), (10, 3, NULL, 'Physical Dimensions', 'The actual physical size of the original image', NULL), (11, 3, NULL, 'Duration', 'Length of time involved (seconds, minutes, hours, days, class periods, etc.)', NULL), (12, 3, NULL, 'Compression', 'Type/rate of compression for moving image file (i.e. MPEG-4)', NULL), (13, 3, NULL, 'Producer', 'Name (or names) of the person who produced the video', NULL), (14, 3, NULL, 'Director', 'Name (or names) of the person who produced the video', NULL), (15, 3, NULL, 'Bit Rate/Frequency', 'Rate at which bits are transferred (i.e. 96 kbit/s would be FM quality audio)', NULL), (16, 3, NULL, 'Time Summary', 'A summary of an interview given for different time stamps throughout the interview', NULL), (17, 3, NULL, 'Email Body', 'The main body of the email, including all replied and forwarded text and headers', NULL), (18, 3, NULL, 'Subject Line', 'The content of the subject line of the email', NULL), (19, 3, NULL, 'From', 'The name and email address of the person sending the email', NULL), (20, 3, NULL, 'To', 'The name(s) and email address(es) of the person to whom the email was sent', NULL), (21, 3, NULL, 'CC', 'The name(s) and email address(es) of the person to whom the email was carbon copied', NULL), (22, 3, NULL, 'BCC', 'The name(s) and email address(es) of the person to whom the email was blind carbon copied', NULL), (23, 3, NULL, 'Number of Attachments', 'The number of attachments to the email', NULL), (24, 3, NULL, 'Standards', '', NULL), (25, 3, NULL, 'Objectives', '', NULL), (26, 3, NULL, 'Materials', '', NULL), (27, 3, NULL, 'Lesson Plan Text', '', NULL), (28, 3, NULL, 'URL', '', NULL), (29, 3, NULL, 'Event Type', '', NULL), (30, 3, NULL, 'Participants', 'Names of individuals or groups participating in the event', NULL), (31, 3, NULL, 'Birth Date', '', NULL), (32, 3, NULL, 'Birthplace', '', NULL), (33, 3, NULL, 'Death Date', '', NULL), (34, 3, NULL, 'Occupation', '', NULL), (35, 3, NULL, 'Biographical Text', '', NULL), (36, 3, NULL, 'Bibliography', '', NULL), (37, 1, 8, 'Contributor', 'An entity responsible for making contributions to the resource', NULL), (38, 1, 15, 'Coverage', 'The spatial or temporal topic of the resource, the spatial applicability of the resource, or the jurisdiction under which the resource is relevant', NULL), (39, 1, 4, 'Creator', 'An entity primarily responsible for making the resource', NULL), (40, 1, 7, 'Date', 'A point or period of time associated with an event in the lifecycle of the resource', NULL), (41, 1, 3, 'Description', 'An account of the resource', NULL), (42, 1, 11, 'Format', 'The file format, physical medium, or dimensions of the resource', NULL), (43, 1, 14, 'Identifier', 'An unambiguous reference to the resource within a given context', NULL), (44, 1, 12, 'Language', 'A language of the resource', NULL), (45, 1, 6, 'Publisher', 'An entity responsible for making the resource available', NULL), (46, 1, 10, 'Relation', 'A related resource', NULL), (47, 1, 9, 'Rights', 'Information about rights held in and over the resource', NULL), (48, 1, 5, 'Source', 'A related resource from which the described resource is derived', NULL), (49, 1, 2, 'Subject', 'The topic of the resource', NULL), (50, 1, 1, 'Title', 'A name given to the resource', NULL), (51, 1, 13, 'Type', 'The nature or genre of the resource', NULL); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]element_sets` -- CREATE TABLE `[[dbprefix]]element_sets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `record_type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `record_type` (`record_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ; -- -- Dumping data for table `[[dbprefix]]element_sets` -- INSERT INTO `[[dbprefix]]element_sets` VALUES (1, NULL, 'Dublin Core', 'The Dublin Core metadata element set is common to all Omeka records, including items, files, and collections. For more information see, http://dublincore.org/documents/dces/.'), (3, 'Item', 'Item Type Metadata', 'The item type metadata element set, consisting of all item type elements bundled with Omeka and all item type elements created by an administrator.'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]element_texts` -- CREATE TABLE `[[dbprefix]]element_texts` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `record_id` int(10) unsigned NOT NULL, `record_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `element_id` int(10) unsigned NOT NULL, `html` tinyint(4) NOT NULL, `text` mediumtext COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `record_type_record_id` (`record_type`,`record_id`), KEY `element_id` (`element_id`), KEY `text` (`text`(20)), KEY `record_element_text` (`record_type`,`record_id`,`element_id`,`text`(20)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]files` -- CREATE TABLE `[[dbprefix]]files` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `item_id` int(10) unsigned NOT NULL, `order` int(10) unsigned DEFAULT NULL, `size` bigint(20) unsigned NOT NULL, `has_derivative_image` tinyint(1) NOT NULL, `authentication` char(32) COLLATE utf8_unicode_ci DEFAULT NULL, `mime_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `type_os` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `filename` text COLLATE utf8_unicode_ci NOT NULL, `original_filename` text COLLATE utf8_unicode_ci NOT NULL, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `added` timestamp NOT NULL DEFAULT '2000-01-01 05:00:00', `stored` tinyint(1) NOT NULL DEFAULT '0', `metadata` mediumtext COLLATE utf8_unicode_ci NOT NULL, `alt_text` mediumtext COLLATE utf8_unicode_ci, PRIMARY KEY (`id`), KEY `item_id` (`item_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]items` -- CREATE TABLE `[[dbprefix]]items` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `item_type_id` int(10) unsigned DEFAULT NULL, `collection_id` int(10) unsigned DEFAULT NULL, `featured` tinyint(4) NOT NULL, `public` tinyint(4) NOT NULL, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `added` timestamp NOT NULL DEFAULT '2000-01-01 05:00:00', `owner_id` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `item_type_id` (`item_type_id`), KEY `collection_id` (`collection_id`), KEY `public` (`public`), KEY `featured` (`featured`), KEY `owner_id` (`owner_id`), KEY `added` (`added`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]item_types` -- CREATE TABLE `[[dbprefix]]item_types` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ; -- -- Dumping data for table `[[dbprefix]]item_types` -- INSERT INTO `[[dbprefix]]item_types` VALUES (1, 'Text', 'A resource consisting primarily of words for reading. Examples include books, letters, dissertations, poems, newspapers, articles, archives of mailing lists. Note that facsimiles or images of texts are still of the genre Text.'), (3, 'Moving Image', 'A series of visual representations imparting an impression of motion when shown in succession. Examples include animations, movies, television programs, videos, zoetropes, or visual output from a simulation.'), (4, 'Oral History', 'A resource containing historical information obtained in interviews with persons having firsthand knowledge.'), (5, 'Sound', 'A resource primarily intended to be heard. Examples include a music playback file format, an audio compact disc, and recorded speech or sounds.'), (6, 'Still Image', 'A static visual representation. Examples include paintings, drawings, graphic designs, plans and maps. Recommended best practice is to assign the type Text to images of textual materials.'), (7, 'Website', 'A resource comprising of a web page or web pages and all related assets ( such as images, sound and video files, etc. ).'), (8, 'Event', 'A non-persistent, time-based occurrence. Metadata for an event provides descriptive information that is the basis for discovery of the purpose, location, duration, and responsible agents associated with an event. Examples include an exhibition, webcast, conference, workshop, open day, performance, battle, trial, wedding, tea party, conflagration.'), (9, 'Email', 'A resource containing textual messages and binary attachments sent electronically from one person to another or one person to many people.'), (10, 'Lesson Plan', 'A resource that gives a detailed description of a course of instruction.'), (11, 'Hyperlink', 'A link, or reference, to another resource on the Internet.'), (12, 'Person', 'An individual.'), (13, 'Interactive Resource', 'A resource requiring interaction from the user to be understood, executed, or experienced. Examples include forms on Web pages, applets, multimedia learning objects, chat services, or virtual reality environments.'), (14, 'Dataset', 'Data encoded in a defined structure. Examples include lists, tables, and databases. A dataset may be useful for direct machine processing.'), (15, 'Physical Object', 'An inanimate, three-dimensional object or substance. Note that digital representations of, or surrogates for, these objects should use Moving Image, Still Image, Text or one of the other types.'), (16, 'Service', 'A system that provides one or more functions. Examples include a photocopying service, a banking service, an authentication service, interlibrary loans, a Z39.50 or Web server.'), (17, 'Software', 'A computer program in source or compiled form. Examples include a C source file, MS-Windows .exe executable, or Perl script.'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]item_types_elements` -- CREATE TABLE `[[dbprefix]]item_types_elements` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `item_type_id` int(10) unsigned NOT NULL, `element_id` int(10) unsigned NOT NULL, `order` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `item_type_id_element_id` (`item_type_id`,`element_id`), KEY `item_type_id` (`item_type_id`), KEY `element_id` (`element_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=48 ; -- -- Dumping data for table `[[dbprefix]]item_types_elements` -- INSERT INTO `[[dbprefix]]item_types_elements` VALUES (1, 1, 7, NULL), (2, 1, 1, NULL), (3, 6, 7, NULL), (6, 6, 10, NULL), (7, 3, 7, NULL), (8, 3, 11, NULL), (9, 3, 12, NULL), (10, 3, 13, NULL), (11, 3, 14, NULL), (12, 3, 5, NULL), (13, 5, 7, NULL), (14, 5, 11, NULL), (15, 5, 15, NULL), (16, 5, 5, NULL), (17, 4, 7, NULL), (18, 4, 11, NULL), (19, 4, 15, NULL), (20, 4, 5, NULL), (21, 4, 2, NULL), (22, 4, 3, NULL), (23, 4, 4, NULL), (24, 4, 16, NULL), (25, 9, 17, NULL), (26, 9, 18, NULL), (27, 9, 20, NULL), (28, 9, 19, NULL), (29, 9, 21, NULL), (30, 9, 22, NULL), (31, 9, 23, NULL), (32, 10, 24, NULL), (33, 10, 25, NULL), (34, 10, 26, NULL), (35, 10, 11, NULL), (36, 10, 27, NULL), (37, 7, 6, NULL), (38, 11, 28, NULL), (39, 8, 29, NULL), (40, 8, 30, NULL), (41, 8, 11, NULL), (42, 12, 31, NULL), (43, 12, 32, NULL), (44, 12, 33, NULL), (45, 12, 34, NULL), (46, 12, 35, NULL), (47, 12, 36, NULL); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]keys` -- CREATE TABLE `[[dbprefix]]keys` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) unsigned NOT NULL, `label` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `key` char(40) COLLATE utf8_unicode_ci NOT NULL, `ip` varbinary(16) DEFAULT NULL, `accessed` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `key` (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]options` -- CREATE TABLE `[[dbprefix]]options` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `value` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=31 ; -- -- Dumping data for table `[[dbprefix]]options` -- INSERT INTO `[[dbprefix]]options` VALUES (1, 'omeka_version', '3.2'), (2, 'administrator_email', '[[admin_email]]'), (3, 'copyright', ''), (4, 'site_title', '[[site_name]]'), (5, 'author', ''), (6, 'description', '[[site_desc]]'), (7, 'thumbnail_constraint', '200'), (8, 'square_thumbnail_constraint', '200'), (9, 'fullsize_constraint', '800'), (10, 'per_page_admin', '10'), (11, 'per_page_public', '10'), (12, 'show_empty_elements', '0'), (13, 'path_to_convert', '[[convert]]'), (14, 'admin_theme', 'default'), (15, 'public_theme', 'default'), (16, 'file_extension_whitelist', 'aac,aif,aiff,asf,asx,avi,bmp,c,cc,class,css,divx,doc,docx,exe,gif,gz,gzip,h,ico,j2k,jp2,jpe,jpeg,jpg,m4a,m4v,mdb,mid,midi,mov,mp2,mp3,mp4,mpa,mpe,mpeg,mpg,mpp,odb,odc,odf,odg,odp,ods,odt,ogg,opus,pdf,png,pot,pps,ppt,pptx,qt,ra,ram,rtf,rtx,swf,tar,tif,tiff,txt,wav,wax,webm,wma,wmv,wmx,wri,xla,xls,xlsx,xlt,xlw,zip'), (17, 'file_mime_type_whitelist', 'application/msword,application/ogg,application/pdf,application/rtf,application/vnd.ms-access,application/vnd.ms-excel,application/vnd.ms-powerpoint,application/vnd.ms-project,application/vnd.ms-write,application/vnd.oasis.opendocument.chart,application/vnd.oasis.opendocument.database,application/vnd.oasis.opendocument.formula,application/vnd.oasis.opendocument.graphics,application/vnd.oasis.opendocument.presentation,application/vnd.oasis.opendocument.spreadsheet,application/vnd.oasis.opendocument.text,application/x-ms-wmp,application/x-ogg,application/x-gzip,application/x-msdownload,application/x-shockwave-flash,application/x-tar,application/zip,audio/aac,audio/aiff,audio/mid,audio/midi,audio/mp3,audio/mp4,audio/mpeg,audio/mpeg3,audio/ogg,audio/wav,audio/wma,audio/x-aac,audio/x-aiff,audio/x-m4a,audio/x-midi,audio/x-mp3,audio/x-mp4,audio/x-mpeg,audio/x-mpeg3,audio/x-mpegaudio,audio/x-ms-wax,audio/x-realaudio,audio/x-wav,audio/x-wma,image/bmp,image/gif,image/icon,image/jpeg,image/pjpeg,image/png,image/tiff,image/x-icon,image/x-ms-bmp,text/css,text/plain,text/richtext,text/rtf,video/asf,video/avi,video/divx,video/mp4,video/mpeg,video/msvideo,video/ogg,video/quicktime,video/webm,video/x-m4v,video/x-ms-wmv,video/x-msvideo'), (18, 'disable_default_file_validation', ''), (20, 'display_system_info', '1'), (21, 'html_purifier_is_enabled', '1'), (22, 'html_purifier_allowed_html_elements', 'p,br,strong,em,span,div,ul,ol,li,a,h1,h2,h3,h4,h5,h6,address,pre,table,tr,td,blockquote,thead,tfoot,tbody,th,dl,dt,dd,q,small,strike,sup,sub,b,i,big,small,tt'), (23, 'html_purifier_allowed_html_attributes', '*.style,*.class,a.href,a.title,a.target'), (24, 'tag_delimiter', ','), (25, 'public_navigation_main', '[{"can_delete":false,"uid":"[[relativeurl_]]\\/items\\/browse","label":"Browse Items","fragment":null,"id":null,"class":null,"title":null,"target":null,"accesskey":null,"rel":[],"rev":[],"customHtmlAttribs":[],"order":1,"resource":null,"privilege":null,"active":false,"visible":true,"type":"Omeka_Navigation_Page_Mvc","pages":[],"action":"browse","controller":"items","module":null,"params":[],"route":"default","reset_params":true,"encodeUrl":true,"scheme":null},{"can_delete":false,"uid":"[[relativeurl_]]\\/collections\\/browse","label":"Browse Collections","fragment":null,"id":null,"class":null,"title":null,"target":null,"accesskey":null,"rel":[],"rev":[],"customHtmlAttribs":[],"order":2,"resource":null,"privilege":null,"active":false,"visible":true,"type":"Omeka_Navigation_Page_Mvc","pages":[],"action":"browse","controller":"collections","module":null,"params":[],"route":"default","reset_params":true,"encodeUrl":true,"scheme":null}]'), (26, 'search_record_types', 'a:3:{s:4:"Item";s:4:"Item";s:4:"File";s:4:"File";s:10:"Collection";s:10:"Collection";}'), (27, 'api_enable', ''), (28, 'api_per_page', '50'), (29, 'show_element_set_headings', '1'), (30, 'use_square_thumbnail', '1'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]plugins` -- CREATE TABLE `[[dbprefix]]plugins` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `active` tinyint(4) NOT NULL, `version` varchar(20) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `active_idx` (`active`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]processes` -- CREATE TABLE `[[dbprefix]]processes` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `class` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `user_id` int(10) unsigned NOT NULL, `pid` int(10) unsigned DEFAULT NULL, `status` enum('starting','in progress','completed','paused','error','stopped') COLLATE utf8_unicode_ci NOT NULL, `args` text COLLATE utf8_unicode_ci NOT NULL, `started` timestamp NOT NULL DEFAULT '2000-01-01 05:00:00', `stopped` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `pid` (`pid`), KEY `started` (`started`), KEY `stopped` (`stopped`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]records_tags` -- CREATE TABLE `[[dbprefix]]records_tags` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `record_id` int(10) unsigned NOT NULL, `record_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `tag_id` int(10) unsigned NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `tag` (`record_type`,`record_id`,`tag_id`), KEY `tag_id` (`tag_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]schema_migrations` -- CREATE TABLE `[[dbprefix]]schema_migrations` ( `version` varchar(16) COLLATE utf8_unicode_ci NOT NULL, UNIQUE KEY `unique_schema_migrations` (`version`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `[[dbprefix]]schema_migrations` -- INSERT INTO `[[dbprefix]]schema_migrations` VALUES ('20100401000000'), ('20100810120000'), ('20110113000000'), ('20110124000001'), ('20110301103900'), ('20110328192100'), ('20110426181300'), ('20110601112200'), ('20110627223000'), ('20110824110000'), ('20120112100000'), ('20120220000000'), ('20120221000000'), ('20120224000000'), ('20120224000001'), ('20120402000000'), ('20120516000000'), ('20120612112000'), ('20120623095000'), ('20120710000000'), ('20120723000000'), ('20120808000000'), ('20120808000001'), ('20120813000000'), ('20120914000000'), ('20121007000000'), ('20121015000000'), ('20121015000001'), ('20121018000001'), ('20121110000000'), ('20121218000000'), ('20130422000000'), ('20130426000000'), ('20130429000000'), ('20130701000000'), ('20130809000000'), ('20140304131700'), ('20150211000000'), ('20150310141100'), ('20150814155100'), ('20151118214800'), ('20151209103299'), ('20151209103300'), ('20161209171900'), ('20170331084000'), ('20170405125800'), ('20200127165700'), ('20240709181800'), ('20240713184500'), ('20240713211400'), ('20240717204800'), ('20240917160000'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]search_texts` -- CREATE TABLE `[[dbprefix]]search_texts` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `record_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `record_id` int(10) unsigned NOT NULL, `public` tinyint(1) NOT NULL, `title` mediumtext COLLATE utf8_unicode_ci, `text` longtext COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `record_name` (`record_type`,`record_id`), FULLTEXT KEY `text` (`text`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]sessions` -- CREATE TABLE `[[dbprefix]]sessions` ( `id` varchar(128) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT '', `modified` bigint(20) DEFAULT NULL, `lifetime` int(11) DEFAULT NULL, `data` blob, PRIMARY KEY (`id`), KEY `modified` (`modified`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]tags` -- CREATE TABLE `[[dbprefix]]tags` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]users` -- CREATE TABLE `[[dbprefix]]users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `name` text COLLATE utf8_unicode_ci NOT NULL, `email` text COLLATE utf8_unicode_ci NOT NULL, `password` varchar(255) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL, `salt` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `active` tinyint(4) NOT NULL, `role` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), KEY `active_idx` (`active`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]users` -- INSERT INTO `[[dbprefix]]users` VALUES (1, '[[admin_username]]', '[[admin_fname]] [[admin_lname]]', '[[admin_email]]', '[[admin_pass]]', 'bcrypt', 1, 'super'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]users_activations` -- CREATE TABLE `[[dbprefix]]users_activations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL, `url` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `added` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; /*!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 */;
Save File
Cancel