68sqg89Z

1-- phpMyAdmin SQL Dump
2-- version 4.7.7
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost:3306
6-- Generation Time: Oct 03, 2019 at 03:45 PM
7-- Server version: 5.6.38
8-- PHP Version: 7.2.1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `LexicalNetwork`
15--
16CREATE DATABASE IF NOT EXISTS `LexicalNetwork` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
17USE `LexicalNetwork`;
18
19-- --------------------------------------------------------
20
21--
22-- Table structure for table `e`
23--
24
25CREATE TABLE `e` (
26  `eid` int(11) NOT NULL,
27  `name` text NOT NULL,
28  `type` int(11) NOT NULL,
29  `w` int(11) NOT NULL,
30  `formatedname` text NOT NULL
31) ENGINE=InnoDB DEFAULT CHARSET=utf8;
32
33-- --------------------------------------------------------
34
35--
36-- Table structure for table `nt`
37--
38
39CREATE TABLE `nt` (
40  `ntid` int(11) NOT NULL,
41  `ntname` text NOT NULL
42) ENGINE=InnoDB DEFAULT CHARSET=utf8;
43
44-- --------------------------------------------------------
45
46--
47-- Table structure for table `r`
48--
49
50CREATE TABLE `r` (
51  `rid` int(11) NOT NULL,
52  `node1` int(11) NOT NULL,
53  `node2` int(11) NOT NULL,
54  `type` int(11) NOT NULL,
55  `w` int(11) NOT NULL
56) ENGINE=InnoDB DEFAULT CHARSET=utf8;
57
58-- --------------------------------------------------------
59
60--
61-- Table structure for table `rt`
62--
63
64CREATE TABLE `rt` (
65  `rtid` int(11) NOT NULL,
66  `trname` text NOT NULL,
67  `trgpname` text NOT NULL,
68  `rthelp` text NOT NULL
69) ENGINE=InnoDB DEFAULT CHARSET=utf8;
70
71--
72-- Indexes for dumped tables
73--
74
75--
76-- Indexes for table `e`
77--
78ALTER TABLE `e`
79  ADD PRIMARY KEY (`eid`);
80
81--
82-- Indexes for table `nt`
83--
84ALTER TABLE `nt`
85  ADD PRIMARY KEY (`ntid`);
86
87--
88-- Indexes for table `r`
89--
90ALTER TABLE `r`
91  ADD PRIMARY KEY (`rid`);
92
93--
94-- Indexes for table `rt`
95--
96ALTER TABLE `rt`
97  ADD PRIMARY KEY (`rtid`);