ASDL:Datenbank-Skripte

From Wiki

Endbericht des ASDL-Projekts
Inhaltsverzeichnis | Hauptseite des ASDL-Projekts

8. Anhang (DTDs der Nachrichten) <<<<< | 8. Anhang (Datenbank-Skripte)

1 Übersicht über die Datenbanken
2 Skript zum Erstellen der Datenbank
3 Skript zum Löschen aller ASDL-Tabellen, die zur Vorschlagsberechnung genutzt werden
4 Skript zum Löschen der Gernerischen Cases
5 Skript zum Erstellen des initialen DB-Inhalts

Übersicht über die Datenbanken

Hier nochmals zum besseren Verständnis eine Übersicht über die Datenbank (ER-Diagramm). Die "Primärschlüssel" sind nicht in den Skripten enthalten und mehr "logischer" Natur.

Skript zum Erstellen der Datenbank

Dieses Skript muss nicht ausgeführt werden. Stellt der Resoning-Agent fest, dass eine Tabelle nicht besteht, dann legt er diese neu an.

 
-- 
-- Tabellen für das ASDL-Projekt (Create-Statements)
-- 
CREATE TABLE "ASDL_Cases" (
  "Case_ID" int(11) NOT NULL DEFAULT '0',
  "Hits" int(11) NOT NULL DEFAULT '0',
  "Operators" int(11) NOT NULL DEFAULT '0',
  "QueryTermsAuthor" varchar(255) DEFAULT NULL,
  "QueryTermsTitle" varchar(255) DEFAULT NULL,
  "QueryTermsFreeText" varchar(255) DEFAULT NULL,
  "QueryTermsYear" varchar(50) DEFAULT NULL,
  "Answeringtime" int(11) NOT NULL DEFAULT '0',
  "DLList_ID" int(11) NOT NULL DEFAULT '0',
  "Extractedterms_ID" int(11) NOT NULL DEFAULT '0',
  "Suggestion_ID" int(11) NOT NULL DEFAULT '0',
  "Timestamp" timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY  ("Case_ID")
);
 
CREATE TABLE "ASDL_DLList" (
  "DLList_ID" int(11) NOT NULL DEFAULT '0',
  "DLName" varchar(50) DEFAULT NULL,
  "Count" int(11) NOT NULL DEFAULT '0'
);
 
CREATE TABLE "ASDL_Extractedterms" (
  "Extractedterms_ID" int(11) NOT NULL DEFAULT '0',
  "Terms_ID" int(11) NOT NULL DEFAULT '0',
  "Authors_ID" int(11) NOT NULL DEFAULT '0',
  "Conferences_ID" int(11) NOT NULL DEFAULT '0',
  "Journals_ID" int(11) NOT NULL DEFAULT '0'
);
 
CREATE TABLE "ASDL_Authors" (
  "Author_ID" int(11) NOT NULL DEFAULT '0',
  "Author" varchar(50) NOT NULL DEFAULT '',
  "Count" int(11) NOT NULL DEFAULT '0'
);
 
CREATE TABLE "ASDL_Conferences" (
  "Conference_ID" int(11) NOT NULL DEFAULT '0',
  "Conference" varchar(50) NOT NULL DEFAULT '',
  "Count" int(11) NOT NULL DEFAULT '0'
);
 
CREATE TABLE "ASDL_Journals" (
  "Journal_ID" int(11) NOT NULL DEFAULT '0',
  "Journal" varchar(50) NOT NULL DEFAULT '',
  "Count" int(11) NOT NULL DEFAULT '0'
);
 
CREATE TABLE "ASDL_Terms" (
  "Term_ID" int(11) NOT NULL DEFAULT '0',
  "Term" varchar(50) NOT NULL DEFAULT '',
  "Count" int(11) NOT NULL DEFAULT '0'
);
CREATE TABLE "ASDL_Suggestion" (
  "Suggestion_ID" int(11) NOT NULL DEFAULT '0',
  "LANGUAGE" char(2) NOT NULL DEFAULT '',
  "TipText" text NOT NULL,
  "Explanation" text NOT NULL
);
 
