WordPress database error: [Unknown storage engine 'MyISAM'] CREATE TABLE IF NOT EXISTS `wp_amz_assets` (
`id` BIGINT(15) UNSIGNED NOT NULL AUTO_INCREMENT,
`post_id` BIGINT(20) NOT NULL,
`asset` VARCHAR(225) NULL DEFAULT NULL,
`thumb` VARCHAR(225) NULL DEFAULT NULL,
`download_status` VARCHAR(20) NULL DEFAULT 'new' COMMENT 'new, success, inprogress, error, remote',
`hash` VARCHAR(32) NULL DEFAULT NULL,
`media_id` BIGINT(20) NULL DEFAULT '0',
`msg` TEXT NULL,
`date_added` DATETIME NULL DEFAULT NULL,
`date_download` DATETIME NULL DEFAULT NULL,
`image_sizes` TEXT NULL,
PRIMARY KEY (`id`),
INDEX `post_id` (`post_id`),
INDEX `hash` (`hash`),
INDEX `media_id` (`media_id`),
INDEX `download_status` (`download_status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci /* From [musthaves.la/20-colleges-where-students-smoke-the-most-weed/] in [/nas/content/live/musthavesla/wp-content/plugins/woozone/modules/setup_backup/default-sql.php:95] */
WordPress database error: [Unknown storage engine 'MyISAM'] CREATE TABLE IF NOT EXISTS `wp_amz_products` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`post_id` BIGINT(20) NOT NULL,
`post_parent` BIGINT(20) NULL DEFAULT '0',
`type` ENUM('post','variation') NULL DEFAULT 'post',
`title` TEXT NULL,
`nb_assets` INT(4) NULL DEFAULT '0',
`nb_assets_done` INT(4) NULL DEFAULT '0',
`status` ENUM('new','success') NULL DEFAULT 'new',
PRIMARY KEY (`post_id`, `id`),
UNIQUE INDEX `post_id` (`post_id`),
INDEX `post_parent` (`post_parent`),
INDEX `type` (`type`),
INDEX `nb_assets` (`nb_assets`),
INDEX `nb_assets_done` (`nb_assets_done`),
INDEX `id` (`id`),
INDEX `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci /* From [musthaves.la/20-colleges-where-students-smoke-the-most-weed/] in [/nas/content/live/musthavesla/wp-content/plugins/woozone/modules/setup_backup/default-sql.php:95] */
WordPress database error: [Unknown storage engine 'MyISAM'] CREATE TABLE IF NOT EXISTS `wp_amz_cross_sell` (
`ASIN` VARCHAR(10) NOT NULL,
`products` TEXT NULL,
`nr_products` INT(11) NULL DEFAULT NULL,
`add_date` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`is_variable` CHAR(1) NULL DEFAULT 'N',
`nb_tries` TINYINT(1) UNSIGNED NULL DEFAULT '0',
PRIMARY KEY (`ASIN`),
UNIQUE INDEX `ASIN` (`ASIN`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci /* From [musthaves.la/20-colleges-where-students-smoke-the-most-weed/] in [/nas/content/live/musthavesla/wp-content/plugins/woozone/modules/setup_backup/default-sql.php:95] */
WordPress database error: [Unknown storage engine 'MyISAM'] CREATE TABLE IF NOT EXISTS `wp_amz_report_log` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`log_id` VARCHAR(50) NULL DEFAULT NULL,
`log_action` VARCHAR(50) NULL DEFAULT NULL,
`desc` VARCHAR(255) NULL DEFAULT NULL,
`log_data_type` VARCHAR(50) NULL DEFAULT NULL,
`log_data` LONGTEXT NULL,
`source` TEXT NULL,
`date_add` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
INDEX `log_id` (`log_id`),
INDEX `log_action` (`log_action`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci /* From [musthaves.la/20-colleges-where-students-smoke-the-most-weed/] in [/nas/content/live/musthavesla/wp-content/plugins/woozone/modules/setup_backup/default-sql.php:95] */
WordPress database error: [Unknown storage engine 'MyISAM'] CREATE TABLE IF NOT EXISTS `wp_amz_queue` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`asin` VARCHAR(100) NOT NULL,
`status` VARCHAR(20) NOT NULL,
`status_msg` TEXT NOT NULL,
`from_op` VARCHAR(30) NOT NULL,
`created_date` TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00',
`imported_date` TIMESTAMP NULL DEFAULT NULL,
`nb_tries` SMALLINT(1) UNSIGNED NOT NULL DEFAULT '0',
`nb_tries_prev` SMALLINT(1) UNSIGNED NOT NULL DEFAULT '0',
`product_title` TEXT NULL,
`country` VARCHAR(30) NOT NULL DEFAULT '',
`provider` VARCHAR(20) NOT NULL DEFAULT 'amazon',
PRIMARY KEY (`id`),
UNIQUE INDEX `asin_from_op` (`asin`, `from_op`),
INDEX `nb_tries` (`nb_tries`),
INDEX `from_op` (`from_op`),
INDEX `status` (`status`),
INDEX `country` (`country`),
INDEX `provider` (`provider`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci /* From [musthaves.la/20-colleges-where-students-smoke-the-most-weed/] in [/nas/content/live/musthavesla/wp-content/plugins/woozone/modules/setup_backup/default-sql.php:95] */
WordPress database error: [Unknown storage engine 'MyISAM'] CREATE TABLE IF NOT EXISTS `wp_amz_search` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`code` VARCHAR(32) NOT NULL,
`publish` ENUM('Y','N') NOT NULL DEFAULT 'Y',
`status` VARCHAR(20) NOT NULL,
`status_msg` TEXT NOT NULL,
`params` TEXT NOT NULL,
`provider` VARCHAR(20) NOT NULL DEFAULT 'amazon',
`search_title` VARCHAR(100) NOT NULL,
`country` VARCHAR(30) NOT NULL DEFAULT '',
`recurrency` VARCHAR(10) NOT NULL,
`created_date` TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00',
`started_at` TIMESTAMP NULL DEFAULT NULL,
`ended_at` TIMESTAMP NULL DEFAULT NULL,
`run_date` TIMESTAMP NULL DEFAULT NULL,
`nb_tries` SMALLINT(1) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE INDEX `code` (`code`),
INDEX `provider` (`provider`),
INDEX `country` (`country`),
INDEX `recurrency` (`recurrency`),
INDEX `status` (`status`),
INDEX `publish` (`publish`),
INDEX `run_date` (`run_date`),
INDEX `nb_tries` (`nb_tries`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci /* From [musthaves.la/20-colleges-where-students-smoke-the-most-weed/] in [/nas/content/live/musthavesla/wp-content/plugins/woozone/modules/setup_backup/default-sql.php:95] */
WordPress database error: [Unknown storage engine 'MyISAM'] CREATE TABLE IF NOT EXISTS `wp_amz_locale_reference` (
`ID` INT(10) NOT NULL AUTO_INCREMENT,
`country` VARCHAR(3) NOT NULL DEFAULT 'US',
`searchIndex` VARCHAR(50) NOT NULL,
`department` VARCHAR(100) NOT NULL,
`browseNode` BIGINT(20) NOT NULL DEFAULT '0',
`sortValues` TEXT NOT NULL,
`itemSearchParams` TEXT NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE INDEX `country_searchIndex` (`country`, `searchIndex`),
INDEX `searchIndex` (`searchIndex`),
INDEX `department` (`department`),
INDEX `browseNode` (`browseNode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci /* From [musthaves.la/20-colleges-where-students-smoke-the-most-weed/] in [/nas/content/live/musthavesla/wp-content/plugins/woozone/modules/setup_backup/default-sql.php:95] */
WordPress database error: [Unknown storage engine 'MyISAM'] CREATE TABLE IF NOT EXISTS `wp_amz_amzkeys` (
`id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
`access_key` VARCHAR(100) NOT NULL,
`secret_key` VARCHAR(100) NOT NULL,
`publish` ENUM('Y','N') NOT NULL DEFAULT 'Y',
`locked` CHAR(1) NOT NULL DEFAULT 'N',
`lock_time` TIMESTAMP NULL DEFAULT NULL,
`nb_requests` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`nb_requests_valid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`ratio_success` FLOAT(5,2) UNSIGNED NOT NULL DEFAULT '0.00',
`last_request_time` TIMESTAMP NULL DEFAULT NULL,
`last_request_status` VARCHAR(50) NULL DEFAULT NULL,
`last_request_input` MEDIUMTEXT NULL,
`last_request_output` MEDIUMTEXT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `access_key_secret_key` (`access_key`, `secret_key`),
INDEX `publish_locked_lock_time` (`publish`, `locked`, `lock_time`),
INDEX `locked_lock_time` (`locked`, `lock_time`),
INDEX `lock_time` (`lock_time`),
INDEX `last_request_time` (`last_request_time`),
INDEX `ratio_success` (`ratio_success`),
INDEX `nb_requests` (`nb_requests`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci /* From [musthaves.la/20-colleges-where-students-smoke-the-most-weed/] in [/nas/content/live/musthavesla/wp-content/plugins/woozone/modules/setup_backup/default-sql.php:95] */
In a survey of 140,000 students, most colleges that made the list were located in states where cannabis is legal, like Vermont, California, and Colorado.
The No. 1 school for weed smokers is the University of Vermont, in Burlington.
For many, toking up has been as integral a part of the college experience as ultimate Frisbee and late-night study sessions. And while the activity has often been shrouded in secrecy, the mainstreaming of marijuana now has college students openly discussing their smoking habits.
To find out which colleges are out-smoking the rest, the Princeton Review surveyed 140,000 students in 385 schools, asking them, "How widely is marijuana used at your school?" Not surprisingly, many of the colleges with students reporting highest marijuana use are in states where recreational use of the drug is legal.
According to a 2017 Monitoring the Future study from the University of Michigan, 38% of college students aged 19 to 22 have reported smoking weed in the past year.
And as a sign of the times, weed isn’t just being smoked on campus anymore — it’s being taught. Some schools, like Cornell University in New York and Colorado’s University of Denver, are offering cannabis courses. The University of Maryland School of Pharmacy will even offer a master’s degree in medical cannabis, according to the Wall Street Journal.
Here are the colleges where students report the most recreational use of weed.
MustHaves.LA a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.AcceptRead More
Privacy & Cookies Policy
Privacy Overview
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Wikimedia Commons
Elstad Ranch/Flickr/CC 2.0 Attribution
Richard Hurd/Flickr/CC 2.0 Attribution