gramps
373ebc8c93
952 days continuous production uptime, 40k+ tp/s single node. Original corpo Bitbucket history not included — clean archive commit.
63 lines
1.7 KiB
SQL
63 lines
1.7 KiB
SQL
-- phpMyAdmin SQL Dump
|
|
-- version 4.5.4.1deb2ubuntu2
|
|
-- http://www.phpmyadmin.net
|
|
--
|
|
-- Host: localhost
|
|
-- Generation Time: Nov 15, 2017 at 08:51 AM
|
|
-- Server version: 10.0.31-MariaDB-0ubuntu0.16.04.2
|
|
-- PHP Version: 7.1.11-1+ubuntu16.04.1+deb.sury.org+1
|
|
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
|
SET time_zone = "+00:00";
|
|
|
|
--
|
|
-- Database: `development_givva`
|
|
--
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `gaTest_tst`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `gaTest_tst`;
|
|
CREATE TABLE `gaTest_tst` (
|
|
`id_tst` int(10) UNSIGNED NOT NULL,
|
|
`testString_tst` varchar(255) DEFAULT NULL,
|
|
`testDouble_tst` double DEFAULT NULL,
|
|
`testInteger_tst` int(11) DEFAULT NULL,
|
|
`testBoolean_tst` tinyint(1) UNSIGNED DEFAULT NULL,
|
|
`createdDate_tst` datetime DEFAULT NULL,
|
|
`lastAccessedDate_tst` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
|
|
`status_tst` varchar(32) DEFAULT NULL,
|
|
`eventGUID_tst` char(36) DEFAULT NULL,
|
|
`token_tst` char(36) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
|
|
--
|
|
-- Indexes for dumped tables
|
|
--
|
|
|
|
--
|
|
-- Indexes for table `gaTest_tst`
|
|
--
|
|
ALTER TABLE `gaTest_tst`
|
|
ADD PRIMARY KEY (`id_tst`),
|
|
ADD UNIQUE KEY `gaTest_tst_token_tst_uindex` (`token_tst`),
|
|
ADD KEY `gaTest_tst_createdDate_tst_status_tst_index` (`createdDate_tst`,`status_tst`),
|
|
ADD KEY `gaTest_tst_eventGuid_tst_index` (`eventGUID_tst`),
|
|
ADD KEY `gaTest_tst_lastAccessedDate_tst_index` (`lastAccessedDate_tst`),
|
|
ADD KEY `testInteger_tst` (`testInteger_tst`),
|
|
ADD KEY `testDouble_tst` (`testDouble_tst`);
|
|
|
|
--
|
|
-- AUTO_INCREMENT for dumped tables
|
|
--
|
|
|
|
--
|
|
-- AUTO_INCREMENT for table `gaTest_tst`
|
|
--
|
|
ALTER TABLE `gaTest_tst`
|
|
MODIFY `id_tst` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;SET FOREIGN_KEY_CHECKS=1;
|