GeezerVisonThe World Wide Web, restored to 800 pixels of glory. |
| Home|About|Gaming cabinet|Archives|How it works|Starter sites |
GeezerVison is showing github.com — APIJSON-Demo/MySQL/single/Demo/sys_routines.sql at master · APIJSON/APIJSON-Demo Expand file tree/ Copy pathsys_routines.sqlMore file actions 68 lines (61 loc) · 2.87 KB / Copy pathsys_routines.sqlFile metadata and controls68 lines (61 loc) · 2.87 KB 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 -- MySQL dump 10.13 Distrib 8.0.31, for macos12 (x86_64) -- -- Host: 47.122.25.116 Database: sys -- ------------------------------------------------------ -- Server version 5.7.43-log /*!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 */; /*!50503 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Temporary view structure for view `ViewTable` -- DROP TABLE IF EXISTS `ViewTable`; /*!50001 DROP VIEW IF EXISTS `ViewTable`*/; SET @saved_cs_client = @@character_set_client; /*!50503 SET character_set_client = utf8mb4 */; /*!50001 CREATE VIEW `ViewTable` AS SELECT 1 AS `commentId`, 1 AS `toId`, 1 AS `momentId`, 1 AS `content`, 1 AS `id`, 1 AS `sex`, 1 AS `name`, 1 AS `tag`, 1 AS `head`, 1 AS `contactIdList`, 1 AS `pictureList`, 1 AS `date`*/; SET character_set_client = @saved_cs_client; -- -- Final view structure for view `ViewTable` -- /*!50001 DROP VIEW IF EXISTS `ViewTable`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`%` SQL SECURITY DEFINER */ /*!50001 VIEW `ViewTable` AS select `C`.`id` AS `commentId`,`C`.`toId` AS `toId`,`C`.`momentId` AS `momentId`,`C`.`content` AS `content`,`U`.`id` AS `id`,`U`.`sex` AS `sex`,`U`.`name` AS `name`,`U`.`tag` AS `tag`,`U`.`head` AS `head`,`U`.`contactIdList` AS `contactIdList`,`U`.`pictureList` AS `pictureList`,`U`.`date` AS `date` from (`Comment` `C` join `apijson_user` `U` on((`U`.`id` = `C`.`userId`))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2024-06-16 0:37:40 |
| You are visitor 01402520 — GeezerVison does not store the pages you look up. Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required. |