node-query/test/sql/mysql.sql

24 lines
479 B
MySQL
Raw Permalink Normal View History

2014-10-23 10:53:16 -04:00
-- sample data to test MySQL
--
-- Table structure for table `create_join`
--
2016-07-20 17:58:34 -04:00
DROP TABLE IF EXISTS `create_join` CASCADE;
CREATE TABLE IF NOT EXISTS `create_join` (
`id` int(10) PRIMARY KEY NOT NULL,
`key` VARCHAR(128),
`val` MEDIUMTEXT
);
--
-- Table structure for table `create_test`
--
2016-07-20 17:58:34 -04:00
DROP TABLE IF EXISTS `create_test` CASCADE;
2014-10-27 17:08:18 -04:00
CREATE TABLE `create_test` (
`id` int(10) NOT NULL,
`key` TEXT,
`val` LONGTEXT
);
ALTER TABLE `create_test`
ADD PRIMARY KEY (`id`)