CREATE TABLE "ASDL_SuggestionClass" (
  "Suggestion_ID" int(11) NOT NULL,
  "JavaClass" varchar(150) DEFAULT NULL,
  PRIMARY KEY  ("Suggestion_ID")
) AUTO_INCREMENT=8 ;
 
 
-- Change Format to UTF8 (check if nessesary for your DB Setup)
ALTER TABLE `ASDL_Suggestion` CHANGE `TipText` `TipText` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL;
ALTER TABLE `ASDL_Suggestion` CHANGE `Explanation` `Explanation` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL;

Skript zum Löschen aller ASDL-Tabellen, die zur Vorschlagsberechnung genutzt werden

Dieses Skript ist sinnvoll, wenn man seine ganze Datenbasis löschen möchte (z.B. alles voller Testdaten - oder es werden nur unbrauchbare Suggestions gemacht)

 
-- Drop all content
TRUNCATE TABLE `ASDL_Authors`;
TRUNCATE TABLE `ASDL_Cases`;
TRUNCATE TABLE `ASDL_Conferences`;
TRUNCATE TABLE `ASDL_DLList`;
TRUNCATE TABLE `ASDL_Extractedterms`;
TRUNCATE TABLE `ASDL_Journals`;
TRUNCATE TABLE `ASDL_Terms`;

Skript zum Löschen der Gernerischen Cases

Dieses Skript ausführen, um die generischen Cases (= Startdatenbasis) zu löschen. Wenn genug "echte" Cases in der Datenbank sind, sollten die generischen Cases nur noch sehr selten vorgeschlagen werden, da sie meist eine geringere Ähnlichkeit haben als tatsächliche Cases.

 
-- Drop generic content only
DELETE FROM `ASDL_Cases` WHERE `Case_ID` < 63;
DELETE FROM `ASDL_Authors` WHERE `Author_ID` < 63;
DELETE FROM `ASDL_Conferences` WHERE `Conference_ID` < 63;
DELETE FROM `ASDL_Journals` WHERE `Journal_ID` < 63;
DELETE FROM `ASDL_Terms` WHERE `Term_ID` < 63;
DELETE FROM `ASDL_DLList` WHERE `DLList_ID` < 63;
DELETE FROM `ASDL_Extractedterms` WHERE `Extractedterms_ID` < 63;

Skript zum Erstellen des initialen DB-Inhalts

Hier werden die generischen Cases angelegt, um eine Startdatenbasis zu erhalten. Empfehlung: Beim erstmaligen Starten von ASDL einmal ausführen (z.B. mit PHPMyAdmin).

