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

BEGIN;

CREATE TABLE `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=InnoDB DEFAULT CHARSET=utf8;

COMMIT;