# occn

**Repository Path**: benq/occn

## Basic Information

- **Project Name**: occn
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2018-01-23
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# occn
### blog sql

```
CREATE TABLE IF NOT EXISTS `occn`.`oc_blog_sort` (
  `sort_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(64),
  `image` varchar(255),
   `description` text,
   `meta_title` varchar(64),
   `meta_description` varchar(128),
   `meta_key` varchar(64),
   `status` tinyint(1),
   `sort_order` int(3),
  PRIMARY KEY (`sort_id`)
);
```

```
CREATE TABLE `occn`.`oc_blog_article` (
  `article_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
   `sort_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `date` datetime NOT NULL,
 
  PRIMARY KEY (`article_id`,`language_id`),
  KEY `article_id` (`article_id`),
 
  CONSTRAINT `abc` FOREIGN KEY (`sort_id`) REFERENCES `oc_blog_sort` (`sort_id`)

)  DEFAULT CHARSET=utf8
```


```
CREATE TABLE IF NOT EXISTS `occn`.`oc_sort_to_store` (
  `sort_id` int(11) NOT NULL,
  `store_id` int(11) NOT NULL,
  PRIMARY KEY (`sort_id`,`store_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
```

```$xslt
alter table occn.oc_blog_sort add `column` int(3);
```