aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/FSAssetStore.migrations
blob: c8f5f66e8c51ace19d1eacdf3f030eb5aa9d52e3 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
# -----------------
:VERSION 1

BEGIN;

CREATE TABLE IF NOT EXISTS `fsassets` (
  `id` char(36) NOT NULL,
  `name` varchar(64) NOT NULL DEFAULT '',
  `description` varchar(64) NOT NULL DEFAULT '',
  `type` int(11) NOT NULL,
  `hash` char(80) NOT NULL,
  `create_time` int(11) NOT NULL DEFAULT '0',
  `access_time` int(11) NOT NULL DEFAULT '0',
  `asset_flags` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

COMMIT;