Sollten eine neue Suggestion erstellt werden, muss für diese auch ein generischer Case angelegt werden.

 
-- 
-- Startdata for table `ASDL_Cases` and fitting SubTables [PreLearning]
-- 
-- case_ID`, `Hits`, `Operators`, `QueryTermsAuthor`, `QueryTermsTitle`, `QueryTermsFreeText`, `QueryTermsYear`, `Answeringtime`, `DLList_ID`, `Extractedterms_ID`, `Suggestion_ID`, `Timestamp`
-- Suggestion-ID 1
INSERT INTO `ASDL_Cases` VALUES (1, 150, -1, '$', '$', '', '$', -1, 1, 1, 1, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (2, 300, -1, '$', '$', '', '$', -1, 2, 2, 1, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (3, 600, -1, '$', '$', '', '$', -1, 3, 3, 1, '1980-01-01 00:00:01');
 
-- Suggestion-ID 2
INSERT INTO `ASDL_Cases` VALUES (4, 150, 0, '$', '$', '$', '$', -1, 4, 4, 2, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (5, 150, 1, '$', '$', '$', '$', -1, 5, 5, 2, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (6, 150, 2, '$', '$', '$', '$', -1, 6, 6, 2, '1980-01-01 00:00:01');
 
INSERT INTO `ASDL_Cases` VALUES (7, 300, 0, '$', '$', '$', '$', -1, 7, 7, 2, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (8, 300, 1, '$', '$', '$', '$', -1, 8, 8, 2, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (9, 300, 2, '$', '$', '$', '$', -1, 9, 9, 2, '1980-01-01 00:00:01');
 
INSERT INTO `ASDL_Cases` VALUES (10, 600, 0, '$', '$', '$', '$', -1, 10, 10, 2, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (11, 600, 1, '$', '$', '$', '$', -1, 11, 11, 2, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (12, 600, 2, '$', '$', '$', '$', -1, 12, 12, 2, '1980-01-01 00:00:01');
 
-- Suggestion-ID 3 und 4
INSERT INTO `ASDL_Cases` VALUES (13, 150, -1, '$', '$', '$', '$', -1, 13, 13, 3, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (14, 300, -1, '$', '$', '$', '$', -1, 14, 14, 3, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (15, 600, -1, '$', '$', '$', '$', -1, 15, 15, 3, '1980-01-01 00:00:01');
 
INSERT INTO `ASDL_Cases` VALUES (16, 150, -1, '$', '$', '$', '$', -1, 16, 16, 4, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (17, 300, -1, '$', '$', '$', '$', -1, 17, 17, 4, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (18, 600, -1, '$', '$', '$', '$', -1, 18, 18, 4, '1980-01-01 00:00:01');
 
-- Suggestion-ID 5
INSERT INTO `ASDL_Cases` VALUES (19, 0, 5, '$', '$', '$', '$', -1, 19, 19, 5, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (20, 5, 5, '$', '$', '$', '$', -1, 20, 20, 5, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (21, 10, 5, '$', '$', '$', '$', -1, 21, 21, 5, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (22, 15, 5, '$', '$', '$', '$', -1, 22, 22, 5, '1980-01-01 00:00:01');
 
INSERT INTO `ASDL_Cases` VALUES (23, 0, 10, '$', '$', '$', '$', -1, 23, 23, 5, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (24, 5, 10, '$', '$', '$', '$', -1, 24, 24, 5, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (25, 10, 10, '$', '$', '$', '$', -1, 25, 25, 5, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (26, 15, 10, '$', '$', '$', '$', -1, 26, 26, 5, '1980-01-01 00:00:01');
 
-- Suggestion-ID 6 und 7
INSERT INTO `ASDL_Cases` VALUES (27, 150, -1, '$', '$', '$', '$', -1, 27, 27, 6, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (28, 300, -1, '$', '$', '$', '$', -1, 28, 28, 6, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (29, 600, -1, '$', '$', '$', '$', -1, 29, 29, 6, '1980-01-01 00:00:01');
 
INSERT INTO `ASDL_Cases` VALUES (30, 150, -1, '$', '$', '$', '$', -1, 30, 30, 7, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (31, 300, -1, '$', '$', '$', '$', -1, 31, 31, 7, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (32, 600, -1, '$', '$', '$', '$', -1, 32, 32, 7, '1980-01-01 00:00:01');
 
-- Suggestion-ID 8 und 9 
INSERT INTO `ASDL_Cases` VALUES (33, 150, 0, '', '', '', '', -1, 33, 33, 8, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (34, 150, 1, '', '', '', '', -1, 34, 34, 8, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (35, 300, 0, '', '', '', '', -1, 35, 35, 8, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (36, 300, 1, '', '', '', '', -1, 36, 36, 8, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (37, 600, 0, '', '', '', '', -1, 37, 37, 8, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (38, 600, 1, '', '', '', '', -1, 38, 38, 8, '1980-01-01 00:00:01');
 
INSERT INTO `ASDL_Cases` VALUES (39, 150, 0, '', '', '', '', -1, 39, 39, 9, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (40, 150, 1, '', '', '', '', -1, 40, 40, 9, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (41, 300, 0, '', '', '', '', -1, 41, 41, 9, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (42, 300, 1, '', '', '', '', -1, 42, 42, 9, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (43, 600, 0, '', '', '', '', -1, 43, 43, 9, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (44, 600, 1, '', '', '', '', -1, 44, 44, 9, '1980-01-01 00:00:01');
 
-- Suggestion-ID 10
INSERT INTO `ASDL_Cases` VALUES (45, 0, 5, '$', '$', '$', '$', -1, 45, 45, 10, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (46, 5, 5, '$', '$', '$', '$', -1, 46, 46, 10, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (47, 10, 5, '$', '$', '$', '$', -1, 47, 47, 10, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (48, 15, 5, '$', '$', '$', '$', -1, 48, 48, 10, '1980-01-01 00:00:01');
 
INSERT INTO `ASDL_Cases` VALUES (49, 0, 10, '$', '$', '$', '$', -1, 49, 49, 10, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (50, 5, 10, '$', '$', '$', '$', -1, 50, 50, 10, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (51, 10, 10, '$', '$', '$', '$', -1, 51, 51, 10, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (52, 15, 10, '$', '$', '$', '$', -1, 52, 52, 10, '1980-01-01 00:00:01');
 
 
-- Suggestion-ID 11
INSERT INTO `ASDL_Cases` VALUES (53, 150, 0, '$', '$', '$', '$', -1, 53, 53, 11, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (54, 150, 1, '$', '$', '$', '$', -1, 54, 54, 11, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (55, 150, 2, '$', '$', '$', '$', -1, 55, 55, 11, '1980-01-01 00:00:01');
 
INSERT INTO `ASDL_Cases` VALUES (56, 300, 0, '$', '$', '$', '$', -1, 56, 56, 11, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (57, 300, 1, '$', '$', '$', '$', -1, 57, 57, 11, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (58, 300, 2, '$', '$', '$', '$', -1, 58, 58, 11, '1980-01-01 00:00:01');
 
INSERT INTO `ASDL_Cases` VALUES (59, 600, 0, '$', '$', '$', '$', -1, 59, 59, 11, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (60, 600, 1, '$', '$', '$', '$', -1, 60, 60, 11, '1980-01-01 00:00:01');
INSERT INTO `ASDL_Cases` VALUES (61, 600, 2, '$', '$', '$', '$', -1, 61, 61, 11, '1980-01-01 00:00:01');
 
-- Suggestion-ID 12
INSERT INTO `ASDL_Cases` VALUES (62, -1, -1, '$', '$', '$', '$', -1, 62, 62, 12, '1980-01-01 00:00:01');
 
 
 
-- Subtables
INSERT INTO `ASDL_Authors` VALUES (1, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (2, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (3, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (4, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (5, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (6, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (7, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (8, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (9, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (10, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (11, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (12, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (13, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (14, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (15, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (16, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (17, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (18, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (19, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (20, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (21, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (22, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (23, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (24, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (25, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (26, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (27, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (28, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (29, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (30, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (31, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (32, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (33, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (34, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (35, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (36, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (37, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (38, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (39, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (40, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (41, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (42, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (43, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (44, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (45, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (46, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (47, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (48, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (49, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (50, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (51, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (52, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (53, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (54, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (55, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (56, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (57, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (58, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (59, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (60, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (61, '$', -1);
INSERT INTO `ASDL_Authors` VALUES (62, '$', -1);
 
INSERT INTO `ASDL_Conferences` VALUES (1, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (2, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (3, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (4, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (5, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (6, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (7, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (8, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (9, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (10, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (11, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (12, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (13, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (14, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (15, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (16, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (17, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (18, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (19, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (20, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (21, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (22, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (23, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (24, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (25, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (26, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (27, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (28, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (29, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (30, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (31, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (32, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (33, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (34, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (35, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (36, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (37, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (38, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (39, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (40, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (41, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (42, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (43, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (44, '$', -1);
INSERT INTO `ASDL_Conferences` VALUES (45,